Skip to Content
avatar image
Former Member

2048 column store error: search parameter error: [2018]

[SAP AG][LIBODBCHDB DLL][HDODBC]General error;2048 column store error: search parameter error: [2018] A received argument has an invalid value;TABLE/VIEW parameter: ( 'I_DateFrom'='$$I_DateFrom$$, 1/1/2018') not supported.

I'm actually inquiring on behalf of a customer we have in common. He has created a query of his data using Alteryx. The query

Select * From _SYS_BIC."table.name/Q_CA_detail"
('I_DateFrom' = ('$$I_DateFrom$$','1/1/2017'),'I_DateTo' = ('$$I_DateTo$$','1/1/2018'))

returns the above error on execution.

(SAP server is PHN (version 1.00.122.10.1496218861)

Connecting to SAP Hana server via ODBC (HDBODBC – version 1.00.112.00))

What advice can you impart?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 06 at 10:02 PM

    did you try your date value as yyyymmdd ? it makes a difference

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15 at 08:18 PM

    Hi,

    I am now convinced that the problem is that the ODBC connector used to transmit the query to the database is eliminating some of the single quotes, so the query that should be

    Select * From _SYS_BIC."table.name/Q_CA_detail"('I_DateFrom' = ('$$I_DateFrom$$','1/1/2017'),'I_DateTo' = ('$$I_DateTo$$','1/1/2018'))

    instead arrives at the database as

    Select * From _SYS_BIC."table.name/Q_CA_detail"('I_DateFrom' = ('$$I_DateFrom$$,1/1/2017'),'I_DateTo' = ('$$I_DateTo$$,1/1/2018'))

    and the database throws the above error.

    This leads to the question, is there a revised connector that doesn't do that?

    Add comment
    10|10000 characters needed characters exceeded