Skip to Content

SAP DBTech JDBC: [266] error when add DATE prompt on HANA based universe

Hello,

Whilst we use a date filter on a prompt on our HANA database, we encounter the following error:

"The following database error occurred: SAP DBTech JDBC: [266] (at 1293): inconsistent datatype 01/07/2017 is not a DATE type const: line 17 col 66 (at pos 1293). For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF)"

Error generated after click on OK :


----IDT configuration:

FYI, changing the format of the DATE does not solve the problem

Plateforme SAP BusinessObjects BI 4.2 Support Pack 4 Patch 4
Version : 14.2.4.2582

Thanks to help on this issue,

Sameerah

niwcs.png (9.7 kB)
rvehc.png (59.0 kB)
eicld.png (76.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 08, 2017 at 10:55 AM

    I am not sure if this will help - looks like this error has appeared before, and this person changed the format of their date to YYYY-MM-DD - see https://blogs.sap.com/2014/03/21/inconsistent-datatype-date-type-from-filtering/

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 10, 2017 at 02:41 AM

    Sameerah,

    I would suggest you to validate your Data source may be calculation views. I assume you created the universe in top of a view. Looking at the error message your HANA view in turn calls a function where the type casting is not happening properly.

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08 at 10:47 AM

    Hi, anyone knows how i can filter with date format DD/MM/YYY in Hana with user input ?

    Add comment
    10|10000 characters needed characters exceeded