I'm trying a dump and load of our 3.00.632 database on my test server to
hopefully improve speed and performance during and after the upgrade to 5.1.
I got the instructions from Epicor and the "dump" portion worked just fine
with no errors. Now I'm trying to load and it fails miserably! After I
type in the command:
I get a series of errors and a message that says "More than 20 errors
encountered. Bulkload terminated (1532)"
The errors are of the type:
Line 58XX: Invalid or non-progress filename "PRDD_Hist" (1510)
Line 58XX: Unknown field "XXXXXXXXXXXXXXXXXX" (1509)
Similar problem with PREmpDedEx. I checked the EraNet and found a document
on the error number 1532 that says something about deleting a section of the
dcdv7.fd program having to with rbreport. I checked and my fd file doesn't
have this anymore, so Epicor must have changed it since the article was
printed, but I did have sections for PRDD_Hist and PREmpDedEX. I followed
the instructions in the EraNet article for deleting entries and resaving the
fd file. Now the load is working.
All this typing to get to my point - Is this normal? I don't want to go
through this whole process again in February when we go live to find out I
have corrupted my database somehow by doing this.
Rick,
I did a dump and load back in 3.0 and never encountered what you are encountering... I'd check it very carefully before doing it on the live system. Do you have any extra tables via custom programming that might affect the load part? It may be that the target database you are loading to does not have the same structure as the database you dumped.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Rick Spriggle
To: vantage@yahoogroups.com
Sent: Wednesday, January 02, 2002 9:47 AM
Subject: [Vantage] Dump and Load problem
I'm trying a dump and load of our 3.00.632 database on my test server to
hopefully improve speed and performance during and after the upgrade to 5.1.
I got the instructions from Epicor and the "dump" portion worked just fine
with no errors. Now I'm trying to load and it fails miserably! After I
type in the command:
I get a series of errors and a message that says "More than 20 errors
encountered. Bulkload terminated (1532)"
The errors are of the type:
Line 58XX: Invalid or non-progress filename "PRDD_Hist" (1510)
Line 58XX: Unknown field "XXXXXXXXXXXXXXXXXX" (1509)
Similar problem with PREmpDedEx. I checked the EraNet and found a document
on the error number 1532 that says something about deleting a section of the
dcdv7.fd program having to with rbreport. I checked and my fd file doesn't
have this anymore, so Epicor must have changed it since the article was
printed, but I did have sections for PRDD_Hist and PREmpDedEX. I followed
the instructions in the EraNet article for deleting entries and resaving the
fd file. Now the load is working.
All this typing to get to my point - Is this normal? I don't want to go
through this whole process again in February when we go live to find out I
have corrupted my database somehow by doing this.