Page 1 of 1

Error: execute procedure P_LOADDATAFILE(3)

Posted: Mon Nov 27, 2017 7:13 pm
by Proffix
rcerr.jpg
rcerr.jpg (28.68 KiB) Viewed 48228 times
Is it Possible to repair this?

Loading games from A800new2.dat
Analysing 4738 games
Creating new database A800new2 from datafile A800new2.dat
Copy Database template
4738 games to import
Loading roms for 4738 games.
Importing 4738 roms
Rebuilding and reordering database. Please wait...
Analysing roms...
Error: execute procedure P_LOADDATAFILE(3)
Error: validation error for column "ROMS"."ROMSIZE", value "*** null ***"
At procedure 'P_GR_TRANSFERTGAMEROMS' line: 144, col: 7
At procedure 'P_LOADDATAFILE' line: 342, col: 1
Duration: 00:01:29
Ready

Re: Error: execute procedure P_LOADDATAFILE(3)

Posted: Mon Nov 27, 2017 11:02 pm
by Wanderer
Hi there.
Proffix wrote:
Mon Nov 27, 2017 7:13 pm
Is it Possible to repair this?
Well, it might be, but we probably won't find out until you post the data file. ;)

There seems to be either an error in the datafile or something that RC does not support. Post it here, it would help Eric find out what's causing this message.

Re: Error: execute procedure P_LOADDATAFILE(3)

Posted: Tue Nov 28, 2017 6:47 am
by Proffix
Oh i forgot that, its the same like when i send an email with an attachement :)

Re: Error: execute procedure P_LOADDATAFILE(3)

Posted: Sat Dec 02, 2017 3:28 pm
by RomCenter
Thank you for the report. I will have a look at the dat and fix the problem.

Re: Error: execute procedure P_LOADDATAFILE(3)

Posted: Sat Dec 09, 2017 8:34 am
by RomCenter
Hi
There is a trailing space char in one game name. This cause the problem in romcenter.
This will be fixed in next release.
Until then, you can edit the dat, look for 'Abuse v2.9 ' and remove the trailing space.

Code: Select all

game (
	name "Abuse v2.9"
	description "Abuse v2.9"
	rom ( name "Abuse v2.9.atr" size 92176 crc c6339b34 md5 25636ddd06de015cac543178341392cb )
)

Re: Error: execute procedure P_LOADDATAFILE(3)

Posted: Thu Dec 14, 2017 11:33 am
by Proffix
Ah ok thanks.

should i send the complete crash reports (abot 1gb) to you or can i delete that?

Re: Error: execute procedure P_LOADDATAFILE(3)

Posted: Fri Dec 22, 2017 8:09 pm
by RomCenter
You can delete. The bug is fixed in next release.