Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
Problem with Azure Data Factory copying data with a special character "$" in column name Oracle
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 48%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDE%3C/text%3E%3C/svg%3E)
Diego Elias
1
Reputation point
Hi, I have been caught a few days with this issue, I would like some help, I have a copy data activity and I´m trying to make a copy from one table to another one in Oracle, like this:
On the sink side, the column has the name: GNSAF$, I tried some changes like put the letter "S" instead "$" and works fine, but on the result with the sink side I can´t make changes, I have to leave the character "$" in the name, but in Azure I received this error:
I would appreciate any advice.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 29,266 Reputation points Microsoft Employee2022-07-05T23:19:23.897+00:00 Hello @Diego Elias ,
Welcome to the Microsoft Q&A platform, and thanks for posting your query.
Please correct me if my understanding is wrong.
After you click on Import schemas, you are trying to update the destination column name from GNSAF$ to GNSAF, and the import is failing.
But if you update the destination column name from GNSAF$ to GNSAFS you do not see any issues with the import.
Can you please clarify the questions below?
- Does your destination table have the column with the name GNSAF$ or GNSAFS?
- Are you trying to update the destination column name(schema) from the mapping tab?
By looking at the error message, the source table columns are not correctly mapped to the sink table. Due to this reason, your inserts are failing.
Can you please ensure the column names referenced on the mapping tab exist on the source and sink tables?
On the mapping tab, you can click on clear and import schemas to make sure your mapping is correct.
Please reference this below article regarding: ORA-00904 ERROR MESSAGE “INVALID IDENTIFIER”
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 ‘$’
Hope this helps. Please let us know if you have any further questions.
-
Diego Elias 1 Reputation point
2022-07-06T15:02:54.837+00:00 Hi, thank you for your answer, I´m sorry if my question it doesn´t be clear.
About the questions that you made:
1) Does your destination table have the column with the name GNSAF$ or GNSAFS?
My destination table has the name GNSAF$, I made a copy of that table by changing the "$" character to "S" and the copy was successful, but I can't change the schema of the main table and the problem occurs in Oracle, because I am trying to copy the data from SQL to Oracle.
2) Are you trying to update the destination column name(schema) from the mapping tab?
No, I don´t, the mapping is fine, recognize the column names correctly, in SQL works fine, the problem occurs in Oracle.
Can you please ensure the column names referenced on the mapping tab exist on the source and sink tables?
Yes, I´m sure that the column names exists and are correctly written on the source and the sink tables
-
Bhargava-MSFT 29,266 Reputation points Microsoft Employee
2022-07-06T21:42:21.417+00:00 Hello @Diego Elias ,
Thank you for the details and clarification. I was able to reproduce the error that you are getting from your end.
I am escalating this issue to the relevant product team. I will get back to you as soon as I hear back from them.Thank you for your patience.
-
Bhargava-MSFT 29,266 Reputation points Microsoft Employee
2022-07-15T22:58:18.15+00:00 Hello @Diego Elias ,
I just wanted to give you an update here. Our Internal team investigated and confirmed the issue is at driver end. They have engaged relevant third-party people to fix the issue. I will keep you posted once I get any further updates. Thank you again for your patience. -
Diego Elias 1 Reputation point
2022-09-12T20:30:49.883+00:00 Hi, @Bhargava-MSFT
I just want to ask, if there are any update about this?
-
Bhargava-MSFT 29,266 Reputation points Microsoft Employee
2022-09-12T21:42:29.787+00:00 Hello @Diego Elias ,
Thanks for the follow-up. Currently, we have a work item in the product team's queue. Let me follow up with them and get back to you. -
Bhargava-MSFT 29,266 Reputation points Microsoft Employee
2022-09-15T21:23:07.307+00:00 Hello @Diego Elias ,
Sorry, I don't have an ETA on this issue. but this is in the product team's backlog item.
Sign in to comment