PEGA upgrade from 5.5 to 7.4
Hi,
we have upgrade PEGA v5.5 to 7.4 with split schema.
PEGA 5.5 is running in WAS 7.0 Application server and 7.4 is in WAS 8.5 app server.
After the upgrade process, when we start WAS 7.0 app server, the application is failed to launch with the following error.
Hi,
we have upgrade PEGA v5.5 to 7.4 with split schema.
PEGA 5.5 is running in WAS 7.0 Application server and 7.4 is in WAS 8.5 app server.
After the upgrade process, when we start WAS 7.0 app server, the application is failed to launch with the following error.
Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem getting a list -206 42703 DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PXCOMMITDATETIME, DRIVER=3.72.54 From: (B5C8380805D73A80E71B6A1852CBF9087:(MBean Access)) SQL: select PXCHANGECLASS as "pxChangeClass" , PXCHANGEOBJCLASS as "pxChangeObjClass" , PXCHANGEPROPERTY as "pxChangeProperty" , PXCHANGEPURPOSE as "pxChangePurpose" , PXCHANGETYPE as "pxChangeType" , PXCOMMITDATETIME as "null" , PXDEFINDEX as "pxDefIndex" , PXINSNAME as "pxInsName" , PXOBJCLASS as "pxObjClass" , PXRULEAPPLIESTO as "pxRuleAppliesTo" , PXRULEKEY as "pxRuleKey" , PXRULEOBJCLASS as "pxRuleObjClass" , PXRULESET as "pxRuleSet" , PXRULESETVERSION as "pxRuleSetVersion" , PXSAVEDATETIME as "null" , PZINSKEY as "pzInsKey" from pr_sys_decchg where pxChangeClass = ? and pxObjClass = ? order by pxChangeProperty , pzInsKey SQL Inserts: <Embed-SecuritySnapshot> <System-Declare-Changes> Caused by SQL Problems. Problem #1, SQLState 42703, Error code -206: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=PXCOMMITDATETIME, DRIVER=3.72.54 Problem #2, SQLState 56098, Error code -727: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-727, SQLSTATE=56098, SQLERRMC=2;-206;42703;PXCOMMITDATETIME, DRIVER=3.72.54 at com.pega.pegarules.engine.database.ExceptionInformation.createExceptionDueToDBFailure
when we analyzed the issue, we found that the app server is trying to access the table present in the RULES schema that was created as part of split schema.
in the upgraded version (7.4), we see 2 additional columns PXcommitdatetime and pxsavedatetime.
System ideally should refer the old schema. but, somehow, its accessing the new schema and that is causing issue.
Please let me know if anyone faced this issue and if there is any resolution.
Thanks
Guhan
Pegasystems Inc.
IN
Could you please explain us what do you meant by old schema and new schema
Pega 7.4 works on split schema. To analysis the issue we need logs files.
AIG
US
Thanks Dinesh,
old schema is the one that contains the PEGA 5.5 rules.
As part of upgrade, we created 2 new schemas 1 for DATA and 1 for RULES.
our plan is to run PEGA5.5 instance (present in different app server) pointing to the old schema and run PEGA 7.4 pointing to newly created RULES and DATA schema.