DataStage - Data Integration

 View Only

RDBMS code -1 error in DS 11.7

  • 1.  RDBMS code -1 error in DS 11.7

    Posted Fri October 29, 2021 08:49 AM
    Hello,

    I am getting error when trying to 'Teradata' connection from DS designer.

    Error = 




    Details as follows:

    Server details =

    Server OS: CentOS 7.9
    DS version: 11.7
    .odbc.ini config done = Yes
    uvodbc.config = Done 
    Java version: openJDK "1.8.0_302"
    DS installation dir = /opt/IBM/InformationServer/Server/Projects/ANALYZERPROJECT
    Teradata drivers version: 15.10 & 16.20 [Tried with both the drivers]
    Teradata server version: 15.07


    Client details = 

    Client OS = Windows Server 2016 STD with desktop experience
    Teradata drivers installed = Yes
    ODBC32 configured for TD = Yes

    Additional information:

    - We selected ALL DS components while installing server on CentOS
    - We selected ALL DS components while installing DS designer on Windows machine
    - OS update was performed on CentOS before installing DS server
    - Required kernel parameter tuning was done before installing DS server


    Pls suggest how to solve this error.
    I am seeing this error for 1st time in my env.
    I have other DS instances running with same set of softwares.

    Thanks & Regards,
    Bipasha.


    ------------------------------
    Bipasha Tandon
    ------------------------------