Error: execute procedure P_LOADDATAFILE(3)
Moderator: Wanderer
Forum rules
No roms requests or illegal links
No roms requests or illegal links
Error: execute procedure P_LOADDATAFILE(3)
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)
Hi there.

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.
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 -
RomCenter: Main site, Bug reporting & enhancement requests, Wiki
RCDBManager: Main site, Bug reporting & enhancement requests, Wiki
RomCenter: Main site, Bug reporting & enhancement requests, Wiki
RCDBManager: Main site, Bug reporting & enhancement requests, Wiki
Re: Error: execute procedure P_LOADDATAFILE(3)
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 4176 times
Re: Error: execute procedure P_LOADDATAFILE(3)
Thank you for the report. I will have a look at the dat and fix the problem.
Eric - RomCenter developer
Report bugs here.
Report bugs here.
Re: Error: execute procedure P_LOADDATAFILE(3)
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.
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.
Report bugs here.
Re: Error: execute procedure P_LOADDATAFILE(3)
Ah ok thanks.
should i send the complete crash reports (abot 1gb) to you or can i delete that?
should i send the complete crash reports (abot 1gb) to you or can i delete that?
Re: Error: execute procedure P_LOADDATAFILE(3)
You can delete. The bug is fixed in next release.
Eric - RomCenter developer
Report bugs here.
Report bugs here.