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 doing upgrade.sh (6.2 to 7.2.1)

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.

 

Suggest Edit

Published August 1, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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