Error connecting with teradat odbc | DatabaseError: (0, u'[632] 523 630')

Connectivity

Error connecting with teradat odbc | DatabaseError: (0, u'[632] 523 630')

I've tried following the advice to export the ODBCINI but still get the 632 523 630 error. Any idea what is causing this?

It works on my MAC but not on a CENTOS server where I've installed the 15.10 odbc via "sudo rpm -ivh --nodeps tdodbc1510-15.10.01.00-1.noarch.rpm"

export ODBCINI=/opt/teradata/client/15.10/odbc_64/odbc.ini

echo $ODBCINI

/opt/teradata/client/15.10/odbc_64/odbc.ini

In [1]: from time import time

In [2]: import pandas as pd

In [3]: import teradata

In [4]: t = time()

In [5]: udaExec = teradata.UdaExec(appName='*appname*', version='1.0', logConsole=True)

2016-01-12 07:55:41,283 - teradata.udaexec - INFO - Initializing UdaExec...

2016-01-12 07:55:41,283 - teradata.udaexec - INFO - Reading config files: [u'/etc/udaexec.ini: Not Found', u'/home/*usr*/udaexec.ini: Not Found', u'/home/*usr*/udaexec.ini: Not Found']

2016-01-12 07:55:41,283 - teradata.udaexec - INFO - Found run number file: "/home/*usr*/.runNumber"

2016-01-12 07:55:41,283 - teradata.udaexec - INFO - Cleaning up log files older than 90 days.

2016-01-12 07:55:41,284 - teradata.udaexec - INFO - Removed 0 log files.

2016-01-12 07:55:41,296 - teradata.udaexec - INFO - Checkpoint file not found: /home/*usr*/*appname*.checkpoint

2016-01-12 07:55:41,300 - teradata.udaexec - INFO - No previous checkpoint found, executing from beginning...

2016-01-12 07:55:41,300 - teradata.udaexec - INFO - Execution Details:

/********************************************************************************

 * Application Name: *appname*

 *          Version: 1.0

 *       Run Number: 20160112075541-6

 *             Host: XXXX

 *         Platform: Linux-2.6.32-504.16.2.el6.x86_64-x86_64-with-centos-6.6-Final

 *          OS User: *usr*

 *   Python Version: 2.7.10

 *  Python Compiler: GCC 4.4.7 20120313 (Red Hat 4.4.7-11)

 *     Python Build: ('default', 'Sep  2 2015 14:30:10')

 *  UdaExec Version: 15.10.0.12

 *     Program Name: /usr/local/bin/ipython

 *      Working Dir: /home/*usr*

 *          Log Dir: /home/*usr*/logs

 *         Log File: /home/*usr*/logs/*appname*.20160112075541-6.log

 *     Config Files: [u'/etc/udaexec.ini: Not Found', u'/home/*usr*/udaexec.ini: Not Found', u'/home/*usr*/udaexec.ini: Not Found']

 *      Query Bands: ApplicationName=*appname*;Version=1.0;JobID=20160112075541-6;ClientUser=*usr*;Production=False;udaAppLogFile=/home/*usr*/logs/*appname*.20160112075541-6.log;UtilityName=PyTd;UtilityVersion=15.10.0.12

********************************************************************************/

In [6]: #session = udaExec.connect(method='odbc',system='*hostname*', username='*usr*', password='*pwd*')

In [7]: session = udaExec.connect(method='odbc',system='*hostname*', username='*usr*', password='*pwd*', MechanismName='LDAP')

2016-01-12 07:55:41,373 - teradata.udaexec - INFO - Creating connection: {'username': '*usr*', 'password': 'XXXXXX', 'MechanismName': 'LDAP', 'system': '*hostname*', 'method': 'odbc'}

2016-01-12 07:55:41,374 - teradata.tdodbc - INFO - Loading ODBC Library: libodbc.so

2016-01-12 07:55:41,378 - teradata.udaexec - ERROR - Unable to create connection: {'username': '*usr*', 'password': 'XXXXXX', 'MechanismName': 'LDAP', 'system': '*hostname*', 'method': 'odbc'}

Traceback (most recent call last):

  File "/usr/local/lib/python2.7/site-packages/teradata/udaexec.py", line 172, in connect

    **args))

  File "/usr/local/lib/python2.7/site-packages/teradata/tdodbc.py", line 358, in __init__

    checkStatus(rc, hDbc=self.hDbc, method="SQLDriverConnectW")

  File "/usr/local/lib/python2.7/site-packages/teradata/tdodbc.py", line 194, in checkStatus

    raise DatabaseError(i[2], u"[{}] {}".format(i[0], i[1]), i[0])

DatabaseError: (0, u'[632] 523 630')

---------------------------------------------------------------------------

DatabaseError                             Traceback (most recent call last)

<ipython-input-7-bd29de93a415> in <module>()

----> 1 session = udaExec.connect(method='odbc',system='*hostname*', username='*usr*', password='*pwd*', MechanismName='LDAP')

/usr/local/lib/python2.7/site-packages/teradata/udaexec.pyc in connect(self, externalDSN, dataTypeConverter, **kwargs)

    170                                          odbcLibPath=self.odbcLibPath,

    171                                          dataTypeConverter=dataTypeConverter,

--> 172                                          **args))

    173             else:

    174                 raise api.InterfaceError(

/usr/local/lib/python2.7/site-packages/teradata/tdodbc.pyc in __init__(self, dbType, system, username, password, autoCommit, transactionMode, queryBands, odbcLibPath, dataTypeConverter, **kwargs)

    356         finally:

    357             lock.release()

--> 358         checkStatus(rc, hDbc=self.hDbc, method="SQLDriverConnectW")

    359 

    360         # Setup autocommit, query bands, etc.

/usr/local/lib/python2.7/site-packages/teradata/tdodbc.pyc in checkStatus(rc, hEnv, hDbc, hStmt, method, ignore)

    192                 logger.debug((u"{} returned non-successful error code "

    193                               u"{}: [{}] {}").format(method, rc, i[0], i[1]))

--> 194                 raise DatabaseError(i[2], u"[{}] {}".format(i[0], i[1]), i[0])

    195             else:

    196                 logger.debug(

DatabaseError: (0, u'[632] 523 630')

"
1 REPLY
Enthusiast

Re: Error connecting with teradat odbc | DatabaseError: (0, u'[632] 523 630')

Hi,

We are also facing similar problem. Did you get the resolution for the problem?

Can anyone please help on this?

 

Thanks & Regards,

Arpan.