Pinned topicImpromptu Application Errror : The report request failed

‏2012-03-06T15:13:29Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

Hi,

When I try to launch IWR reports from Cognos Upfront I get the below error :
Application Error:
The report request failed.
The execution of this report at 03/06/12 10:09:30 failed due to the following reason:
Unable to connect to database.

Re: Impromptu Application Errror : The report request failed

‏2012-04-05T01:04:34Z

This is the accepted answer.
This is the accepted answer.

Have you checked the user login information on the server and database? Did that user lose accessibility on the server? Did the user have permission changes in the database? Perhaps the database logs would have an entry to help troubleshoot the issue.

You can also look at this page for some other clues/options:
http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm

Re: Impromptu Application Errror : The report request failed

This could either be that the tnsname.ora is not setup properly or the IWR application, specifically impserver.exe cannot access it.

Try running the report through impserver by double clicking on the impserver.exe CTRL-O and locating the report within the Apps directory. If the report runs then its most likely an ENV PATH issue. Make sure that Oracle\bin directory is on the path for the user starting the IWR Service.

If the report does not run, its most likely the oracle setup itself, ensure that you can perform a TNSPING on the service ID and that you are able to connect through SQLPlus before attempting to run the report within IWR.h