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

Still persists: Link Server problem - "The provider ran out of memory"

Expand Messages
  • Rajinder Raina
    Still stuck on the same issue..Tried all workarounds...didnt help.. ... to ... restarting ... out ... restart ... XDCCODE,FNAME, ... out ... XDCCODE,FNAME, ...
    Message 1 of 7 , Oct 31, 2006
    • 0 Attachment
      Still stuck on the same issue..Tried all workarounds...didnt help..


      --- In sqlcon@yahoogroups.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, "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, 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://www.sqlknowledge.com
      > > >
      > > >
      > > >
      > > >
      > > > ----- Original Message ----
      > > > From: Rajinder Raina <raina_raj77@>
      > > > To: sqlcon@yahoogroups.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]
      > > >
      > >
      >
    • Rajinder Raina
      Will DTS packages helps in this case....??? Still stuck with same issue ... query ... ran ... files ... Standard ... - ... CARD0003 ) ... mst_batchno ... - ...
      Message 2 of 7 , Nov 2, 2006
      • 0 Attachment
        Will DTS packages helps in this case....??? Still stuck with same
        issue

        --- In sqlcon@yahoogroups.com, "Rajinder Raina" <raina_raj77@...>
        wrote:
        >
        >
        > Still stuck on the same issue..Tried all workarounds...didnt help..
        >
        >
        > --- In sqlcon@yahoogroups.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, "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, 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://www.sqlknowledge.com
        > > > >
        > > > >
        > > > >
        > > > >
        > > > > ----- Original Message ----
        > > > > From: Rajinder Raina <raina_raj77@>
        > > > > To: sqlcon@yahoogroups.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]
        > > > >
        > > >
        > >
        >
      Your message has been successfully submitted and would be delivered to recipients shortly.