Support Article
PR_DATA_IH_DIM_ACTION missing IH_FACT records (pzActionID)
SA-69121
Summary
Error generated in the logs when duplicate entries for the same interaction is present in the R_DATA_IH_DIM_ACTION dimension table.
Error Messages
[fault (self-tuning)'] [STANDARD] [ ] [YOUR_APP:01.05] (internal.access.Opener) ERROR <YOUR HOST>|<your IP>|SOAP|YOURService|Services|getOffers|ARSDSDDCVFFFFFC9K3HZG5RE - Caught exception during open
com.pega.pegarules.pub.database.MultipleInstancesWithKeyException: There is more than one instance in the database with the following keys: pxObjClass = "Data-Decision-IH-Dimension-Action", pzID = "-6222617780775096245"
at com.pega.pegarules.data.internal.store.AutoCommitTransaction.getResultFromResultSet(AutoCommitTransaction.java:501) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.AutoCommitTransaction.performQuery(AutoCommitTransaction.java:359) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Opener$1.getResultPageFromDatabase(Opener.java:740) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:723) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:720) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.store.DataStoreManager.readInTransaction(DataStoreManager.java:71) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:751) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.Opener.open(Opener.java:2126) ~[prprivate.jar:?]
at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:2619) ~[prprivate.jar:?]
at com.pegarules.generated.pzLoadDimensionFromDatabase_071017_rhuX47JYKZCuyHwk5LhbfA.pzLoadDimensionFromDatabase07_10_17(pzLoadDimensionFromDatabase_071017_rhuX47JYKZCuyHwk5LhbfA.java:111) ~[?:?]
at com.pegarules.generated.pzLoadDimensionFromDatabase_071017_rhuX47JYKZCuyHwk5LhbfA.invoke(pzLoadDimensionFromDatabase_071017_rhuX47JYKZCuyHwk5LhbfA.java:78) ~[?:?]
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222) ~[prprivate.jar:?]
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9201) ~[prprivate.jar:?]
at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:258) ~[prpublic.jar:?]
at com.pegarules.generated.pega_decisionengine_interactionhistory.pzLoadDimensionFromDatabase(pega_decisionengine_interactionhistory.java:469) ~[?:?]
at com.pegarules.generated.pzLoadDimension_071017_nzVmSz_8WBY413wJofQsPQ.pzLoadDimension07_10_17(pzLoadDimension_071017_nzVmSz_8WBY413wJofQsPQ.java:115) ~[?:?]
at com.pegarules.generated.pzLoadDimension_071017_nzVmSz_8WBY413wJofQsPQ.invoke(pzLoadDimension_071017_nzVmSz_8WBY413wJofQsPQ.java:78) ~[?:?]
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222) ~[prprivate.jar:?]
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9201) ~[prprivate.jar:?]
at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:258) ~[prpublic.jar:?]
at com.pegarules.generated.pega_decisionengine_interactionhistory.pzLoadDimension(pega_decisionengine_interactionhistory.java:460) ~[?:?]
at com.pegarules.generated.pzStoreDimension_071017_yJ68joMzP_mt_C6ibDbXUQ.pzStoreDimension07_10_17(pzStoreDimension_071017_yJ68joMzP_mt_C6ibDbXUQ.java:120) ~[?:?]
at com.pegarules.generated.pzStoreDimension_071017_yJ68joMzP_mt_C6ibDbXUQ.invoke(pzStoreDimension_071017_yJ68joMzP_mt_C6ibDbXUQ.java:78) ~[?:?]
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222) ~[prprivate.jar:?]
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9201) ~[prprivate.jar:?]
at
.
.
.
com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646) ~[prprivate.jar:?]
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivitiesAlt(PRThreadImpl.java:481) ~[prprivate.jar:?]
at com.pega.pegarules.integration.engine.internal.RuleExecutionUtils.runServiceActivity(RuleExecutionUtils.java:436) ~[printegrint.jar:?]
at com.pega.pegarules.integration.engine.internal.services.ServiceAPI.runActivities(ServiceAPI.java:1946) ~[printegrint.jar:?]
at com.pega.pegarules.session.external.engineinterface.service.EngineAPI.processRequestInner(EngineAPI.java:399) ~[prenginext.jar:?]
at sun.reflect.GeneratedMethodAccessor369.invoke(Unknown Source) ~[?:?]
Steps to Reproduce
Not Applicable
Root Cause
A software use or operation error.
Interaction History (IH) schema was externalized by making a copy of the existing IH schema in Pega DATA. The primary key constraints were missing on the externalized PR_DATA_IH_DIM_ACTION table.
Resolution
Perform the following local-change:
Add the primary key constraint to PR_DATA_IH_DIM_ACTION as defined in the out-of-the-box tables.
Tags:
Published December 12, 2018 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.