The PeopleTools upgrade step “Running DBTSFIX Report” might fail with the error:
Rel script conversion program
Error on line 842:
(SQR 3725) Bad return fetching row from database.
SQR for PeopleSoft: Program Aborting.
How to Fix (SQR 3725) Bad return fetching row from database.
This error is caused by invalid packages in case of an Oracle database. You can run either of the following SQLs:
- Select * from all_objects where status =’INVALID’
- SELECT owner, object_type, object_name, status FROM dba_objects WHERE status = ‘INVALID’ ORDER BY owner, object_type, object_name;
If the output is something like shown below, it clearly shows that there are packages which are invalid.
These invalid packages may not even make any difference in your application’s day to day function, but you will need to fix this error in case of an upgrade.
Depending on who is the owner of your PeopleSoft application (SYSADM in my case), run the below SQL:
exec dbms_utility.compile_schema( ‘SYSADM’ )
It makes sense to check the validity of the objects before doing an upgrade. But if you miss to perform the check and the DBTSFIX step fails, you should restart the step and run it again. Your error will be gone this time around!