SAP HANA SDI SPS 12.1: Flowgraph CLOB--> NCLOB (CDS-Tables)

[draschke]

Hi Sap,

I think there seems to be a bug, if we want to convert from CLOB to NCLOB. If I try to create a flowgraph task for this task (screenshot), than I get this error: "CLOB type is incompatible with NCLOB".

If we convert VARCHAR TO NVARCHAR with the filter feature than it works.

09:00:06] Error while activating /development/projects/tbase/flowgraph/HDI/diraschk/hdiUntersuchung.hdbflowgraph:
[development.projects.tbase.flowgraph.HDI.diraschk:hdiUntersuchung.hdbflowgraph] inconsistent datatype: CLOB type is incompatible with NCLOB type: line 7 col 216 (at pos 1051)

@SAP I think it should be very easy to reproduce it by your own. Try to create a task from clob to nclob. Its not possible.

[former_member240828 · Accepted solution]

Hello Dirk Raschke,

I just looked into this and I think I found a solution for the problem you mentioned.

Did you directly map the "Befund" Column coming in with the "Befund" Column going out? If so, can you please try to add a TO_NCLOB function around it?

You can do that by clicking on the "Befund" column in the right (target) table and adjust the mapping. (See screenshot below).

Best regards,

Timo Wagner

[draschke]

Hi Richard,

we did it and found a solution for our problem. It seems so, that German "Umlaute" cause this issue.

Timo gave us the right hint. To get it solved we need to use TO_NCLOB((TO_NVARCHAR FIELD)). This works fine.

Thanks for your help!

[former_member198251]

Hi Dirk,

Please open an incident.

Best Regards,

Richard

[draschke]

Hi Timo,

after we could successfully create and activate the task, we found out now, that there are a lot of the data missing for this NCLOB field.

I checked more tables, where we used this TO_NCLOB function, but is all the same.

I could send you a small source and target file, if you wish.

Shall I open up an incident?

Thanks!

[draschke]

Hi Timo,

thank you very much for your fast helpful response.

I did it as you said and it works! 🙂

Could the task activate and load the data successfully.

Thanks a lot!!!

Dirk