Skip to main content
Solved

Oracle Spatial and ArcPRO

  • June 6, 2022
  • 6 replies
  • 38 views

mr_fme
Enthusiast
Forum|alt.badge.img+9

I'm inserting data into an Oracla Spatial with FME Desktop. I see that the data is written correctly when used or when I see SQL Developer, when showing that a resource is not designed by ArcGIS, but it shows that a resource is not designed correctly and does not open in ArcGIS, what will be done?

 

image 

image 

Thank´s

Best answer by rahulsharma

I tried what you suggested but i got this answer:

 

An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220960'. The error message from ArcObjects is: {The application is not licensed to create or modify schema for this type of data }

GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details

Hi @mr_fme​ I have escalated(C676111) to the support ticket as we need to look at additional information i.e. log files, system report, and workspace.

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.

6 replies

rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • 359 replies
  • June 6, 2022

Hi @mr_fme​ 

I think the issue is that you are writing to the underlying database instead of the ArcSDE writer.

In order to do this correctly, in your workspace you should write the feature to Esri Geodatabase (ArcSDE Geodb)

Hope this helps, there is a way to convert this table to SDE feature class but it may be a bit complicated. The best solution would be to drop the table, switch the writer in the FME workspace, and run the workspace.

 


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • 145 replies
  • June 6, 2022

Hi @mr_fme​ 

I think the issue is that you are writing to the underlying database instead of the ArcSDE writer.

In order to do this correctly, in your workspace you should write the feature to Esri Geodatabase (ArcSDE Geodb)

Hope this helps, there is a way to convert this table to SDE feature class but it may be a bit complicated. The best solution would be to drop the table, switch the writer in the FME workspace, and run the workspace.

 

I tried what you suggested but i got this answer:

 

An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220960'. The error message from ArcObjects is: {The application is not licensed to create or modify schema for this type of data }

GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details


rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • 359 replies
  • June 6, 2022

I tried what you suggested but i got this answer:

 

An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220960'. The error message from ArcObjects is: {The application is not licensed to create or modify schema for this type of data }

GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details

Ok, the error indicates that you have not deleted the table SDE.VAR_TESTE

Can you try deleting the table first?

Or can you try changing the feature type name to VAR_TESTE1 or something?

Might be unrelated but are you sure that you are using a STANDARD or ADVANCED license for ArcGIS Pro? check this Esri article


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • 145 replies
  • June 6, 2022

I tried what you suggested but i got this answer:

 

An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220960'. The error message from ArcObjects is: {The application is not licensed to create or modify schema for this type of data }

GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details

I've done all that is, the error is the same. My license is standard


rahulsharma
Safer
Forum|alt.badge.img+10
  • Safer
  • 359 replies
  • Best Answer
  • June 6, 2022

I tried what you suggested but i got this answer:

 

An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220960'. The error message from ArcObjects is: {The application is not licensed to create or modify schema for this type of data }

GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details

Hi @mr_fme​ I have escalated(C676111) to the support ticket as we need to look at additional information i.e. log files, system report, and workspace.


mr_fme
Enthusiast
Forum|alt.badge.img+9
  • Author
  • Enthusiast
  • 145 replies
  • June 6, 2022

I tried what you suggested but i got this answer:

 

An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220960'. The error message from ArcObjects is: {The application is not licensed to create or modify schema for this type of data }

GEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for details

Thank´s