Skip to Content
avatar image
-2
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 14 at 10:51 PM

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

    Add comment
    10|10000 characters needed characters exceeded

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