topic Re: Feature Class getting stuck in Load-Only Mode running script through task schedul in Data Management Questions

Feature Class getting stuck in Load-Only Mode running script through task scheduler

MarcCusumano — Wed, 11 Sep 2013 11:55:20 GMT

I have developed a Python Script that performs a variety of geoprocessing and data-loading tasks, including kicking off SQL statements through the command-line. We have tested the script extensively in our development environment, and it successfully runs in production. However when run through the windows task scheduler the target SDE feature class ends up getting stuck in "Load-Only Mode", even though the script ran successfully.

All SQL statements run as a sub-process and report errors back to the Python environment, but messages that do not halt execution are not transferred.

I'm at a loss as to why this would happen exclusively through automation and not when run manually. Any help, ideas, or comments would be appreciated.

Re: Feature Class getting stuck in Load-Only Mode running script through task schedul

SachinKanaujia — Wed, 11 Sep 2013 16:04:53 GMT

Can you elaborate a bit on it? Is it a long running script? Have you run the script again after that and it works fine when not run from Task scheduler? Can you try to run just a script from the task scheduler which changes the layer from loadonly to normal_io. I am just trying to rule out a possibility of timeout issues etc.

Are you logging all messages?

Re: Feature Class getting stuck in Load-Only Mode running script through task schedul

MarcCusumano — Wed, 11 Sep 2013 18:48:11 GMT

The script takes about 45 minutes to complete. After the feature class gets stuck in "Load-Only Mode" it is unusable.

I have tried replicating the issue in our development environment by launching the script in task scheduler there, but have been unsuccessful. I am thinking it is something unique to production, ie a conflict with another process etc.

Re: Feature Class getting stuck in Load-Only Mode running script through task schedul

MarcoBoeringa — Thu, 12 Sep 2013 10:00:44 GMT

I have tried replicating the issue in our development environment by launching the script in task scheduler there, but have been unsuccessful. I am thinking it is something unique to production, ie a conflict with another process etc.

Have you ruled out differences in database privileges / rights between development and production? It might be that your development environment database user login has more rights than a "similar" user on production.

Re: Feature Class getting stuck in Load-Only Mode running script through task schedul

SachinKanaujia — Thu, 12 Sep 2013 14:24:04 GMT

You can try to explicitly change it to normal_io mode and see if it is giving you some error. It could be something specific to your production environment. Either its failing abruptly while loading the data and so leaves it in load only mode or else there are tablespace issues which is not allowing it to rebuild the indexes and thus change it to normal mode.