Copy oracle data with $ in the column name

Question

Copy oracle data with $ in the column name

Ravi Kumar 80

Hello,

I am using copy activity to copy data using oracle as source and sink. If I have the column name with special character like $ in the staring of the column, I am getting an error: "invalid error in parameter"

Did anyone seen this issue?

QuantumCache 20,366 Reputation points Moderator

2023-07-03T18:45:16.58+00:00

Hello @Ravi Kumar,
Did you try any pre-processing step to fix the column names?
Sedat SALMAN 14,180 Reputation points MVP

2023-07-03T18:56:58.77+00:00

There is a previous discussion with the same problem

https://learn.microsoft.com/en-us/answers/questions/913484/problem-with-azure-data-factory-copying-data-with

according to this discussion this problem has been escalated to the Product team but i could not find any update or fix
Ravi Kumar 80 Reputation points

2023-07-06T03:18:34.3866667+00:00

Thank you Sedat SALMAN

did it ever resolved?
QuantumCache 20,366 Reputation points Moderator

2023-07-06T14:07:42.4833333+00:00

hello @Ravi Kumar,

Could you please add more info on the source table column info (how does it looks?), the above referred link is referring to target(sink) data and the column name is ending with $, i think it may be a different scenario from yours, correct me if i am wrong!
QuantumCache 20,366 Reputation points Moderator

2023-07-07T18:59:24.5333333+00:00

hello @Ravi Kumar,Just checking if we are still connected on this discussion?

Could you please provide more info on the Source Data? any Oracle table's sample preview of the source data? so that we can better assist you!

Is the Table column name ending with $, like shown in the below sample? please provide more info from your side!
Ravi Kumar 80 Reputation points

2023-07-10T03:38:59.88+00:00

SatishBoddu-MSFT, The issue is if the destination table name has $ then the pipeline is failing.

As Sedat mentioned, this is exactly the same issue I was facing. Please let me know if you have any further details from my end.
Ravi Kumar 80 Reputation points

2023-07-10T03:41:34.5033333+00:00

SatishBoddu-MSF It looks like your tool is broken. I posted a comment but I can't see it after that.
also, I am getting error when I try to post a question. I hope Microsoft is aware of the Q&A tool issues.
QuantumCache 20,366 Reputation points Moderator

2023-07-17T02:58:07.3466667+00:00

Hello @Ravi Kumar
Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!
QuantumCache 20,366 Reputation points Moderator

2023-07-25T16:58:55.9366667+00:00

Hello @Ravi Kumar
Just checking if we are still connected on this discussion?
QuantumCache 20,366 Reputation points Moderator

2023-07-31T21:27:36.9666667+00:00

Hello @Ravi Kumar
Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!

1 answer

Your answer

QuantumCache 20,366 Reputation points Moderator

2023-07-03T18:45:16.58+00:00

Hello @Ravi Kumar,
Did you try any pre-processing step to fix the column names?
Sedat SALMAN 14,180 Reputation points MVP

2023-07-03T18:56:58.77+00:00

There is a previous discussion with the same problem

https://learn.microsoft.com/en-us/answers/questions/913484/problem-with-azure-data-factory-copying-data-with

according to this discussion this problem has been escalated to the Product team but i could not find any update or fix
Ravi Kumar 80 Reputation points

2023-07-06T03:18:34.3866667+00:00

Thank you Sedat SALMAN

did it ever resolved?
QuantumCache 20,366 Reputation points Moderator

2023-07-06T14:07:42.4833333+00:00

hello @Ravi Kumar,

Could you please add more info on the source table column info (how does it looks?), the above referred link is referring to target(sink) data and the column name is ending with $, i think it may be a different scenario from yours, correct me if i am wrong!
QuantumCache 20,366 Reputation points Moderator

2023-07-07T18:59:24.5333333+00:00

hello @Ravi Kumar,Just checking if we are still connected on this discussion?

Could you please provide more info on the Source Data? any Oracle table's sample preview of the source data? so that we can better assist you!

Is the Table column name ending with $, like shown in the below sample? please provide more info from your side!
Ravi Kumar 80 Reputation points

2023-07-10T03:38:59.88+00:00

SatishBoddu-MSFT, The issue is if the destination table name has $ then the pipeline is failing.

As Sedat mentioned, this is exactly the same issue I was facing. Please let me know if you have any further details from my end.
Ravi Kumar 80 Reputation points

2023-07-10T03:41:34.5033333+00:00

SatishBoddu-MSF It looks like your tool is broken. I posted a comment but I can't see it after that.
also, I am getting error when I try to post a question. I hope Microsoft is aware of the Q&A tool issues.
QuantumCache 20,366 Reputation points Moderator

2023-07-17T02:58:07.3466667+00:00

Hello @Ravi Kumar
Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!
QuantumCache 20,366 Reputation points Moderator

2023-07-25T16:58:55.9366667+00:00

Hello @Ravi Kumar
Just checking if we are still connected on this discussion?
QuantumCache 20,366 Reputation points Moderator

2023-07-31T21:27:36.9666667+00:00

Hello @Ravi Kumar
Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!

Answer 1

@Ravi Kumar

The issue is if the destination table name has $ then the pipeline is failing. As Sedat mentioned, this is exactly the same issue I was facing. Please let me know if you have any further details from my end.

Could you please provide few more details?

The destination table name has $ character in the starting or ending? OR
The destination Table's one of the column has a $ Character?

As per your initially posted question, i thought you were referring to the Column containing $ character,

I am using copy activity to copy data using oracle as source and sink. If I have the column name with special character like $ in the staring of the column, I am getting an error: "invalid error in parameter"

Coming to the referred thread in the above response, the scenario was successful in copying the data to the Sink table!!!
I tried to reproduce the issue with SQL as the data source and was able to copy the data using the destination column name ending with ‘$’

I tried to reproduce the issue with SQL as the data source and was able to copy the data using the destination column name ending with ‘$’

Share via

Copy oracle data with $ in the column name

1 answer

Your answer