Thanks for the response Scott.
Actually,I was checking just the logs of Adapters and missed to check the System Log.
The adapter was executing,creating a connection but got stuck while fetching data.
As suspected,it got clear from the system logs that adapter was not able to write data to the DB as the tablespace had gotten full.
Had discussion with Maheshwar regarding this the other day and have asked my DBA to do the needful.
Regards,
Sushank Saini