While testing data source, FM doesn't respond and freezes

[Cognos_World]

Hi,

While testing the data source connection in FM, the FM does not respond and freezes. The database is Oracle. When queried against the database, thru Toad, it works fine.
Checked the network firewall and environment variables etc.. but nothing has helped so far.Any ideas why this might be happening and has anyone had any success resolving this?

Web server and the app server is on the same box. The gateway server is on the other.

Appreciate your answers.

Best!