Skip to main content
  • 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
Question

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

  • October 24, 2017
  • 2 replies
  • 212 views
R
Forum|alt.badge.img
  • r8

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.

2 replies

trentatsafe
Safer
Forum|alt.badge.img+6
  • trentatsafeSafer
  • Safer
  • October 24, 2017

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
R
Forum|alt.badge.img
  • r8
  • Author
  • October 27, 2017
trentatsafe wrote:

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


Most helpful members this week

Community Stats

30,847
Posts
116,941
Replies
38,670
Members
Terms & ConditionsCookie settings

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
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.