Forum Discussion
General error;-10427 Conversion of parameter/column (5) from data type VARCHAR1 to ASCII failed
Hi Team,
I am connecting my pbix with SAP HANA DB calc view in direct query mode.
In my pbix table I am getting below error (screenshot below) for few records in live connection/direct query. This is the complete record name which is not getting displayed in power bi tablix Independent Authority Against Corruption (IAAC) investigation results in a finding that questions the legality/sanctity of the foundation agreements that underpin Rio Tinto’s investment in OT [123456].
and throwing below error . For other records, complete name is displayed correctly.
Also, while doing same thing - connecting my pbix with SAP HANA DB calc view in import mode, I am not getting any error at all for the above said record.
Please check this issue and let me know a solution as per my organizations's business requirement I need to use direct query only.
Help is appreciated!
Regards,
DIPANJAN
Hi dipanjan_sarkar ,
This is a problem that occurs when the ODBC driver tries to hand over Unicode data to your client variables.
Here are two workarounds, please check:
1. Change the data type of the columns (with unicode data) to nvarchar in the task
2.You might want to set the
CHAR_AS_UTF8 = trueconnection option to avoid that.- In the validated1.00.85.02 version of the driver, click on Settings, Special Property settings, and Add.
- For newer versions of the driver such as 2.4, the option is in this menu: Advanced, Additional connection properties, and Add.
Refer to:
SAP HANA Client Interface Programming Reference.
Conversion of parameter/column from data type VARCHAR1 to ASCII failed
https://knowledge.informatica.com/s/article/466932?language=en_US
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi dipanjan_sarkar ,
This is a problem that occurs when the ODBC driver tries to hand over Unicode data to your client variables.
Here are two workarounds, please check:
1. Change the data type of the columns (with unicode data) to nvarchar in the task
2.You might want to set the
CHAR_AS_UTF8 = trueconnection option to avoid that.- In the validated1.00.85.02 version of the driver, click on Settings, Special Property settings, and Add.
- For newer versions of the driver such as 2.4, the option is in this menu: Advanced, Additional connection properties, and Add.
Refer to:
SAP HANA Client Interface Programming Reference.
Conversion of parameter/column from data type VARCHAR1 to ASCII failed
https://knowledge.informatica.com/s/article/466932?language=en_US
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.