May 28, 2013 at 11:31 am
I have a view that is built on OPENQUERY function calls to linked server (Oracle db). When I run queries against that view, I sometimes get the following error:
OLE DB provider "OraOLEDB.Oracle" for linked server "VTRACK" returned message "ORA-01403: no data found".
Msg 7346, Level 16, State 2, Line 1
Cannot get the data of the row from the OLE DB provider "OraOLEDB.Oracle" for linked server "VTRACK".
This doesn't happen all of the time, but comes up frequently enough to be a problem. This error has been thrown by multiple queries, so I'm thinking the problem does not lie with the query itself. Any idea what causes this error?
May 29, 2013 at 6:32 am
Also, the OraOLEDB provider was already set to 'Allow Inprocess,' so this isn't the problem. I've tried deselecting this option, selecting it again, and then restarting the instance, but the result is the same. I haven't found any other possible solutions in my searching, unfortunately.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply