Unable to connect to Teradata Data Source db_name. -1 Message Not Found

Technote (troubleshooting)


Problem(Abstract)

Encounter error "Unable to connect to Teradata Data Source db_name. -1 Message Not Found" when



1. Using TD plugin or TDCC stage in a DataStage job. Or

2.Using Import table definition from TeraData plugin or connector.

Symptom

Encounter error "Unable to connect to Teradata Data Source db_name. -1 Message Not Found" when

1. Using TD plugin or TDCC stage in a DataStage job. Or
2. Using Import table definition from TeraData plugin or connector..


Cause

The error is given is due to errmsg.cat file missing either from TD lib directory or the environment variable COPERR is missing or not defined properly.

Resolving the problem

In case the issue occurred:

1. check if errmsg.cat exists in the TD lib path defined for TD. For example, if you have LIBPATH defined as below in dsenv, check if errmsg.cat exists in "/opt/teradata/client/13.10/lib64"

LIBPATH=$LIBPATH:/opt/teradata/client/13.10/lib64

2. check if COPERR is defined or is defined properly in dsenv.

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere DataStage

Software version:

8.0, 8.0.1, 8.0.1.1, 8.0.1.2, 8.0.1.3, 8.0.2, 8.1, 8.1.0.1, 8.1.0.2, 8.5, 8.5.0.1, 8.5.0.2, 8.5.0.3, 8.7, 8.7.0.1, 9.1

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:

1624025

Modified date:

2014-01-22

Translate my page

Machine Translation

Content navigation