GamesView selectionchanged: 0 items removed, 1 items added, item area51t selected4365182 GamesView: Focus item area51t4365183 GameRomsView selectionchanged: 0 items removed, 1 items added, item 136105-0003c.3h selected4365184 Save window size in Properties.Settings4365185 Command 'RequestShutDown' launched4365186 Save romcenter settings to C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config4365187 Close all databases4365188 Close mame20104365189 Create view models6 View models created7 Settings loaded from C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config8 create dir C:\ProgramData\romcenter\9 create dir C:\Users\Ben Melluish\AppData\Local\Temp\romcenter\10 create dir D:\RomCenter\backups\11 create dir D:\Programs\romcenter32_4.0.0\plugin\12 D:\Programs\romcenter32_4.0.0\firebird32\fbclient.dll version 2.5.8.2708913 EntityFramework.Firebird.dll version 5.12.1.014 FirebirdSql.Data.FirebirdClient.dll version 5.12.1.015 7z.dll version 18.05 32b16 Template database version = 4.041517 Welcome to RomCenter 4.0.0.4046119 Log saved to C:\ProgramData\romcenter\romcenter_xml.log20 Os: 64-bits, Romcenter: 32-bits21 Initializing...22 Save romcenter settings to C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config23 Check for a new version...24 Add database 'mame2010'25 Create view models26 View models created27 Ready28 Memory usage: 6MB29 Restore window size from Properties.Settings30 Adding 2 sub menus in Game Info menu31 Rc versions: Current :4.0.0, latest :4.0.s032 Create database33 Dat in Mame070 format34 Loading games from mame2015.xml35 Mame xml datafile loaded.36 Analysing 30906 games37 Detect plugin38 Creating new database mame2015 from datafile mame2015.xml39 Copy Database template40 Set database to read/write41 Shell Input: chcp 65001 > nul "D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt"42 Shell Ouput: C:\Users\Ben Melluish\AppData\Local\Temp>chcp 65001 1>nul C:\Users\Ben Melluish\AppData\Local\Temp>"D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt" 43 Wait for file C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_a5ocvb3guuk.cmd to be released44 File C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_a5ocvb3guuk.cmd released45 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released46 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released47 Filter used: { "KeepAll": true, "SourceFiles": [], "KeepClone": true, "KeepSamples": true, "KeepDisks": true, "KeepBadDumps": true, "KeepNoDumps": true, "KeepGood": true, "KeepVerified": true, "ExcludeMechanical": false, "ExcludeSlots": false, "ExcludeEmptyGames": false, "OnlyBiosAndDevices": false, "ExcludePreliminary": false, "ExcludeImperfect": false, "ExcludeUselessRoms": false, "DescContains": "", "Releases": { "UseReleases": false, "OneGameOneRom": true, "KeepPClRelation": false, "Regions": [] } }48 Clear all firebird pools49 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released50 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released51 Datafile already loaded52 Splitting lists53 No filter used54 30906 games to import55 Loading rom for 30906 games.56 Reading 648114 rom...57 Split in 4 lists58 Importing 648114 rom...59 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp5E24.tmp...60 File tmp5E24.tmp created61 Importing table DATAFILETMPEXTtmp5E24...62 Drop table DATAFILETMPEXTtmp5E2463 Delete file tmp5E24.tmp64 Done with tmp5E24.tmp65 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpD2B9.tmp...66 File tmpD2B9.tmp created67 Importing table DATAFILETMPEXTtmpD2B9...68 Drop table DATAFILETMPEXTtmpD2B969 Delete file tmpD2B9.tmp70 Done with tmpD2B9.tmp71 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp43F2.tmp...72 File tmp43F2.tmp created73 Importing table DATAFILETMPEXTtmp43F2...74 Drop table DATAFILETMPEXTtmp43F275 Delete file tmp43F2.tmp76 Done with tmp43F2.tmp77 Adding 108114 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpB7EB.tmp...78 File tmpB7EB.tmp created79 Importing table DATAFILETMPEXTtmpB7EB...80 Drop table DATAFILETMPEXTtmpB7EB81 Delete file tmpB7EB.tmp82 Done with tmpB7EB.tmp83 648114 items imported84 Apply custom romcenter settings85 save config86 Rebuilding and reordering database. Please wait...87 Analysing rom...88 Pass 1/989 Execution time: 00:0090 Pass 2/991 Execution time: 00:5892 Pass 3/993 Execution time: 00:4194 Pass 4/995 Execution time: 00:0396 Pass 5/997 Execution time: 00:0198 Pass 6/999 Execution time: 00:30100 Pass 7/9101 Execution time: 00:20102 Pass 8/9103 RomCenter.DataAccess.Firebird.EF5.Entities/ExecuteStoreCommand : execute procedure P_LOADDATAFILE(8)104 RomCenter.Logic.ViewModel.MainViewModel+<>c__DisplayClass81_0/<CreateDatabaseAsync>b__0 : violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1FirebirdSql.Data.FirebirdClient.FbException (0x80004005): violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 ---> violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.<CreateDatabaseAsync>b__0() violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.b__0()]]>105 Duration: 00:05:27106 Ready107 Tab mame2010 displayed108 Loading mame2010109 Refreshing DB start110 Loading games111 Loading games collection...112 Add 8835 GameItem113 8835 items added114 Load games : 00:00:03.9972102115 Loading files collection...116 Add 8797 FileItem117 8797 items added118 Load files : 00:00:05.0344910119 Refreshing DB done120 Resync view: file null121 Add 7 TreeItem122 7 items added123 TreeView Item 'Rom files' expanded124 TreeView Item 'Root' expanded125 Add 2 TreeItem126 2 items added127 Updating display...128 TreeView Item 'All games' selected129 Show master view GamesViewModel130 Master View update disabled131 Games view: Update with tree item 'All games'132 Find a game to select for item 'null'133 Game '005' found for selection134 Master View update enabled135 GamesViewModel view: item '005' selected136 Datagrid update: Update roms for game '005'138 Duration: 00:00:11137 Gameroms view: update with game 005139 Add 30 GameRomItem140 30 items added141 GamesViewModel view: item '005' selected142 GamesView selectionchanged: 0 items removed, 1 items added, item 005 selected143 Ready145 Show detail view GameromsViewModel144 Datagrid update: Update roms for game '005'146 Gameroms view: update with game 005147 GamesView: Focus item 005148 GameRomsView selectionchanged: 0 items removed, 1 items added, item 1346b.cpu-u25 selected149 Create database150 Dat in Mame070 format151 Loading games from mame2015.xml152 Mame xml datafile loaded.153 Analysing 30906 games154 Detect plugin155 Creating new database mame2015 from datafile mame2015.xml156 Copy Database template157 Set database to read/write158 Shell Input: chcp 65001 > nul "D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt"159 Shell Ouput: C:\Users\Ben Melluish\AppData\Local\Temp>chcp 65001 1>nul C:\Users\Ben Melluish\AppData\Local\Temp>"D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt" 160 Wait for file C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_mgeei4nujyq.cmd to be released161 File C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_mgeei4nujyq.cmd released162 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released163 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released164 Filter used: { "KeepAll": true, "SourceFiles": [], "KeepClone": true, "KeepSamples": true, "KeepDisks": true, "KeepBadDumps": true, "KeepNoDumps": true, "KeepGood": true, "KeepVerified": true, "ExcludeMechanical": false, "ExcludeSlots": false, "ExcludeEmptyGames": false, "OnlyBiosAndDevices": false, "ExcludePreliminary": false, "ExcludeImperfect": false, "ExcludeUselessRoms": false, "DescContains": "", "Releases": { "UseReleases": false, "OneGameOneRom": true, "KeepPClRelation": false, "Regions": [] } }165 Clear all firebird pools166 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released167 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released168 Datafile already loaded169 Splitting lists170 No filter used171 30906 games to import172 Loading rom for 30906 games.173 Reading 648114 rom...174 Split in 4 lists175 Importing 648114 rom...176 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpAFAB.tmp...177 File tmpAFAB.tmp created178 Importing table DATAFILETMPEXTtmpAFAB...179 Drop table DATAFILETMPEXTtmpAFAB180 Delete file tmpAFAB.tmp181 Done with tmpAFAB.tmp182 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp1C70.tmp...183 File tmp1C70.tmp created184 Importing table DATAFILETMPEXTtmp1C70...185 Drop table DATAFILETMPEXTtmp1C70186 Delete file tmp1C70.tmp187 Done with tmp1C70.tmp188 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp8A4E.tmp...189 File tmp8A4E.tmp created190 Importing table DATAFILETMPEXTtmp8A4E...191 Drop table DATAFILETMPEXTtmp8A4E192 Delete file tmp8A4E.tmp193 Done with tmp8A4E.tmp194 Adding 108114 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp6E2.tmp...195 File tmp6E2.tmp created196 Importing table DATAFILETMPEXTtmp6E2...197 Drop table DATAFILETMPEXTtmp6E2198 Delete file tmp6E2.tmp199 Done with tmp6E2.tmp200 648114 items imported201 Apply custom romcenter settings202 save config203 Rebuilding and reordering database. Please wait...204 Analysing rom...205 Pass 1/9206 Execution time: 00:00207 Pass 2/9208 Execution time: 01:00209 Pass 3/9210 Execution time: 00:44211 Pass 4/9212 Execution time: 00:02213 Pass 5/9214 Execution time: 00:01215 Pass 6/9216 Execution time: 00:31217 Pass 7/9218 Execution time: 00:20219 Pass 8/9220 RomCenter.DataAccess.Firebird.EF5.Entities/ExecuteStoreCommand : execute procedure P_LOADDATAFILE(8)221 RomCenter.Logic.ViewModel.MainViewModel+<>c__DisplayClass81_0/<CreateDatabaseAsync>b__0 : violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1FirebirdSql.Data.FirebirdClient.FbException (0x80004005): violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 ---> violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.<CreateDatabaseAsync>b__0() violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.b__0()]]>222 Duration: 00:06:37223 Ready224 Create database225 Dat in Mame070 format226 Loading games from MAME 0.160.xml227 Mame xml datafile loaded.228 Analysing 30906 games229 Detect plugin230 Creating new database MAME 0.160 from datafile MAME 0.160.xml231 Copy Database template232 Set database to read/write233 Shell Input: chcp 65001 > nul "D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\MAME 0.160.rdt"234 Shell Ouput: C:\Users\Ben Melluish\AppData\Local\Temp>chcp 65001 1>nul C:\Users\Ben Melluish\AppData\Local\Temp>"D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\MAME 0.160.rdt" 235 Wait for file C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_xnep2xegjx1.cmd to be released236 File C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_xnep2xegjx1.cmd released237 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\MAME 0.160.rdt to be released238 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\MAME 0.160.rdt released239 Filter used: { "KeepAll": true, "SourceFiles": [], "KeepClone": true, "KeepSamples": true, "KeepDisks": true, "KeepBadDumps": true, "KeepNoDumps": true, "KeepGood": true, "KeepVerified": true, "ExcludeMechanical": false, "ExcludeSlots": false, "ExcludeEmptyGames": false, "OnlyBiosAndDevices": false, "ExcludePreliminary": false, "ExcludeImperfect": false, "ExcludeUselessRoms": false, "DescContains": "", "Releases": { "UseReleases": false, "OneGameOneRom": true, "KeepPClRelation": false, "Regions": [] } }240 Clear all firebird pools241 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\MAME 0.160.rdt to be released242 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\MAME 0.160.rdt released243 Datafile already loaded244 Splitting lists245 No filter used246 30906 games to import247 Loading rom for 30906 games.248 Reading 648114 rom...249 Split in 4 lists250 Importing 648114 rom...251 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpE921.tmp...252 File tmpE921.tmp created253 Importing table DATAFILETMPEXTtmpE921...254 Drop table DATAFILETMPEXTtmpE921255 Delete file tmpE921.tmp256 Done with tmpE921.tmp257 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp5AF7.tmp...258 File tmp5AF7.tmp created259 Importing table DATAFILETMPEXTtmp5AF7...260 Drop table DATAFILETMPEXTtmp5AF7261 Delete file tmp5AF7.tmp262 Done with tmp5AF7.tmp263 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpCC50.tmp...264 File tmpCC50.tmp created265 Importing table DATAFILETMPEXTtmpCC50...266 Drop table DATAFILETMPEXTtmpCC50267 Delete file tmpCC50.tmp268 Done with tmpCC50.tmp269 Adding 108114 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp40C5.tmp...270 File tmp40C5.tmp created271 Importing table DATAFILETMPEXTtmp40C5...272 Drop table DATAFILETMPEXTtmp40C5273 Delete file tmp40C5.tmp274 Done with tmp40C5.tmp275 648114 items imported276 Apply custom romcenter settings277 save config278 Rebuilding and reordering database. Please wait...279 Analysing rom...280 Pass 1/9281 Execution time: 00:00282 Pass 2/9283 Execution time: 00:56284 Pass 3/9285 Execution time: 00:40286 Pass 4/9287 Execution time: 00:02288 Pass 5/9289 Execution time: 00:01290 Pass 6/9291 Execution time: 00:30292 Pass 7/9293 Execution time: 00:20294 Pass 8/9295 RomCenter.DataAccess.Firebird.EF5.Entities/ExecuteStoreCommand : execute procedure P_LOADDATAFILE(8)296 RomCenter.Logic.ViewModel.MainViewModel+<>c__DisplayClass81_0/<CreateDatabaseAsync>b__0 : violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1FirebirdSql.Data.FirebirdClient.FbException (0x80004005): violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 ---> violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.<CreateDatabaseAsync>b__0() violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.b__0()]]>297 Duration: 00:05:13298 Ready299 Save window size in Properties.Settings300 Command 'RequestShutDown' launched301 Save romcenter settings to C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config302 Close all databases303 Close mame2010304 GamesViewModel view: item 'null' selected305 Gameroms view: No game selected, clear306 Clear all GameItem (8835)307 Gameroms list: No games selected, clear list308 GamesViewModel view: item 'null' selected309 Gameroms view: No game selected, clear310 GamesView selectionchanged: 1 items removed, 0 items added, item null selected311 Clear all FileItem (8797)312 Clear all firebird pools313 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2010.rdt to be released314 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2010.rdt released315 Tab Welcome displayed316 RomCenter.Logic.Model.DataManager/CloseRomCenter : Memory usage: 6MB -> 63MB (+57MB)317 ===> Romcenter Shutdown318 319 GameRomsView selectionchanged: 1 items removed, 0 items added, item null selected320 Ready321 Create view models6 View models created7 Settings loaded from C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config8 create dir C:\ProgramData\romcenter\9 create dir C:\Users\Ben Melluish\AppData\Local\Temp\romcenter\10 create dir D:\RomCenter\backups\11 create dir D:\Programs\romcenter32_4.0.0\plugin\12 D:\Programs\romcenter32_4.0.0\firebird32\fbclient.dll version 2.5.8.2708913 EntityFramework.Firebird.dll version 5.12.1.014 FirebirdSql.Data.FirebirdClient.dll version 5.12.1.015 7z.dll version 18.05 32b16 Template database version = 4.041517 Welcome to RomCenter 4.0.0.4046119 Log saved to C:\ProgramData\romcenter\romcenter_xml.log20 Os: 64-bits, Romcenter: 32-bits21 Initializing...22 Save romcenter settings to C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config23 Check for a new version...24 Add database 'mame2010'25 Create view models26 View models created27 Ready28 Memory usage: 6MB29 Restore window size from Properties.Settings30 Adding 2 sub menus in Game Info menu31 Rc versions: Current :4.0.0, latest :4.0.s032 Command 'OpenDatabase' launched33 Create database34 Dat in Mame070 format35 Loading games from mame2015.xml36 Mame xml datafile loaded.37 Analysing 30906 games38 Detect plugin39 Creating new database mame2015 from datafile mame2015.xml40 Copy Database template41 Set database to read/write42 Shell Input: chcp 65001 > nul "D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt"43 Shell Ouput: C:\Users\Ben Melluish\AppData\Local\Temp>chcp 65001 1>nul C:\Users\Ben Melluish\AppData\Local\Temp>"D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt" 44 Wait for file C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_inlu0zn0pr4.cmd to be released45 File C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_inlu0zn0pr4.cmd released46 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released47 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released48 Filter used: { "KeepAll": true, "SourceFiles": [], "KeepClone": true, "KeepSamples": true, "KeepDisks": true, "KeepBadDumps": true, "KeepNoDumps": true, "KeepGood": true, "KeepVerified": true, "ExcludeMechanical": false, "ExcludeSlots": false, "ExcludeEmptyGames": false, "OnlyBiosAndDevices": false, "ExcludePreliminary": false, "ExcludeImperfect": false, "ExcludeUselessRoms": false, "DescContains": "", "Releases": { "UseReleases": false, "OneGameOneRom": true, "KeepPClRelation": false, "Regions": [] } }49 Clear all firebird pools50 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released51 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released52 Datafile already loaded53 Splitting lists54 No filter used55 30906 games to import56 Loading rom for 30906 games.57 Reading 648114 rom...58 Split in 4 lists59 Importing 648114 rom...60 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp9838.tmp...61 File tmp9838.tmp created62 Importing table DATAFILETMPEXTtmp9838...63 Drop table DATAFILETMPEXTtmp983864 Delete file tmp9838.tmp65 Done with tmp9838.tmp66 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp73F.tmp...67 File tmp73F.tmp created68 Importing table DATAFILETMPEXTtmp73F...69 Drop table DATAFILETMPEXTtmp73F70 Delete file tmp73F.tmp71 Done with tmp73F.tmp72 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp7636.tmp...73 File tmp7636.tmp created74 Importing table DATAFILETMPEXTtmp7636...75 Drop table DATAFILETMPEXTtmp763676 Delete file tmp7636.tmp77 Done with tmp7636.tmp78 Adding 108114 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpE33A.tmp...79 File tmpE33A.tmp created80 Importing table DATAFILETMPEXTtmpE33A...81 Drop table DATAFILETMPEXTtmpE33A82 Delete file tmpE33A.tmp83 Done with tmpE33A.tmp84 648114 items imported85 Apply custom romcenter settings86 save config87 Rebuilding and reordering database. Please wait...88 Analysing rom...89 Pass 1/990 Execution time: 00:0091 Pass 2/992 Execution time: 00:5793 Pass 3/994 Execution time: 00:3795 Pass 4/996 Execution time: 00:0297 Pass 5/998 Execution time: 00:0199 Pass 6/9100 Execution time: 00:28101 Pass 7/9102 Execution time: 00:18103 Pass 8/9104 RomCenter.DataAccess.Firebird.EF5.Entities/ExecuteStoreCommand : execute procedure P_LOADDATAFILE(8)105 RomCenter.Logic.ViewModel.MainViewModel+<>c__DisplayClass81_0/<CreateDatabaseAsync>b__0 : violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1FirebirdSql.Data.FirebirdClient.FbException (0x80004005): violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 ---> violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.<CreateDatabaseAsync>b__0() violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.b__0()]]>106 Duration: 00:05:10107 Ready108 Save window size in Properties.Settings109 Command 'RequestShutDown' launched110 Save romcenter settings to C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config111 Close all databases112 Memory usage: 6MB -> 12MB (+6MB)113 ===> Romcenter Shutdown114 115 Create view models6 View models created7 Settings loaded from C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config8 create dir C:\ProgramData\romcenter\9 create dir C:\Users\Ben Melluish\AppData\Local\Temp\romcenter\10 create dir D:\RomCenter\backups\11 create dir D:\Programs\romcenter32_4.0.0\plugin\12 D:\Programs\romcenter32_4.0.0\firebird32\fbclient.dll version 2.5.8.2708913 EntityFramework.Firebird.dll version 5.12.1.014 FirebirdSql.Data.FirebirdClient.dll version 5.12.1.015 7z.dll version 18.05 32b16 Template database version = 4.041517 Welcome to RomCenter 4.0.0.4046119 Log saved to C:\ProgramData\romcenter\romcenter_xml.log20 Os: 64-bits, Romcenter: 32-bits21 Initializing...22 Save romcenter settings to C:\Users\Ben Melluish\AppData\Local\RomCenter\RomCenter.exe_Url_dkmp4el152i5lkgq1qqpyntmla4ac5fx\4.0.0.40462\user.config23 Check for a new version...24 Add database 'mame2010'25 Create view models26 View models created27 Ready28 Memory usage: 6MB29 Restore window size from Properties.Settings30 Adding 2 sub menus in Game Info menu31 Rc versions: Current :4.0.0, latest :4.0.s032 Tab mame2010 displayed33 Loading mame201034 Refreshing DB start35 Loading games36 Loading games collection...37 Add 8835 GameItem38 8835 items added39 Load games : 00:00:03.114609740 Loading files collection...41 Add 8797 FileItem42 8797 items added43 Load files : 00:00:02.060739544 Refreshing DB done45 Resync view: file null46 Add 7 TreeItem47 7 items added48 TreeView Item 'Rom files' expanded49 TreeView Item 'Root' expanded50 Add 2 TreeItem51 2 items added52 Updating display...53 TreeView Item 'All games' selected54 Show master view GamesViewModel55 Master View update disabled56 Games view: Update with tree item 'All games'57 Find a game to select for item 'null'58 Game '005' found for selection59 Master View update enabled60 GamesViewModel view: item '005' selected61 Datagrid update: Update roms for game '005'62 Duration: 00:00:0663 Gameroms view: update with game 00564 Add 30 GameRomItem65 30 items added66 Show detail view GameromsViewModel68 Ready67 GamesView selectionchanged: 0 items removed, 1 items added, item 005 selected69 GamesView: Focus item 00570 GameRomsView selectionchanged: 0 items removed, 1 items added, item 1346b.cpu-u25 selected71 Create database72 Dat in Mame070 format73 Loading games from mame2015.xml74 Mame xml datafile loaded.75 Analysing 30906 games76 Detect plugin77 Creating new database mame2015 from datafile mame2015.xml78 Copy Database template79 Set database to read/write80 Shell Input: chcp 65001 > nul "D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt"81 Shell Ouput: C:\Users\Ben Melluish\AppData\Local\Temp>chcp 65001 1>nul C:\Users\Ben Melluish\AppData\Local\Temp>"D:\Programs\romcenter32_4.0.0\firebird32\gfix.exe" -user *** -password *** -mode read_write "D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt" 82 Wait for file C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_v1ivlmfyuus.cmd to be released83 File C:\Users\Ben Melluish\AppData\Local\Temp\rc_update_v1ivlmfyuus.cmd released84 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released85 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released86 Filter used: { "KeepAll": true, "SourceFiles": [], "KeepClone": true, "KeepSamples": true, "KeepDisks": true, "KeepBadDumps": true, "KeepNoDumps": true, "KeepGood": true, "KeepVerified": true, "ExcludeMechanical": false, "ExcludeSlots": false, "ExcludeEmptyGames": false, "OnlyBiosAndDevices": false, "ExcludePreliminary": false, "ExcludeImperfect": false, "ExcludeUselessRoms": false, "DescContains": "", "Releases": { "UseReleases": false, "OneGameOneRom": true, "KeepPClRelation": false, "Regions": [] } }87 Clear all firebird pools88 Wait for file D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt to be released89 File D:\Cloud Storage\SynologyDrive\RomCenter Databases\mame2015.rdt released90 Datafile already loaded91 Splitting lists92 No filter used93 30906 games to import94 Loading rom for 30906 games.95 Reading 648114 rom...96 Split in 4 lists97 Importing 648114 rom...98 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp2895.tmp...99 File tmp2895.tmp created100 Importing table DATAFILETMPEXTtmp2895...101 Drop table DATAFILETMPEXTtmp2895102 Delete file tmp2895.tmp103 Done with tmp2895.tmp104 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp9143.tmp...105 File tmp9143.tmp created106 Importing table DATAFILETMPEXTtmp9143...107 Drop table DATAFILETMPEXTtmp9143108 Delete file tmp9143.tmp109 Done with tmp9143.tmp110 Adding 180000 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmpFC04.tmp...111 File tmpFC04.tmp created112 Importing table DATAFILETMPEXTtmpFC04...113 Drop table DATAFILETMPEXTtmpFC04114 Delete file tmpFC04.tmp115 Done with tmpFC04.tmp116 Adding 108114 rom into C:\Users\Ben Melluish\AppData\Local\Temp\tmp6697.tmp...117 File tmp6697.tmp created118 Importing table DATAFILETMPEXTtmp6697...119 Drop table DATAFILETMPEXTtmp6697120 Delete file tmp6697.tmp121 Done with tmp6697.tmp122 648114 items imported123 Apply custom romcenter settings124 save config125 Rebuilding and reordering database. Please wait...126 Analysing rom...127 Pass 1/9128 Execution time: 00:00129 Pass 2/9130 Execution time: 00:53131 Pass 3/9132 Execution time: 00:39133 Pass 4/9134 Execution time: 00:02135 Pass 5/9136 Execution time: 00:01137 Pass 6/9138 Execution time: 00:30139 Pass 7/9140 Execution time: 00:20141 Pass 8/9142 RomCenter.DataAccess.Firebird.EF5.Entities/ExecuteStoreCommand : execute procedure P_LOADDATAFILE(8)143 RomCenter.Logic.ViewModel.MainViewModel+<>c__DisplayClass81_0/<CreateDatabaseAsync>b__0 : violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1FirebirdSql.Data.FirebirdClient.FbException (0x80004005): violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 ---> violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<NonQuery>b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.<ExecuteStoreCommand>b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.<CreateDatabaseAsync>b__0() violation of PRIMARY or UNIQUE KEY constraint "INTEG_66" on table "FILEGAMES" Problematic key value is ("GAMEID" = 1312, "GAMEROMID" = 237771) At procedure 'P_FG_UPDATEFILEGAMES' line: 209, col: 1 At procedure 'P_LOADDATAFILE' line: 333, col: 1 at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.b__0(DbCommand t, DbCommandInterceptionContext`1 c) at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__21() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass22.b__20() at System.Data.Entity.Infrastructure.DefaultExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(TransactionalBehavior transactionalBehavior, String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommand(String commandText, Object[] parameters) at RomCenter.DataAccess.Firebird.EF5.Entities.ExecuteStoreCommand(String command) in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 112 at RomCenter.DataAccess.Firebird.EF5.Entities.P_LOADDATAFILES() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\Entities.cs:line 194 at RomCenter.DataAccess.Firebird.EF5.Ef.BuildDatabase() in C:\Projects\Romcenter\DataAccess\Firebird\EF5\EF.cs:line 1351 at RomCenter.Logic.Model.RwDatabase.ImportDat(DatReader datReader, IRdtConfigUser rdtConfig, FilterOptions datFilter) at RomCenter.Logic.Model.DataManager.CreateDatabase(DatReader datReader, String dstDbFilename, IRdtConfigUser dbsettings, FilterOptions datFilter) at RomCenter.Logic.ViewModel.MainViewModel.<>c__DisplayClass81_0.b__0()]]>144 Duration: 00:22:15145 Ready146