I am still getting the error code from the server was '1000' and the message was: 'String or binary data would be truncated, when I try to delete or insert records into AGOL from my Writer. My Reader, Writer and AGOL field sizes all match. I have not changed the data type for any of the values. I am truncating to the field sizes. Not sure how to debug what is erroring off during the write to AGOL.
Question
Anyone having problems deleting and inserting records into AGOL?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
I was able to eliminate “The error code from the server was '1000' and the message was: 'String or binary data would be truncated” errors writing to the AGOL feature layer by modifying my “DateTimeConverters” and “TestFilters” in my workspace. My AGOL Writer is no longer failing and is doing updates, deletes and inserts correctly. I’m thinking I was duplicating records with the same “Id” and FME was getting confused when comparing to existing AGOL feature layer from the reader before writing to the same AGOL feature layer. It was primarily affecting “inserts”. Attached is a copy of my workspace. Hopefully it will help someone else.