REL851unDBTSFIX Script Failed – PeopleTools Upgrade Bug

When upgrading database from PeopleTools 8.50 to PeopleTools 8.53.06, you’re likely to see a situation where the step “Updating PeopleTools System Tables” fails. The failure is while running REL851unDBFIX.sql. Subsequently the error is encountered for REL852unDBFIX.sql and REL853unDBFIX.sql as well.

The REL851UNDBTSFIX.log will show that all the SQL statements were executed and no errors were encountered. Open the file UpdatingPeopleToolsSystemTables_search.log and you will notice errors which are similar to the one shown below:

Searching for file of scripts\PT851TLS.dms in Q:\pt85300\ – File Found.
Searching for file of scripts\PT851TLS.dms in Q:\pt85300\ – File Found.
Searching for file of scripts\PT851TLSENG.dms in Q:\pt85300\ – File Not Found.
Searching for file of scripts\PT851TLSENG.dms in Q:\pt85300\ – File Not Found.
Searching for file of scripts\PT851TLSENG.dms in Q:\pt85300\ – File Not Found.
Searching for file of PT851TLSENG.dms – Unsuccessful:File Not Found.
Searching for file of scripts\PT852TLS.dms in Q:\pt85300\ – File Found.
Searching for file of scripts\PT852TLS.dms in Q:\pt85300\ – File Found.
Searching for file of scripts\PT852TLSENG.dms in Q:\pt85300\ – File Not Found.
Searching for file of scripts\PT852TLSENG.dms in Q:\pt85300\ – File Not Found.
Searching for file of scripts\PT852TLSENG.dms in Q:\pt85300\ – File Not Found.

Resolution to REL851unDBTSFIX error:

As you might have guessed it already – it is safe to assume that your task completed fine and you can mark the step as complete. You can also refer to the tip at the bottom of the post.

This error is caused by BUG 17322988 and here is a workaround:

1. Check REL851UNDBTSFIX.log and verify all the SQL statements were executed fine. If there were SQL errors – you need to address those.
2. As long as all the scripts within this step have completed to success, you will be fine to mark the step as complete and continue with the upgrade.
   You also have the option to run the SQL outside CA to mark complete and continue.
3. If you have multiple tools version steps to run (851,852,853), and you still need the others, please follow the steps mentioned under the topic How to Restart “Update PeopleTools System Tables” Step in Upgrade

How to Restart “Update PeopleTools System Tables” Step in Upgrade

i)   In Change Assistant, go to the step that says “Update PeopleTools System Tables”
ii)  Right click on this step and click on “View Logs”
iii)  A pop-up box will show up that will show the list of all the scripts being run.
iv)  Click the flashlight icon that will allow you to edit the step.
v)  Mark the steps that have already completed as “Completed” and mark the steps that need to be run as “Restart”
vi)  Once you are done editing all the scripts as you want, then click on “OK”, and  “OK” again.
vii)  If this step failed in the middle of running a rel script, then you want to make sure to go into the release script in the Change Assistant’s staging directory that you are planning to rerun, and comment out all the steps that have already been run.  If you do not do this,  there will be big problems if you attempt to rerun the steps that have already been run.
viii)  Mark the “Update PeopleTools System Tables” as “Restart” and then run the step again.

Tip: Because you may refer to this scripts directory multiple times, you can create the following three dummy files in the scripts directory and witness a successful completion instead of failed status.

PT851TLSENG.dms
PT852TLSENG.dms
PT853TLSENG.dms