Hi ,
Getting following error after updating CDT with new column, updated DB and published data store as well without errors.
Expression evaluation error in rule 'ewr_getslparfbyslparfid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [EWREPMSLPARFDT4106], query: [EWR_getSLPARFbySLPARFID], order by: [[]], filters:[(EPMSLPARFID = TypedValue[it=1,v=480])])
Thanks
Soujanya
Discussion posts and replies are publicly visible
Hi Vinay, Latest/Last column which I have added is of Date type. I have already tried with sortinfo but still getting the same error.
Expression evaluation error in rule 'ewr_getslparfbyslparfid' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Unexpected error executing query (type: [EWREPMSLPARFDT4106], query: [EWR_getSLPARFbySLPARFID], order by: [[Sort[AgreementDate asc]]], filters:[(EPMSLPARFID = TypedValue[it=1,v=482])])
Thanks Soujanya
Thanks for the reply! Both the datatypes in CDT and DB are same. I just added one new column in DSE AgreementDate (Date and TIme ) in CDT and then alter table EPM_SL_PARF add column AGREEMENTDATE timestamp; commit; in table (DB) Refreshed the DSE in DS and verified then did Save and published. I didn't get any errors. Getting an error only while executing. And one more thing , I have deleted newly added column and undo all my changes , it started working .So some issue with the new column which I have added.
Tried with different datatypes , same error for all of them.
Might be the issue in the order of creation , not sure ?