Skip to Content
0

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

Dec 08, 2017 at 10:48 AM

208

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Tammy Powlas
Dec 08, 2017 at 10:55 AM
0

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/

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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! :(

0
Manikandan Elumalai Dec 10, 2017 at 02:41 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 08 at 10:47 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded