Discussion

7
Replies
305
Views
HariShankar Member since 2010 10 posts
Incessant Technologies Pvt. Ltd
Posted: December 22, 2015
Last activity: April 6, 2018
Closed

Data only upgrade issue - 5.5 SP1 to Pega 7

Hi,

We have upgraded from 5.5 SP1 to 7.1.8 in devenvironment and followed below approach for next higher environment

1. Copied the upgraded rule schema from dev environemnt to higher environment

2. Generated the DDL's for dataonly upgrade in higher environment and executed them

3. Executed upgrade.bat for dataonly upgrade in higher environment by bypassing the schema generation

4. Encountered issue as it is unable to insert records into pr_data_products and pr_data_restore.

5. We have truncated the data in the tables.

6. Then we resumed the dataupgrade by executing the resume.bat

Now we have encountered a different issue. Below are the details of the issue:

[java] 2015-12-21 17:12:13,257 [ main] [ ] [ ] ( external.util.Application) ERROR - A problem occurred.
[java] com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1634)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:682)
[java] at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:290)
[java] at com.pega.pegarules.deploy.external.util.Application.main(Application.java:500)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:483)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable dbo.pr_History_Data_Event_Recurrin PegaDATA
[java] From: (unknown)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:651)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:500)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
[java] at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2509)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:1436)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:476)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1402)
[java] ... 12 more
[java] Dec 21, 2015 5:12:13 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.external.util.Application.main(Application.java:505)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:483)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1634)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:682)
[java] at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:290)
[java] at com.pega.pegarules.deploy.external.util.Application.main(Application.java:500)
[java] ... 9 more
[java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable dbo.pr_History_Data_Event_Recurrin PegaDATA
[java] From: (unknown)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:651)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:500)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
[java] at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2509)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:1436)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:476)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1402)
[java] ... 12 more
[java]
[java] Dec 21, 2015 5:12:13 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega
[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.external.util.Application.main(Application.java:505)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:483)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1634)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:682)
[java] at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:290)
[java] at com.pega.pegarules.deploy.external.util.Application.main(Application.java:500)
[java] ... 9 more
[java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable dbo.pr_History_Data_Event_Recurrin PegaDATA
[java] From: (unknown)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:651)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:500)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
[java] at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2509)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:1436)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:476)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1402)
[java] ... 12 more
[java]
[java] Exception in thread "main" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:278)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRException: A problem occurred.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.external.util.Application.main(Application.java:505)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:483)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:272)
[java] ... 1 more
[java] Caused by: com.pega.pegarules.pub.PRException: Unable to complete import of Application Bundle.
[java] From: (unknown)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1634)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:682)
[java] at com.pega.pegarules.deploy.external.util.Application.deployApplication(Application.java:290)
[java] at com.pega.pegarules.deploy.external.util.Application.main(Application.java:500)
[java] ... 9 more
[java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable dbo.pr_History_Data_Event_Recurrin PegaDATA
[java] From: (unknown)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:651)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:500)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
[java] at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2509)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:1436)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:476)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1402)
[java] ... 12 more

BUILD FAILED
F:\PEGA 718 Upgrade Folder\114819_Pega718_sys\scripts\setupDatabase.xml:2154: Java returned: 1

Total time: 4 minutes 57 seconds
Exiting with Error

Can anyone help me to identify what is the cause of issue. I understand that the table is not present but we haven't the issue in dev environment. I have verified in our higher 5.5 SP1 environments the table doesn't exist in the pega schema. Even the DDL's generated also doesn't contain this table.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn