Skip to Content
-2

When trying to run a Analytic view in HANA, i am receiving below error.

Feb 14 at 11:36 AM

45

avatar image
Former Member

When trying to run a Analytic view in HANA, i am receiving error ""Error: SAP DBTech JDBC: [2]: general error: >= Cannot compare Daydate and Secondtime"

It is working fine in Dev, but not working in QA. Please let me know what I am missing.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Michael Healy
Feb 14 at 10:51 PM
0

your date conditions that have been set are probably wrong.

If you want to use CURRENT_DATE in a condition, the comparison target should contain the year and date information as below.
(1=1) AND (CURRENT_DATE BETWEEN '0001-01-01 00:00:00.000' AND '0001-01-01 23:59:59.999')

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

Hi Michael,

The view is working fine in DEV. If there is an error in the view it should not work in DEV also.

Do we need to set the comparison target somewhere in the system config?

Or are there any settings we need to change in system?

Regards,

Raja.

0

Hi Raja,

If the view works in DEV but not in QA then going by logic there is obviously something different here, there has to be.

As Florian has already pointed out:

"Please add more details to your question so that people are maybe able to react on your question. Just posting an error message, w/o description of the view, the relevant fields, maybe calculated columns, is not enough.

I removed also the tag "BW SAP HANA Modeling Tools (Eclipse)", because the question has nothing to do with that question. Or are you able to create your view with that tools??"

0