When I try to launch IWR reports from Cognos Upfront I get the below 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.
When i checked the iwr.log file it shows me below description:
IWRcer5:ImpServer:ImpServer.OleExceptionError: <servername>, 1951(1), 2012/03/06 10:09:33.301; Logon error while connecting the database.
Data Services are not available. Impromptu Web Reports is unable to perform data access.Error number -4:
DMS-E-CONNECTREJECT, A connection has been rejected by the remote interface during operation 'attach database'.
ORA-12154: TNS:could not resolve the connect identifier specified
Can someone let me know why this is happening.?
Thanx in advance.
This topic has been locked.
2 replies Latest Post - 2012-04-24T22:46:29Z by DanielWagemann
Pinned topic Impromptu Application Errror : The report request failed
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-24T22:46:29Z at 2012-04-24T22:46:29Z by DanielWagemann
Bobznkazoo 270004RF8B4 PostsACCEPTED ANSWER
Re: Impromptu Application Errror : The report request failed2012-04-05T01:04:34Z in response to mistrydHave 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:
DanielWagemann 2700058MAJ2 PostsACCEPTED ANSWER
Re: Impromptu Application Errror : The report request failed2012-04-24T22:46:29Z in response to mistrydThis 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