Forum Discussion

caomayan's avatar
caomayan
Helper I
2 years ago
Solved

Load Lakehouse data to Oracle

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!

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      caomayan
      Helper I
      2 years ago

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