none
Retrieve Packages fails during OSD RRS feed

  • Question

  • Hello. My environment is SCCM 2012 SP2 with MDT 2012 Update 1 integrated. We will be moving to R2 and MDT 2013 in the near future. I am using the MDT database and I am trying to get the stored procedure called Retrieve Packages to run during the build. I am using the blog entry below as a guideline. In addition to the steps in the blog, I have granted my Network Access Account execute permissions on the stored procedure. I can successfully execute the store procedure manually from Management Studio and it returns the correct packages. However, when it runs in the build I get the below errors. Any ideas what I am missing?

    ERROR - Opening Record Set (Error Number = -2147217887) (Error Description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.).

      ADO error: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. (Error #-2147217887; Source: Microsoft OLE DB Provider for SQL Server; SQL State: ; NativeError: 0)    ZTIGather    2/27/2014 10:28:31 AM    0 (0x0000)

    Unable to execute database query.    ZTIGather    2/27/2014 10:28:31 AM    0 (0x0000)

    Step that I am following

    http://blogs.technet.com/b/deploymentguys/archive/2012/02/02/dynamically-installing-computer-specific-applications-using-configuration-manager-with-mdt.aspx

    Saturday, March 1, 2014 12:03 AM

Answers