000036909 - RSA Archer ODBC SQL Transporter Data Feed failing with ORA-12514: TNS listener does not currently know of service requested in connect descriptor

Document created by RSA Customer Support Employee on Nov 5, 2018
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000036909
Applies ToRSA Product Set: Archer
RSA Product/Service Type: RSA Archer (On-Premise)
RSA Version/Condition: 6.3.0.5
Platform: Windows
IssueWhen running an Oracle SQL Transporter Data Feed, the following error is reported:
 

<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent"> 
 <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system"> 
 <EventID>3</EventID> 
 <Type>3</Type> 
 <SubType Name="Critical">0</SubType> 
 <Level>1</Level> 
 <TimeCreated SystemTime="2018-06-29T16:02:39.2937274Z"/> 
 <Source Name="ArcherTech.DataFeed"/> 
 <Correlation ActivityID="{00000000-0000-0000-0000-000000000000}"/> 
 <Execution ThreadID="9" ProcessID="" ProcessName="w3wp"/> 
 <AssemblyVersion>6.3.500.1018</AssemblyVersion> 
 <Channel/> 
 <Computer></Computer> 
 </System> 
 <ApplicationData> 
 <TraceData> 
 <DataItem> 
 <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"> 
 <TraceIdentifier>ArcherTech.DataFeed</TraceIdentifier> 
 <Description>Unable to connect to database: ERROR [HY000] [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Most likely cause is the connection string contains invalid information. Please verify the connection string. Other possible causes... 1) User specified in connection string does not have the proper permissions.2) Database is not accessible from this server. 3) Database is not currently online. </Description> 
 <AppDomain>/LM/W3SVC/1/ROOT/archer-1-131747364097559172</AppDomain> 
 <ContextData> 
 <LogReferenceId>062918-122912-3684</LogReferenceId> 
 </ContextData> 
 <Exception> 
 <ExceptionType>ArcherTech.DataFeed.Util.LoadFieldsException, ArcherTech.DataFeed.Util, Version=6.3.500.1018, Culture=neutral, PublicKeyToken=null</ExceptionType> 
 <Message>Unable to connect to database: ERROR [HY000] [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor Most likely cause is the connection string contains invalid information. Please verify the connection string. Other possible causes... 1) User specified in connection string does not have the proper permissions.2) Database is not accessible from this server. 3) Database is not currently online. </Message> 
 <Source>ArcherTech.DataFeed.Util</Source> 
 <StackTrace> at ArcherTech.DataFeed.Util.SqlDbWrapper.OpenConnection(IDbConnection connection) at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetDatabaseQuerySchemaSet(XDocument configXDoc) at ArcherTech.DataFeed.Util.DataFeedSchemaSetGenerator.GetSchemaSetWithConfig(Stream streamConfigAndSource)</StackTrace> 
 <InnerException> 
 <ExceptionType>System.Data.Odbc.OdbcException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType> 
 <Message>ERROR [HY000] [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY000] [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descriptor </Message> 
 <Source> </Source> 
 <StackTrace> at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.Odbc.OdbcConnection.Open() at ArcherTech.DataFeed.Util.SqlDbWrapper.OpenConnection(IDbConnection connection)</StackTrace> 
 </InnerException> 
 </Exception> 
 </TraceRecord> 
 </DataItem> 
 </TraceData> 
 </ApplicationData> 
 </E2ETraceEvent>
CauseThe Archer server that is running the Data Feed, or loading the Source Definition fields is not capable of connecting to the Oracle Database through the Server's preconfigured ODBC connections and/or Oracle tnsnames.ora file.
 
Resolution

From each Archer Server (including web and job engine servers)
1. Start ->ODBC Data Sources ->  Verify there is a valid DSN connection to the Oracle database that is referenced from the ODBC connection string configured in the Archer Data Feed.




2. Confirm that each Archer server has a tnsnames.ora file correctly configured with a valid reference to the database server and database name that is being used by the Archer Data Feed.  From a Windows Command prompt run the command:




notepad.exe %ORACLE_HOME%\network\admin\tnsnames.ora


 



3. If missing, install and configure Oracle ODBC software on all Archer servers (including web and job engine servers).  The software needs to be configured to point to a valid Oracle Database server that is reachable from all Archer servers in the environment, and it also needs to be configured with a reference to a valid Database on that server.

For Oracle documentation on this error, please see: 
https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12500.htm

Attachments

    Outcomes