Wednesday Apr 18, 2012

REP-0178 - "Reports Server cannot establish connection" Error Message

During this last week I saw an interesting thread in Oracle Forums about this error message, and wanted to share the findings that I got to answer in the forum thread:
REP-0178: Reports Server [server_name] cannot establish connection


This problem may occur when a wrong rwclient is picked. Perhaps the environment is not set appropriately before rwclient is called or the rwclient.bat/rwclient.sh in /bin is found and used, but it is only a template that upon install allowed to create the valid rwclient.bat/rwclient.sh in the /config/reports/bin (in fact when the instance was actually configured).

So you can try using the appropriate rwclient.bat/rwclient.sh as it calls rwclient.exe/rwclient after setting the environment. Either set in the PATH the directory /config/reports/bin before /bin or specify the full path to rwclient.bat/rwclient.sh.


Another possibility can be that the services were started as root and therefore some log files have been created with the user root. Hence there is no more write access to theses log files for the basic Oracle user (which is the owner of the installation):
$INSTANCE_HOME/diagnostics/logs/OHS/ohs1/access_log
$INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/runtime_diagnostic.log
$INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/zrclient_diagnostic.log

If that's the case, then try to change the owner of the following log files to ORACLE user (which is the owner of the installation):
$INSTANCE_HOME/diagnostics/logs/OHS/ohs1/access_log
$INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/runtime_diagnostic.log
$INSTANCE_HOME/diagnostics/logs/ReportsToolsComponent/ReportsTools/zrclient_diagnostic.log
And then restart the report server and run again the rwclient.sh command to generate the reports.
About


Principal Technical Support Engineer in the Exalogic Enterprise Support Team (EEST).

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today