Post reply

Linked server job failed

  • May 17, 2005 at 1:06 am

    #113790

    Hi,

    I get the following error when executing a job in my production server

    Step Error Source: Microsoft OLE DB Provider for SQL Server

    Step Error DescriptionLE DB provider 'MSDAORA' reported an error.   (Microsoft OLE DB Provider for SQL Server (80040e14): OLE DB error trace [OLE/DB Provider 'MSDAORA' IRowset::GetNextRows returned 0x80004005:   ].) (Microsoft OLE DB Provider for SQL Server (80040e14): [OLE/DB provider returned message: ORA-04030: out of process memory when trying to allocate 1049100 bytes (cursor work he,kllcqas:kllsltba)

    ])

    I use a linked server to oracle

    Any help is appriciated

     

    Helen


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • May 17, 2005 at 11:45 pm

    #559464

    I think this error is returned from oracle and if my knowledge is coreect this happend because the process is not able to allcate PGA memmory.I think you can change and set memmory limit on server running oracle.Also try searching on any oracle related forums.

     

    Regds

    Rafi-

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

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