OBI Publisher with empty OBI catalog

yesterday we installed OBI publisher in our development environment and today i was troubleshooting issue with config, integrating it with presentation service.
here is scenario:
1. creating report using BI answers as data source.
2. select the report you want to use. it gives empty BI Catqalog message.
on analysis, we found that it's calling saw_popup.jsp. for troubleshooting, we introduced few out.print statement. This inturn gave following error:
Bad envelop tag: HTML. this clearly indicates that it's related SSO.

siteminder is not supported by Oracle for marketing Integration. we suspected that it could be the same issue here as well. so we created a virtual path analytics_r which is unprotected by siteminder. at the same, it has access only to web, app server of analytics.

after making these changes, OBI worked fine.

Please note: virtual path unprotected in siteminder is case sensitive.

Issues - runing DAC/OC4j as windows service

i found some issues with DaC windows service. for some reason, it's not reading customsql folder.
i will update you when it's fixed

runing DAC/OC4j as windows service

To install DAC server as a service, you need javaservice.exe. this is open source and you can down load from http://forge.ow2.org/projects/javaservice/. the latest version is 1.0.10.
after file download , extract it run the javaservice.exe from that folder.
now, create a batch file(dacservice.bat) with following content under oraclebi\dac


call config.bat
javaservice -install "Oracle BI DAC Server Service" "\jre\bin\client\jvm.dll" -Xms256m -Xmx1024m "-Djava.class.path=%DAC_CLASSPATH%"
"-Duser.dir=%DAC_HOME%"
-start com.siebel.etl.net.QServer -description "Oracle BI DAC Server Service"

--- config.bat consists of all the config setting for startserver.bat. we are just re-using it.

- prior to this i was running it under windows scheduled task.

let me know if you face any issues in installing

---
for oc4j, first ensure that bi publisher is installed.
javaservice -install "Oracle BI OC4J Service" "\bin\client\jvm.dll" -XX:MaxPermSize=128m "-Djava.class.path=\oc4j_bi\j2ee\home\oc4j.jar" -start oracle.oc4j.loader.boot.BootStrap -params -description "Oracle BI Publisher Server"

happy week end

how to create COB/stand by repository for Informatica

In most of the corporates have Disater recovery or failover environments.
Practically,in Informatica 8.1 you can create only 1 domain per DB. For Disater Recovery, you may require to use same DB by informatica application in different server/ you will be using differnt db all together.

The very problem comes when you go for installation.

What we did..
for Stand by application, we installed it by pointing to dev db with same Domain name , node name, port as in live server.

after installation, we updated the repository so that it's pointing live informatica repository DB.

If you want to use the informatica application permanently by retiring the live server, then, you can update the hostname of 'PCSF%' and OPB_Reposit tables.

if you want to use it as stand by then update the hosts file with live server name and ip address of stand by server

obiee presentation service in hanging state - troubleshoot

After starting obeii service it was hanging and never went to started state. On Analysis nothing notable found in SAWlog.log. On futher digging found following message in the event viewer..
" The description for Event ID[21] in source[oracle BI Utility ] cannot be found. The local computer may not have the neccessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event . Invalid error message catalog d:\Apps\OracleBI\server\Locale\NQErrorMsg.cat"

Troubleshooting : NQErrorMsg.cat is in corrupted state(instead of NQErrorMsg found NQErrorMsg_L_en.cat). Replace the files from install setup.

SBL-EAI-04308: Operation 'logon' of Webservice 'com.siebel.analytics.web/soap/v1.SAWSessionService'

Whe i try to add a new segment by pick segment, i get follwing error message

SBL-EAI-04308: Operation 'logon' of Webservice 'com.siebel.analytics.web/soap/v1.SAWSessionService' at port 'SAWSessionServiceSoap' failed with the following explanation : "***kmsgSoapNotLicensed: message text not found ***".

please check ‘analyticsweblicnese.xml’ file,
and add SOAP license. once it's done try adding a new the Segment.

Unable to open Admin tool in OBIEE / siebal analytics

I am unable to open Admin tool in OBIEE/ siebel analytics
- check the NQSConfig
- check with nqsconfig which came along with installation
- if it works fine with original config file, then the problem should be with your NQSConfig.
- in such scenarios, even your OBI server service won't start.

Failed to open SMTP server

Failed to open SMTP server.
- ping the smtp server and see if ping is successful.
- You will also get this error if the smtp server recently configured. Meaning the configuration is wrong.
- select the oproperty of the smtp server and check if the ip address is perfect.

DAC Client using pmrep and pmcmd

How to Verify that the DAC Client is able to use pmrep and pmcmd
From a Windows command prompt, execute pmrep and then pmcmd. The test is
successful if the pmrep and pmcmd prompts appear.
If pmrep and pmcmd are not recognized, then:
■ Ensure Service Pack 4 has been applied to Informatica PowerCenter 8.1.1.
■ Verify that the INFA_DOMAINS_FILE variable points to the domains.infa file
located in the Informatica directory.
■ Verify that the PATH variable includes the path to the Informatica binaries
(\Informatica\PowerCenter\client\bin), and that pmrep.exe and pmcmd.exe
exist in the \bin folder.

Error when selecting Shared folder for creating segment

When I select the shared folder for creating segment, I am getting
following error
Getsubitems unable retrieve values

- this related timeout. Try to refresh / check for performance of
website.