Originally posted by: SystemAdmin

We have this problem where even when we send the fully working code to other systems(test), we get 'target Not Found' Error.

We have a DB insertion(oracle) in the map and we have a mdq file being used.

The tester is using the same oracle instance as us.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

Hi,

Have U verified if the Database settings(DBName,User ID, Password etc. ) same in both environments and the table structure same.

Thanks,
Deepthi
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: TarunB

First of all, confirm which target the TX map is failing to connect to, by using the audit log.

If it is indeed the Oracle database, then check that the MDQ is available in the directory that the map code expects it to be in. Then check that the Oracle connect string has been defined in the server .ora file. Make sure that you have an Oracle client install on the server and that the TX user is authorised to connect to the database. It may prove helpful setting a DB trace on the TX map where the DB call is initiated.

If it isn't one of those, then perhaps there is a network issue (firewall for example) that is preventing the map from connecting to the database.

Good luck -

Tarun
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange