Support Article

Unable to execute migrate for upgrade

SA-29985

Summary



Unable to execute migrate for upgrade in DB2 zOS environment with Pega 7.2.

Error Messages

[java] 2016-09-27 23:43:59,380 ( SchemaGenerator) SEVERE - Cannot continue with ddl generation due to misssing properties
[java] 2016-09-27 23:43:59,443 ( SchemaGenerator) INFO - Missing property: wlmudf
[java] 2016-09-27 23:43:59,443 ( SchemaGenerator) SEVERE - Error while creating Zos Schema Generator
[java] Cannot continue with missing zos properties: wlmudf
[java]
[java] java.lang.IllegalStateException: Cannot continue with missing zos properties: wlmudf
[java] at com.pega.pegarules.data.ddl.ZosSchemaGenerator.validateZosProperties(ZosSchemaGenerator.java:77)
[java] at com.pega.pegarules.data.ddl.ZosSchemaGenerator.<init>(ZosSchemaGenerator.java:64)
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1793)
[java] Exception in thread "main" java.lang.IllegalStateException: Error generating ddl for db2zos, KBZFGCMG
[java] null
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1818)
[java] Caused by: java.lang.NullPointerException
[java] at com.pega.pegarules.data.ddl.SchemaGenerator.main(SchemaGenerator.java:1814)
 

Steps to Reproduce



Executing Migrate.bat to generate DDL for the DB2 zOS system. 


Root Cause



Configuration issue in which missing WLM related properties in db2sitedependant.properties file.

Resolution



Perform the following local-change steps: 

1. Enable WLM to support UDF. Configure db2sitedependant.properties with missing WLMUDF and other properties related to Work Load Manager (WLM).
2. For Pega 7.2, Deployment guide (Refer Page 109, 33) suggested to use db2jcc4.jar

To Follow the series of steps sequentially:

3. Update MigrateSystem.properties and execute migrate.sh, dba to apply DDL script and again execute migrate.sh.
4. Modify setupDatabase.properties and execute generateDDLupgrade, after dba action execute upgrade.sh.
5. Update MigrateSystem.properties and execute migrate.sh.
6. Modify setupDatabase.properties and exec geneateDDL, after dba, to execute upgrade.sh --dataonly = true.
 

 

Published November 4, 2016 - Updated November 14, 2016

Have a question? Get answers now.

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