Issue in creating declare index
Hi Team,
I am trying to create a declare index rule for a page property. I created a index table mapped it to a class and when i say test connectivity in class it throws errors.
"There is a key mismatch: the keys defined for class Index-AMZN-FW-RytmFW-TaskSchedule do not match the primary key columns for external data table DATA.Index_TaskSchedule in database PegaAdmin; the class keys are [pxInsIndexedKey, pxIndexCount, pxIndexPurpose], but the table's primary keys are []"
Is there a wizard to create declare index class and index rules? I read few posts in pdn on doing optimize for property but that didnt work.
PFA document.
Accepted Solution
IN
Issue is Resolved. I had to add pxobjclass column in table.
Pegasystems Inc.
US
I typically use the Index-WorkPartyUri class as an example when I need to create a new index class. The primary key of the table is pzInsKey. The pzInsKey is made up of the keys specified in the class.
IN
Hi Carissaw,I tried the approach u mentioned. My table has pzinskey key as PK and class has that 3 index properties as keys. Still test connectivity fails and same old error
I have a quick question here the keys in class and the table shd be same right? How can we give pzinskey in table and something else in class