1. In the odbc.ini, go to the [ODBC] entry.
It should look something like this by default:
[ODBC]
Trace=0
TraceFile=/<InformaticaInstallationDir>/ODBC7.0/odbctrace.out
TraceDll=/<InformaticaInstallationDir>/ODBC7.0/lib/DWtrc26.so
InstallDir=/<InformaticaInstallationDir>/ODBC7.0
2. Enter the following:
? Set Trace to 1
? Set TraceFile to the desired output file name including full path.
Where TRACEFILE specifies the name and full path of the trace file ? Leave all other settings as is.
Example
[ODBC]
Trace=1
TraceFile=/<InformaticaInstallationDir>/ODBC7.0/odbctrace.out
TraceDLL=/<InformaticaInstallationDir>/ODBC7.0/lib/DWtrc26.so
InstallDir=/<InformaticaInstallationDir>/ODBC7.0
3. Run the PowerCenter session with the error.
4. Set Trace=0 after running the session.
Please send the trace file (/<InformaticaInstallationDir>/ODBC7.0/odbctrace.out).