Error: execute procedure P_LOADDATAFILE(3)

Forum rules
No roms requests or illegal links

Post a reply

Smilies
:D :) :( :o :shock: :? 8) :lol: :x :P :oops: :cry: :evil: :twisted: :roll: :wink: :!: :?: :idea: :arrow: :| :mrgreen: :clap: :hum: :gnak: :lol: :super: :uh: :toobad:
View more smilies

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Error: execute procedure P_LOADDATAFILE(3)

Re: Error: execute procedure P_LOADDATAFILE(3)

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 )
)

Re: Error: execute procedure P_LOADDATAFILE(3)

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.

Re: Error: execute procedure P_LOADDATAFILE(3)

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

Re: Error: execute procedure P_LOADDATAFILE(3)

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.

Error: execute procedure P_LOADDATAFILE(3)

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

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

Top