Discoverer4i Troubleshooting

Posted on July 26, 2007. Filed under: Discoverer |

Below are the errors which we had encountered post upgrade of 
Discoverer4i wherein the discoverer component doesn't startup. 
This post will be a running document, wherein it will be updated 
as and when we encounter a new issue and obviously a solution 
to that 🙂

First -> Make sure Jserv is up and running. 

Issue 1 
OAD Fatal Error in oad.log

$ORACLE_HOME/discwb4/util > vi oad.log
               "oad.log" 3 lines, 184 characters
               OAD: Fatal Error [Cross-device link].

Solution

Make sure VBROKER_ADM environment variable is set up 
correctly.


Issue 2

Unable to create repository file: 
$ORACLE_HOME/vbroker/adm/impl_dir/impl_rep. in oad.log

Solution

Add this line in $ORACLE_HOME/discwb4/discwb4.sh
            TMPDIR=/dchpgi/applmgr/product/806/discwb4/tmp 
            export TMPDIR


Issue 3

DISCOVERER VIEWER is not working.
Abstract: DISCOVERER VIEWER DOES NOT WORK WITH THE 
PARAMETER "SHOW_GRAPHS=TRUE" 

Solution

The file $IAS_ORACLE_HOME/Apache/Apache/htdocs/
disco4iv/html/disco4iv.html has to have the entry 
show_graphs="false" instead of show_graphs="true". 
This is the fix and the relevant bug is 2664219.


Issue 4

DISCOVERER VIEWER  Page is blank and also hanging for long time

Solution

Correct the entry for the TNS in discwb.sh to point to correct 
TNS_ADMIN value. 
echo $TNS_ADMIN can be used to get the value.
Bounce the apache and start the services.


Issue 5

INTERNAL SERVER ERROR on Viewer Page

Solution

Check these values
wrapper.classpath=$IAS_ORACLE_HOME/Apache/Apache/htdocs/
disco4iv/disco4iv.jar was added in  viewer4i.properties file  
before the translator.zip

It should be in two separate lines

wrapper.classpath=$IAS_ORACLE_HOME/Apache/Apache/htdocs/
disco4iv/disco4iv.jar
wrapper.classpath=$IAS_ORACLE_HOME/sqlj/lib/translator.zip


Issue 6

Unable to find the Locator.ior file. Error message in 
Discoverer viewer page

Solution

vi $IAS_ORACLE_HOME/Apache/Apache/htdocs/disco4iv/html/
disco4iv.xml
Locator name="Hostname.domainname_PortOracleDiscoverer
Locator4" 
path="$IAS_ORACLE_HOME/Apache/Apache/htdocs/discwb4/
applet/"/>

Modify the Alias (file or path) to the Real URL:

$IAS_ORACLE_HOME//Apache/Apache/htdocs/disco4iv/html/
disco4iv.xml
servlet.Viewer.code=oracle.discoiv.Disco4iv
servlet.Viewer.initArgs=config=file:$IAS_ORACLE_HOME/
Apache/Apache/htdocs/disco4iv/html/disco4iv.xml


Issue 7

Discoverer BIS report not working.

Solution

To resolve errors accessing Discoverer BIS report 
(login as SYSADMIN, on Selfservice application -> 
Disco BIS Report)
Add FND_DEBUG_DIR=$APPLCSF/tmp ; 
export FND_DEBUG_DIR in $ORACLE_HOME/discwb4/discwb.sh 
and bounce discoverer services.


Issue 8

Unable to start locator session while starting discoverer services

Solution

Go to $ORACLE_HOME/discwb4
Verify values in discwb4.sh
vi discwb4.sh
INSTANCE_NAME=Hostname.DomainName_Port
TMPDIR=$ORACLE_HOME/discwb4/tmp
Export TMPDIR
Save and exit the file
cd $VBROKER_ADM
pwd
$ORACLE_HOME/vbroker/adm
cd impl_dir
mv impl_rep impl_rep_bkp
mv impl_rep~ impl_rep~_bkp
Run Registerall.sh will create these new folders.
ls
README README.txt impl_rep impl_rep_bkp impl_rep~ 
impl_rep~_bkp


Issue 9

Unable to start Gatekeeper services

Solution

Go to $IAS_ORACLE_HOME/Apache/htdocs/discwb4/applet 
directory
Check exterior_port in 
$ORACLE_HOME/vbroker/bin/gatekeeper.properties and 
$APACHE_TOP/Apache/htdocs/discwb4/applet/
gatekeeper.properties
Check the gatekeeper.log file for errors like 
'unable to bind to port' or other errors.
Fix the error and restart the gatekeeper.



cheers,
OraclePitStop Team
Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: