IICS Informatica Cloud - DTM 10.2 Update common errors.

Version 8

    Are you facing issues post DTM 10.2 update?
    We have identified some of the common issues encountered by users and pulled together a list of solutions to help you address them. Read on to know more.

    Note: If you have any technical issues, clickhere to open a support case or to contact Global Customer Support.

     

     

               

    Issues and Solution

    Issue: 1

    Tasks failing with Internal DTM error.
    Error observed: error while loading shared libraries: libidn.so.11: cannot   open shared object file.
        
    Solution: Please install libidn.so and restart the agent.
    Kb:   https://knowledge.informatica.com/s/article/Data-Integration-tasks-fail-with-the-error-error-while-loading-shared-libraries-libidn-so-11-cannot-open-shared-object-file-No-such-file-or-directory?language=en_US

    Issue: 2

    Tasks failing with Internal DTM error.
    Error seen in tomcat logs: terminate called after throwing an instance of   'std::ios_base::failure[abi:cxx11]'\n what(): basic_ios::clear: iostream   error\n
        
    The above error is seen when the agent is installed on Amazon Linux.
    Please refer IICS PAM for supported Linux OS on which the agents can be   installed.

    Issue: 3

    Tasks failing with Internal DTM error.
    Error in tomcat: /apps/Data_Integration_Server/60.0.5.1/ICS/main/bin/rdtm/pmdtm: /lib64/libresolv.so.2: version `GLIBC_2.9' not found (required by ./libkrb5.so.3)\n

    Solution: Please update Glib to 2.9 version or higher.

    Issue: 4

    Oracle jobs starts failing with below error after DTM 10.2 update.

     

     

    READER_1_1_1> RR_4036  Error connecting to database [

    [DataDirect][ODBC lib] Data source name not found and no default driver specified

    Database driver error...

    Function Name : Connect

    Database driver error...

    Function Name : Connect

    Database Error: Failed to connect to database using user [USER] and connection string [Driver=Yes;Host=HOSTNAME.com;ServiceName=Serv;Port=1521;UID=XXX;AS=6000000;EBL=0;ENS=1;IACP=4;ETWT=1;WorkArounds2=2;AllowedOpenSSLVersions=1.0.2;EnableEmptyLobs=1].].

     

     

     

    Temporary workaround:

     

     

     

    Windows:

    Create a DSN with the name as "Yes" in the registry pointing to the Driver =  install path\drivers\odbc\datadirect\r37\DWora28.so.

    Following are the steps required on a Windows Machine for Oracle:

     

    Open regedit as administrator.

    Go to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers

    Right click and click on new > String Value

    Provide the name as Yes  and value as Installed.

    Go to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI

    Right click on ODBCINST.INI > New > Key

    Create a newKey and add the name as Yes.

    Right click on Yes and add  below string values:

     

    Driver: <agent>\drivers\odbc\datadirect\r37\dwora28.dll

    Setup : <agent>\drivers\odbc\datadirect\r37\dwora28.dll

     

    Linux:

     

    Create an entry in odbcinst.ini file with “Yes” as name:

    Steps To be followed:

    Take the backup of the odbcinst.ini file present under <AGENT> directory.

    Edit the odbcinst.ini file and add the below entry in it:

    [Yes]

    Description = Temp entry for Oracle

    Driver = <Agent>/drivers/odbc/datadirect/r37/DWora28.so

    Setup = <Agent>/drivers/odbc/datadirect/r37/DWora28.so

    (These actions do not require a machine reboot or Agent restart.)

    Are you