While loading data to SAP HANA from ECC using BODS I am getting error.

[aparnami]

Hi Experts,

I am very new to BODS and using it first time only. When I am loading data using BODS I am getting following error:

I am aware that it is failing because of Chinese char. I tried to find out the issue  by my self and I googled it out but it didn't help. I need your immediate help with permanent fix of this kind of issues.

Thanks.

Br,

Arpan Parnami

[jayasree_r · Accepted solution]

You will find this Temp table options. Select it as yes and run the job.

[aparnami · Accepted solution]

What if I want to exclude Chinese language data? How to achieve this?

[jayasree_r]

Hi Arpan,

Even I got this error while loading Chinese characters to HANA database,

1.If the target table is already created and a physical table then only option is to alter the table definition and increase the size of that column.(In my case I have to increase size to 5000, then it worked).

2. If it is temporary table, we can find an option in table miscellaneous properties: 'Use NVARCHAR for VARCHAR column in supported database:' select it yes and execute.

Thanks,

Jayasree.

[aparnami]

I am using the template table. Can we change the data type of the template table?

[former_member187605]

Yes, set Use NVARCHAR for VARCHAR column in supported database in template table options.

[former_member187605]

Use nvarchar instead of varchar data type.

[former_member198401]

Hi Arpan,

Can you change the column definition of the HANA table column to longer varchar(100) or more.

This should be resolved then

Regards

Arun Sasi