Hi ,
I created a Map with one Input Card and one Output Card.Source for InputCard is File and Target for Output Card is Database.It worked fine until i changed my DB password.Since then Map does not run any more,it gives me error "Target Not Avaialble" .I was using MDQ file to connect to the database.I recreted Outut Cards,recreated MDQ ,recompiled type trees so far none of them seems to work.Does Datastage Tx caches the Database information any where ? Any clues/suggestions ?
Thanks
Jack
Run Map Fails -- Target Not Available
-
- Participant
- Posts: 10
- Joined: Fri May 28, 2004 8:01 am
- Location: Netherlands
Re: Run Map Fails -- Target Not Available
Try putting a trace on the SQL insert or query to the database. Trace information should tell you what your problem is. As stated in the other reply, don't forget to recycle the Event Server.