Skip to main content
Solved

ArcGIS Feature Service

  • February 20, 2023
  • 2 replies
  • 62 views
anthrax_79
Contributor
Forum|alt.badge.img+4

I was able to insert 847k records out of 1.6M last Friday then it just failed (token was refreshed). This morning, I've disabled / re -enabled versioning in ArcPro and was able to insert 600+ new records using FME. Tried another 600+ and failed with the below error.

 

ArcGIS Portal Feature Service Writer: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Unable to complete operation.'. Details: 'Insufficient permissions [42000:[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The EXECUTE permission was denied on the object 'i24_get_ids', database 'CORPGIS', schema 'gisadmin'.] [Prod_Address]'

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

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

 

P.S.

I have tried adding new records using ArcPro thru the same feature service and works fine. it only fails in FME even if I try to insert only 1 record.

 

Thanks in advance

Best answer by saraatsafe

Hi @Lex Adove​, this error comes from the backend of the database. A few things to try: can you reduce features per transaction, or use Fiddler to see which request is the one that fails? You can then use the Feature Service WebUI to send exactly what FME is sending. Does doing this result in the same error, and does it occur around the same spot?

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

2 replies

saraatsafe
Safer
Forum|alt.badge.img+10
  • saraatsafeSafer
  • Safer
  • Best Answer
  • February 22, 2023

Hi @Lex Adove​, this error comes from the backend of the database. A few things to try: can you reduce features per transaction, or use Fiddler to see which request is the one that fails? You can then use the Feature Service WebUI to send exactly what FME is sending. Does doing this result in the same error, and does it occur around the same spot?

J

thanks for your feedback really helpful for me also

regards

Alight Motion

 

Reply


Helpful Members This Week

Community Stats

31,399
Posts
119,072
Replies
39,018
Members

Latest FME

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.