Writing data to a sde geodatabase (Esri Geodatabase /ArcSDE Geodb), but I got an error: invalid cursor state

Hello all,

I am trying to write some data to my SDE geodatabase(file), and I tried two transformers to achieve my goals:

1. Feature writer

I got an error: invalid cursor state from the database. When I filtered one row and run the writer, the data were successfully injected, but some of the injected data are different from the intended data. For example, a foreign key needs to be injected as 5 but it's injected as null or 2 in a different row.

Please see the setting below.

1. Python Caller

I used Geometry extractor to write the shape attribute, Shape@XY with the value (longitude, latitude), and then used arpy.cursor.insurtRow to insert the data under the input function using feature.getAttribute method. I got an error: the INSERT statement conflicted with the FOREIGN KEY constraint.

Thank you,

Tae