Cannot get the data of the row from the OLE DB pro

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Cannot get the data of the row from the OLE DB pro

Author

Topic

Narinder
Starting Member

7 Posts

Posted - 2011-09-26 : 14:31:51

Hi,
We are in the process of upgrading from SQL server 2000 to 2008. The following codes worked fine on SQL server 2000 for years feteching data from "Sybase" linked server. But it fails on 2008. FYI, the data set is more than 3,000,000 records.

insert into csr_dem
select oq.csr_nbr, oq.CSR_BRT_DTE, oq.csr_pcc_cde, oq.csr_pcp_nbr, oq.csr_sex_cde,
oq.csr_pri_car_cln_cde, oq.csr_dth_flg, getdate()
FROM openquery(dw_sybase,'select csr_nbr,
csr_brt_dte,
csr_pri_car_cln_cde as csr_pcc_cde,
csr_pcp_nbr,
csr_sex_cde,
csr_pri_car_cln_cde,
csr_dth_flg
from data_warehouse.dbo.csr_dem') OQ

Here is the error message. FYI, there are no rows marked for deletion.

OLE DB provider "MSDASQL" for linked server "dw_sybase" returned message "Row handle referred to a deleted row or a row marked for deletion.".
Msg 7346, Level 16, State 2, Procedure edm_load_csr_dem, Line 4
Cannot get the data of the row from the OLE DB provider "MSDASQL" for linked server "dw_sybase".

NS

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-26 : 15:09:59

is this part of batch? are there any other openquery statements to same linked server within the same batch?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Narinder
Starting Member

7 Posts

Posted - 2011-09-27 : 11:48:32

It's a stored proc and there is only openquery in this strored proc. We added more memory to sql server and that didn't helped either. Sometimes the error is related ODBC driver.

Here's one manifestation of the error:

OLE DB provider "MSDASQL" for linked server "dw_sybase" returned message "[Sybase][ODBC Driver]String data, right truncated".
OLE DB provider "MSDASQL" for linked server "dw_sybase" returned message "[Sybase][ODBC Driver]Internal Error".
OLE DB provider "MSDASQL" for linked server "dw_sybase" returned message "[Sybase][ODBC Driver]Data overflow. Increase specified column size or buffer size".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "dw_sybase".

Here's another manisfestation of errors:

OLE DB provider "MSDASQL" for linked server "dw_sybase" returned message "[Sybase][ODBC Driver]Internal Error".
OLE DB provider "MSDASQL" for linked server "dw_sybase" returned message "[Sybase][ODBC Driver]Internal Error".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDASQL" for linked server "dw_sybase".

NS

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources