setNLSPATH=/opt/teradata/client/lib/odbc/%N.cat Once this is setup, the driver should return the correct error code messages andwith that information, further troubleshooting can be done according to the message received. tdwallet -14.10.00.001 - Teradata Wallet Utility 11. Error Message QueryEngine encountered error: FetchScroll. Not the answer you're looking for? navigate here
more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed 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. mqaxsmod - 14.10.00.01 - WebSphere(r) Access Module for Teradata7. tpump - 14.10.00.04 - Teradata TPump Utility When I try to connect to the remote host via Python, I receive a 'Unable to https://community.microstrategy.com/t5/Architect/TN44677-quot-Unable-to-get-catalog-string-quot-error-message/ta-p/194421
The teradata DB version is 14.10. More Information INFA_More_InformationANSI Mode: When a character string requires truncation, the excess pad characters are truncated without reporting an error. Please enter your message and try again. 1 Reply Latest reply: Dec 5, 2014 4:02 AM by Gil Holmes Unable to get catalog string - intermittent error tpluck Dec 1, 2014 MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability 0 of 2 people found this article helpful.
Sometimes it fails and a third try works.Any help would be appreciated.We run Informatica 9.1 on AIX connecting to Teradata 13.10Thank you. 314Views Categories: V9 Tags: none (add) teradataContent tagged with Applies To Product(s): Metadata Manager Product Version(s): Metadata Manager Metadata Manager KB Database: Operating System(s): Other Software: Reference INFA_Referencehttp://www.info.teradata.com/HTMLPubs/DB_TTU_14_10/index.html#page/Database_Management/B035_1093_112A/1093Chap8.030.01.html http://forums.teradata.com/forum/teradata-studio/error-right-truncation-of-string-data Related Documents INFA_Related_Docs Attachments INFA_Attachments Last Modified Date:3/11/2015 4:47 AMID:313902 Feedback This document resolved my issue This document did not resolve my issue This document helped but additional information was required to resolve my issue What can we do to improve this Like Show 0 Likes (0) Actions Follow Share Like Show 0 Likes 0 More Like This Retrieving data ...
I think you need to set an NLSPATH environment value pointing to where your tdodbc.cat file is. DBCName=jonny.xxx.xxx.xxxI can ping jonny.xxx.xxx.xxxI can ping jonnyI can ping jonnyCOP1I can ping jonnyCOP1.xxx.xxx.xxx 0 Kudos Reply Fred Teradata Employee Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Teradata Mode: When a character string requires truncation, the string is truncated silently with no truncation notification given. https://network.informatica.com/thread/21440 Unable to get catalog string.
For example,if the "tdodbc.cat" file is located in "/opt/teradata/client/lib/odbc/tdodbc.cat",use the command shown below to set the proper value. 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). Dinakar Back to top sukravPrincipal MemberJoined: 29 Jan 2008Posts: 114 Posted: Wed Dec 02, 2009 5:35 amPost subject: Re: Getting ODBC Error Hi Dinakar, Test the ODBC driver which is used Development of retrosynthesis plan Why is the size of my email so much bigger than the size of its attached files?
Connectivity All communityThis categoryThis boardKnowledge baseUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches http://centralpedia.com/unable-to/unable-to-map-error-code-998.html Total sockets created:8 [ cwinsock.cpp 1322 ] 65 TS:17610: *** LCC: select() waiting for 0.240000 seconds. 8 active connections [ cwinsock.cpp 1203 ] 66 TS:20010: *** LCC: select() TIMEDOUT [ cwinsock.cpp Why does removing Iceweasel nuke GNOME? Below is the error message: -----------------------------------./demoodbc DataDirect Technologies, Inc. Rr_4035 Sql Error Informatica Teradata
Are assignments in the condition part of conditionals a bad practice? Error type: Odbc success with info. Error Message Unable to get catalog string. his comment is here Showing results for Search instead for Did you mean: Teradata : Product Forums : Connectivity : centos 6.4 + tdodbc 15 getting error: 110 Unable t...
Hi all, hoping someone can help. making new symbol from two symbols 2011 MacBook Pro upgrade? Thanks, 0 Kudos Reply All forum topics Previous Topic Next Topic 6 REPLIES Fred Teradata Employee Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Get Direct Link Print Email
You cannot post a blank message. Database driver error... fastld - 14.10.00.04 - Teradata FastLoad Utility 4. What does the DBCName parameterfor yourDSN entry look like?If it's a single name "X" can you ping XCOP1 (with the added suffix)?
Unable to populate section table sect1.error IM002 Microsoft ODBC DRiver Manager Data Source name not found and no default drive specified 0 Kudos Reply jayceitr2nv Fan Options Mark as New Bookmark 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. PCMag Digital Group AdChoices unused Not endorsed by or affiliated with SAP Register| Login Follow BOB on Twitter! (Opens a new window) Index|About Sponsors| Contact Us| Calendar| FAQ| Rules http://centralpedia.com/unable-to/unable-to-load-error-string-from-resource.html Is there a way to determine what the underlying issue would be and how to prevent it from happening again?appreciate any guidances..... 0 Kudos Reply amittera Enthusiast Options Mark as New
I believe it's a network firewall issue. Total sockets created:6 [ cwinsock.cpp 1322 ] 57 TS:12800: *** LCC: select() waiting for 0.240000 seconds. 6 active connections [ cwinsock.cpp 1203 ] 58 TS:15200: *** LCC: select() TIMEDOUT [ cwinsock.cpp Something along these lines: /opt/teradata/client/lib/odbc/%N.cat That funky looking %N.cat is standard, you just need to point to the correct location. The host that I am trying to connect from is 64-bit RHEL 6.x with the following Teradata software installed: bteq fastexp fastld jmsaxsmod mload mqaxsmod npaxsmod sqlpp tdodbc tdwallet tptbase tptstream