(SQR 3725) Bad return fetching row from database.

by Apurva T. on March 28, 2014

in PeopleSoft Administration

The PeopleTools upgrade step “Running DBTSFIX Report” might fail with the error:

Rel script conversion program
PRCSDEFN match
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.

(SQR 3725) Bad return fetching row from database.

 

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!

Also Read:  PeopleTools 8.53 - Understanding Installation Locations

{ 0 comments… add one now }

Leave a Comment

Previous post:

Next post: