Skip to Content
0

Calculated Column issue in HANA

May 05, 2017 at 08:34 AM

204

avatar image
Former Member

Hi Expert,

I am facing a issue in hana for calculated column whose datatype assigned is NVARCHAR(30),I am concatenating date at the end with other value.

After Concatenating the value is becoming more than 30 but their is no error coming while doing data preview.

e.g:

SRCDOC_ID= ORIGINALDOC_ID+SRC_TS, where ORIGINALDOCID='1831858076201021234WDevice1' and SRC_TS='20170405'

in data preview i am getting the value as SRCDOC_ID='1831858076201WDevice12017-04-05'

Please Help me about how its coming like this

Thanks

Saurabh Agarwal

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

4 Answers

Krishna Tangudu May 23, 2017 at 06:00 PM
0

This is seems to be know issue/solution where we see we define the length of the columns to be of specific length but the calculation view returns the complete value without mentioning any errors or warnings.

The issue becomes more visible, when we try to consume this view in BO or we use this in the data loading procedures where the length of the column is defined in synch with the length of the column in view . And the data loading fails due to maximum length violation error.

Would like to know if this is a known thing or if there are any enhancements coming to fix this. It would really help us a lot

Regards,
Krishna Tangudu

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

Hi krishna,

U are correct, while inserting through stored procedure i am getting the error while in the view no error or warning is coming.

Let me know in case u find any other thread or any fix for this issue.

Thanks

Saurabh Agarwal

0
avatar image
Former Member May 21, 2017 at 04:32 AM
0

In HANA date format is YYYY-MM-DD instead of YYYYMMD (as in ABAP). I assume SRC_TS is declared as DATE. In case you want result as '1831858076201WDevice120170405' instead of '1831858076201WDevice12017-04-05', try below -

SRCDOC_ID= "ORIGINALDOC_ID" + replace(string("SRC_TS"),'-','')

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

Hi Ashwini,

I think u didnt get the question correctly. SRC_TS i declared as date, and because of hyphen(-) only this issue is coming. Please check it and let me know the other solution.

Thanks

Saurabh Agarwal

0
Anjali Chimnani
May 21, 2017 at 01:05 PM
0

Hi,

The data will not be truncated in case the length you defined in the calculated column is less than the length of the data.

The data shall be properly shown to the user after calculation without any loss or error.

Thus, as in your case even though the length is 30, we see the concatenation result correctly.

Thank you.

Best Regards,

Anjali.

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

Hi Anjali,

As u said data will not be truncated if its more than the length of variable defined than what is the use of giving the size of variable in calculated column?

Thanks

Saurabh Agarwal

0
avatar image
Former Member May 25, 2017 at 09:00 PM
0

Hi,

We have also faced similar issue, it occurred only while processing huge number of records. We have realized that there is a mismatch in the result length and the length defined for the column. Only after increasing the field length, we could resolve the issue.

Regards

Santhosh

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

Hi Santhosh,

If i will increase the size of that field the issue will resolve. But the issue is i am not increasing than how its possible that it is accepting more than 30char?

Let me know in case u find any other thread or any fix for this issue.

Thanks

Saurabh

0