cancel
Showing results for 
Search instead for 
Did you mean: 

column store error: search table error: [6968]

0 Kudos

Hi Team,

I'm passing multiple input values in one of my stored procedure, it is working fine only when I pass either numeric or alphabets to a field.

it_proj_his = CE_PROJECTION(:it_ct_his, [HISTORYID, RECORD_ID, XN_GUID, COND_RATE, COGS_RATE, CANCEL_IND], ' in("RECORD_ID", :IP_RECORD_ID) AND in("XN_GUID", :IP_XN_GUID) AND "CANCEL_IND" != ''X'' ');

If I pass alphanumeric values to a field, it returns the syntax error.

call "_SYS_BIC"."CRM.PB/PROC_PB_QTY_MRMS"('1006059910,1002830256',

'4C40E989825462E0E10000000AB40A10,4E947D45D4BC04D8E10000000AB40A10',null);

Syntax error as follows:

SAP DBTech JDBC: [2048]: column store error: search table error:  [6968] Evaluator: syntax error in expression string;expected TK_RPAREN,parsing " in(\"RECORD_ID\", 1006059910,1002830256) AND in(\"XN_GUID\", 4[here]C40E989825462E0E10000000AB40A10,4E947D45D4BC04D8E10000000AB40A10) AND \"CANCEL_IND\" != 'X' "

I tried changing the data type from NVARCHAR to ALPHANUM for a field, still doesn't work. Please help me resolving this issue.

Thanks for your help in Advance.

Regards,

Sathish


Accepted Solutions (0)

Answers (1)

Answers (1)

SergioG_TX
Active Contributor
0 Kudos

hi sathish, were you able to solve this? i am also having this issue