Post reply

SP_OA Error

  • May 17, 2005 at 9:09 am

    #86386

    When exporting a table to a flat file from a stored procedure using SP_OA..., we are randomly getting the following message error :

    OLE Automation Error Information HRESULT: 0x80070008 sp_OAGetErrorInfo failed.

    Once this errors occurs, any call made to a DTS with SP_OA returns the same error. The only way to fix is to reboot the server ( W2000, SQL2000 SP3).

    Would someone already had similar issue ?

  • May 20, 2005 at 9:18 am

    #560244

    I have no experience of using DTS from sp_OA-procs, but it sounds to me as if something is not being closed and deallocated correctly with your sp_OA-usage. Any memory requests larger than 8KB made by something executed with sp_OA will be allocated from the MemToLeave area, which is not as large as the rest of SQL Server's memory pool. If something is leaking memory then the available memory might easily be 'eaten up', and you would not be able to create anything using sp_OA. So, try monitoring the memory to see if there is memory leakage, and make sure the code using sp_OA is behaving as it should.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

  • November 11, 2005 at 8:18 am

    #603444

    Hi,

    Check-out this link: http://www.sqlteam.com/item.asp?ItemID=19595

    Hope this is the solution

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply