Could not connect with provided configuration. ORA-00972: identifier is too long

Connector Development
, , ,
1

Could you help me?
I’m trying to connect two Oracle databases in Destinations and I’m getting the following error:
The connection tests failed.
Could not connect with provided configuration. ORA-00972: identifier is too long
Has anyone ever experienced this?

  • Is this your first time deploying Airbyte?: Yes
  • OS Version / Instance: RHEL 7.9
  • Memory / Disk: 100Gb
  • Deployment: Are you using Docker or Kubernetes deployment? Yes (Docker 19.3.12 e kubernetes v1.18.5)
  • Airbyte Version: What version are you using now? v0.40.25
  • Source name/version: TF1
  • Destination name/version: TUD
  • Step: The issue is happening during sync, creating the connection or a new source?
    The connection tests failed.

Could not connect with provided configuration. ORA-00972: identifier is too long

2

Hello! Could you please provide the connector versions and their full names? Could you also please provide the full logs? Currently this isn’t enough info for me to go off of, unfortunately!

3

Hello!

connector-builder-server:0.40.25

airbyte-worker-78c9dcf967-9p2r5.log (2.3 MB)

4

I see we have an issue open for this:
https://github.com/airbytehq/airbyte/issues/5862

I’ve also found an answer to that error - “This error occurs because the object’s name is longer than 30 characters.” So I’m wondering what the object is.

I see this in the logs:

OracleOperations(createTableIfNotExists):53 - Error while creating table.
java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

If there are any raw tables created, I’d suggest looking at those to see what table names might be causing problems!