July 23, 2024 at 10:12 pm
Hi,
SS ver: SS 2017, SE; Oracle: 19.23 SE
We have a nightly job that connects from our Sql server env to an Oracle database via Linked server that we have created for this purpose. This job had been running fine for the past several years - it pulls data from multiple tables. However, the past few days, it is erring out with the message
-----------------------------------------------------------------------------------------------------
Msg 7399, Level 16, State 1, Line 50
The OLE DB provider "ORAOLEDB.Oracle" for linked server "PROD" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7330, Level 16, State 2, Line 50
Cannot fetch a row from OLE DB provider "ORAOLEDB.Oracle" for linked server "PROD".
-----------------------------------------------------------------------------------------------------
while retrieving data for some tables from the Oracle database.
We decided to run queries manually on SS Mgmt Studio selecting data from one or two tables using "select * from OPENQUERY". We get the same message, but it is inconsistent. ie. if we retrieve just a few columns it seems to run to completion. If we try to retrieve all the columns in the table we get this message. Sometimes, it errs out for the same 3 or 4 columns, sometimes it does not err out for the same 3 or 4 columns. However it consistently errs out for "select * from table" ie, retrieving all columns in the table.
Searching on internet, we tried creating several Linked servers with fetch sizes from 150 to 10,000. ie, 150, 250, 500, 1000, 2000, 3000, 5000, 7000, 10000. All of them have the same issue.
I have not see this type of error before. Any tips?
Thanks a lot for your help,
Ram
July 24, 2024 at 11:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply