cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member183326
Active Contributor
0 Kudos

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')

Former Member
0 Kudos

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.

former_member183326
Active Contributor
0 Kudos

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??"