Getting error in query rule after updating CDT column

Hi,

when shorting is not pass on the query rule/Entity, then appian bydefault sort by the last column of the CDT,

I think your last column is boolean type

just for try can you pass the pagingInfo on query rule with sortinfo on the primary key field .

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

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

Did you try to verify the datastore?

yes

Please try to sort with different column

Tried with multiple columns and tried all the possible ways. same error.

please check on the server logs, you get the exact error

Soujanya B If the column types are changed in the database once the DSE is created, Appian will not throw any error message even if the type of the columns in the table and the CDT types are not matching. Please check the types of each and every column in the table with the type if the CDT fields.

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 ?