Error: execute procedure P_LOADDATAFILE(3)

Romcenter 4 support discussion. Please do not post roms requests or illegal links, posts will be deleted.

Moderators: Wanderer, Logiqx, Iron Man

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

Error: execute procedure P_LOADDATAFILE(3)

Post by Proffix » Mon Nov 27, 2017 7:13 pm

rcerr.jpg
rcerr.jpg (28.68 KiB) Viewed 184 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: 645
Joined: Wed Oct 03, 2001 10:37 am
Location: Floating around

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by Wanderer » Mon Nov 27, 2017 11:02 pm

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

For Romcenter bug reporting or enhancement requests, click here.

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

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by Proffix » Tue Nov 28, 2017 6:47 am

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 9 times

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

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by RomCenter » Sat Dec 02, 2017 3:28 pm

Thank you for the report. I will have a look at the dat and fix the problem.
Eric - RomCenter developer
http://www.romcenter.com

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

Re: Error: execute procedure P_LOADDATAFILE(3)

Post by RomCenter » Sat Dec 09, 2017 8:34 am

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
http://www.romcenter.com

Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests