Synpase - Copy columns with special characters

Khaled Radmal 31

I want to copy data from a source (in this case SAPHANA) where the columns have a dot in them. The copy activity fails when the multiple columns are queried and the part before the dot is the same.

Example:
select col1, col1.test from sourceTable

Error message:
{
"errorCode": "2100",
"message": "Failure happened on 'Source' side. ErrorCode=InvalidParameter,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The value of the property '' is invalid: 'Can not add property col1 to Newtonsoft.Json.Linq.JObject. Property with the same name already exists on object.'.,Source=,''Type=System.ArgumentException,Message=Can not add property col1 to Newtonsoft.Json.Linq.JObject. Property with the same name already exists on object.,Source=Newtonsoft.Json,'",
"failureType": "UserError",
"target": "Lookup1",
"details": []
}

Workaround:
When aliasing the columns the copy activity is succesfull.

--> select col1, col1.test as test from sourceTable

Question:
How can I copy the data without alias the columns?

KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee

2021-09-28T23:38:06.16+00:00

Hi @Anonymous ,

Thanks for posting your query. Just wanted to check if you have got a chance to try enclosing the columns with dot in it in a square brackets like select col1, [col1.test] from sourceTable and see how it goes? If not please give a try and let us know how it goes.

We look forward to your response.

Thank you
KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee

2021-09-30T00:25:17.293+00:00

Hi @Anonymous ,

Just checking to see if you have got a chance to try the recommendation mentioned in my previous response. Do let us know how it goes.

Thank you
Khaled Radmal 31 Reputation points

2021-09-30T09:45:06.553+00:00

Thanks for you response, square brackets result in a syntax error:
{
"errorCode": "2100",
"message": "Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near \"[\": line 2 col 1 (at pos 9),Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [42000] [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near \"[\": line 2 col 1 (at pos 9),Source=libodbcHDB.dll,'",
"failureType": "UserError",
"target": "Lookup1",
"details": []
}
KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee

2021-10-08T22:54:40.423+00:00

Hi @Anonymous ,

Apologies for the delayed response and thanks for sharing additional details.
This looks like a query formation issue and more specific to SAP HANA rather than ADF. Hence I would recommend you to please reach out in SAP HANA Community forum where SAP experts can better assist on this issue.

SAP community forum: https://answers.sap.com/tags/73554900100700000996

Do let us know if you have any specific query related to ADF.

Thank you

Share via

Synpase - Copy columns with special characters

Your answer