Issue | When running an Oracle SQL Transporter Data Feed, the following error is reported:
<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>
|
Resolution | From each Archer Server (including web and job engine servers)
- 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.
- 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
- 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. 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
|