Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Discussion

 Sandeep Ghosh (Sandeep_Ghosh)
Scotiabank
Lead System Architect
Scotiabank
CA
Sandeep_Ghosh Member since 2011 43 posts
Scotiabank
Posted: Jul 17, 2016
Last activity: Jul 20, 2016
Posted: 17 Jul 2016 11:40 EDT
Last activity: 20 Jul 2016 10:59 EDT
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  [email protected] - 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 
To see attachments, please log in.
Pega Academy

Posted: 8 years ago
Posted: 18 Jul 2016 10:39 EDT
James Adair (JamesAdair)
PEGA
Lead Service Assurance Advisor
Pegasystems Inc.
US

I just tested the import of Case Design Case Study 1 and found no errors on the import or in the logfile. Perhaps you are not unzipping the .zip file to get 2 files (Solution pdf and  .jar file). You must then import the .jar file. Another source of error is that you are not importing to the most current PRPC version for the CLSA course.

To see attachments, please log in.
Posted: 8 years ago
Posted: 19 Jul 2016 12:34 EDT
Sandeep Ghosh (Sandeep_Ghosh)
Scotiabank
Lead System Architect
Scotiabank
CA

Hello

I have extracted the .zip file but still facing issues while performing an import. I downloaded this VM on 28th June and running this on Oracle VM Virtual Box. Do you have any idea if any new version of VM was released after 28th June? 

Also I checked the documentation now, it has provided two options to run the VM, either Virtual box or VMWare player. earlier when I downloaded only one option was there i.e. Virtual box.

Regards,

Sandeep

To see attachments, please log in.
Posted: 8 years ago
Posted: 19 Jul 2016 12:57 EDT
Sandeep Ghosh (Sandeep_Ghosh)
Scotiabank
Lead System Architect
Scotiabank
CA

I checked the documentation and file name suffix, I think there was a new version released on 8th July 2016. I will download it and try to import again.

A suggestion would be to send an email to all users who have enrolled to the course whenever a new VM is launched.

Regards,

Sandeep

To see attachments, please log in.
Posted: 8 years ago
Posted: 20 Jul 2016 10:59 EDT
Eddie Moczygemba (eddie.jm)
PEGA
Principal Application Support Engineer
Pegasystems Inc.
US

Sandeep,

the new version of the VM released on 8th July 2016 is simply a new archive format. The VM itself, and the Pega 7 app in particular, is exactly the same.

All of the Pega Academy VMs are now distributed in an open format, allowing training participants to use a VM player of their preference. 

The issue you have re importing the jar for the Data Model case study is unrelated to the VM archive.

eddie

To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice