Loading ...
Sorry, an error occurred while loading the content.

RE: MUGH-SQLCON Re: Still persists: Link Server problem - "The provider ran out of memory"

Expand Messages
  • Veer Ji Wangoo
    Hi Raju, I had asked to try BCP rather than DTS ...? Did you try that one ...? Regards Veer Ji Wangoo ITIL, MCDBA , Certified PMP Microsoft MVP SQL Server ,
    Message 1 of 4 , Nov 5, 2006
    • 0 Attachment
      Hi Raju,

      I had asked to try BCP rather than DTS ...? Did you try that one ...?


      Regards

      Veer Ji Wangoo
      ITIL, MCDBA ,
      Certified PMP
      Microsoft MVP SQL Server ,



      ________________________________

      From: sqlcon@yahoogroups.com on behalf of Rajinder Raina
      Sent: Mon 11/6/2006 11:06 AM
      To: sqlcon@yahoogroups.com
      Subject: MUGH-SQLCON Re: Still persists: Link Server problem - "The provider ran out of memory"



      Hi Veer,
      Tried out with DTS package, it's working and the process is under
      monitoring. The DTS package has consumed 80-85% system memory and not
      releasing the memory once the process is completed.

      Do you have any other clue, how to go about ?
      Thanks & Regards,
      Raina

      --- In sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> , "Veer Ji Wangoo" <veerw@...> wrote:
      >
      >
      > Raj can you try using BCP rather than DTS for this ...
      >
      >
      >
      > ________________________________
      >
      > From: sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> [mailto:sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> ] On
      Behalf
      > Of Rajinder Raina
      > Sent: Thursday, November 02, 2006 1:35 PM
      > To: sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com>
      > Subject: MUGH-SQLCON Re: Still persists: Link Server problem - "The
      > provider ran out of memory"
      >
      >
      >
      >
      > Will DTS packages helps in this case....??? Still stuck with same
      > issue
      >
      > --- In sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> <mailto:sqlcon%40yahoogroups.com> ,
      > "Rajinder Raina" <raina_raj77@>
      > wrote:
      > >
      > >
      > > Still stuck on the same issue..Tried all workarounds...didnt
      help..
      > >
      > >
      > > --- In sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> <mailto:sqlcon%40yahoogroups.com> ,
      > "Prasad Gelli" <prasad_gelli@>
      > > wrote:
      > > >
      > > > Hi
      > > >
      > > > I got the same problem while at my front which i changed the
      > query
      > > to
      > > > get the output result first into a local #Temp table
      > > > and then transfer data from #Temp to local table and then you
      can
      > > > drop the #Temp table.
      > > >
      > > > Just check it.. it should work.
      > > >
      > > > Prasad
      > > >
      > > > --- In sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> <mailto:sqlcon%
      40yahoogroups.com> ,
      > "Rajinder Raina" <raina_raj77@>
      > > > wrote:
      > > > >
      > > > > Dear Aneesh,
      > > > >
      > > > > Facing the same problem using the below query even after
      > > restarting
      > > > > the SQL services:
      > > > >
      > > > > output message :
      > > > > -----------------
      > > > > OLE DB provider 'MSDASQL' reported an error. The provider ran
      > > out
      > > > of
      > > > > memory.
      > > > > OLE DB error trace [OLE/DB Provider 'MSDASQL'
      > > > > IRowsetChange: :InsertRow returned 0x8007000e: The provider
      > ran
      > > > out
      > > > > of memory.]
      > > > >
      > > > > Havent tried to restart the server. Anyways, we cant go far
      > > restart
      > > > > of live server many times a day to perform this operation.
      > > > >
      > > > > Please suggest other workarounds that could resolve this
      issue.
      > > > >
      > > > > IS VEER there ???
      > > > >
      > > > > Regards,
      > > > > Raina
      > > > >
      > > > >
      > > > >
      > > > > --- In sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> <mailto:sqlcon%
      40yahoogroups.com> ,
      > aneesh <aneeshattingal@> wrote:
      > > > > >
      > > > > > What's the output of this
      > > > > >
      > > > > > SELECT * FROM openQuery(CARDBABA, ' select CARD , SERIAL_NO,
      > > > > COMPANY,
      > > > > > LANGUAGE ,LNAME,ADDRESS1, CITY,STATE, COUNTRY,DISPO,
      > > > > > Value,usage, prev_usage, RECHARGE, Calls_ACT, calls_ATH,
      > > > > > CALLS_TIM,LAST_CALL,SURCHARGE, FLAT_RATE, RATE_SET,MIN_
      > > > > TIME,INCREMENT,
      > > > > > MIN_CALL,INC_ TIME,options, VRUCOMPANY, LOCATION,
      > > XDCCODE,FNAME,
      > > > > ADDRESS2, ZIP,
      > > > > > PHONE1,PHONE2, EXPIRATION, ACTIVATION, NOTES
      > > > > > from CARD0003')
      > > > > >
      > > > > > Aneesh R.
      > > > > > SQL Server MVP,
      > > > > > Expert Exchange.com Genius SQL server
      > > > > > http://sequelserver.blogspot.com/ <http://sequelserver.blogspot.com/>
      > <http://sequelserver.blogspot.com/ <http://sequelserver.blogspot.com/> >
      > > > > > http://www.sqlknowledge.com <http://www.sqlknowledge.com> <http://www.sqlknowledge.com <http://www.sqlknowledge.com> >
      > > > > >
      > > > > >
      > > > > >
      > > > > >
      > > > > > ----- Original Message ----
      > > > > > From: Rajinder Raina <raina_raj77@>
      > > > > > To: sqlcon@yahoogroups.com <mailto:sqlcon%40yahoogroups.com> <mailto:sqlcon%40yahoogroups.com>
      > > > > > Sent: Monday, October 30, 2006 2:19:21 PM
      > > > > > Subject: MUGH-SQLCON Link Server problem - "The provider ran
      > > out
      > > > of
      > > > > memory"
      > > > > >
      > > > > > Hi,
      > > > > >
      > > > > > Using Link Server to push the data from SQL server to DBF
      > files
      > > > > > version III using ODBC dsn.
      > > > > >
      > > > > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
      > > > > > 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
      > Standard
      > > > > > Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
      > > > > >
      > > > > > While running SQL command using Openquery
      > > > > > ------------ --------- --------- --------- --------- -------
      --
      > -
      > > > > > Insert into openQuery(CARDBABA, ' select CARD , SERIAL_NO,
      > > > COMPANY,
      > > > > > LANGUAGE ,LNAME,ADDRESS1, CITY,STATE, COUNTRY,DISPO,
      > > > > > Value,usage, prev_usage, RECHARGE, Calls_ACT, calls_ATH,
      > > > > > CALLS_TIM,LAST_ CALL,SURCHARGE, FLAT_RATE, RATE_SET,MIN_
      > > > > TIME,INCREMENT,
      > > > > > MIN_CALL,INC_ TIME,options, VRUCOMPANY, LOCATION,
      > > XDCCODE,FNAME,
      > > > > ADDRESS2, Z
      > > > > > IP,PHONE1,PHONE2, EXPIRATION, ACTIVATION, NOTES from
      > CARD0003')
      > > > > Select
      > > > > > a.account_id+ a.pin_id, a.Attribute_ field2, '0003', '01',
      > > > > b.batchname,
      > > > > > b.address, (select City_name from mst_city where
      > > city_id=b.city)
      > > > as
      > > > > > CITY, (select state_name from mst_state where
      > > state_id=b.statecod
      > > > > e)
      > > > > > as STATE,(select country_name from mst_country where
      > > > > > Country_code= b.countrycode) as COUNTRY,'S' ,
      > > > > > (b.prepaidamount* 100),0,0,
      > > > > > 0,0,'1',0,0, 0,0,'DFLT' ,0,0,0,0, ' ! ','','','',' ','','','
      > > > > 04','', '2008
      > > > > > -12-31 00:00:00.000' ,'','' from mst_pindetails a ,
      > mst_batchno
      > > b
      > > > > > where a.swhbatchcode= 'QLTY0545' and a.agentcode= '123' and
      > > > > > a.swhbatchcode= b.swhbatchcode
      > > > > > ------------ --------- --------- --------- --------- -------
      --
      > -
      > > > > >
      > > > > > output message :
      > > > > > OLE DB provider 'MSDASQL' reported an error. The provider
      ran
      > > out
      > > > > of
      > > > > > memory.
      > > > > > OLE DB error trace [OLE/DB Provider 'MSDASQL'
      > > > > > IRowsetChange: :InsertRow returned 0x8007000e: The provider
      > ran
      > > > out
      > > > > > of memory.].
      > > > > >
      > > > > > When we check Windows Task Manager, available space is
      > getting
      > > > > lesser
      > > > > > as and when the SQL command starts executing.
      > > > > >
      > > > > > Looking forward to provide an immediate solution or
      > workarounds.
      > > > > >
      > > > > > Regards,
      > > > > > Raina
      > > > > >
      > > > > >
      > > > > >
      > > > > >
      > > > > >
      > > > > >
      > > > > > [Non-text portions of this message have been removed]
      > > > > >
      > > > >
      > > >
      > >
      >
      >
      >
      >
      >
      > DISCLAIMER:
      > ----------------------------------------------------------
      ---------------------------------------------------
      > The contents of this e-mail and any attachment(s) are confidential
      and intended for the named recipient(s) only.
      > It shall not attach any liability on the originator or HCL or its
      affiliates. Any views or opinions presented in
      > this email are solely those of the author and may not necessarily
      reflect the opinions of HCL or its affiliates.
      > Any form of reproduction, dissemination, copying, disclosure,
      modification, distribution and / or publication of
      > this message without the prior written consent of the author of
      this e-mail is strictly prohibited. If you have
      > received this email in error please delete it and notify the sender
      immediately. Before opening any mail and
      > attachments please check them for viruses and defect.
      > ----------------------------------------------------------
      ---------------------------------------------------
      >
      > [Non-text portions of this message have been removed]
      >






      DISCLAIMER:
      -----------------------------------------------------------------------------------------------------------------------

      The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only.
      It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in
      this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates.
      Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of
      this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have
      received this email in error please delete it and notify the sender immediately. Before opening any mail and
      attachments please check them for viruses and defect.

      -----------------------------------------------------------------------------------------------------------------------

      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.