Support Article

Receiving error during initial rules migration step

SA-26331

Summary



Attempting to update from Pega 7.1.8 to Pega 7.2.1. During the first migration step from current rules718 schema to temporary pega_upgrade schema, the build fails.


Error Messages



[java] Fri Jul 22 13:24:29 EDT 2016 (INFO): Encountered exception during processing!
[java] ORA-00942: table or view does not exist
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
[java] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
[java] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
[java] at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3714)
[java] at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1378)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1222)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:728)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:366)
[java]
[java] PegaBulkMover:: SQLException loading Database.
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.loadDatabaseTable(PegaBulkMover.java:1239)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.process(PegaBulkMover.java:728)
[java] at com.pega.pegarules.util.deploy.PegaBulkMover.main(PegaBulkMover.java:366)
[java]

BUILD FAILED
e:\Pega_Installs\115143_Pega721\scripts\migrateSystem.xml:644: The following error occurred while executing this line:
e:\Pega_Installs\115143_Pega721\scripts\migrateSystem.xml:39: Java returned: 8

Total time: 18 minutes 22 seconds
Exiting with Error


Steps to Reproduce



Initiate the migrate.bat file. After 18 minutes the migrate fails


Root Cause



Create ddl and apply ddl properties mentioned below in the migrateSystem.properties file was set to false. So, when the migrate.bat script was executed, the temporary Pega schema was empty causing the issue.
  • pega.clone.create.ddl=false
  • pega.clone.apply.ddl=false

Resolution



Update the migrateSystem.properties and set the Create ddl and apply ddl properties to true. After these changes the migration step will be successful. 
  • pega.clone.create.ddl=true
  • pega.clone.apply.ddl=true


These steps are documented in the upgrade guide: https://pdn.pega.com/documents/pega-721-platform-upgrade-guide page 35 onwards.

​Look for the section "Migrating the rules schema when the system has access to both databases".

Published August 2, 2016 - Updated August 11, 2016

Have a question? Get answers now.

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