SA-25842

Summary

User upgrading from PRPC 6.2 SP1 to  Pega 7.2.1 and the upgrade fails when user set the update.applications.schema property to True during the upgrade.sh execution. 

Error Messages

[java] 2016-07-12 21:56:53,425 [      laa2app2107xrv] [  STANDARD] [                    ] (ernal.access.DataSourceManager) ERROR   - Unable to obtain DataSource for pegarulesbat: jdbc/PegaRULES
     [java] 2016-07-12 21:56:53,426 [      laa2app2107xrv] [  STANDARD] [                    ] (ernal.access.DataSourceManager) ERROR   - Unable to obtain DataSource for pegarulesiu: jdbc/PegaRULES
     [java] 2016-07-12 21:56:53,533 [      laa2app2107xrv] [  STANDARD] [                    ] (external.util.NodeShutdownUtil) INFO    - Cluster shutdown completed
     [java] Jul 12, 2016 9:56:53 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
     [java] SEVERE: Problem during method invocation (main)
     [java] com.pega.pegarules.pub.PRException: A problem occurred
     [java] From: (unknown) 
     [java]     at com.pega.pegarules.deploy.internal.util.UpgradeApplicationSchemaUtility.callProcess(UpgradeApplicationSchemaUtility.java:114)
     [java]     at com.pega.pegarules.deploy.internal.util.UpgradeApplicationSchemaUtility.main(UpgradeApplicationSchemaUtility.java:66)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:601)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
     [java]     at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
     [java]     at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
     [java]     at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
     [java]     at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
     [java] Caused by: com.pega.pegarules.pub.database.DatabaseException: Unable able to parse table metadata.: code: <none> SQLState: Premature end of file. Message: <none>
     [java] DatabaseException caused by prior exception: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Premature end of file.
     [java] 
     [java] From: (AF61A10C7F30FE55E80E9C5F225E36FF7) 
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.generateDDL(DDLGenerator.java:179)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.generateUpgradeDDL(DDLGenerator.java:212)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.getTableClassMapping(DDLGenerator.java:632)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.compareTables(DDLGenerator.java:490)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.generateSchemaChanges(DDLGenerator.java:159)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.generateSchemaChanges(DDLGenerator.java:135)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.SchemaChangeUtilityImpl.generateSchemaChanges(SchemaChangeUtilityImpl.java:287)
     [java]     at com.pega.pegarules.data.internal.access.UpgradeApplicationSchemaImpl.generateSchemaChanges(UpgradeApplicationSchemaImpl.java:51)
     [java]     at com.pega.pegarules.deploy.internal.util.UpgradeApplicationSchemaUtility.getAllTableClassMappingList(UpgradeApplicationSchemaUtility.java:168)
     [java]     at com.pega.pegarules.deploy.internal.util.UpgradeApplicationSchemaUtility.process(UpgradeApplicationSchemaUtility.java:133)
     [java]     at com.pega.pegarules.deploy.external.util.CommandLineUtility.processWrapper(CommandLineUtility.java:71)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
     [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
     [java]     at java.lang.reflect.Method.invoke(Method.java:601)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentUtility.performAction(DeploymentUtility.java:62)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentRunner.run(DeploymentRunner.java:137)
     [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1290)
     [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1038)
     [java]     at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:847)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentRunner.startRequestor(DeploymentRunner.java:98)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentUtility.runMethodWithRequestor(DeploymentUtility.java:92)
     [java]     at com.pega.pegarules.deploy.external.util.DeploymentUtility.runMethodWithRequestor(DeploymentUtility.java:83)
     [java]     at com.pega.pegarules.deploy.external.util.CommandLineUtility.runUtility(CommandLineUtility.java:52)
     [java]     at com.pega.pegarules.deploy.internal.util.UpgradeApplicationSchemaUtility.callProcess(UpgradeApplicationSchemaUtility.java:109)
     [java]     ... 10 more
     [java] Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Premature end of file.
     [java]     at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:251)
     [java]     at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:300)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.parseXMLDoc(DDLGenerator.java:781)
     [java]     at com.pega.pegarules.data.internal.ddlcomp.DDLGenerator.generateDDL(DDLGenerator.java:176)
     [java]     ... 34 more

Steps to Reproduce

Perform upgrade from Pega v62sp1 to v7.2.1 by initializing the update.applications.schema property to true 

Root Cause

Issue with the Update application schema functionality during the upgrade process.

Resolution

Perform the following local-change steps:
 

1. Set update.applications.schema property to False and complete the upgrade process successfully.
2. After completion of the upgrade process launch the Designer Studio and perform the Update application schema functionality from (Designer Studio > System > Release > Upgrade > Upgrade Applications Schema).
3. Download all the scripts which need to be installed into the database from the below landing page and executed the scripts into the database.