none
Error: 0xC002F210 on Execute SQL Task

    Question

  • Hi Techies,

    I have one Package in that I used Execute SQL Task for Exec Shrink_Log Procedure.

    When i run that package manually It sounds good.

    but when i try to run same package with Jobs i got an error.

    Error Code: 0xC002F210  Description: Executing the query "Exec dbo.USP_SHRINK_LOG 'AT'  " failed with the following error: "Backup and file manipulation operations (such as ALTER DATABASE ADD FILE) on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed.". Possible failure reasons: Problems with the query<c/> "ResultSet" property not set correctly<c/> parameters not set correctly<c/> or connection not established correctly.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  6:15:01 PM  Finished: 6:32:37 PM  Elapsed:  1056.23 seconds.  The package execution failed.  The step failed.,00:17:37,0,0,,,,0

    Wednesday, December 26, 2012 11:00 AM

All replies

  • Hi,

    My guess is that your SQL Agent account has less permissions than your login which you use to execute your job manually.

    Please have a look at the following links; -

    http://msdn.microsoft.com/en-gb/library/ms191543.aspx

    http://msdn.microsoft.com/en-us/library/ms190698.aspx

    Kind Regards,

    Kieran.


    If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood


    Wednesday, December 26, 2012 11:13 AM
  • Hi,

    It seems permission issue. I would assume when you run the package locally through SSIS/VS , the package inherits your permissions and can access the object, but SQL Server Agent is unable to do so as it does not have the neccessary access.

    Thanks

    Saikat

    Wednesday, December 26, 2012 11:18 AM
  • Hi Chandra6.

    When you see a SSIS package fails running in a SQL Agent job, you need to first consider the following conditions:

    1. The user account that is used to run the package under SQL Server Agent differs from the original package author.
    2. The user account does not have the required permissions to make connections or to access resources outside the SSIS package.

     
    You can find the detailed information in this KB article:
    An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step: http://support.microsoft.com/kb/918760 

    Thanks,
    Eileen


    Eileen Zhao
    TechNet Community Support

    Thursday, December 27, 2012 9:06 AM
  • Hello Eileen,

    My SQL Sever Agent has sufficient permissions.  The main thing is I have nearlly 25 EST in my package. In one of the stage I called Child Package in my Parent Package.

    While am runing main package the Error occured at first EST in Child Package.

    Thanks in advance.

    Thursday, December 27, 2012 10:00 AM
  • This error indicates that there is already a backup/shrink or similar operation taking place - you can't execute a similar command until the first one has completed. 

    If the issue persists, execute the following statement to determine what other similar processes are running.

    Taken from (http://social.msdn.microsoft.com/Forums/en/sqldatabaseengine/thread/437dd6e3-8ab0-48f0-965f-013f3a77c8ac)

    select session_id, Text

    from sys.dm_exec_requests r

    cross apply sys.dm_exec_sql_text(sql_handle) t


    Thanks! Josh Ash

    Wednesday, January 02, 2013 9:41 AM