Hello Everyone,
I am getting the following error when querying one of the table from application. The entity I am querying is a nested CDT.
Expression evaluation error in rule 'dcm_getproductbycaseid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [DCM_getProductByCaseId], type: [DCMCaseProductDT3274], objects successfully converted: [0]
It is an existing CDT which used to work just fine. The only recent change I have made is increased the column length for some of the fields in the table and removed the length parameter from the xsd annotation. Could it be the issue?
I am able to get data by sql select statement.
Please help if anyone knows or have experience on how to fix this issue. Thank you.
Discussion posts and replies are publicly visible
This is a bit of a guess but does your data store entity still verify without errors in the data store?
yes it does without any errors
I suggest to modify XSD to have the length parameter as well so that its in sync with the database table attributes. As the issue happened after you made the changes, fixing the change should resolve the issue as well.
HI subhashreel0001, Try to modify the xsd according to your db changes , keep lenth value in xsd same as your db and then check if it works.