Table doesn't have a primary key Error
I am having trouble utilizing the Lookup Table function. When I try to add a record to the table, I get the following error:
Error executing link in Automation: ABI_P_SAQSubmit2 - From: ABI_P_SAQSubmit2.CountIndex.Properties To: ABI_P_SAQSubmit2.OrderNums.AddRecord()
Table doesn't have a primary key.
Screenshot attached. I have the key I want set to TRUE in the Collection Editor, but that hasn't seemed to help. Any ideas?
Jamie
Pegasystems Inc.
US
Is OrderNum blank? You might add a right before AddRecord and then add a watch to the OrderNum to see what its value is. I would guess that is the issue.
Anheuser-Busch Inc
US
Thank you for the response.
OrderNum has a string value of 143026 being sent into the Table. I've attached a screenshot.
Is it a data type issue? I specified on the table that the type should be string, but I might have missed something else.
Thanks!
Jamie
Pegasystems Inc.
US
From here it looks like it should work. I would create a simple test where you call AddRecord to that table from a win form to see if you have corrupted the table. Absent any other information, I have no real suggestion other than you might consider opening an SR to get someone from support to assist you.
Pegasystems Inc.
US
Just wanted to add corroborating information to your response Manish.
I had the same issue as above with a local LookupTable. Making the local LookupTable global solved the issue.
Thanks!