Skip to main content
Solved

The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {FDO error: -2147216072}

  • August 23, 2016
  • 9 replies
  • 2363 views

Forum|alt.badge.img

Hi All,

I am facing an issue while translating data from Oracle Spatial to ESRI Geodatabase. while translating the data using FME workbench getting error message "Unable to drop the table/feature class 'GD_EXPANSION_JOINT_point'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {FDO error: -2147216072}". i did google search for this FDO error number but did not find anything. Could anyone help me out in this error.

Thanks in advance.

Thanks & Regards,

Ravi Kumar

Best answer by ravi255210

Hi All,

Thank you for all your reponses. I Could able to find out the issue and fixed the issue. Main reason for this issue is Problematic Domain Indexes. i found this error from Arc Catalog software. in FME workbench file they are not giving clear description of the problem just mentioning like FDO Error. Rebiuld indexes fixed the issue.

View original
Did this help you find an answer to your question?

9 replies

pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • August 23, 2016

Forum|alt.badge.img
  • Author
  • August 23, 2016
pratap wrote:
There is no solution described in that question. and also even though error code is same description is different. my issue description is "Unable to drop the table/feature class" and existing question description is "Error occurred while attempting to insert a row into the table using a cursor"

 

 

I don't think these two are similar.

 

 

Thanks,

 

Ravi Kumar

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • August 24, 2016

Hi Ravi,

This is a very general DB I/O error number which is produced by Esri when there are issues with the database. The most common causes are documented here - https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/Tips_for_Using_the_Geoda.htm

Try deleting the table using ArcCatalog and see if that works. Check the security settings and that there are no locks on the table.

If you are attempting to build the table using FME then check that all the attribute names are valid for the underlying database - i.e. are not reserved words.

There are a number of articles around this error number - try searching for 2147216072 esri and see if anything applies. It usually points to an issue with the Geodatabase or the underlying database.

Regards,

Robyn

 


pratap
Contributor
Forum|alt.badge.img+11
  • Contributor
  • August 24, 2016
ravi255210 wrote:
There is no solution described in that question. and also even though error code is same description is different. my issue description is "Unable to drop the table/feature class" and existing question description is "Error occurred while attempting to insert a row into the table using a cursor"

 

 

I don't think these two are similar.

 

 

Thanks,

 

Ravi Kumar
Identified solution has been provided as comment in that thread.

 

 


itay
Supporter
Forum|alt.badge.img+17
  • Supporter
  • August 24, 2016

Another issue to consider is the presence of a network on the destination database.


bruceharold
Contributor
Forum|alt.badge.img+17
  • Contributor
  • August 24, 2016
fmelizard wrote:

Hi Ravi,

This is a very general DB I/O error number which is produced by Esri when there are issues with the database. The most common causes are documented here - https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/Tips_for_Using_the_Geoda.htm

Try deleting the table using ArcCatalog and see if that works. Check the security settings and that there are no locks on the table.

If you are attempting to build the table using FME then check that all the attribute names are valid for the underlying database - i.e. are not reserved words.

There are a number of articles around this error number - try searching for 2147216072 esri and see if anything applies. It usually points to an issue with the Geodatabase or the underlying database.

Regards,

Robyn

 

Retired Robyn?

 

 


Forum|alt.badge.img
  • Author
  • Best Answer
  • August 29, 2016

Hi All,

Thank you for all your reponses. I Could able to find out the issue and fixed the issue. Main reason for this issue is Problematic Domain Indexes. i found this error from Arc Catalog software. in FME workbench file they are not giving clear description of the problem just mentioning like FDO Error. Rebiuld indexes fixed the issue.


Forum|alt.badge.img
  • January 23, 2017

If you're writing to an Oracle database, you may receive this error when attempting to insert a new table with an attribute name that is on Oracle reserved word list. Verify that all of your attribute names are not included in the Oracle reserved words.


philsc
Contributor
Forum|alt.badge.img+2
  • Contributor
  • June 28, 2017

Hi

I just got this errir today and the problem was that I tried to insert values in SDE with FME but the value was calculated with an arithmetic formula where the divider was sometime '0'. In those case, even though the value was 0 in the field, it seems to generate errors with SDE. I used a conditionnal value instead (if divider = 0 than write 0) and everything was fine.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings