arithmetic exception, numeric overflow, or string truncation

[Guest]

I have used clrmamepro in the past. My new set I have 120 split is complete with clrmamepro. But for the life of my I can fix my CHD set. I know all of the files are good just not in the right directories.

So this brings me to romcenter as it seems much easier to use. I have the dat's up to date and I pointed the rom path to my correct good verified sets. Although it shows all files missing. I dont see any walk trues around here but dont think it is needed since this romcenter is so well organized. Yet, I show no roms from a good known working set?

help?

[RomCenter]

Hello

Please try with the alpha 6 version. It is more accurate than rc2 with the latest mame builds.

Tell me if you succeed.

[Guest]

I tried with 3.00 6 (77) and I read in the dat files then added a rom folder. After that point I get...

Add rom path [R:\temp\]
Loading 184 files in DB
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : arithmetic exception, numeric overflow, or string truncation
erreur : Impossible d'ouvrir le fichier "R:\temp\845jaa02.chd". The process cannot access the file because it is being used by another process
erreur : Impossible d'ouvrir le fichier "R:\temp\845jab02.chd". The
process cannot access the file because it is being used by another process
...

[RomCenter]

Ok, this error is back

Here is a special debug build of rc3a6to track this error (not available on my pc). This error is quite hard to analyse because it depends of character sets, country, file date format etc...
Please, rename your current romcenter.exe, and extract the new one at the same place.
Run rc3 and import the same rom path. A lot more message should appear in the message window. Then, paste a part of the messages (where the error appears) in the forum.(If some other peoples have same problems, they are also welcome to do the same.)

Thank you for helping.

[Guest]

=============================================
Welcome to RomCenter 3.00 alpha 6 (77)
Template database version = 3.0076
Client db: WI-V6.3.3.12981 Firebird 2.0
MAME SuperSet v0.120 (Split-merged MAME Supplement) database version = 3.0076
Loading gameslist
173 games loaded.
Updating games status
Status updated for 173 items.
Updating fileslist
Done
Add new rom path
Add rom path [R:\temp\]
Loading 184 files in DB
file:33s000.chd, date:929528279, datetime:11/7/2007 3:14:46 PM
insert into filestmp(pathname,pathtype,filename,fileformat,filedate,filesize,filetype,romname,romext,pluginext,romdate,romsize,romsig,volumename,volumeserial,error) values('R:\temp\','roms','33s000','.chd','2007-11-07 15:14:46',67850966,null,'33s000.chd','.chd','','2007-11-07 15:14:46',67850966,'47c7ae0f2dc47c7d28bdf66d378a3aaba4c99c75','roms and games','246A-765E','')

erreur : arithmetic exception, numeric overflow, or string truncation
file:3ga000.chd, date:929523396, datetime:11/7/2007 12:54:08 PM
insert into filestmp(pathname,pathtype,filename,fileformat,filedate,filesize,filetype,romname,romext,pluginext,romdate,romsize,romsig,volumename,volumeserial,error) values('R:\temp\','roms','3ga000','.chd','2007-11-07 12:54:08',43246653,null,'3ga000.chd','.chd','','2007-11-07 12:54:08',43246653,'76e9fdef020c4b85a10aa8828a63e67c7dca22bd','roms and games','246A-765E','')

erreur : arithmetic exception, numeric overflow, or string truncation
file:420uaa04.chd, date:929511492, datetime:11/7/2007 7:02:08 AM
insert into filestmp(pathname,pathtype,filename,fileformat,filedate,filesize,filetype,romname,romext,pluginext,romdate,romsize,romsig,volumename,volumeserial,error) values('R:\temp\','roms','420uaa04','.chd','2007-11-07 07:02:08',186689704,null,'420uaa04.chd','.chd','','2007-11-07 07:02:08',186689704,'18fe867c44982bacf0d3ff8453487cd06425a6b7','roms and games','246A-765E','')

erreur : arithmetic exception, numeric overflow, or string truncation
file:623jaa02.chd, date:929527910, datetime:11/7/2007 3:03:12 PM
insert into filestmp(pathname,pathtype,filename,fileformat,filedate,filesize,filetype,romname,romext,pluginext,romdate,romsize,romsig,volumename,volumeserial,error) values('R:\temp\','roms','623jaa02','.chd','2007-11-07 15:03:12',142414060,null,'623jaa02.chd','.chd','','2007-11-07 15:03:12',142414060,'a7dc6086d0244b5472f61b41992623c7a9dc2e9c','roms and games','246A-765E','')

...

[RomCenter]

This is fixed.
The device ID value was limited to 10 char long.

[ulaoulao]

Hey it's me!, I'm registered. good old programming short comings I do it my self to often. So were is the fix?

[RomCenter]

Welcome. Thank you for registering.

Be patient !
I have some other things to finish before posting the new version.

[ulaoulao]

understood.

[RomCenter]

Expect a new wip release by the end of the week.

[opjose]

With the latest 3.00 Beta 1 I'm getting:

--->Import missing roms
File zoom909.zip
epr-5211.prom-ic74 imported from C:\Program Files\Mame\roms\buckrog.zip\epr-5208.prom-ic58
arithmetic exception, numeric overflow, or string truncation
At procedure 'P_CREATEFILEROM'
--->End fixing

[RomCenter]

Yes, I already noticed that by myself. It happens when the rom has an extension of 9 char.
It is fixed in the next released.

Thank your for reporting