Breadcrumbs

10. Troubleshooting

This troubleshooting guide addresses frequent issues related to data source configuration, synchronization errors, Copilot connectivity, and Customer Insights logic updates.

Customer Insights Displays Multiple Lines for a Single Customer

Issue

Multiple records are shown for the same customer in the Customer Insights.

Cause

The Data Load was not configured correctly. The Batching Dimension Field must be selected to ensure that the field’s value remains consistent across all transaction records for a given customer.

Error Message

Java
PricingOpportunityTable [via QueryUtils]: ERROR(@32): toDMQuery: Invalid Datamart query:
[productAttribute] ERROR(@0): IFNULL: Incompatible arguments ExpirationDate:DATE <-> "Unknown":STRING

Resolution

The issue occurs because the product master date field is incorrectly marked as a dimension. To fix it, remove the dimension flag from the product master date field.

Reference

CI: crash on product column of a DATE type | Org - Pricefx Agents > Technical Readiness | Microsoft Teams (internal)

Data Source Not Accessible

Issue

After installing the Customer Insights package, a "Data Source Not Accessible" error appears.

Cause

Installing the Customer Insights package triggers a resynchronization of DS.Product and DS.Customer. If these data sources are not synchronized correctly, access issues may occur.

Resolution

  1. Open the Data Source in the application.

  2. Temporarily remove SKU or CustomerID as the key.

  3. Assign a random text field as a temporary key.

  4. Return to IntelliJ IDEA with the Pricefx Studio plugin.

  5. Redeploy both data sources.

  6. Once deployment is successful, run Internal Copy Data Load to repopulate data into DS.Product and DS.Customer.

Copilot Stuck in Processing State

Issue

The Copilot remains in the processing state indefinitely.

Cause

This typically occurs when the PlatformManager cannot establish a connection to the target partition.
If the partition has been recently refreshed, the PlatformManager Technical User may need to be recreated.

Resolution

  1. In the PlatformManager, navigate to Partition Access Entitlement.

  2. Select the Technical User.

  3. Click Test and Save.
    info This action will recreate and validate the technical user connection.

Customer Insights - Missing Aggregation Variables

Issue

The following error is displayed:

Java
CI: CustomerHealthSummaryTable [via QueryUtils]: ERROR(@41): toDMQuery: Invalid Datamart query:
[AggregationPeriodStartDate] Unknown variable: AggregationPeriodStartDate,
[AggregationPeriodEndDate] Unknown variable: AggregationPeriodEndDate

Cause

This occurs when the CI_AggregatedData Data Source is not properly configured according to the latest upgrade instructions.

Resolution

Adjust the CI_AggregatedData Data Source following the guidance in the Upgrade Notes 1.11.2 (Customer Insights).