Skip to Content

column store error: search table error: [6968]

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 29, 2015 at 02:07 PM

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

    Add comment
    10|10000 characters needed characters exceeded