EPM - Common ODBC Errors

This document contains a list of common ODBC errors, their causes, and solutions.

Background:

Certain error codes denote problems with ODBC connections (used to connect to EPM databases). This document describes some of those error messages, their causes, and potential solutions to underlying problems.

Errors:

TNS-03505: Failed to resolve name

  • When it appears: User runs 'tnsping' command to verify ODBC database connectivity.

  • Cause: User mistypes name of ODBC connection and/or ODBC connection named or formatted incorrectly in tnsnames.ora file. Example: if tnsames.ora contains a connection entry named 'DATABASE' but user types 'DATABSAE' at the tnsping prompt, error will appear. Can also appear if tnsnames.ora does not exist.

  • Solutions: Verify presence of tnsnames.ora file. Ensure the name of the connection typed at the tnsping prompt matches the name of the connection entry in tnsnames.ora.

TNS-12545: Connect failed because target host or object does not exist

  • When it appears: User runs 'tnsping' command to verify ODBC database connectivity.

  • Causes: Invalid hostname in tnsnames.ora and/or local networking issues.
  • Solutions: Verify basic network connectivity on local machine. Verify that the
    Host =
    entry in tnsnames.ora contains a valid hostname.

ORA-01013: User requested cancel of current operation

  • When it appears: User runs query against an Oracle database in any of a variety of applications (e.g. MS Access, TOAD, SQL Developer).
  • Causes: Can appear if user prematurely cancels an SQL operation over an ODBC connection. Can also indicate a connection timeout in the event of a long or malformed query.
  • Solutions: If user is not cancelling connection intentionally, disable timeout on ODBC connection. User should check query/SQL operation for errors.

ORA-01254: TNS: could not resolve the connect identifier specified

  • When it appears: User attempts to configure ODBC connection.
  • Causes: Malformed (incorrect or improperly formatted) connection entry in tnsnames.ora
  • Solutions: Run 'tnsping' to determine which of the above two TNS- errors is applicable. Work through the corresponding solution(s).

See Also:




Keywords:tnsnames, tnsnames.ora, names, EPM, ODBC, Enterprise Performance Management, HRS, data warehouse, data, ora file, sqlnet, MS Access, access, tsnnames, tns, Oracle Database, database, database connection, tnsping, ping, errors, error, common error, error message, timeout, time, out, 01013, 01254, 12545, 03505, ORA-, TNS-, ora, tns   Doc ID:19644
Owner:Leah S.Group:DoIT Help Desk
Created:2011-08-08 19:00 CDTUpdated:2012-05-10 14:55 CDT
Sites:DoIT Help Desk
Feedback:  0   0