topic Re: Error 001156: Failed on input OID <value>; could not write value '<value>' to output field <value>. Script fails when run on scedule, no fail when run manually in Python Questions

Error 001156: Failed on input OID ; could not write value '' to output field . Script fails when run on scedule, no fail when run manually

HåvardMoe1 — Fri, 13 Jul 2018 07:50:39 GMT

I have a script that reads a table with data from a CSV file and processes the information. This script is set to run on a server through the scheduler, after the updated csv files are made available. For each run, I recreate an empty inputtable from a template and append the data from the csv. I might add that the script has been working flawless for months, but this suddenly changed about two weeks ago. Recently, the script has started to fail every time, with the error message shown above:

001156: Failed on input OID <value>; could not write value '<value>' to output field <value>

It fails on the first line from the csv, the failing value is '601240.2' and the output field is a double field.

The strange thing is that if I open the script in IDLE and run it from there, it will run perfectly.

Does anyone have any suggestions as to why this fails in the sceduler and works perfectly when ran maually?

Re: Error 001156: Failed on input OID ; could not write value '' to output field . Script fails when run on scedule, no fail when run manually

JoeBorgione — Fri, 13 Jul 2018 10:57:50 GMT

What changed two weeks ago? Did the field names in the csv change? Any blanks or special characters? A google search of the error (001156: Failed on input OID ; could not write value '' to output field .—Help | ArcGIS Desktop ) suggests a field type mismatch. Maybe change your target field to float?

Re: Error 001156: Failed on input OID ; could not write value '' to output field . Script fails when run on scedule, no fail when run manually

HåvardMoe1 — Fri, 13 Jul 2018 11:38:17 GMT

What changed two weeks ago? Good question. As far as I know nothing changed. The input CSV files are formatted in the same way, and that first line that fails now is not changed from before. The script or the target database is not changed. The error suggests a type mismatch, but the data is already set as a float (double) - and it works when I run it manually.

The strange thing is just that: it runs fine in the shell, but fails when sceduled.

Re: Error 001156: Failed on input OID ; could not write value '' to output field . Script fails when run on scedule, no fail when run manually

MichaelVolz — Fri, 13 Jul 2018 12:22:00 GMT

Was there any kind of patch (Windows OS I assume) applied to the server in the past two weeks that you were not informed about?

Re: Error 001156: Failed on input OID ; could not write value '' to output field . Script fails when run on scedule, no fail when run manually

HåvardMoe1 — Wed, 22 Aug 2018 14:19:20 GMT

It might have been, but not to my knowledge. The question is what kind of patch would that be to mess up a script only when run by the sceduler from a .bat-file and not when running the same script from console/IDLE...?

Re: Error 001156: Failed on input OID ; could not write value '' to output field . Script fails when run on scedule, no fail when run manually

deleted-user-JVpgF2XzWoGH — Mon, 02 Dec 2019 19:42:13 GMT

Was there ever a resolution for this?