XSA Calculation View text join

[anandmuthu]

Hi experts,

I am hitting a funny problem where my calculation view text join returns funny records and any editing to change after first build returns an error.

I have a simple calculation view where table A is joining to table B with text join . Both join mapping fields are the same length and size but with different naming.

And the text join.

First issue.

The results are funny where the text sometimes truncated and multiple entries.

Second Issue.

Any changes after this causes error on the calculation view that requires it to be rebuild from scratch. First time activation always works without error. Once the error occurs no way to rectify but to delete the whole model and build again with the same join.

Error: com.sap.hana.di.calculationview: Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0Invalid datatype, length or/and scale are missing: type=0, intDigits=0, fractDigits=0 (node: Join_1, attribute: DDTEXT, status: Inconsistent calculation model, code: 34011) [8252071]
at "src/data/models/test/BTest_TextJoin.hdbcalculationview" (0:0,//Join_1/DDTEXT)

Attached is the calculation view full code for reference.

cv-text.txt

Further additional details.

HANA XSA SP04

Right table is build on HANA-column view

Left text table is remote table through SDA synonyms which is row based.

Hope you can help shed some light into the matter.

Thanks.

Anand

[gcadri]

Hi Anand,

I have the same problem as you also on SP4.

Did you find the solution?

Regards

Adrián

[anandmuthu]

Hi Adrian,

Unfortunately, I didnt find a solution except to redo the view everytime I make a change. I copy the xml and proceed with the change and hope it would not cause errors. I believe it didnt improve on SP05 as well. I have raised the issue to SAP and will update once there is response.

Thanks.

Anand

[ramaanne]

Iam on SAP HANA 2.0 SP04 express edition even I get the same error as bove with a simple calculation using hana xsa (sap web ide for sap hana) as well

is there a resolution in my case I used SLT replication from abap nw system to hana express and used cross schema access with synonyms to create a calculation view

thanks

rama anne