DATA Step, Macro, Functions and more

SAP HANA

Reply
New Contributor
Posts: 2

SAP HANA

We recently purchased the SAP/HANA connector. Some tables work great but with others I get

 

ERROR: CLI cursor extended fetch error: [SAP AG][LIBODBCHDB SO][HDBODBC] General error;-10427 Conversion of parameter/column (20)

       from data type NVARCHAR to ASCII failed

 

I was able to pull a couple of examples on what data is being errored out on. One conatains a ',' and the other a '-' . Does anyone have an idea how to fix this?

 

Super User
Posts: 10,538

Re: SAP HANA

I would be tempted to look for unicode characters. ASCII only has 255 characters. Since the unicode sets exceed that then mapping can be an issue.

 

This is a guess. This is only a guess. I do not have access to SAP or similar.

New Contributor
Posts: 2

Re: SAP HANA

That's what I think as well, how do you fix it though?

Ask a Question
Discussion stats
  • 2 replies
  • 410 views
  • 0 likes
  • 2 in conversation