Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error upgrading from 7.1.5 to 7.1.6 after applying DDL manually



Admin trying to update from 7.1.5 to 7.1.6.  PRPC database utilizes a split schema and is DB2-LUW.

For the first attempt, admin generated the DDL via the appropriate bat file command. He then took the resulting udb.sql file and sent it to DBAs to be reviewed and applied. After DBAs applied the script, admin then used the GUI installer to complete the process. He checked the checkbox to indicate that the DDL was applied manually. The installer then ran for many hours before failing. 

Please note that our DBAs will not give the application ID being used to run the upgrade the SYSADM priv. We have a separation of duties and any table structure changes being made or database objects being created / deleted need to be done via udb.sql.

Error Messages

     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at
     [java]     at com.pega.pegarules.install.SQLLoader.main(

Steps to Reproduce

1.  Run the generateDDL.bat and have DBA apply SQL
2.  Run update.bat

Root Cause

The user running the update does not have the required permissions to do the final few steps of the update, which 
creates a trigger in the database and clears the database cache.


This issue is resolved through the following local change: 

Altered the setupDatabase.xml file to remove the final steps before cleanup where the tool is attempting to enable the database triggers and truncate the cache table.

                                              Enable Database Triggers
                                             Truncate Updates Cache

As a post update step the DBA must manually run the scripts in the "schema\generated\udb\util\triggers\enable" directory to enable the database triggers and will truncate the pr_sys_updatescache table which is in the data schema.


Published January 31, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us