on 02-14-2018 11:36 AM
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.
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')
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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??"
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.