April 30, 2015 at 7:54 am
I am getting an error running a query(it also generates a stack dump): SQL 2008R2 standard 10.50.2868.0 NT x64
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "OraOLEDB.Oracle" for linked server "ZEZASQL" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7321, Level 16, State 2, Line 2
An error occurred while preparing the query "SELECT PE.*
select *
FROM OPENQUERY(ZEZASQL, 'SELECT PE.*
FROM AWACSUSER.COMPANY CO
JOIN AWACSUSER.COMPANYLOC CL ON CL.CLCOMPANYMDK = CO.COID
JOIN AWACSUSER.MAPPEDCOMPANYMANAGER MC ON MC.MCOMACOMPANYMDK = CL.CLID
JOIN AWACSUSER.PERSON PE ON PE.PEID = MC.MCOMAPERSONMDK
LEFT JOIN AWACSUSER.MGRPERSON MP ON MP.MPPERSONMDK = PE.PEID
LEFT JOIN PERLIVE.RF_MANAGER_STATUS MS ON MS.MANAGER_STATUS_ID = MP.MPCLIENTROLEMDK
LEFT JOIN AWACSUSER.LOOKUPPOSITIONTITLE LP ON LP.LPTID = PE.PETITLEMDK
WHERE PE.PEID = 0 OR (CL.CLID = 1020095 AND PE.PECLIENT = ''Yes'') ')
If i run it with explicit column references it does work. the query works on all our other servers.
First question: Since i am getting a SQL and not an Oracle, does that mean it is a SQL error?
Any input would be appreciated.
April 30, 2015 at 8:35 am
Looks like you need to talk to Oracle
Gerald Britton, Pluralsight courses
April 30, 2015 at 8:57 am
If i have 10 other SQL servers making the same call how can it be an Oracle issue? Possible the Oracle client on that Sql Server. and making explicit columns calls also works...strange
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply