Discussion
Coforge - DPA Pvt. Ltd. (Incessant Technologies Pvt. Ltd)
CA
Last activity: 6 Apr 2018 19:26 EDT
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.
Pegasystems Inc.
IN
Hari,
The probable reason for this failure.
1) you higher enviornemnt might defined some synonyms. Run the following query to check the synonyms.
Select synonym_name,table_name,owner from all_synonyms
2) check whether PegaRULES database rule is configued with static URL intead of JNDI bindings
Thanks,
Dhev
Coforge - DPA Pvt. Ltd. (Incessant Technologies Pvt. Ltd)
CA
Hi Dev,
I have verified the higher environment, there are no synonyms present in the database. As the rules engine is upgraded successfully, i am planning to start the server and once it is started successfully, i would import the data RAP "DataOnly_07.10.zip" (generated in the upgrade temp folder of scripts directory when executed the command upgrade.bat --dataOnly true). Upon successfully import, i would restart the server and verify the apps if there is issue.
Please let me know if you find any issue in doing this.
Thanks,
Hari Shankar
Accenture
IN
The problem is, it is not able to find tables pr_data_products and pr_data_restore and insert records as they exist in rules schema.
Before running data only upgrade, you should run Migrate script where source and target for rulesschema should be same and source should be blank for data schema and target should be filledwith data schema. This will ensure the cross granting.
Coforge - DPA Pvt. Ltd. (Incessant Technologies Pvt. Ltd)
CA
Hi Rahul,
I want to clarify my issue, we have run the migrate.bat for generation of rule schema objects and we haven't faced any issue. We encountered issues during dataonly upgrade. The first issue is the system is unable to insert records into tables "pr_data_products and pr_data_restore" due to primary key validation and it doesn't has any issue in identifying the tables.
Below is issue encountered when resuming the data upgrade process after solving the first issue:
[java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable dbo.pr_History_Data_Event_Recurrin PegaDATA
Regards,
Hari
Accenture
IN
HI Hari,
If you have copied rules schema from an existing upgraded environment to SIT environment, in that case you have to truncate below tables from rules schema before running dataOnly upgarde. Otherwise you may get unique constraint error on pr_data_products.
1. truncate table pr_data_restore;
2.truncate table pr_data_products;
so please truncate those 2 table and restart your dataOnly upgrade script.
PR_DATA_RESTORE table is used for reversing an update and this feature is introduced in Pega 7.1.7 onwards. This table captures all the data instances which got imported during the Data Upgrade process.
When we perform the reversibility then it gets all the records from this table and removes from the Data schema. Reversibility is only supported if you are already on Pega7.1.x and doing an update to Pega 7.1.y.
As you are performing the data upgrade second time it is trying to capture all the data instances one more time in the PR_DATA_RESTORE table and failing with unique constraint violation error
Accenture
IN
HI Hari,
If you have copied rules schema from an existing upgraded environment to SIT environment, in that case you have to truncate below tables from rules schema before running dataOnly upgarde. Otherwise you may get unique constraint error on pr_data_products.
1. truncate table pr_data_restore;
2.truncate table pr_data_products;
so please truncate those 2 table and restart your dataOnly upgrade script.
PR_DATA_RESTORE table is used for reversing an update and this feature is introduced in Pega 7.1.7 onwards. This table captures all the data instances which got imported during the Data Upgrade process.
When we perform the reversibility then it gets all the records from this table and removes from the Data schema. Reversibility is only supported if you are already on Pega7.1.x and doing an update to Pega 7.1.y.
As you are performing the data upgrade second time it is trying to capture all the data instances one more time in the PR_DATA_RESTORE table and failing with unique constraint violation error
Regards
Shankha
Updated: 4 Feb 2016 1:44 EST
Scope International
SG
Hi All,
After the upgrade while checking the rule schema tables, observed that for the below table records did not copied from data schema to rule schema and when we look the logs there is not entry in log files for the below tables. Can any one explain what is purpose of the below tables and whether while in upgrade it should copy or not. It seems some of the tables are related cache by the name. Need information for other tables.
PR_DATA_PRODUCTS
PR_DATA_RESTORE
PR_SYS_APPCACHE_DEP
PR_SYS_APPCACHE_ENTRY
PR_SYS_APPCACHE_SHORTCUT
PR_SYS_APP_HIERARCHY_FLAT
PR_SYS_APP_RULESET_INDEX
PR_SYS_CACHE_DEP
PR_SYS_CACHE_ENTRY
PR_SYS_CACHE_IMPL
PR_SYS_CLASS_ANCESTORS
PR_SYS_RULESET_INDEX
And can any one tell what is the purpose of the PR4_RULE_SYSGEN table.
Thanks In Advance