SA-9167

Summary

User is on Pega 7.1.6 split schema and are trying to upgrade to Pega 7.1.7.   

As the initial step, user started running the migrate.sh script with appropriate properties as described in the upgrade guide but it is failing

Error Messages

Apply Cloned DDL:
[propertyfile] Creating new property file: /oracle/backups/temp/MigrateTemp-17-April-2015-17.34.19/target.properties
     [java] Apr 17, 2015 5:46:03 PM com.pega.pegarules.install.SQLLoader writeMessage
     [java] INFO: Starting logging to : 'logs/SQLinstaller.log'
     [java] Apr 17, 2015 5:46:03 PM com.pega.pegarules.install.SQLLoader writeMessage
     [java] WARNING: Invalid directory: /oracle/backups/scripts/../schema/generated/oracledate/clone/statements

BUILD FAILED
/oracle/backups/scripts/migrateSystem.xml:508: Java returned: 1

Steps to Reproduce

Run migrate.sh 

Root Cause

The root cause of this problem is software use/operation error.  

There is a typo misspelling 'true' in the migrateSystem.properties file for the pega.clone.create.ddl property.  

Since this property is not set to true the step to actually generate the clone DDL is being skipped and then when it goes to the next step to apply the ddl it finds that it does not exist. 

pega.clone.create.ddl=ture

Resolution

This issue is resolved by making the following change to the operating environment:

Update property pega.clone.create.ddl=true and then the migrate script completes successfully.