Question
Charter Communications
US
Last activity: 17 Mar 2023 2:38 EDT
Exposed new column to Interaction history fact table causing PropertyValueInvalid Exception
Hello,
We had requirement to expose new column to Pega's Interaction history FACT Table. We have done below steps based on https://docs-previous.pega.com/pega-customer-decision-hub-user-guide/86/extending-interaction-history:
1) Created new property 'Disprequired' in CDH-SR and Data-Decision-IH-Fact class as Text property
2) Updated Data transform "pyInteractionHistoryConfiguration" to add below:
Primary.pyFactProperties(<APPEND>) = "Disprequired"
Primary.pyMeasurements(<APPEND>) = "Disprequired"
3) Created new column in Pegadatacdh.pr_data_ih_fact table as "DISPREQUIRED" with VARCHAR2(32).
After doing above test, we tested GetNBA request through postman and we are able to see Disprequired value is capturing correctly.
However, when we are checking PDC, we are getting below exception:
PropertyValueInvalid .Disprequired Cannot cast the value (Y) to double
Call stack:
Hello,
We had requirement to expose new column to Pega's Interaction history FACT Table. We have done below steps based on https://docs-previous.pega.com/pega-customer-decision-hub-user-guide/86/extending-interaction-history:
1) Created new property 'Disprequired' in CDH-SR and Data-Decision-IH-Fact class as Text property
2) Updated Data transform "pyInteractionHistoryConfiguration" to add below:
Primary.pyFactProperties(<APPEND>) = "Disprequired"
Primary.pyMeasurements(<APPEND>) = "Disprequired"
3) Created new column in Pegadatacdh.pr_data_ih_fact table as "DISPREQUIRED" with VARCHAR2(32).
After doing above test, we tested GetNBA request through postman and we are able to see Disprequired value is capturing correctly.
However, when we are checking PDC, we are getting below exception:
PropertyValueInvalid .Disprequired Cannot cast the value (Y) to double
Call stack:
| Relative Position | Stack Frame Description |
|---|---|
| (top of stack) | DataFlow-Execute |
| RULE-OBJ-ACTIVITY @BASECLASS CAPTUREINTERACTION #20200713T133011.344 GMT Step: 4 Circum: 0 | |
| doActivity Rule-Obj-Activity:CaptureInteraction | |
| call CaptureInteraction | |
| RULE-OBJ-ACTIVITY INT-PEGACDH-CONTAINER CAPTUREIMPRESSIONSINBATCH #20200311T062849.384 GMT Step: 6 Circum: 0 | |
| 2 additional frames in stack |
Can somebody let me know if they faced similar issue or have any resolution ? I tried searching Pega community discussions/questions but not able to find correct solution.