Load Lakehouse data to Oracle

[caomayan]

Good day! I have created the pipeline in Fabric,  load lakehouse data to Oracle by using the gateway. The source and destination are both working, the account on gateway has the write permission. After running, the error is:

Failure happened on 'destination' side. ErrorCode=OracleWriteError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to write data.,Source=Microsoft.DataTransfer.Connectors.OracleV2Core,''Type=Oracle.ManagedDataAccess.Client.OracleException,Message=ORA-00904: "CREATED_BY": invalid identifier,Source=Oracle Data Provider for .NET, Managed Driver,'

any idea about the error? Thanks in advance!

[v-yilong-msft · Accepted solution]

Hi @caomayan ,

I noticed in your error message Message=ORA-00904: “CREATED_BY”: invalid identifier, which is usually caused by case-sensitive issues. Normally, Oracle tables and columns are not case-sensitive and cannot contain punctuation or spaces. However, if you use double quotes to create an identifier with quotes, you must always refer to the identifier with double quotes and the correct case.

If you want to learn more about it, you can read this topic: oracle - Why do I have ORA-00904 even when the column is present? - Stack Overflow

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[caomayan]

Thanks so much Yilong! I have redone the table creation and remapping, the load is successful!