Stephen Weblog

Had a chance to do a disco installation on Linux. Had a strange issue when I login to Oracle Applications via disco it said invalid user name and password. Cannot connect to database, all i know is disco uses the .dbc file for connection.. I did copy the .dbc file from apps tier to disco tier, but the file name was in uppercase. Don’t know for what reason I changed the file name to lowercase it started working…

Copy apps dbc file to disco tier under location: $ORACLE_HOME/discoverer/secure/

We had a strange situation where registration of BI+ was failing with HSS. When I go through the config log we see this error

(Mar 11, 2009, 03:10:14 AM), com.hyperion.cis.config.wizard.RunAllTasksWizardAction, ERROR, Error:
java.lang.Exception: Adding following Apps to Project failed : ‘0000011fea328b9c-0001-0f17-8c55fe6b.HAVA;’.
at com.hyperion.cis.config.CmsRegistrationUtil.registerApplication(CmsRegistrationUtil.java:222)
at com.hyperion.cis.config.wizard.RunAllTasksWizardAction.executeHubRegistrationTask
(RunAllTasksWizardAction.java:360)
at com.hyperion.cis.config.wizard.RunAllTasksWizardAction.execute
(RunAllTasksWizardAction.java:165)
at com.installshield.wizard.RunnableWizardBeanContext.run(Unknown Source)

To resolve this issue, we need to perform the following:

1. Delete the Hyperion System BIPlus project from Shared Services.
2. Invoke the config utility and register BI Plus with SharedServices.

Now you will see BI+ getting registred to HSS properly, but when you invoke the project we got this error.

Module not found : cds.mode

3. To fix this issue we need to bounce Workspace alone.

When we try to start WebAnalysis, it will in turn check for Workspace and we might hit this issue and by which webanalysis url will not come up.

Log from the WebAnalysis.log file
——————————————–

[WARN] Timer-6 com.hyperion.analyzer.utils.general.HYAUtil - .
[ERROR] Timer-6 com.hyperion.analyzer.utils.general.HYAUtil - isWorkspaceUp:exception: Connection refused: connect
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:507)
at java.net.Socket.connect(Socket.java:457)
at java.net.Socket.<init>(Socket.java:365)
at java.net.Socket.<init>(Socket.java:238)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(Unknown Source)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(Unknown Source)
at org.apache.commons.httpclient.HttpConnection.open(Unknown Source)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(Unknown Source)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(Unknown Source)
at org.apache.commons.httpclient.HttpClient.executeMethod(Unknown Source)
at org.apache.commons.httpclient.HttpClient.executeMethod(Unknown Source)
at com.hyperion.analyzer.utils.general.HYAUtil.isWorkspaceUp(Unknown Source)
at com.hyperion.analyzer.utils.general.f.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
[WARN] Timer-6 com.hyperion.analyzer.utils.general.HYAUtil - .

Fix
—-
Check the %BIPLUS_HOME%/InstallableApps/config/WebAnalysis.properties file and check the value for field ConfigURL. It should be holding the appropriate port on this tag. Normally we will hit this issue when we configure Virtual URL for your BI+ components. Once you change the setting recycle WebAnalysis alone to reflect the changes.

Had spent couple of days in trying to launch planing business rule from EAS but was never able to until I figure out the actual cause.

Issue
——-
-Login to EAS
-Business Rules -> Repository View -> BusinessRule1 (Right Click and select Validate)
-Click on browse button and select Planning. Here planning server details are not listed.

Fix
—
We need to verify few things to make this work, firstly check in which port RMI registry is configured. To check this view the file

%HYPERION_HOME%\common\RMI\1.0.0\HyperionRMI_Port.properties

Also check whether port is running using the netstat -an command

netstat -an | grep 11333

C:\Documents and Settings\test>netstat -an | grep 11333
TCP    0.0.0.0:11333          0.0.0.0:0              LISTENING
TCP    140.85.254.105:2029    140.85.254.105:11333   TIME_WAIT
TCP    140.85.254.105:2072    140.85.254.105:11333   TIME_WAIT

Secondly, login to hyperion planning url and navigate as below

Administration -> Manage Properties -> System Properties
and set the PLANNING_RMI_PORT value, in my case its 10733

Thirdly,if you come across this error in the hyperion planning opmn log run the below mentioned alter table command.

Receiving error Query Failed: SQL_SYSDB_DELETE_EXPIRED_EXTERNAL_ACTIONS:[100]
java.sql.SQLException: [Hyperion][Oracle JDBC Driver][Oracle]ORA-00932: inconsistent datatypes: expected INTERVAL DAY TO SECOND got NUMBER

The HSP_ACTION table has an ACTION_TIME field that should be of type DATE but it was set to TIMESTAMP.

SQL> desc  hsp_action;
Name                                      Null?    Type
—————————————– ——– —————————-
ID                                        NOT NULL NUMBER(38)
FROM_ID                                            NUMBER(38)
TO_ID                                              NUMBER(38)
ACTION_ID                                          NUMBER(38)
OBJECT_TYPE                                        NUMBER(38)
PRIMARY_KEY                                        VARCHAR2(255)
MESSAGE                                            VARCHAR2(254)
ACTION_TIME                                        TIMESTAMP(6)

SQL> ALTER TABLE HSP_ACTION MODIFY ACTION_TIME DATE;

Table altered.

SQL> desc  hsp_action;
Name                                      Null?    Type
—————————————– ——– —————————-
ID                                        NOT NULL NUMBER(38)
FROM_ID                                            NUMBER(38)
TO_ID                                              NUMBER(38)
ACTION_ID                                          NUMBER(38)
OBJECT_TYPE                                        NUMBER(38)
PRIMARY_KEY                                        VARCHAR2(255)
MESSAGE                                            VARCHAR2(254)
ACTION_TIME                                        DATE

SQL>

Recycle the RMI services and Hyperion Planning oc4j instance.