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

[s_mungloo]

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

[Former Member]

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

[former_member182521]

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

[TammyPowlas]

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/

[s_mungloo]

Hi Tammy!

Thanks for your answer. I have seen this blog as well and changed the format of the date, however, the problem still persists! 😞