[Tool] Grim Dawn Item Assistant

Mike_Salopek · May 6, 2020, 8:48am

Hi, I just got the IA running in my base game, but had a whoops moment and am now desperate for help. I later went back to my Reign of Terror game where I already had items sitting in my shared stash. They have vanished. I am desperately hoping there is a way to fins and restore as I had complete sets of set gear and will be sick if these are all lost. I did not realize that IA had to NOT be running before dwitching over the fiablo mod
side note, my horadric cube and staff were in my shared too. OMG

slipperypete · May 6, 2020, 7:10pm

Try selecting the mod in the upper right corner of IA, as IA stores mod items separately from vanilla ones.

If the items are truly gone, go to the help tab and look at instructions for restoring an old stash, as IA makes backups before it touches anything.

slipperypete · May 6, 2020, 7:11pm

Try running IA as administrator, or switching to 64 bit GD.

Anything else juicy in the logs? Stash status “ERROR” is a rare one.

3sword · May 7, 2020, 1:56am

My items in stash 4 (last) get looted and deposited, but when I try to transfer them to my stash it says “Cannot deposit item, please ensure SHARED Stash tab is empty.” I have all SHARED stash unlocked, it’s saying in the log my transfer file doesn’t have more than one stash but it has all 4, and the 4th stash for looting works fine.

[07/05 02:46:02] DEBUG Item transfer requested, arguments: StashTransferEventArgs[Id:0]
[07/05 02:46:02] DEBUG Found 1 items to transfer
[07/05 02:46:02] DEBUG Applying stats to 1 items
[07/05 02:46:02] DEBUG Applied stats to 1 items
[07/05 02:46:02] WARN File “D:\Josh\Documents\My Games\Grim Dawn\Save\transfer.gst” only contains 1 pages, must have at least 2 pages to function properly.
[07/05 02:46:02] WARN Please purchase more stash pages!
[07/05 02:46:02] INFO Successfully deposited 0 out of 1 items

EDIT: So, transfer.gst seems to be your personal stash, .bst is shared stash from what I saw opening them in GDstash. Since I don’t have the expansion, I don’t have more than one stash tab in my personal (.gst the file it reads in the log) so it might just not be compatiable without aom.

SkeletorOne · May 7, 2020, 8:16pm

I just updated GDIA and now it doesn’t start anymore It briefly shows up in the Taskbar just to shutdown immediately. Does GDIA write logs anywhere so I can take a look?

slipperypete · May 7, 2020, 8:24pm

Logs can be found at: %appdata%\..\local\evilsoft\iagd

SkeletorOne · May 7, 2020, 8:28pm

Got this:

2020-05-07 22:16:05,249 [Main] INFO [IAGrim.Program]: Checking for database updates..
2020-05-07 22:16:05,428 [SQL] ERROR[NHibernate.AdoNet.AbstractBatcher]: Could not execute command: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)

System.Data.SQLite.SQLiteException (0x80004005): constraint failed
NOT NULL constraint failed: deletedplayeritem_v2.Id
   bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
2020-05-07 22:16:05,431 [SQL] WARN [NHibernate.Util.ADOExceptionReporter]: System.Data.SQLite.SQLiteException (0x80004005): constraint failed
NOT NULL constraint failed: deletedplayeritem_v2.Id
   bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   bei NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-07 22:16:05,432 [SQL] ERROR[NHibernate.Util.ADOExceptionReporter]: constraint failed
NOT NULL constraint failed: deletedplayeritem_v2.Id
2020-05-07 22:16:05,433 [Main] WARN [IAGrim.Database.Synchronizer.ThreadExecuter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)
]
2020-05-07 22:16:05,433 [Main] WARN [IAGrim.Database.Synchronizer.ThreadExecuter]:    bei NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   bei NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   bei NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   bei IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   bei IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.Run()
2020-05-07 22:16:05,434 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)
]
2020-05-07 22:16:05,434 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]:    bei NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   bei NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   bei NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   bei IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   bei IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   bei IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   bei IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   bei IAGrim.Program.Main(String[] args)
2020-05-07 22:16:05,437 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Outer exception: 
2020-05-07 22:16:05,437 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-07 22:16:05,437 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Inner exception: 
2020-05-07 22:16:05,437 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-07 22:16:05,525 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Uploaded crash report to developer.
2020-05-07 22:16:05,526 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x
)
]
2020-05-07 22:16:05,526 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-07 22:16:05,527 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Outer exception: 
2020-05-07 22:16:05,527 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-07 22:16:05,527 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Inner exception: 
2020-05-07 22:16:05,527 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-07 22:16:05,567 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Uploaded crash report to developer.

Garfunkel · May 7, 2020, 8:44pm

After the update to the latest version there are again tons of copies of same items (not duplicates but just same item in several versions). Not that it takes much disk space but choosing one item out of 7-11 exemplars is kinda time consuming. I don’t want my items to be propagated like that. I also consider it cheating. Why is that even happening?

slipperypete · May 7, 2020, 8:55pm

Fixed in 1.2.7432.32103

Fix available at: http://grimdawn.dreamcrash.org/ia/latest.php

slipperypete · May 7, 2020, 8:56pm

IA is creating non identical duplicates?
That’s a first… are certain?

IA never changes the seed of items.

SkeletorOne · May 7, 2020, 9:02pm

Installed it, still doesn’t start. Full log from just now:

2020-05-07 23:00:32,188 [Main] INFO [IAGrim.Program]: Starting IA:GD..
2020-05-07 23:00:32,198 [Main] INFO [IAGrim.Program]: Starting exception monitor for bug reports..
2020-05-07 23:00:32,198 [Main] DEBUG[IAGrim.Program]: Crash reports can be seen at http://ribbs.dreamcrash.org/iagd/logs.html
2020-05-07 23:00:32,199 [Main] INFO [IAGrim.StartupService]: Running version 1.2.7432.32103 from 07.05.2020
2020-05-07 23:00:32,201 [Main] DEBUG[IAGrim.Utilities.DependencyChecker]: Checking if .Net Framework v4.52 is installed
2020-05-07 23:00:32,202 [Main] DEBUG[IAGrim.Utilities.DependencyChecker]: Checking if VC++ 2013 Runtimes are installed
2020-05-07 23:00:32,202 [Main] DEBUG[IAGrim.Utilities.DependencyChecker]: Checking if VC++ 2010 Runtimes are installed
2020-05-07 23:00:32,202 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copying missing files / etc to IA storage folder
2020-05-07 23:00:32,837 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copy complete
2020-05-07 23:00:32,837 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copying missing files / etc to IA storage folder
2020-05-07 23:00:33,387 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copy complete
2020-05-07 23:00:33,387 [Main] INFO [IAGrim.Program]: Calling run..
2020-05-07 23:00:33,389 [Main] INFO [IAGrim.Program]: Visual styles enabled..
2020-05-07 23:00:33,546 [SQL] INFO [IAGrim.Database.SessionFactory]: Creating session on thread 6
2020-05-07 23:00:33,547 [SQL] DEBUG[SessionFactory]: Creating session factory
2020-05-07 23:00:33,998 [SQL] DEBUG[SessionFactory]: Building session factory
2020-05-07 23:00:34,292 [SQL] DEBUG[SessionFactory]: Running schema updates
2020-05-07 23:00:34,400 [SQL] INFO [SessionFactory]: Database connection established.
2020-05-07 23:00:34,601 [SQL] DEBUG[IAGrim.Database.Migrations.AddSkillTables]: Executing migration
2020-05-07 23:00:34,633 [SQL] DEBUG[IAGrim.Database.Migrations.AddSkillTables]: Executing migration
2020-05-07 23:00:34,717 [Main] INFO [IAGrim.Program]: Your user id is f4ec2a1b1c794425ba4cc7f5d9461eff, use this for any bug reports
2020-05-07 23:00:34,717 [Main] DEBUG[IAGrim.Program]: Updating augment state..
2020-05-07 23:00:35,499 [Main] INFO [IAGrim.StartupService]: IA is configured to loot from the last stash page
2020-05-07 23:00:35,500 [Main] INFO [IAGrim.StartupService]: IA is configured to deposit to the second-to-last stash page
2020-05-07 23:00:35,500 [Main] INFO [IAGrim.Database.SessionFactory]: Creating session on thread 1
2020-05-07 23:00:35,500 [Main] DEBUG[SessionFactory]: Creating session factory
2020-05-07 23:00:35,506 [Main] DEBUG[SessionFactory]: Building session factory
2020-05-07 23:00:35,518 [Main] DEBUG[SessionFactory]: Running schema updates
2020-05-07 23:00:35,572 [Main] INFO [SessionFactory]: Database connection established.
2020-05-07 23:00:35,580 [Main] INFO [IAGrim.StartupService]: There are 35084 items stored in the database.
2020-05-07 23:00:35,580 [Main] INFO [IAGrim.StartupService]: Buddy items is disabled
2020-05-07 23:00:35,580 [Main] INFO [IAGrim.StartupService]: Show recipes as items is disabled
2020-05-07 23:00:35,580 [Main] INFO [IAGrim.StartupService]: Transfer to any mod is disabled
2020-05-07 23:00:35,580 [Main] INFO [IAGrim.StartupService]: Experimental updates is disabled
2020-05-07 23:00:35,588 [Main] INFO [IAGrim.StartupService]: The following transfer files has been found:
2020-05-07 23:00:35,588 [Main] INFO [IAGrim.StartupService]: "C:\Users\Skel\Documents\My Games\Grim Dawn\Save\transfer.gst": Mod: "", HC: False
2020-05-07 23:00:35,588 [Main] INFO [IAGrim.StartupService]: "C:\Users\Skel\Documents\My Games\Grim Dawn\Save\Nydiamar\transfer.gst": Mod: "Nydiamar", HC: False
2020-05-07 23:00:35,588 [Main] INFO [IAGrim.StartupService]: "C:\Users\Skel\Documents\My Games\Grim Dawn\Save\transfer.gsh": Mod: "", HC: True
2020-05-07 23:00:35,588 [Main] INFO [IAGrim.StartupService]: There are items stored for the following mods:
2020-05-07 23:00:35,810 [Main] INFO [IAGrim.StartupService]: Mod: "", HC: False
2020-05-07 23:00:35,810 [Main] INFO [IAGrim.StartupService]: Mod: "", HC: True
2020-05-07 23:00:35,815 [Main] INFO [IAGrim.StartupService]: The path to Grim Dawn is "e:\games\steamgames\steamapps\common\grim dawn"
2020-05-07 23:00:35,815 [Main] INFO [IAGrim.StartupService]: Startup data dump complete
2020-05-07 23:00:35,873 [Main] INFO [IAGrim.Program]: Checking for database updates..
2020-05-07 23:00:35,987 [SQL] ERROR[NHibernate.AdoNet.AbstractBatcher]: Could not execute command: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)

System.Data.SQLite.SQLiteException (0x80004005): constraint failed
NOT NULL constraint failed: deletedplayeritem_v2.Id
   bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
2020-05-07 23:00:35,990 [SQL] WARN [NHibernate.Util.ADOExceptionReporter]: System.Data.SQLite.SQLiteException (0x80004005): constraint failed
NOT NULL constraint failed: deletedplayeritem_v2.Id
   bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   bei NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   bei NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-07 23:00:35,990 [SQL] ERROR[NHibernate.Util.ADOExceptionReporter]: constraint failed
NOT NULL constraint failed: deletedplayeritem_v2.Id
2020-05-07 23:00:35,991 [Main] WARN [IAGrim.Database.Synchronizer.ThreadExecuter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)
]
2020-05-07 23:00:35,992 [Main] WARN [IAGrim.Database.Synchronizer.ThreadExecuter]:    bei NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   bei NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   bei NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   bei IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   bei IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.Run()
2020-05-07 23:00:35,992 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)
]
2020-05-07 23:00:35,993 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]:    bei NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   bei NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   bei NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   bei IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   bei IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   bei IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- Ende der Stapelüberwachung vom vorhergehenden Ort, an dem die Ausnahme ausgelöst wurde ---
   bei IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   bei IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   bei IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   bei IAGrim.Program.Main(String[] args)
2020-05-07 23:00:35,995 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Outer exception: 
2020-05-07 23:00:35,995 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-07 23:00:35,995 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Inner exception: 
2020-05-07 23:00:35,995 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-07 23:00:36,074 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Uploaded crash report to developer.
2020-05-07 23:00:36,075 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
AND azpartition_v2 IS NOT NULL
AND azuuid_v2 IS NOT NULL
	group by UQ
	) x
)
]
2020-05-07 23:00:36,075 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-07 23:00:36,075 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Outer exception: 
2020-05-07 23:00:36,075 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-07 23:00:36,075 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Inner exception: 
2020-05-07 23:00:36,075 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-07 23:00:36,107 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Uploaded crash report to developer.

slipperypete · May 7, 2020, 9:10pm

v1.2.7432.32574
Same link as above.

Hopefully a better fix this time around.

SkeletorOne · May 7, 2020, 9:14pm

Yes, this one works. Thanks for the quick fix!

Garfunkel · May 8, 2020, 10:30am

Just to clarify what I did. I installed Windows 10 instead of my old Win 7. Of course I did a backup (that export.ias file). So I opened GDIA (for the first time on a fresh computer), logged in online with my email, then exported that export.ias file. And many items look like this

Summary

Before that I didn’t have any items in several copies. I always keep only 1 best copy of an item. Now there’re hundreds items in 2-4+ copies. My guess is that GDIA exported items from online and then from export.ias backup. I tried clearing the database (removing all items) and exporting export.ias again but to no avail.

That issue already happened to me after one of updates of GDIA on Windows 7 but then I was able to fix it by clearing the database and exporting the backup file.

By the way same problem happened to Krag ( [Tool] Grim Dawn Item Assistant ) in November.

UPD: Today I updated GDIA to 1.2.7432.32574 version. Did nothing else. Just updated it. And see what the two items I gave the screenshot above now look like

Summary

Now there are 7 (!! ) copies of Jaravuuk’s Bite instead of 4. Why?? I didn’t export anything at all.

spyrosagranitis · May 9, 2020, 9:44am

Item assistant not opening after last upgrade. Has this happened to anyone? Any suggestions? It sucks if I just lost all my items

spyrosagranitis · May 9, 2020, 9:59am

I have the same problem. did you find any solutions?

spyrosagranitis · May 9, 2020, 10:27am

I saw Skeletor one’s solution. That download didn’t work for me. Here’s my log 2020-05-09 13:21:16,085 [Main] INFO [IAGrim.Program]: Starting IA:GD…

2020-05-09 13:21:16,094 [Main] INFO [IAGrim.Program]: Starting exception monitor for bug reports..
2020-05-09 13:21:16,095 [Main] DEBUG[IAGrim.Program]: Crash reports can be seen at http://ribbs.dreamcrash.org/iagd/logs.html
2020-05-09 13:21:16,096 [Main] INFO [IAGrim.StartupService]: Running version 1.2.7432.32574 from 07/05/2020
2020-05-09 13:21:16,098 [Main] DEBUG[IAGrim.Utilities.DependencyChecker]: Checking if .Net Framework v4.52 is installed
2020-05-09 13:21:16,098 [Main] DEBUG[IAGrim.Utilities.DependencyChecker]: Checking if VC++ 2013 Runtimes are installed
2020-05-09 13:21:16,098 [Main] DEBUG[IAGrim.Utilities.DependencyChecker]: Checking if VC++ 2010 Runtimes are installed
2020-05-09 13:21:16,100 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copying missing files / etc to IA storage folder
2020-05-09 13:21:17,422 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copy complete
2020-05-09 13:21:17,422 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copying missing files / etc to IA storage folder
2020-05-09 13:21:18,343 [Main] DEBUG[IAGrim.Utilities.ItemHtmlWriter]: Copy complete
2020-05-09 13:21:18,344 [Main] INFO [IAGrim.Program]: Calling run..
2020-05-09 13:21:18,346 [Main] INFO [IAGrim.Program]: Visual styles enabled..
2020-05-09 13:21:18,541 [SQL] INFO [IAGrim.Database.SessionFactory]: Creating session on thread 6
2020-05-09 13:21:18,542 [SQL] DEBUG[SessionFactory]: Creating session factory
2020-05-09 13:21:19,094 [SQL] DEBUG[SessionFactory]: Building session factory
2020-05-09 13:21:19,449 [SQL] DEBUG[SessionFactory]: Running schema updates
2020-05-09 13:21:19,566 [SQL] INFO [SessionFactory]: Database connection established.
2020-05-09 13:21:19,833 [SQL] DEBUG[IAGrim.Database.Migrations.AddSkillTables]: Executing migration
2020-05-09 13:21:19,872 [SQL] DEBUG[IAGrim.Database.Migrations.AddSkillTables]: Executing migration
2020-05-09 13:21:19,943 [Main] INFO [IAGrim.Program]: Your user id is f200709949d54b19b69d4b44008448a1, use this for any bug reports
2020-05-09 13:21:19,943 [Main] DEBUG[IAGrim.Program]: Updating augment state..
2020-05-09 13:21:20,790 [Main] INFO [IAGrim.StartupService]: IA is configured to loot from the last stash page
2020-05-09 13:21:20,790 [Main] INFO [IAGrim.StartupService]: IA is configured to deposit to the second-to-last stash page
2020-05-09 13:21:20,790 [Main] INFO [IAGrim.Database.SessionFactory]: Creating session on thread 1
2020-05-09 13:21:20,790 [Main] DEBUG[SessionFactory]: Creating session factory
2020-05-09 13:21:20,797 [Main] DEBUG[SessionFactory]: Building session factory
2020-05-09 13:21:20,813 [Main] DEBUG[SessionFactory]: Running schema updates
2020-05-09 13:21:20,883 [Main] INFO [SessionFactory]: Database connection established.
2020-05-09 13:21:20,893 [Main] INFO [IAGrim.StartupService]: There are 5783 items stored in the database.
2020-05-09 13:21:20,893 [Main] INFO [IAGrim.StartupService]: Buddy items is disabled
2020-05-09 13:21:20,893 [Main] INFO [IAGrim.StartupService]: Show recipes as items is disabled
2020-05-09 13:21:20,893 [Main] INFO [IAGrim.StartupService]: Transfer to any mod is disabled
2020-05-09 13:21:20,893 [Main] INFO [IAGrim.StartupService]: Experimental updates is disabled
2020-05-09 13:21:20,904 [Main] INFO [IAGrim.StartupService]: The following transfer files has been found:
2020-05-09 13:21:20,904 [Main] INFO [IAGrim.StartupService]: "C:\Users\spiros\Documents\My Games\Grim Dawn\Save\transfer.gst": Mod: "", HC: False
2020-05-09 13:21:20,904 [Main] INFO [IAGrim.StartupService]: There are items stored for the following mods:
2020-05-09 13:21:21,121 [Main] INFO [IAGrim.StartupService]: Mod: "", HC: False
2020-05-09 13:21:21,127 [Main] INFO [IAGrim.StartupService]: The path to Grim Dawn is "c:\program files (x86)\steam\steamapps\common\grim dawn"
2020-05-09 13:21:21,127 [Main] INFO [IAGrim.StartupService]: Startup data dump complete
2020-05-09 13:21:21,181 [Main] INFO [IAGrim.Program]: Checking for database updates..
2020-05-09 13:21:21,237 [SQL] ERROR[NHibernate.AdoNet.AbstractBatcher]: Could not execute command: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL

System.Data.SQLite.SQLiteException (0x80004005): constraint failed
UNIQUE constraint failed: deletedplayeritem_v2.Id, deletedplayeritem_v2.Partition
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
2020-05-09 13:21:21,241 [SQL] WARN [NHibernate.Util.ADOExceptionReporter]: System.Data.SQLite.SQLiteException (0x80004005): constraint failed
UNIQUE constraint failed: deletedplayeritem_v2.Id, deletedplayeritem_v2.Partition
   at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-09 13:21:21,241 [SQL] ERROR[NHibernate.Util.ADOExceptionReporter]: constraint failed
UNIQUE constraint failed: deletedplayeritem_v2.Id, deletedplayeritem_v2.Partition
2020-05-09 13:21:21,243 [Main] WARN [IAGrim.Database.Synchronizer.ThreadExecuter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL
]
2020-05-09 13:21:21,243 [Main] WARN [IAGrim.Database.Synchronizer.ThreadExecuter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
2020-05-09 13:21:21,244 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL
]
2020-05-09 13:21:21,244 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-09 13:21:21,247 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Outer exception: 
2020-05-09 13:21:21,247 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-09 13:21:21,247 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Inner exception: 
2020-05-09 13:21:21,247 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-09 13:21:21,476 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Uploaded crash report to developer.
2020-05-09 13:21:21,477 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]: could not execute native bulk manipulation query:
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL
[SQL: 
insert into deletedplayeritem_v2(id,partition)
select azpartition_v2, azuuid_v2 FROM playeritem WHERE ID NOT IN (
SELECT id FROM (
	SELECT COUNT(*) c, baserecord || prefixrecord || modifierrecord || suffixrecord || materiarecord || transmuterecord || seed as UQ, * FROM PlayerItem
	WHERE StackCount < 2
	AND baserecord NOT LIKE '%materia%'
	AND baserecord NOT LIKE '%questitems%'
	AND baserecord NOT LIKE '%potions%'
	AND baserecord NOT LIKE '%crafting%'
	group by UQ
	) x 
) AND azpartition_v2 IS NOT NULL AND azuuid_v2 IS NOT NULL
]
2020-05-09 13:21:21,477 [Main] FATAL[EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-09 13:21:21,478 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Outer exception: 
2020-05-09 13:21:21,478 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
   at NHibernate.Impl.SessionImpl.ExecuteNativeUpdate(NativeSQLQuerySpecification nativeQuerySpecification, QueryParameters queryParameters)
   at NHibernate.Impl.SqlQueryImpl.ExecuteUpdate()
   at IAGrim.Database.PlayerItemDaoImpl.DeleteDuplidates()
   at IAGrim.Database.Synchronizer.PlayerItemRepo.<DeleteDuplidates>b__11_0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.<>c__DisplayClass8_0.<Execute>b__0()
   at IAGrim.Database.Synchronizer.ThreadExecuter.Run()
--- End of stack trace from previous location where exception was thrown ---
   at IAGrim.Database.Synchronizer.ThreadExecuter.Execute(Action func, Int32 timeout)
   at IAGrim.Database.Synchronizer.PlayerItemRepo.DeleteDuplidates()
   at IAGrim.Program.Run(String[] args, ThreadExecuter threadExecuter)
   at IAGrim.Program.Main(String[] args)
2020-05-09 13:21:21,478 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Inner exception: 
2020-05-09 13:21:21,478 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]:    at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
   at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
   at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(DbCommand cmd)
   at NHibernate.Engine.Query.NativeSQLQueryPlan.PerformExecuteUpdate(QueryParameters queryParameters, ISessionImplementor session)
2020-05-09 13:21:21,580 [Main] INFO [EvilsoftCommons.Exceptions.ExceptionReporter]: Uploaded crash report to developer.

slipperypete · May 9, 2020, 2:03pm

I’ll get a fix out within the next hour or so =)

For emergencies, just downgrade to the version on the website.

spyrosagranitis · May 9, 2020, 2:14pm

Thanks for the quick reply and action!!!

Steve_T · May 9, 2020, 2:41pm

GDIA just had an automatic update kept giving me the cancel retry ignore option for various files kept hitting retry to no avail so I tried the ignore then just canceled. My question is should GDIA be closed after auto update starts and is this update needed as in is this a QOL update or a real fix?