Run Map Fails -- Target Not Available

[jackcool]

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

[janhess]

Did you change the password in the mdq? Did you restart the Event Server?

[cloggieroo]

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.

[jackcool]

Thanks for the reply guys.Issue was with the Database permissions.
Accidently my Database permission were changed ,which gives read only[SELECT] access to DB,which i did not pay attention.
After changing the permissions to read/write everything works fine.