Support Article
Data is not saving in index table
SA-72309
Summary
Unable to save data to the index table and instances are not created for work objects.
Error Messages
Not Applicable
Steps to Reproduce
Create a declare index rule.
Root Cause
The index table which is mapped to the index class has more than one primary key constraint as below:
CONSTRAINT "MODALITY_PK" PRIMARY KEY ("PXINSINDEXEDKEY", "PXINDEXCOUNT", "PXINDEXPURPOSE", "MODALITY")
However, when passing data at runtime, the required properties are not passed to the index table. Hence, no instance was saved to the index table.
Resolution
Perform the following local-change:
Change the primary key constraint to the PZINSKEY property and create the table.
CONSTRAINT "Idx-GE-Hlds-Data-Modality_PK" PRIMARY KEY ("PZINSKEY")
Published March 9, 2019 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.