ORA-01436: CONNECT BY loop in user data when importing table

dataservices performance
1

When I want to import metadata from an Oracle database, I get error BODI-1112338/ORA-01436: CONNECT BY loop in user data.

What’s going on?

It appears that I can import tables and views, but synonyms give this error.

I used the following workaround (possible only because of the fact that the name of the synonym is equal to that of the underlying table or view):

  • create an alias in the data-store by the name of the owner of the synonym
  • let that synonym point to the table or view for which the synonym is defined
  • import the table or view
  • remove the synonym
    Now the definition will apply to the synonym’s owner, thus the synonym will be used.

I am running 14.1.1.210

lamanp :netherlands: (BOB member since 2008-09-02)

2

Sounds like the same problem as this thread: Unable to import Oracle Table

Synonyms were supposed to work in 4.x. I’m running the same version. If I get time I’ll try it out.

eganjp :us: (BOB member since 2007-09-12)