Discussion

4
Replies
281
Views
Sandeep_Ghosh Member since 2011 39 posts
Scotiabank
Posted: 4 years ago
Last activity: 4 years 2 months ago
Closed

Unable to import solutions of the Case Studies

Hello

I am facing error while importing solutions of the case studies into the PVS (I have the latest PVS downloaded), I faced the issue for Case Design as well as Data Model chapter. PFB the error I found in the log file while importing jar file for Data Model case study solution. Please help.

 

2016-07-17 16:48:49,569 [   PegaRULES-Batch-3] [  STANDARD] [                    ] [     PegaRULES:07.10] (ga_importexport_pximportexport) ERROR  Administrator@pega.com - ImportArchive: Encountered the following error: A problem occurred. 
com.pega.pegarules.pub.PRException: A problem occurred. 
From: (BBC7FB2F6CFE56DAE1591F2AAC45D8D32)  
	at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:539) 
	at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:889) 
	at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:762) 
	at com.pega.pegarules.deploy.internal.util.ImportImpl.importArchive(ImportImpl.java:670) 
	at com.pega.pegarules.deploy.internal.util.ImportImpl.importPegaArchive(ImportImpl.java:739) 
	at com.pega.pegarules.deploy.internal.archive.PegaArchiveAbstract.doImport(PegaArchiveAbstract.java:362) 
	at com.pegarules.generated.pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.pxImportArchive07_10_17(pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.java:142) 
	at com.pegarules.generated.pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.invoke(pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.java:84) 
	at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:133) 
	at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110) 
	at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9000) 
	at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181) 
	at com.pegarules.generated.pega_importexport_pximportexport.pxImportArchive(pega_importexport_pximportexport.java:281) 
	at com.pegarules.generated.activity.ra_action_pegarulesmove_zip_to_db_ecb772d78bf08bbc28d582ede9b48554.step8_circum0(ra_action_pegarulesmove_zip_to_db_ecb772d78bf08bbc28d582ede9b48554.java:884) 
	at com.pegarules.generated.activity.ra_action_pegarulesmove_zip_to_db_ecb772d78bf08bbc28d582ede9b48554.perform(ra_action_pegarulesmove_zip_to_db_ecb772d78bf08bbc28d582ede9b48554.java:207) 
	at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3505) 
	at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) 
	at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:572) 
	at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:453) 
	at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:257) 
	at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:320) 
	at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945) 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259) 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008) 
	at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901) 
	at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670) 
	at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:991) 
	at com.pega.jsr166backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:532) 
	at java.lang.Thread.run(Thread.java:745) 
Caused by: com.pega.pegarules.pub.PRException: Batch entry 0 WITH source as (SELECT 'INDEX-REFERENCE DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pzInsKey" , NULL::timestamp "pxCreateDateTime" , NULL::varchar "pxCreateOperator" , NULL::varchar "pxCreateOpName" , NULL::varchar "pxCreateSystemID" , '8'::numeric "pxIndexCount" , 'RuleReference'::varchar "pxIndexPurpose" , 'Data-Admin-Operator-AccessGroup'::varchar "pxInsIndexedClass" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS'::varchar "pxInsIndexedKey" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pxInsName" , NULL::varchar "pxJavaClass" , NULL::varchar "pxJavaMethodName" , 'Index-Reference'::varchar "pxObjClass" , NULL::varchar "pxPageName" , NULL::varchar "pxReferencingDescription" , 'RESQUESTFW:ADMINISTRATORS'::varchar "pxReferencingInsName" , NULL::varchar "pxReferencingRuleSetName" , NULL::varchar "pxReferencingRuleSetVersion" , NULL::varchar "pxRuleClassName" , NULL::varchar "pxRuleFamilyName" , 'Rule-Portal'::varchar "pxRuleObjClass" , NULL::timestamp "pxSaveDateTime" , NULL::timestamp "pxUpdateDateTime" , NULL::varchar "pxUpdateOperator" , NULL::varchar "pxUpdateOpName" , NULL::varchar "pxUpdateSystemID" , NULL::varchar "pyLabel" , 'Developer'::varchar "pyRuleName"), upsert AS (UPDATE pegarules.pr_index_reference t SET pxCommitDateTime = CURRENT_TIMESTAMP , pxcreatedatetime = source."pxCreateDateTime" , pxcreateoperator = source."pxCreateOperator" , pxcreateopname = source."pxCreateOpName" , pxcreatesystemid = source."pxCreateSystemID" , pxindexcount = source."pxIndexCount" , pxindexpurpose = source."pxIndexPurpose" , pxinsindexedclass = source."pxInsIndexedClass" , pxinsindexedkey = source."pxInsIndexedKey" , pxinsname = source."pxInsName" , pxjavaclass = source."pxJavaClass" , pxjavamethodname = source."pxJavaMethodName" , pxobjclass = source."pxObjClass" , pxpagename = source."pxPageName" , pxreferencingdescription = source."pxReferencingDescription" , pxreferencinginsname = source."pxReferencingInsName" , pxreferencingrulesetname = source."pxReferencingRuleSetName" , pxreferencingrulesetversion = source."pxReferencingRuleSetVersion" , pxruleclassname = source."pxRuleClassName" , pxrulefamilyname = source."pxRuleFamilyName" , pxruleobjclass = source."pxRuleObjClass" , pxsavedatetime = source."pxSaveDateTime" , pxupdatedatetime = source."pxUpdateDateTime" , pxupdateoperator = source."pxUpdateOperator" , pxupdateopname = source."pxUpdateOpName" , pxupdatesystemid = source."pxUpdateSystemID" , pylabel = source."pyLabel" , pyrulename = source."pyRuleName" FROM source WHERE t.pzinskey = source."pzInsKey" RETURNING *) INSERT INTO pegarules.pr_index_reference (pzInsKey , pxCommitDateTime , pxcreatedatetime , pxcreateoperator , pxcreateopname , pxcreatesystemid , pxindexcount , pxindexpurpose , pxinsindexedclass , pxinsindexedkey , pxinsname , pxjavaclass , pxjavamethodname , pxobjclass , pxpagename , pxreferencingdescription , pxreferencinginsname , pxreferencingrulesetname , pxreferencingrulesetversion , pxruleclassname , pxrulefamilyname , pxruleobjclass , pxsavedatetime , pxupdatedatetime , pxupdateoperator , pxupdateopname , pxupdatesystemid , pylabel , pyrulename) SELECT source."pzInsKey" , CURRENT_TIMESTAMP , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxIndexCount" , source."pxIndexPurpose" , source."pxInsIndexedClass" , source."pxInsIndexedKey" , source."pxInsName" , source."pxJavaClass" , source."pxJavaMethodName" , source."pxObjClass" , source."pxPageName" , source."pxReferencingDescription" , source."pxReferencingInsName" , source."pxReferencingRuleSetName" , source."pxReferencingRuleSetVersion" , source."pxRuleClassName" , source."pxRuleFamilyName" , source."pxRuleObjClass" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyLabel" , source."pyRuleName" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted.  Call getNextException to see the cause. 
From: (BBC7FB2F6CFE56DAE1591F2AAC45D8D32)  
	at com.pega.pegarules.deploy.internal.loaders.SaverLoader.issueCommit(SaverLoader.java:837) 
	at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:263) 
	... 28 more 
Caused by: com.pega.pegarules.pub.database.DatabaseException: Batch entry 0 WITH source as (SELECT 'INDEX-REFERENCE DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pzInsKey" , NULL::timestamp "pxCreateDateTime" , NULL::varchar "pxCreateOperator" , NULL::varchar "pxCreateOpName" , NULL::varchar "pxCreateSystemID" , '8'::numeric "pxIndexCount" , 'RuleReference'::varchar "pxIndexPurpose" , 'Data-Admin-Operator-AccessGroup'::varchar "pxInsIndexedClass" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS'::varchar "pxInsIndexedKey" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pxInsName" , NULL::varchar "pxJavaClass" , NULL::varchar "pxJavaMethodName" , 'Index-Reference'::varchar "pxObjClass" , NULL::varchar "pxPageName" , NULL::varchar "pxReferencingDescription" , 'RESQUESTFW:ADMINISTRATORS'::varchar "pxReferencingInsName" , NULL::varchar "pxReferencingRuleSetName" , NULL::varchar "pxReferencingRuleSetVersion" , NULL::varchar "pxRuleClassName" , NULL::varchar "pxRuleFamilyName" , 'Rule-Portal'::varchar "pxRuleObjClass" , NULL::timestamp "pxSaveDateTime" , NULL::timestamp "pxUpdateDateTime" , NULL::varchar "pxUpdateOperator" , NULL::varchar "pxUpdateOpName" , NULL::varchar "pxUpdateSystemID" , NULL::varchar "pyLabel" , 'Developer'::varchar "pyRuleName"), upsert AS (UPDATE pegarules.pr_index_reference t SET pxCommitDateTime = CURRENT_TIMESTAMP , pxcreatedatetime = source."pxCreateDateTime" , pxcreateoperator = source."pxCreateOperator" , pxcreateopname = source."pxCreateOpName" , pxcreatesystemid = source."pxCreateSystemID" , pxindexcount = source."pxIndexCount" , pxindexpurpose = source."pxIndexPurpose" , pxinsindexedclass = source."pxInsIndexedClass" , pxinsindexedkey = source."pxInsIndexedKey" , pxinsname = source."pxInsName" , pxjavaclass = source."pxJavaClass" , pxjavamethodname = source."pxJavaMethodName" , pxobjclass = source."pxObjClass" , pxpagename = source."pxPageName" , pxreferencingdescription = source."pxReferencingDescription" , pxreferencinginsname = source."pxReferencingInsName" , pxreferencingrulesetname = source."pxReferencingRuleSetName" , pxreferencingrulesetversion = source."pxReferencingRuleSetVersion" , pxruleclassname = source."pxRuleClassName" , pxrulefamilyname = source."pxRuleFamilyName" , pxruleobjclass = source."pxRuleObjClass" , pxsavedatetime = source."pxSaveDateTime" , pxupdatedatetime = source."pxUpdateDateTime" , pxupdateoperator = source."pxUpdateOperator" , pxupdateopname = source."pxUpdateOpName" , pxupdatesystemid = source."pxUpdateSystemID" , pylabel = source."pyLabel" , pyrulename = source."pyRuleName" FROM source WHERE t.pzinskey = source."pzInsKey" RETURNING *) INSERT INTO pegarules.pr_index_reference (pzInsKey , pxCommitDateTime , pxcreatedatetime , pxcreateoperator , pxcreateopname , pxcreatesystemid , pxindexcount , pxindexpurpose , pxinsindexedclass , pxinsindexedkey , pxinsname , pxjavaclass , pxjavamethodname , pxobjclass , pxpagename , pxreferencingdescription , pxreferencinginsname , pxreferencingrulesetname , pxreferencingrulesetversion , pxruleclassname , pxrulefamilyname , pxruleobjclass , pxsavedatetime , pxupdatedatetime , pxupdateoperator , pxupdateopname , pxupdatesystemid , pylabel , pyrulename) SELECT source."pzInsKey" , CURRENT_TIMESTAMP , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxIndexCount" , source."pxIndexPurpose" , source."pxInsIndexedClass" , source."pxInsIndexedKey" , source."pxInsName" , source."pxJavaClass" , source."pxJavaMethodName" , source."pxObjClass" , source."pxPageName" , source."pxReferencingDescription" , source."pxReferencingInsName" , source."pxReferencingRuleSetName" , source."pxReferencingRuleSetVersion" , source."pxRuleClassName" , source."pxRuleFamilyName" , source."pxRuleObjClass" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyLabel" , source."pyRuleName" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted.  Call getNextException to see the cause. 
From: (BBC7FB2F6CFE56DAE1591F2AAC45D8D32)  
	SQL: WITH source as (SELECT ?::varchar "pzInsKey" , ?::timestamp "pxCreateDateTime" , ?::varchar "pxCreateOperator" , ?::varchar "pxCreateOpName" , ?::varchar "pxCreateSystemID" , ?::numeric "pxIndexCount" , ?::varchar "pxIndexPurpose" , ?::varchar "pxInsIndexedClass" , ?::varchar "pxInsIndexedKey" , ?::varchar "pxInsName" , ?::varchar "pxJavaClass" , ?::varchar "pxJavaMethodName" , ?::varchar "pxObjClass" , ?::varchar "pxPageName" , ?::varchar "pxReferencingDescription" , ?::varchar "pxReferencingInsName" , ?::varchar "pxReferencingRuleSetName" , ?::varchar "pxReferencingRuleSetVersion" , ?::varchar "pxRuleClassName" , ?::varchar "pxRuleFamilyName" , ?::varchar "pxRuleObjClass" , ?::timestamp "pxSaveDateTime" , ?::timestamp "pxUpdateDateTime" , ?::varchar "pxUpdateOperator" , ?::varchar "pxUpdateOpName" , ?::varchar "pxUpdateSystemID" , ?::varchar "pyLabel" , ?::varchar "pyRuleName"), upsert AS (UPDATE pegarules.pr_index_reference t SET pxCommitDateTime = CURRENT_TIMESTAMP , pxcreatedatetime = source."pxCreateDateTime" , pxcreateoperator = source."pxCreateOperator" , pxcreateopname = source."pxCreateOpName" , pxcreatesystemid = source."pxCreateSystemID" , pxindexcount = source."pxIndexCount" , pxindexpurpose = source."pxIndexPurpose" , pxinsindexedclass = source."pxInsIndexedClass" , pxinsindexedkey = source."pxInsIndexedKey" , pxinsname = source."pxInsName" , pxjavaclass = source."pxJavaClass" , pxjavamethodname = source."pxJavaMethodName" , pxobjclass = source."pxObjClass" , pxpagename = source."pxPageName" , pxreferencingdescription = source."pxReferencingDescription" , pxreferencinginsname = source."pxReferencingInsName" , pxreferencingrulesetname = source."pxReferencingRuleSetName" , pxreferencingrulesetversion = source."pxReferencingRuleSetVersion" , pxruleclassname = source."pxRuleClassName" , pxrulefamilyname = source."pxRuleFamilyName" , pxruleobjclass = source."pxRuleObjClass" , pxsavedatetime = source."pxSaveDateTime" , pxupdatedatetime = source."pxUpdateDateTime" , pxupdateoperator = source."pxUpdateOperator" , pxupdateopname = source."pxUpdateOpName" , pxupdatesystemid = source."pxUpdateSystemID" , pylabel = source."pyLabel" , pyrulename = source."pyRuleName" FROM source WHERE t.pzinskey = source."pzInsKey" RETURNING *) INSERT INTO pegarules.pr_index_reference (pzInsKey , pxCommitDateTime , pxcreatedatetime , pxcreateoperator , pxcreateopname , pxcreatesystemid , pxindexcount , pxindexpurpose , pxinsindexedclass , pxinsindexedkey , pxinsname , pxjavaclass , pxjavamethodname , pxobjclass , pxpagename , pxreferencingdescription , pxreferencinginsname , pxreferencingrulesetname , pxreferencingrulesetversion , pxruleclassname , pxrulefamilyname , pxruleobjclass , pxsavedatetime , pxupdatedatetime , pxupdateoperator , pxupdateopname , pxupdatesystemid , pylabel , pyrulename) SELECT source."pzInsKey" , CURRENT_TIMESTAMP , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxIndexCount" , source."pxIndexPurpose" , source."pxInsIndexedClass" , source."pxInsIndexedKey" , source."pxInsName" , source."pxJavaClass" , source."pxJavaMethodName" , source."pxObjClass" , source."pxPageName" , source."pxReferencingDescription" , source."pxReferencingInsName" , source."pxReferencingRuleSetName" , source."pxReferencingRuleSetVersion" , source."pxRuleClassName" , source."pxRuleFamilyName" , source."pxRuleObjClass" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyLabel" , source."pyRuleName" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) 
 
Caused by SQL Problems. 
Problem #1, SQLState XX001, Error code 0: java.sql.BatchUpdateException: Batch entry 0 WITH source as (SELECT 'INDEX-REFERENCE DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pzInsKey" , NULL::timestamp "pxCreateDateTime" , NULL::varchar "pxCreateOperator" , NULL::varchar "pxCreateOpName" , NULL::varchar "pxCreateSystemID" , '8'::numeric "pxIndexCount" , 'RuleReference'::varchar "pxIndexPurpose" , 'Data-Admin-Operator-AccessGroup'::varchar "pxInsIndexedClass" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS'::varchar "pxInsIndexedKey" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pxInsName" , NULL::varchar "pxJavaClass" , NULL::varchar "pxJavaMethodName" , 'Index-Reference'::varchar "pxObjClass" , NULL::varchar "pxPageName" , NULL::varchar "pxReferencingDescription" , 'RESQUESTFW:ADMINISTRATORS'::varchar "pxReferencingInsName" , NULL::varchar "pxReferencingRuleSetName" , NULL::varchar "pxReferencingRuleSetVersion" , NULL::varchar "pxRuleClassName" , NULL::varchar "pxRuleFamilyName" , 'Rule-Portal'::varchar "pxRuleObjClass" , NULL::timestamp "pxSaveDateTime" , NULL::timestamp "pxUpdateDateTime" , NULL::varchar "pxUpdateOperator" , NULL::varchar "pxUpdateOpName" , NULL::varchar "pxUpdateSystemID" , NULL::varchar "pyLabel" , 'Developer'::varchar "pyRuleName"), upsert AS (UPDATE pegarules.pr_index_reference t SET pxCommitDateTime = CURRENT_TIMESTAMP , pxcreatedatetime = source."pxCreateDateTime" , pxcreateoperator = source."pxCreateOperator" , pxcreateopname = source."pxCreateOpName" , pxcreatesystemid = source."pxCreateSystemID" , pxindexcount = source."pxIndexCount" , pxindexpurpose = source."pxIndexPurpose" , pxinsindexedclass = source."pxInsIndexedClass" , pxinsindexedkey = source."pxInsIndexedKey" , pxinsname = source."pxInsName" , pxjavaclass = source."pxJavaClass" , pxjavamethodname = source."pxJavaMethodName" , pxobjclass = source."pxObjClass" , pxpagename = source."pxPageName" , pxreferencingdescription = source."pxReferencingDescription" , pxreferencinginsname = source."pxReferencingInsName" , pxreferencingrulesetname = source."pxReferencingRuleSetName" , pxreferencingrulesetversion = source."pxReferencingRuleSetVersion" , pxruleclassname = source."pxRuleClassName" , pxrulefamilyname = source."pxRuleFamilyName" , pxruleobjclass = source."pxRuleObjClass" , pxsavedatetime = source."pxSaveDateTime" , pxupdatedatetime = source."pxUpdateDateTime" , pxupdateoperator = source."pxUpdateOperator" , pxupdateopname = source."pxUpdateOpName" , pxupdatesystemid = source."pxUpdateSystemID" , pylabel = source."pyLabel" , pyrulename = source."pyRuleName" FROM source WHERE t.pzinskey = source."pzInsKey" RETURNING *) INSERT INTO pegarules.pr_index_reference (pzInsKey , pxCommitDateTime , pxcreatedatetime , pxcreateoperator , pxcreateopname , pxcreatesystemid , pxindexcount , pxindexpurpose , pxinsindexedclass , pxinsindexedkey , pxinsname , pxjavaclass , pxjavamethodname , pxobjclass , pxpagename , pxreferencingdescription , pxreferencinginsname , pxreferencingrulesetname , pxreferencingrulesetversion , pxruleclassname , pxrulefamilyname , pxruleobjclass , pxsavedatetime , pxupdatedatetime , pxupdateoperator , pxupdateopname , pxupdatesystemid , pylabel , pyrulename) SELECT source."pzInsKey" , CURRENT_TIMESTAMP , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxIndexCount" , source."pxIndexPurpose" , source."pxInsIndexedClass" , source."pxInsIndexedKey" , source."pxInsName" , source."pxJavaClass" , source."pxJavaMethodName" , source."pxObjClass" , source."pxPageName" , source."pxReferencingDescription" , source."pxReferencingInsName" , source."pxReferencingRuleSetName" , source."pxReferencingRuleSetVersion" , source."pxRuleClassName" , source."pxRuleFamilyName" , source."pxRuleObjClass" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyLabel" , source."pyRuleName" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted.  Call getNextException to see the cause. 
Problem #2, SQLState XX001, Error code 0: org.postgresql.util.PSQLException: ERROR: invalid page in block 8634 of relation base/16385/287483 
	at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:299) 
	at com.pega.pegarules.data.internal.access.ConnectionStatementStore.executeBatchForAllStatements(ConnectionStatementStore.java:200) 
	at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.executeOutstandingBatches(ThreadConnectionStoreImpl.java:269) 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2676) 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2322) 
	at com.pega.pegarules.data.internal.access.DatabaseImpl.commit(DatabaseImpl.java:2061) 
	at com.pega.pegarules.deploy.internal.loaders.SaverLoader.issueCommit(SaverLoader.java:831) 
	... 29 more 
Caused by: java.sql.BatchUpdateException: Batch entry 0 WITH source as (SELECT 'INDEX-REFERENCE DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pzInsKey" , NULL::timestamp "pxCreateDateTime" , NULL::varchar "pxCreateOperator" , NULL::varchar "pxCreateOpName" , NULL::varchar "pxCreateSystemID" , '8'::numeric "pxIndexCount" , 'RuleReference'::varchar "pxIndexPurpose" , 'Data-Admin-Operator-AccessGroup'::varchar "pxInsIndexedClass" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS'::varchar "pxInsIndexedKey" , 'DATA-ADMIN-OPERATOR-ACCESSGROUP RESQUESTFW:ADMINISTRATORS!8!RULEREFERENCE'::varchar "pxInsName" , NULL::varchar "pxJavaClass" , NULL::varchar "pxJavaMethodName" , 'Index-Reference'::varchar "pxObjClass" , NULL::varchar "pxPageName" , NULL::varchar "pxReferencingDescription" , 'RESQUESTFW:ADMINISTRATORS'::varchar "pxReferencingInsName" , NULL::varchar "pxReferencingRuleSetName" , NULL::varchar "pxReferencingRuleSetVersion" , NULL::varchar "pxRuleClassName" , NULL::varchar "pxRuleFamilyName" , 'Rule-Portal'::varchar "pxRuleObjClass" , NULL::timestamp "pxSaveDateTime" , NULL::timestamp "pxUpdateDateTime" , NULL::varchar "pxUpdateOperator" , NULL::varchar "pxUpdateOpName" , NULL::varchar "pxUpdateSystemID" , NULL::varchar "pyLabel" , 'Developer'::varchar "pyRuleName"), upsert AS (UPDATE pegarules.pr_index_reference t SET pxCommitDateTime = CURRENT_TIMESTAMP , pxcreatedatetime = source."pxCreateDateTime" , pxcreateoperator = source."pxCreateOperator" , pxcreateopname = source."pxCreateOpName" , pxcreatesystemid = source."pxCreateSystemID" , pxindexcount = source."pxIndexCount" , pxindexpurpose = source."pxIndexPurpose" , pxinsindexedclass = source."pxInsIndexedClass" , pxinsindexedkey = source."pxInsIndexedKey" , pxinsname = source."pxInsName" , pxjavaclass = source."pxJavaClass" , pxjavamethodname = source."pxJavaMethodName" , pxobjclass = source."pxObjClass" , pxpagename = source."pxPageName" , pxreferencingdescription = source."pxReferencingDescription" , pxreferencinginsname = source."pxReferencingInsName" , pxreferencingrulesetname = source."pxReferencingRuleSetName" , pxreferencingrulesetversion = source."pxReferencingRuleSetVersion" , pxruleclassname = source."pxRuleClassName" , pxrulefamilyname = source."pxRuleFamilyName" , pxruleobjclass = source."pxRuleObjClass" , pxsavedatetime = source."pxSaveDateTime" , pxupdatedatetime = source."pxUpdateDateTime" , pxupdateoperator = source."pxUpdateOperator" , pxupdateopname = source."pxUpdateOpName" , pxupdatesystemid = source."pxUpdateSystemID" , pylabel = source."pyLabel" , pyrulename = source."pyRuleName" FROM source WHERE t.pzinskey = source."pzInsKey" RETURNING *) INSERT INTO pegarules.pr_index_reference (pzInsKey , pxCommitDateTime , pxcreatedatetime , pxcreateoperator , pxcreateopname , pxcreatesystemid , pxindexcount , pxindexpurpose , pxinsindexedclass , pxinsindexedkey , pxinsname , pxjavaclass , pxjavamethodname , pxobjclass , pxpagename , pxreferencingdescription , pxreferencinginsname , pxreferencingrulesetname , pxreferencingrulesetversion , pxruleclassname , pxrulefamilyname , pxruleobjclass , pxsavedatetime , pxupdatedatetime , pxupdateoperator , pxupdateopname , pxupdatesystemid , pylabel , pyrulename) SELECT source."pzInsKey" , CURRENT_TIMESTAMP , source."pxCreateDateTime" , source."pxCreateOperator" , source."pxCreateOpName" , source."pxCreateSystemID" , source."pxIndexCount" , source."pxIndexPurpose" , source."pxInsIndexedClass" , source."pxInsIndexedKey" , source."pxInsName" , source."pxJavaClass" , source."pxJavaMethodName" , source."pxObjClass" , source."pxPageName" , source."pxReferencingDescription" , source."pxReferencingInsName" , source."pxReferencingRuleSetName" , source."pxReferencingRuleSetVersion" , source."pxRuleClassName" , source."pxRuleFamilyName" , source."pxRuleObjClass" , source."pxSaveDateTime" , source."pxUpdateDateTime" , source."pxUpdateOperator" , source."pxUpdateOpName" , source."pxUpdateSystemID" , source."pyLabel" , source."pyRuleName" FROM source WHERE NOT EXISTS (SELECT null FROM upsert) was aborted.  Call getNextException to see the cause. 
	at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762) 
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1999) 
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:421) 
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929) 
	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 
	at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) 
	at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:534) 
	at com.pega.pegarules.data.internal.access.ConnectionStatementStore.executeBatchForAllStatements(ConnectionStatementStore.java:198) 
	... 34 more 
Pega Academy
Moderation Team has archived post
Share this page LinkedIn