Skip to main content
Question

Issue reading data from a Oracle Synonym via database-link.

  • October 27, 2020
  • 0 replies
  • 139 views
T

We use to be able to read data from an Oracle Synonym pointing to a table via a database link. But now we are getting a strange error and are unable to see the attributes any more.

 

Warning: Unable to use schema obtained for Oracle Spatial layer 'schema.table'

 

We are getting the same error from both "Oracle Autonomous Non-Spatial" and "Oracle Non-Spatial" that use to work before.

 

I have looked into this article https://community.safe.com/s/article/working-with-synonyms-in-oracle and executed the command on a test synonym without any luck. 

 

Have somebody else seen this issue before and have any knowledge of how to get it working again. We are not sure what happened, suggestions are much welcome.

 

The synonyms work just fine with normal SQL, it's just FME Desktop we see issues.

 

We are running Oracle 12.0.1 on Windows in a test/developer environment.

 

FME 2020.1.1.1 (20200817 - Build 20614 - WIN64)

FME Desktop Professional Edition 

Oracle 12.0.1 Client 64-bit - Administration

 

I see the same issue in FME Desktop 2019.2 and 2021 Beta.

 

Regards, Tony

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.