cancel
Showing results for 
Search instead for 
Did you mean: 

Design Studio throwing error on valid field

Former Member
0 Kudos

ds-error.jpgHi All,

I am beginning to use Design Studio (DS) after 3-4 years now. Last version that i worked on was 1.3. I am facing issues when I am trying to grad data from HANA Calculation View (CV) into DS. CV has two measure which are defined as Data Type Decimal, Length 11 and Scale 2. By itself the measure show the total value but when I add any characteristics, it throws an error in Live Preview window stating "Could not Find any data to display." Error message says "

  • SQL Error: SAP DBTech JDBC: [266]: inconsistent datatype: [6970] Evaluator: type error in expression evaluator "

I have attached the screenshot for reference. I would greatly appreciate if someone can help.

Former Member
0 Kudos

I am using 1.6 version

TammyPowlas
Active Contributor
0 Kudos

Which SP? Are you using an http connection?

Former Member
0 Kudos

Design Studio version 16.5.3. I have native client install and I am connecting to Native Hana using ODBC connection.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Well Tammy, I am able to connect to HANA Backend and when I bring in measure, I see the data. It is only when I bring the characteristics, I see that error. Please see the attached screenshot.capture.jpg

Former Member
0 Kudos

I am on HANA SP12

TammyPowlas
Active Contributor
0 Kudos

Raj - reading the SAP PAM, it appears to me that only http connection is supported for HANA, not ODBC:

Source: SAP

https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/SBOP_DSTUDIO_16.pdf