Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • Error while flushing the cursor for feature class 'test1'. Error number frm ArcObjects is: '-2147216072'. Error message from ArcObjects is: {Underlying DBMS error [ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

I am creating feature class using geoprocessing tool, in that i have some columns with VARCHAR(2000), while writing features i am getting An error occurred while flushing the cursor for the table/feature class 'featureclass1'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column. But once i change VARCHAR(2000) to NCLOB its writing without any issues. i am not understanding why this happening. I have to use VARCHAR(2000) at any cost. Is any solution for this? I am using FME 2016 32 bit and ArcGIS 10.2.

Thank you.

Hello @r8,

While the data that is returned does appear to be an Oracle error, the original source error appears to be the ArcObjects error '-2147216072', This suggests a basic I/O database error. If the writer seems to fail on a specific feature, ensure the feature is not larger than the 2000 character limit.

 

 

There are a few more suggestions found here:

 

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/Tips_for_Using_the_Geoda.htm

Hello @r8,

While the data that is returned does appear to be an Oracle error, the original source error appears to be the ArcObjects error '-2147216072', This suggests a basic I/O database error. If the writer seems to fail on a specific feature, ensure the feature is not larger than the 2000 character limit.

 

 

There are a few more suggestions found here:

 

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/Tips_for_Using_the_Geoda.htm
Hi @trentatsafe,

 

Thank you for your quick reply. I checked all the VARCHAR2(2000) columns and it has less than 2000 characters only. The writer was not even writing a single feature in target feature class.

 

Reply


Community Stats

30,363
Posts
115,370
Replies
38,139
Members
Terms & ConditionsCookie settings
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.