Skip to main content
Question

Writer with dynamic schema fails

  • September 15, 2020
  • 2 replies
  • 68 views
markcoopersdc
Contributor
Forum|alt.badge.img+6

I am reading some oracle tables (non spatial) and trying to write them out to to sql server tables using a dynamic schema. However, I constantly get this error:

 

Provider error `(2760) The specified schema name either does not exist or you do not have permission to use it.'

 

Please can someone let me know what I am doing wrong, otherwise I will have to add a separate reader and writer for each table

 

Many thanks

Mark

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.

2 replies

david_r
Celebrity
  • david_rCelebrity
  • September 15, 2020

Sounds like the schema name isn't matching the feature names. Check that fme_feature_type has the exact same value on both the schema feature and the data features.

markcoopersdc
Contributor
Forum|alt.badge.img+6
  • markcoopersdcContributor
  • Author
  • Contributor
  • September 15, 2020

No reason it shouldn't - I used 'generate workspace' to build it so should all be automatic.

 

I do wonder if its because the names of the tables in Oracle have a dot (ie DatabaseName.TableName) - I don't think SQL like the dot

Community Stats

32,208
Posts
122,308
Replies
39,892
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.