Discussion

7
Replies
306
Views
Harisankar Tankala (HariShankar)
Coforge - DPA Pvt. Ltd. (Incessant Technologies Pvt. Ltd)
Technical Architect
Coforge - DPA Pvt. Ltd. (Incessant Technologies Pvt. Ltd)
CA
HariShankar Member since 2010 10 posts
Coforge - DPA Pvt. Ltd. (Incessant Technologies Pvt. Ltd)
Posted: December 22, 2015
Last activity: April 6, 2018
Posted: 22 Dec 2015 19:21 EST
Last activity: 6 Apr 2018 19:26 EDT
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.

System Administration Upgrades
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.