Saturday, September 24, 2011

For the followers

Hello All,

Thanks for following my blog. I would like to say that i'm not going to post any more items in this blog. You can follow my latest blog obiapps4u.blogspot.com for all the useful information about OBI Apps. Please note that this new blog is not limited to OBIEE alone. I will combine Informatica, DAC and OBIEE tips together in this new blog. Thanks for the understanding and hope to see you there !!!!

Cheers,
Siva

Monday, February 14, 2011

OBIEE Services Problem in Windows

Hello All,

Have you ever faced problems with OBIEE services in windows like BI Server not starting up or Presentation Server not starting up?? If yes, this post is for you....!!

Basically, we all will use services.msc to go to windows services and try to start the OBIEE services from there. If any service fails to start, then there would just be a dialogue box simply saying "Service failed to start"!!!???. We really don't know why as there is no proper description for the cause of the failure. So, now is there a better way of starting the OBIEE services on windows which will give you the exact error which is causing the start up failure ?? Continue reading the below to know..!!

When you install OBIEE on your windows machine, all the services that needs to start in order to work in OBIEE will get installed in the installation directory as given below.

BI Server: C:\OracleBI\server\Bin\NQSServer.exe
BI Presentation Server: C:\OracleBI\web\bin\sawserver.exe
BI Java Host: C:\OracleBI\web\bin\sawjavahostsvc.exe
BI Scheduler: C:\OracleBI\server\Bin\NQScheduler.exe
BI Cluster Controller: C:\OracleBI\server\Bin\NQSClusterController.exe

When you have problem in starting any of these services, just go to command prompt and switch to the directory of the service for which you are facing the problem. For example if the BI Presentation Server is not starting up, then go to command prompt and follow the steps below.

cd c:\OracleBI\web\bin

then type sawserver.exe

This will give you the exact log of what OBIEE is trying to do in the command prompt. And you should be able to trouble shoot the problem. Follow the same process for any of the services in which you are facing an issue.

Hope this helps...!!

Siva