Can anyone help me with the above error. I cannot find where the error lies and i do not have a developing background, i am new to Appian so any advise would be great.
Discussion posts and replies are publicly visible
Hi ,
Could you please tell us more about what is your PLM_View_CapturedLockData contains?I hope the view which you are creating many not be referring all the tables properly.
Hi,
It contains fields for properties and the relevant lock information so location, lock type, lock size, pricing etc. This was amended as previously it stored more information but this was no longer needed. So should this of been created as a new CDT?
Hi sarahb0001
Few things to consider here.
1) If this is a view, make sure the table mappings of the view are in line with that of the CDT. The verification should be successful and you need not need to publish the datastore to create the table.
2) It is very important that the table name,column name and column type of the view and that of the cdt are exactly matching.
If possible, can you post your cdt (xsd file) and the view's columns screenshot, it would be easier to debug
Hi sarahb0001,
Just a suggestion has the primary key been declared for the column. Since in Appian, it is necessary to have a primary key column for a unique identifier
Thanks Irshad Mohammed. Setting the primary key fixed the problem for me.