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