I have a batch job to rebuild about 100 files. The batch job ran successfully on a test server, but not on the production server. Three of the files got an error 3 during the rebuild. One of the files is very large, with 17 extensions. Another is large with one extension. The third file is relatively small. We have about 100 gig free on the server. The three that got the error were dispersed throughout the batch job. Thanks for any information.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Error 3 on Pervasive Rebuild
- Thread starter MarshaP
- Start date
How did you rebuild the files? Was it with the GUI tool, command line tool, or some other process? Can you post the errors as they were listed in the log (if you used the command line or GUI tool)?
If you rebuild those files manually, do they rebuild fine?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
If you rebuild those files manually, do they rebuild fine?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Thread starter
- #3
I used rbldcli in a batch file. The files rebuilt on the test server.
The rebuild operation start time is 06/13/13 21:30:36.
rbldcli -c -p16384 -lrebuildlog.txt -f95 E:\AOD\magic8\C001\MRORDREXT
REBUILD-20: The utility is processing E:\AOD\magic8\C001\MRORDREXT.
REBUILD-68: Status code 3 was returned while copying records from the following file:
E:\AOD\magic8\C001\_rblda04188.
REBUILD rejected a total of 13149 records.
REBUILD copied a total of 56350 records.
REBUILD rebuilt a total of 0 indexes.
The rebuild operation end time is 06/13/13 21:33:12.
The rebuild operation start time is 06/13/13 22:31:43.
rbldcli -c -p16384 -lrebuildlog.txt -f95 E:\AOD\magic8\C001\MRORDRCHGLOG2
REBUILD-20: The utility is processing E:\AOD\magic8\C001\MRORDRCHGLOG2.
REBUILD-68: Status code 3 was returned while copying records from the following file:
E:\AOD\magic8\C001\_rblda06028.
REBUILD rejected a total of 5408993 records.
REBUILD copied a total of 3207262 records.
REBUILD rebuilt a total of 0 indexes.
The rebuild operation end time is 06/14/13 00:41:01.
The rebuild operation start time is 06/14/13 02:23:10.
rbldcli -c -p16384 -lrebuildlog.txt -f95 E:\AOD\magic8\C001\P2RESIDENTMONTHLYCHARTING2
REBUILD-20: The utility is processing E:\AOD\magic8\C001\P2RESIDENTMONTHLYCHARTING2.
REBUILD-68: Status code 3 was returned while copying records from the following file:
E:\AOD\magic8\C001\_rblda05932.
REBUILD rejected a total of 543435 records.
REBUILD copied a total of 511164 records.
REBUILD rebuilt a total of 0 indexes.
The rebuild operation end time is 06/14/13 02:32:53.
The rebuild operation start time is 06/13/13 21:30:36.
rbldcli -c -p16384 -lrebuildlog.txt -f95 E:\AOD\magic8\C001\MRORDREXT
REBUILD-20: The utility is processing E:\AOD\magic8\C001\MRORDREXT.
REBUILD-68: Status code 3 was returned while copying records from the following file:
E:\AOD\magic8\C001\_rblda04188.
REBUILD rejected a total of 13149 records.
REBUILD copied a total of 56350 records.
REBUILD rebuilt a total of 0 indexes.
The rebuild operation end time is 06/13/13 21:33:12.
The rebuild operation start time is 06/13/13 22:31:43.
rbldcli -c -p16384 -lrebuildlog.txt -f95 E:\AOD\magic8\C001\MRORDRCHGLOG2
REBUILD-20: The utility is processing E:\AOD\magic8\C001\MRORDRCHGLOG2.
REBUILD-68: Status code 3 was returned while copying records from the following file:
E:\AOD\magic8\C001\_rblda06028.
REBUILD rejected a total of 5408993 records.
REBUILD copied a total of 3207262 records.
REBUILD rebuilt a total of 0 indexes.
The rebuild operation end time is 06/14/13 00:41:01.
The rebuild operation start time is 06/14/13 02:23:10.
rbldcli -c -p16384 -lrebuildlog.txt -f95 E:\AOD\magic8\C001\P2RESIDENTMONTHLYCHARTING2
REBUILD-20: The utility is processing E:\AOD\magic8\C001\P2RESIDENTMONTHLYCHARTING2.
REBUILD-68: Status code 3 was returned while copying records from the following file:
E:\AOD\magic8\C001\_rblda05932.
REBUILD rejected a total of 543435 records.
REBUILD copied a total of 511164 records.
REBUILD rebuilt a total of 0 indexes.
The rebuild operation end time is 06/14/13 02:32:53.
When these files rebuilt on the test server, how many records were rejected and how many were copied?
What version of PSQL are you using? Is it the same exact version as on the test server?
A status 3 indicates the file isn't open which doesn't make sense.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
What version of PSQL are you using? Is it the same exact version as on the test server?
A status 3 indicates the file isn't open which doesn't make sense.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Status
Similar threads
- Locked
- Question
- Locked
- Question