There is a GP model that updates the featureclass with new data every night, with a windows scheduled task. The application server is a Windows Server 2008 and ArcGIS Server 9.3.1 with ArcSDE 9.3.1. The services are MXD based, AGSSOM.exe is used to stop ans start the services, but the model is unable to complete the update task as the undelying feature tables have a schema lock.
I have to kill the connections and manually update by the model everyday. It is strange, as the same model had worked for more than 2 years now on the same 9.3.1 AGS.
Any suggestions and reasons for this to be happening?