Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Top 10 Common Errors

Posted by Venkatakrishnan J on October 18, 2007

Now that BI EE is gaining traction among a lot of users, i thought i would document a list of most common errors that users might encounter while using OBI EE. I will also be giving in the possible workarounds/solutions possible for these errors. Feel free to chip in with the error that you got and the solution which you used in the comments section.

1.   Failed to load the DLL D:\Oracle\OracleBI\server\Bin\nqsdbgatewayoci10g.dll. Check if ‘Oracle OCI 10G’ database client is installed.

         There can be many variations of the above error. But what this error essentially means is that BI Server is not able to identify the Oracle OCI drivers. So, first thing to check is whether you have installed Oracle client or database on the same machine as the BI Server. If you have these installed already but still getting this error, then if you are on windows check the Path variable. Check my blog entry here to know what your path should have. If you are Linux/Solaris check whether you have ORACLE_HOME, TNS_ADMIN, LD_LIBRARY_PATH properly set. For AIX, check whether ORACLE_HOME, TNS_ADMIN, LIBPATH are properly set. This should get you started and hopefully solve it. Of course there could be many other reasons, but the common reasons are that the environment variables are not properly set.

2.   Unable to start the BI Scheduler Service.

      For this one would have to go through a list of configuration steps. Scheduler is not configured by default since it requires a database to run the schedules on. Check my blog entry here.

3.   Unable to save an ibot. Errors out saying “Authentication Failed”.

      The most probable cause for this is that cryptotools utility was not run in the Scheduler configuration step. Check the 7th and 8th step of my blog entry here

4.   Errors while using Writeback option.

      a.   Template not found.

            This error occurs if the XML template that you have created is not identified by BI Server. Place the Templates in {OracleBI}/web/msgdb/custommessages folder.

      b.   Errors while doing the writeback.

            Check this forum entry here. Try all the options that are mentioned here. Always use OCI drivers for updating/inserting back to the database.

      For detailed step by step instructions, check my earlier blog entry here

5.   Unable to view the charts in BI EE.

      There can be a couple of reasons why this could happen. The display of charts depend on the Java Host service. Try starting that service. If it still does not work, then it could be so that you do not have a flash plugin installed. Check whether the other chart types like SVG, PNG are working. To set up SVG or PNG charts use my blog entry here

6.   Unable to start/stop the BI Server/Presentation Services/ Java host.

      If you are unable to stop/start the services, try starting them from command line. Use the following commands to start/stop the services from command line.

      net start/stop “Oracle BI Server” – For BI Server
      net start/stop “sawsvc” – For presentation Services
      net start/stop “sawjavahostsvc” – For Java Host
      net start/stop “Oracle BI Scheduler” – For scheduler

7.   While setting up external authentication, one might get error messages like init block not initialized.

      One of the possible reasons, if you think everything has been properly setup, is the overlap of users between the repository and the external directory. Remove the overlapping users from the RPD and test it out. For more info on how to setup LDAP/OID authentication check my blog entry here and here

8.   While using Evaluate function, common errors like “Union of non-compatible types. (HY000)”.

      I believe this is a bug in the Evaluate function implementation. One must cast all the arguments to the same data type before passing them as arguments.

9.   Unable to create a new style by following the documentation.

      Again, you have not done anything wrong. I believe there is a documentation bug on this. Check my blog entries here and here

10.   Unable to view/change the images in Answers Title view using FMAP.

      This is again a common problem due to a documentation bug. Try using my blog entry here. One would have to copy the images to 2 folders instead on 1 as given in the documentation.

There could be many other reasons why you might get these errors. But the above list would give you an idea of where to start looking if you are new to OBI EE. Feel free to share your thoughts here.

Advertisements

33 Responses to “Oracle BI EE 10.1.3.3/2 – Top 10 Common Errors”

  1. Rajeev said

    I have a Fact table that has about 50 fact columns. I want to group them into separate folders in the Presentation Layer. Does anybody know how to do in the Admin Tool / Answers.

  2. Shan said

    Please define the steps to create a new repository…i have created new repository but now BI server service could not be started,even i have made entries in incetanceconfig and CQNFConfiguation files. But still this service is not started,any idea ?

  3. Chan Leong Ng said

    Rajev,
    You would use ‘->’ (without the quotes and actual description text can follow after the >) in the Presentation Table folder description for the child folders. The parent folders should not have ‘->’ in the description.

  4. Wic said

    Why can´t I see anything in Answers after clearing cache?

  5. Choudhury said

    Hi
    We are getting TNS Timed out error while trying to start the scheduler services.
    Please let me know how to make this work..
    thanks,
    Babu.

  6. FKNOZTURK said

    Hi
    Why the charts cant view. Flash or the other one.

  7. Sergey said

    Hi
    I have a Request (Rep1) using Union (Combine with Similar Request). When i use a Value interaction (Navigate) in my Rep1, then values don’t sending to Filter of Navigation target. Does anybody know how send these values to target report?

  8. Sergey said

    And i using in my request Pivot Table. Values send without Pivot table.

  9. Edward Eloian said

    I cannot start obiee presentation service. I get this:

    C:\>net start sawsvc
    The Oracle BI Presentation Server service is starting.
    The Oracle BI Presentation Server service could not be started.

    A service specific error occurred: 4294967295.

    More help is available by typing NET HELPMSG 3547.

  10. Raviben said

    Hi ,

    I am trying to import tables from ORMS. I was just importing around 10 tables it’s taking ages to be exact about 3 1/2 hrs. Could anyone let me know which is a musch faster way to import tables into physical layers.

    Thanks in Advance.
    Raviben

  11. john said

    Cannot start BIpublisher from analytics dashboards.When clicked on from more products,BIPublisher hangs.Any help

  12. Dan Sielicki said

    10) Use Import Connection Type OCI 10g/11g (this is a type 1 data access driver)

  13. Ashok said

    I tried to start Oracle BI server, even through command line you have specified. But still I am not able to start Oracle BI server. May i know why? Can anyone find me a solution?

  14. Prakash said

    I am getting the following error while startin Oracle BI presentation service.

    —————————————
    Type: Error
    Severity: 20
    Time: Mon Mar 17 21:44:13 2008
    File: project/sawserver/winmain.cpp Line: 74
    Properties: ThreadID-4744
    Location:
    saw.sawserver.initializesawserver
    saw.sawserver

    Error loading security privilege /system/privs/catalog/ChangePermissionsPrivileg
    e.
    —————————————

  15. Paul said

    I cannot get the BI Presentation Service to start either, I have tried shutting everything down manually and then starting each component up one at a time…. Same result…. Is there another error log I should be looking in for a more specific error message??? Where would I look???

    I get the following error in the Windows Event Log:

    Log Name: System
    Source: Service Control Manager
    Date: 5/2/2008 3:38:00 PM
    Event ID: 7024
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: AGITM07
    Description:
    The Oracle BI Presentation Server service terminated with service-specific error 4294967295 (0xFFFFFFFF).

  16. Rachna D said

    hi
    I am getting the following error while using the write back

    An error occurred while writing to the server. Please check to make sure you have entered appropriate values.
    Error detail
    The execute physical statement must specify a physical SQL statement to execute.

    please suggest me what to do

    Thanks
    Rachna

  17. suresh said

    Description:Oracle BI Presentation Server service terminated with service-specific error 4294967295

    Reason:
    please check the tags are closed properly in
    instanceConfig.xml(C:\OracleBIData\web\config\instanceconfig.xml) and the path you have provided for your catalog is correct.

  18. Shweta said

    I Need help while working in OBI
    I am getting below error it has come at the time of checking the connectivity using the “update all row counts”.

    unable to connect to database using connection pool but at the time of testing connections its successful

    Could you please suggect me how to make the failed connections.

    Thanks ….

  19. ashish said

    C:\Documents and Settings\284403>net start sawsvc
    The Oracle BI Presentation Server service is starting.
    The Oracle BI Presentation Server service could not be started.

    A service specific error occurred: 4294967295.

    More help is available by typing NET HELPMSG 3547.

  20. sridev said

    i got error like that…
    pls give the solution for that (its in scheduler based error)
    Oracle BI Scheduler Error: [nQSError: 12008] Unable to connect to port 9705 on machine INCDB006. [nQSError: 12010] Communication error connecting to remote end point: address = INCDB006; port = 9705. [nQSError: 12002] Socket communication error at call=: (Number=-1) Unknown

    Error 1064:An exception occured in the service when handling the
    control request

  21. Ramesh Chanda said

    I have got one strange error while loading the reports in word BI Publisher. Error it says is :

    Error Occured please check the settings and try again.

    This error coming for me because I have created the reports by using the Firefox browser, which is giving the issue in loading this reoprt in word with BIP. It works fine when I create the same report in IE brower. User my mail id for further communication.

  22. malleshn said

    Hi Venkat,

    For the issue Unable to save an ibot. Errors out saying “Authentication Failed” there is one more reason is there. I tried and tested this, when the Cryptotools is run on Solaris server the password is not getting encrypted properly and so, the issue is still happening after running the cryptotools. So we need to run the cryptotools on a Windows server and move the file to the solaris environment. Everybody is making use of your blogs, so thought it would help others if you update once you test it on your own.

    Thanks
    Mallesh

  23. Edward Eloian said

    UNCLASSIFIED////

    Hey,

    How are you. I am having trouble getting the OBIEE scheduler service to
    startup. When I try I get the 1064 error. Specifically, it says:

    “Could not start Oracle BI Scheduler service on local computer.

    Error 1064: An exception occurred in the service when handling the
    control request”.

    Thanks for any help you can give me.

    If you reply can you send it to eeloian2002@yahoo.com

    Edward M. Eloian
    USAAC
    Consultant
    502-626-2396
    UNCLASSIFIED////

  24. venkatesh said

    I had trouble in Starting OBI Scheduler, i got the same Error 1064: An exception occurred in the service when handling the
    control request”.

    I made a mistake in giving the Data Source Name while Configuring the Scheduler, i gave the Data Source Name as the exact Data Source Name,later on i figured out that, it should be the TNS Service name of the ODBC driver not the exact name of Data Source Name.

    Changing the Data Source Name in Scheduler Configuration solved my problem, i hope it will work out for you too

  25. Prakash said

    Hi Venkatesh,

    You said that you made a mistake in giving the Data Source Name while Configuring the Scheduler, i gave the Data Source Name as the exact Data Source Name,later on i figured out that, it should be the TNS Service name of the ODBC driver not the exact name of Data Source Name.

    Can you please explain in detail how this DSN has to be created as I am facing the same problem.

    Thanks in advance

  26. Prakash said

    Sorry ..I will expalin my problem in detail as the above message is confusing.

    I have an instance orcl and I created a schema ibot under which I created the 4 tables which are required for scheduler. Now how to create a DSN. I should select the ODBC driver??

  27. Sitesh said

    hi prakash,
    the database which u r using select that one only.for example if i am using Sql Server i will select Sql Server only.Please let me know if u have some problems…
    thanks
    sitesh

  28. dakshayani said

    Hi Venkat,

    Presentation services are not starting, when i try to start it from command line, also the i get error something like this: C:\Documents and Settings>net start sawsvc
    The Oracle BI Presentation Server service is starting.
    The Oracle BI Presentation Server service could not be started.

    A service specific error occurred: 4294967295.

    More help is available by typing NET HELPMSG 3547.

    I have checked the sawlog0.log file in D:\OracleBIData\web\log and noted the error with the most recent error, it is like this: Type: Error
    Severity: 30
    Time: Wed Feb 04 11:38:21 2009
    File: project/webcomm/rpcserver.cpp Line: 145
    Properties:
    Location:
    saw.unknown

    Assertion failure: m_pImpl != 0 at line 145 of ./project/webcomm/rpcserver.cpp

    Plse suggest how to solve this,

    thanks in advance

    dakshayani

  29. Roni Vered said

    Hello,

    I encountered the error mentioned in this post (#1):
    Failed to load the DLL D:\Oracle\OracleBI\server\Bin\nqsdbgatewayoci10g.dll. Check if ‘Oracle OCI 10G’ database client is installed

    I have OBIEE installed over Windows 2003 64bit.
    My Oracle Database (64bit)is installed on the same machine.

    I’m getting the error above in the Admin tool, while trying to import objects from the database.

    In order to solve the issue, I downloaded the InstantClient for 32bit , that contains all the relevant OCI DLLs.

    I added the directory of those OCI DLLs to the path variable, opened the Admin tool, and the error vanished!

    This time it wansn’t a path issue, but the actual OCI drivers that were missing.

    Anyway, you site helped me with other BI issues, thank you for you blog, it is very helpful!

    Roni.

  30. Srinath Rao said

    Guys,

    NEVER EVER develop the reports or Save the existing report in GOOGLE CHROME.

    The reports once saved you can NOT open in WORD for editing the RTF. Uffff!!!!!

    Error Occured please check the settings and try again.

    I am sitting and redeveloping all!!!!

    Srinath Rao

  31. Amazing!!! I found this site on google poking around for something completely unrelated- and now I’m gonna have to go back and go through all the archives 🙂 So much for spare time today, but this was a truly great find.

  32. Osama said

    Again : Error Occured please check the settings and try again.

    I developed it using IE 8 but this error appears when try to open the report at MS Word 2007

    problem solved when I removed the parameters from report but I still Ignorant why.

    I read at some place that the reason may be that report returns too much data, I fixed the query to fetch few records but MS Word still give me the same error !

  33. Sandeepa said

    All the required service is started but still while am trying to execute the answers in the browser its not opening showing that page is not found. I have changed in NQSconfig this
    Star = paint.rpd, DEFAULT;
    SH = SH.rpd
    As my repository name is SH.

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

 
%d bloggers like this: