Error: execute procedure P_LOADDATAFILE(3)

Romcenter 4 support discussion. Please do not post roms requests or illegal links, posts will be deleted. After discussion in this forum, please report any new bugs here.

Moderator: Wanderer

Forum rules
No roms requests or illegal links
Proffix
Galaga
Galaga
Posts: 29
Joined: Wed Sep 27, 2017 6:48 am

Error: execute procedure P_LOADDATAFILE(3)

Post by Proffix »

rcerr.jpg
rcerr.jpg (28.68 KiB) Viewed 48149 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

User avatar
Wanderer
Board master
Board master
Posts: 791
Joined: Wed Oct 03, 2001 10:37 am
Location: Milky way

Re: Error: execute procedure P_LOADDATAFILE(3)

Post 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.

Proffix
Galaga
Galaga
Posts: 29
Joined: Wed Sep 27, 2017 6:48 am

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by Proffix »

Oh i forgot that, its the same like when i send an email with an attachement :)
Attachments
A (2017-05-01).zip
(9.15 KiB) Downloaded 3144 times

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by RomCenter »

Thank you for the report. I will have a look at the dat and fix the problem.
Eric - RomCenter developer
Report bugs here.

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Error: execute procedure P_LOADDATAFILE(3)

Post 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 )
)
Eric - RomCenter developer
Report bugs here.

Proffix
Galaga
Galaga
Posts: 29
Joined: Wed Sep 27, 2017 6:48 am

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by Proffix »

Ah ok thanks.

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

User avatar
RomCenter
Author
Author
Posts: 1519
Joined: Fri Sep 28, 2001 12:34 pm
Location: France
Contact:

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by RomCenter »

You can delete. The bug is fixed in next release.
Eric - RomCenter developer
Report bugs here.

Post Reply