error during execute sql task execution, but only at times...
Posted on 2016-08-02
There is an
execute sql task
in the package.. it runs fine sometimes.. othertimes, get the following error:
Description: Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized.
Reissue the statement after the current backup or file manipulation operation is completed.
" ALTER DATABASE GOTN SET RECOVERY SIMPLE "
failed with the following error: "ALTER DATABASE statement failed.".
Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
End Error DTExec: The package execution returned DTSER_FAILURE (1).
Started: 9:00:12 AM Finished: 9:01:39 AM Elapsed: 2687.04 seconds. The package execution failed. The step failed.
can you see how this be made fail-proof if possible? (make the statement to give error message instead of crashing.. what is the rootcause for this error which happens only at times...
The exact statement in the EXEC TASK are:
ALTER DATABASE GOTN SET RECOVERY SIMPLE
DBCC SHRINKFILE (GOTN_Log,5120)
GRANT SHOWPLAN TO [FLYKHS\YK-eKOG_GOTN_Query]