-
1. Re: Error Run Data Viewer
Akshay HB Feb 14, 2020 1:52 AM (in response to Deni Kusdeni)Hi,
Please verify if all the required environment variables such as ODBCHOME, PATH and LD_LIBARARY_PATH are set properly prior to starting the services.
Could you share the tomcat_envvars.txt present under <INFA_HOME>/tomcat/temp which will have all the env variables at the time the service was started and also, let us know the OS on which the server is running?
Thanks and Regards
Akshay
-
2. Re: Error Run Data Viewer
Deni Kusdeni Feb 14, 2020 2:04 AM (in response to Akshay HB)Hi,
I will check that.
I'm using CentOS 7
-
3. Re: Error Run Data Viewer
puneeth natesha Feb 14, 2020 6:50 AM (in response to Deni Kusdeni)Hi,
This issue occurs because none of the ODBC related environment variables were set.
To resolve this issue, follow the steps:
Set the following environment variables and restart the Domain:
ODBCHOME=$INFA_HOME/ODBC7.1
ODBCINI=$ODBCHOME/odbc.ini
PATH=$ODBCHOME/bin:$PATH
LD_LIBRARY_PATH=$ODBCHOME/lib:$LD_LIBRARY_PATH
Inside odbc.ini change the follows:InstallDir=xxx/10.1.1 change it to InstallDir=$ODBCHOME
-
4. Re: Error Run Data Viewer
Deni Kusdeni Feb 16, 2020 1:17 AM (in response to puneeth natesha)Now, I'm have error
[LDTMCMN_0029] The LDTM could not complete the request because of the following error: com.informatica.sdk.dtm.ExecutionException: [EdtmExec_00007] RR_4036 Error connecting to database [
523 630
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [sa] and connection string [XXXXX].].
-
5. Re: Error Run Data Viewer
Akshay HB Feb 17, 2020 2:57 AM (in response to Deni Kusdeni)Hi,
Though CentOS is a "free" version of Red Hat, it is still not supported by Informatica and the only supported operating systems for BDM 10.2.2 are SLES and RHEL.
Having said that, is the database entry present in TNS config file (tnsnames.ora)? You can verify the connection to the database via sqlplus utility before running the BDM mapping/data viewer.
Thanks and Regards
Akshay
-
6. Re: Error Run Data Viewer
Deni Kusdeni Feb 17, 2020 7:33 PM (in response to Akshay HB)Hi,
Thanks for you info.
I'm using Ms SQL Server 2016.
I have been solve this issue with check Use DSN in my connection properties and do some modification in odbc.ini file
Thanks