All Forums Connectivity
jgirish 1 post Joined 10/08
15 Oct 2008
Catalog Error

I am getting the following error when trying to connect to Teradata from UNIX (Sun OS). This connection was working couple of weeks back and stopped working after the server crashed due to user libraries were deleted (do not know how). I am trying to connect using ODBC entry and below is how my ODBC is setup. ---------------------------[tdp1_ip]Driver=/usr/odbc/ drivers/tdata.soDescription=Dev TeradataDBCName=10.206.68.19DateFormat=AAASessionMode= ANSIDefaultDatabase=UserName=Password=---------------- -----------I am using to test my odbc connection. Below is the error message: -----------------------------------./demoodbc DataDirect Technologies, Inc. ODBC Sample Application../demoodbc: will connect to data source 'tdp1_ip' as user 'user1/passwd1'.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.No connection could be established. ----------------------------------------Any help on this is greatly appreciated. Thanks,

Fred 1096 posts Joined 08/04
18 Oct 2008

Be sure you have installed proper TDICU and TeraGSS libraries also.

sk73 52 posts Joined 07/09
10 Nov 2009

hi Fred, one of my team members is facing the same situation right now. Our team uses Teradata ODBC driver in Business Objects reports. The situation came up when she was trying to pull a Business Objects report.The "Catalog error" prompt shows up only when Business Objects alone is being used. If she just logs in to Teradata and then opens the report in Business Objects, then, there is no catalog error.I understand that the issue is with the ODBC driver. Can you help me in fixing this? Whom should I consult or what should I do now?Any suggestion is greatly appreciated.Thank you

vhari 111 posts Joined 12/08
10 Nov 2009

"[ODBC Teradata Driver] Unable to get catalog string."This error indicates that Teradata ODBC driver trying to post an error, but it cannot find it's error message catalog file.Search for "tdodbc.cat" file and set NLSPATH variable. For example if you find tdodbc.cat in/opt/teradata/client/lib/odbc/tdodbc.catthen setNLSPATH=/opt/teradata/client/lib/odbc/%N.cat---It would let you see the actual error message.

brownsn 1 post Joined 03/12
16 Mar 2012

Status Code: 8140 Connecting to ODBC. Unable to populate section table sect1.error IM002 Microsoft ODBC DRiver Manager Data Source name not found and no default drive specified

jayceitr2nv 3 posts Joined 02/12
16 Sep 2014

I have similar issues but with Informatica. Below is the error message.
RR_4036 Error connecting to database [
[Teradata][Unix system error] 238 Unable to get catalog string.
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [MMDMETL] and connection string [TDPRD_BTET].].
Restarting the job from autosys typically resolves this issue. Is there a way to determine what the underlying issue would be and how to prevent it from happening again?
appreciate any guidances.....

Mr.Jayce

amittera 35 posts Joined 12/09
09 Sep 2015

Hi Jayce, 
 
Di you get any clue to the above error posted and seen at Informatica?

Amit Saxena
Teradata Consultant

You must sign in to leave a comment.