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,As per your suggestion , created a new column and able to retrieve and add data to it in DB. But , when I am executing a query using that new column in DB , I am getting as invalid identifier.
ORA-00904 , AGREEMENTDATE : invalid identifier
Any idea ?
Please wrap the column in double quotes,
select * from tableName where "ColumnName" = 1111