Business Intelligence - Oracle

Oracle BI EE 10.1.3.3 - Configuring Delivers - iBots

Posted by Venkatakrishnan J on September 13, 2007

I had one OBI EE user today who had specifically asked about configuring iBots. Though it is pretty straight forward, the customer was looking out for a screenshot by screenshot tutorial on how to go about setting delivers. Well, i had some time to put this one together. Hopefully, you would find it of some use.

1.   The first step is to configure a schema that would hold all our scheduler tables. If you do not have a schema create or use an existing one. In my case i have a schema called S_NQ_SCHED wherein i would create all my scheduler tables.

2.   Navigate to your {ORACLEBI}/Server/Schema folder and run the scheduler scripts. If you are on an Oracle Database, you would have to run SAJOBS.Oracle.sql. This would basically create the scheduler tables that Oracle Delivers would use later.

3.   The next step is to open your Job Manager. Go to File - > Configuration Options and enter the schema and connection details for the scheduler schema. In my case it would be S_NQ_SCHED schema.

      

4.   Go to the General tab. If you had followed the default install, then leave everything the same. Just enter in the Administrator usernames and passwords.

   

5.   Go to the Mail tab and enter in your mail server details.

      

6.   Open your instanceconfig.xml and add in the scheduler details. This step basically lets the presentation server know about the machine and port details of the scheduler. By default the scheduler port is 9705.

      

7.   The next step is to run a cryptotools utility that would basically store the username and password of the scheduler into an XML file called credentialstore.xml.

8.   Go to {OracleBI}/web/bin from command prompt. Then enter in the following command.

cryptotools credstore -add -infile OracleBIData_HOME/web/config/credentialstore.xml

   

Ensure that you have the alias as “Admin”.

9.   The next step is to add the details of this credentialstore.xml file into the instanceconfig.xml.

   

Once this is done you should be able to schedule and create new ibots. The best and quick way to check whether the configuration has been done properly is to save a sample ibot. If you are able to properly save one then your configuration has been properly set. For more details refer the docs here.

45 Responses to “Oracle BI EE 10.1.3.3 - Configuring Delivers - iBots”

  1. SA Says:

    Hi Venkat, Thanks for publishing this. I tried the same thing. I have done a default install and I did not change any passwords. I restarted the Oracle BI Scheduler service after executing the steps listed. Still I am getting authentication failed error messsage. I used default user name “Administrator” and default password “Administrator”

    Thanks,
    SA

  2. Venkatakrishnan J Says:

    I believe you have not run the 7th step. You have to run the cryptotools so that presentation services would know which scheduler to use.

  3. vikas Says:

    Hi Venkat

    I have followed all the steps posted by you. but still when i am not able to save a simple ibot. getting the error:

    Oracle BI Scheduler Error: [nQSError: 12008] Unable to connect to port 9705 on machine DAMCO-ORACLE. [nQSError: 12010] Communication error connecting to remote end point: address = DAMCO-ORACLE; port = 9705. [nQSError: 12002] Socket communication error at call=: (Number=-1) ???
    Error Details
    Error Codes: GYFPI8RN

    Please Help

  4. Venkatakrishnan J Says:

    Vikas,

    Did you start your Scheduler Service? Did it start? Looks like there is nothing running on port 9705 which is the default scheduler port. You need to start the scheduler service.

    Venkat

  5. Vikas Says:

    Venkat,

    Thanks for reply.

    I have installed OBIEE on Windows 2003 Server. Scheduler service is not starting. When i starts the service through command prompt it does not show any message, but when i shutdown the Bi scheduler service it is giving the ERROR:

    D:\ORACLEBI\SERVER\BIN>NQscheduler.exe

    D:\ORACLEBI\SERVER\BIN>schshutdown.exe
    Missing required argument(s): -s, -u, or -p
    SCHSHUTDOWN.exe -s -u -p [-l [-c -k -q | -w | -y ] [-h ] -v [
    -e ] [-d ][-f ][-t <SSL Trusted Peer DNs ]]

    —————ERROR(s)—————
    [nQSError: 12008] Unable to connect to port 9705 on machine localhost.
    [nQSError: 12010] Communication error connecting to remote end point: address =
    localhost; port = 9705.
    [nQSError: 12002] Socket communication error at call=: (Number=-1) ???

    When i tried to start the service from service menu it gave the error:

    Could not start the Oracle BI Scheduler Service on local computer.
    Error:1064: An Exception occurred in the service when handling the control request

    All other services are running fine and i am able create dashboards and all. I also followed all the steps above.

    Please Help
    Please Help

  6. Vikas Says:

    Hi venkat, i am able to solve this error, and the BI Scheduler service is started now.

    Thanks
    Vikas

  7. Oracle BI EE 10.1.3.3/2 - Top 10 Common Errors « Business Intelligence - Oracle Says:

    [...] Posts Customizing OBI EE - SOAP APIOracle BI EE 10.1.3.3/2 - Write Back Option - Budgeting/PlanningOracle BI EE 10.1.3.3 - Configuring Delivers - iBotsOracle BI EE 10.1.3.3/2 - Understanding Dates in AnswersCustomizing OBI EE – GO URL [...]

  8. sathish Says:

    hi venkat..
    i am unable to run an i bot ..
    getting the error
    +++ ThreadID: 748 : 2007-10-24 16:57:27.562
    Global Error: [nQSError: 77030] Oracle BI Presentation Server Connection Error: An error occurred during execution of “recv”. An unknown error occurred in the sockets library. [Socket:968]
    Error Codes: ETI2U8FA

  9. Robb Says:

    We are getting -

    Oracle BI Scheduler Error: [nQSError: 68019] Authentication Failed.
    Error Details
    Error Codes: GYFPI8RN

    We use Administrator with password (defined as the Administrator in the RPD and is included in the administrator groups in both the RPD and the presentation server) - I have created Adminstrator using the cryptotools and have pointed the instanceconfig.xml at the credentialstore.xml - we’ve restarted the services…

    Any ideas?

  10. Venkatakrishnan J Says:

    Check the Presentation Services URL under Job Manager->Configuration Options->ibots. What is the URL that you have there. If you have done a default install it should be localhost:9710. Also, restart your scheduler after making any modifications to the Job Configuration Options.

  11. Rajeev Says:

    Vikas,

    Can you pls tell us how did you resolve your error? We are encountering the same issue that you did with the Scheduler.

    Thanks
    Rajeev

  12. Vikas Says:

    Rajeev,

    just check the log file under folder d:\oraclebi\server\log\NQScheduler.log. this will tell u ab’t ur exact error. Most probable the reason is that u r not able to start BI Scheduler Services.
    Check the DSN created, whether u r able to connect to the database where u ran the scripts to generate the Scheduler tables.one more thing try to use Oracle Database 10g cleint Driver instead of Microsoft for ODBC driver. This is the place where ur problem resides.

    Thanks
    Vikas

  13. Rajeev Says:

    Thanks Vikas for your reply.i figured out the problem, the SQL SERVER Microsoft DSN that i was using on Windows for the DB that had the scheduler tables was considering another Database on the same SQL Server as default and hence the scheduler was not getting started. I changed the default DB name and it worked. But now i have a new challenge.I need to now setup the scheduler on a Linux box on whicj schconfig ( scheduler config file) does not provide an option for SQL Server as the database.

    Has anybody configured Scheduler from a Linux Box ( OBIEE install on Linux) with the scheduler tables in a SQL server?

  14. Sunil Epari Says:

    We are getting the following error.. (Sorry for the Long Error message.. just wanted to provide the details)
    Status:
    This is Fusion Financials. OBIEE Authentication is through a SESSION COOKIE.
    As far as the scheduler is concerned, I am able to start the Scheduler. Can save and run ibots using Run As “Administrator”, but not as the users from Oracle Financials.

    Appreciate if anybody has seen similar issues can comment on this.

    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
    +++ ThreadID: 14c9ba0 : 2007-10-30 09:23:47.000 [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Authentication Failure. Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC Odbc driver returned an error (SQLDriverConnectW). State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused. [nQSError: 43001] Authentication failed for IYCHEN in repository Star: invalid user/password. (08004) Error Codes: . Error Codes: AGEGTYVF +++ ThreadID: 14c9ba0 : 2007-10-30 09:23:47.000 iBotID: /users/iychen/_ibots/test7 …Trying iBot Get Response Content loop again. +++ ThreadID: 14c9ba0 : 2007-10-30 09:23:47.000 … Sleeping for 8 seconds. +++ ThreadID: 14c9ba0 : 2007-10-30 09:23:55.000 [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Authentication Failure. Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC Odbc driver returned an error (SQLDriverConnectW). State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused. [nQSError: 43001] Authentication failed for IYCHEN in repository Star: invalid user/password. (08004) Error Codes: . Error Codes: AGEGTYVF +++ ThreadID: 14c9ba0 : 2007-10-30 09:23:55.000 iBotID: /users/iychen/_ibots/test7 …
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

    Thanks
    Sunil

  15. Daan Bakboord Says:

    How To — Invoke the Scheduler Configuration Utility from Linux/Unix

    Go to {OracleBI}

    run –> . setup/common.sh

    run –> export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:{OracleBI}/server/Bin

    Go to {OracleBI}/server/Bin

    run ./schconfig

  16. Madhav Says:

    Venkat,

    Thanks a lot for this article. I am trying to set up the Scheduler and followed all the steps you mentioned but when I try to start the Scheduler service it gives me this error : “Could not start the Oracle BI Scheduler service on Local Computer. Error 1064: An exception occured in the service when handling the control request.” Could you help me with this?
    Thanks.

  17. Vinayak Says:

    Hi Venkat,

    I have implemented all the steps you have mentioned above. Still I am unable to create an iBot. I am getting the following error:
    “Oracle BI Scheduler Error: [nQSError: 68019] Authentication Failed”.

    Error Codes: GYFPI8RN

    I also checked the logs and there are no error messages there. Please help …

    -Vinayak

  18. Sunil Epari Says:

    Just an update for everybody’s benefit on a question I have posted on Oct 30.

    Delivers cannot be configured if we use OBIEE Fusion Intelligence. Although the Oracle Development Team is still trying to figure this out as per the SR I have raised.

    Thanks
    Sunil Epari

  19. vini Says:

    I have done all of steps above..
    But I still cannot start the scheduler services on my pc..
    For your information, i’ve installed my obiee on windows XP..
    Can you give me the whole steps to start the scheduler services?
    -Thanks-

  20. Choudhury Says:

    hi
    we are getting ‘TNS Timed Out’ error when trying to start the scheduler services.
    Please advice me how to handle this.
    thanks,
    babu.

  21. Brijesh Says:

    Hi Venkat,

    I have successfully configured scheduler following the steps given by you.

    Now,the problem is when I create an ibot on Answers it works but when I try to schedule a report on BI publisher it throws error with the message “Error Code: 942 Call:UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + 1 WHERE SEQ_NAME = ‘SUBSCRIPTION_ID_SEQ’ Query:DataModifyQuery()”.

    I have also configured SMTP server on BI publisher as well on Admin tab but all in vain.

    -Brijesh

  22. pradeep Says:

    I have presntation services on one machine and server on the other. I ran the cryptotools utility and added the schedulername tag in the instanceconfig.xml too.. But still i get the following error.

    Oracle BI Presentation Server Connection Error: An error occurred during execution of “connect”. No connection could be made because the target machine actively refused it.

    Any Ideas

  23. sree Says:

    Hi,
    I am using Sybase as a backend. In the specified path i did not find any Scheduler Scrips for Sybase. How can i over come this issue.

    Can any body advise

    Sree

  24. Esther Says:

    Hi venkat,

    Followed the steps to configure scheduler… Everything went well; but when I tried creating an iBot I got the error below:

    Oracle BI Scheduler Error: [nQSError: 68019] Authentication Failed”.
    Error Codes: GYFPI8RN

    Checked the NQScheduler.log and I noticed an entry like the one below:
    [nQSError: 12002] Socket communication error at call=recv: (Number=10004) A blocking operation was interrupted by a call to WSACancelBlockingCall.

    Any help with this is highly appreciated!
    -Esther

  25. Venkatakrishnan J Says:

    I believe you have not run the cryptotools utility. Check the 7th and 8th steps above.

  26. Esther Says:

    Hi Venkat,

    Thanks for your response… As a matter of fact, I did run cryptotools utility (steps 7th and 8th you gave). But still have the error.

    Any other thoughts on how to get around this would be great!

    -Esther

  27. Esther Says:

    Hi Venkat,

    Update: am currently able to save my iBot. The issue I had was with job manager configuration on the “General” tab. I gave the administrator name as Administrator but I didn’t leave the password field blank.

    Thanks,
    -Esther

  28. Gathatharan Says:

    hi Venkat
    for me i bot is getting created
    what do i have to do for creating an alert

  29. Rob Says:

    Venkat,

    Could you show one for BIPublisher?

    Does the BIPublisher password have to be the same as the OBIEE Administrator?

    Rob

  30. anjireddy Says:

    when i followed ur steps and when i am starting the BI scheduler it is giving an error which i mention below,pls help me to resolve this problem…

    Could not start the Oracle BI Scheduler Service on local computer.
    Error:1064: An Exception occurred in the service when handling the control request

  31. StClair Says:

    Thks Mr. Venkat
    I have followyour steps
    But still have Error:1064: An Exception occurred in the service when handling the control request.

    Please Help me to solve this.

  32. Abid Says:

    Hi,
    Can anybody help me?
    When i log in the BI Publisher, “the Admin tab is empty”.
    i cannot move further steps in configuration.

  33. Stepa Says:

    Hi Mr Venkat,

    after step 8) I can’t restart service OracleBI Presentation Server

    You write on this step

    “Ensure that you have the alias as “Admin”.”

    Where can I see this alies?

  34. Stepa Says:

    Execuse me,

    after step number eight.

  35. JDSanders Says:

    After you update the credentialstore.xml file using cryptotools, please remember to reboot your machine. I was getting the same error “Authentication Failed” until I performed a reboot. This fixed the issue.

    Stepa: You will find the “Admin” alias in the file I mentioned above: C:\OracleBIData\web\config\credentialstore.xml

    If you have succeeded in using the cryptotools utility, you will find a record at the bottom of the credentialstore.xml file called Admin with the relevant information in it.

  36. Somnath de Says:

    I am using a clustered environment with external database authentication and authorization. I did all the steps mentioned here but it is still giving me the error in sawlog0.log file -

    ***kmsgNoDisconnectedApplicationFound: message text not found ***
    —————————————
    Type: Error
    Severity: 40
    Time: Wed Mar 26 09:39:00 2008
    File: project/webodbcaccess/odbcconnectionimpl.cpp Line: 369
    Properties: ConnId-46,46;ThreadID-9204
    Location:
    saw.odbc.connection.open
    saw.connectionPool.getConnection
    saw.delivers.rpc.getDeviceContent
    saw.rpc.server.responder
    saw.rpc.server
    saw.rpc.server.handleConnection
    saw.rpc.server.dispatch
    saw.threadPool
    saw.threads

    Odbc driver returned an error (SQLDriverConnectW).
    State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
    [nQSError: 43001] Authentication failed for user123 in repository Star: invalid user/password. (08004)
    —————————————
    Type: Error
    Severity: 42
    Time: Wed Mar 26 09:39:00 2008
    File: project/webconnect/connection.cpp Line: 276
    Properties: ThreadID-9204
    Location:
    saw.connectionPool.getConnection
    saw.delivers.rpc.getDeviceContent
    saw.rpc.server.responder
    saw.rpc.server
    saw.rpc.server.handleConnection
    saw.rpc.server.dispatch
    saw.threadPool
    saw.threads

    Authentication Failure.
    Odbc driver returned an error (SQLDriverConnectW).
    —————————————
    Type: Error
    Severity: 42
    Time: Wed Mar 26 09:39:00 2008
    File: project/websubsystems/ibotsessions.cpp Line: 72
    Properties: ThreadID-9204
    Location:
    saw.delivers.rpc.getDeviceContent
    saw.rpc.server.responder
    saw.rpc.server
    saw.rpc.server.handleConnection
    saw.rpc.server.dispatch
    saw.threadPool
    saw.threads

    Authentication Failure.
    Error Codes: IHVF6OM7:OPR4ONWY:U9IM8TAC

    Odbc driver returned an error (SQLDriverConnectW).
    State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
    [nQSError: 43001] Authentication failed for user123 in repository Star: invalid user/password. (08004)

    Regards,
    Somnath

  37. raghu Says:

    Hi venkat,

    I need overall Architecture of OBI like all the servers connection related to informatica and DAC.

    Thanks,
    RAGHU

  38. rye Says:

    Hi Venkat,

    Just want to say that this is a very useful guide. I wish I had this before when I was configuring Delivers. Then it wouldn’t have taken me days(!) to configure it. Your posts are very informative. Please keep them coming. Many thanks!

  39. anamika Says:

    Hi Venkat,
    To execute the 3 step, i tried to open Bin /Job Manager , but got following error:
    “Component ‘mscomtl.ocx’ or one of its dependencies not currently registered: a file missing or invalid”

    Please tell the probable cause and the way to get out of it.

    Thanks

  40. Manju Nambiar Says:

    Hey Venkat,
    I am able to successfully save an iBot. But when I schedule it, it fails with the following error message - gist is that the LDAP authentication initialization block is causing issues. Following is the error:
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW). Error Codes: OPR4ONWY:U9IM8TAC State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004]
    [nQSError: 10018] Access for the requested connection is refused.
    [nQSError: 13024] Successful completion of init block ‘analyticsWeb_session_init_blk’ is required. (08004) Error Codes: . Error Codes: AGEGTYVF
    +++ ThreadID: 4e0 : 2008-04-11 13:53:02.997 iBotID: /users/administrator/_ibots/iBotTestManju …Trying iBot RunCR loop again.
    +++ ThreadID: 4e0 : 2008-04-11 13:53:02.997 … Sleeping for 8 seconds.
    +++ ThreadID: 4e0 : 2008-04-11 13:53:10.998
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW). Error Codes: OPR4ONWY:U9IM8TAC State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004]
    [nQSError: 10018] Access for the requested connection is refused.
    [nQSError: 13024] Successful completion of init block ‘analyticsWeb_session_init_blk’ is required. (08004) Error Codes: . Error Codes: AGEGTYVF
    +++ ThreadID: 4e0 : 2008-04-11 13:53:10.998 iBotID: /users/administrator/_ibots/iBotTestManju …Trying iBot RunCR loop again.
    +++ ThreadID: 4e0 : 2008-04-11 13:53:10.998 … Sleeping for 6 seconds.
    +++ ThreadID: 4e0 : 2008-04-11 13:53:16.998
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Odbc driver returned an error (SQLDriverConnectW). Error Codes: OPR4ONWY:U9IM8TAC State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004]
    [nQSError: 10018] Access for the requested connection is refused.
    [nQSError: 13024] Successful completion of init block ‘analyticsWeb_session_init_blk’ is required. (08004) Error Codes: . Error Codes: AGEGTYVF
    +++ ThreadID: 4e0 : 2008-04-11 13:53:16.998 iBotID: /users/administrator/_ibots/iBotTestManju Exceeded number of request retries.
    +++ ThreadID: 16a0 : 2008-04-11 13:53:16.998 iBotID: /users/administrator/_ibots/iBotTestManju No Content for user : Administrator

    I am logged in as Administrator but need the initialization block for LDAP authentication. How do I get around this?

    Any suggestions would be much appreciated. Again thanks for detailing the configuration steps in a detailed yet precise manner.

    Thanks,
    Manju

  41. Walt Says:

    how to config this on unix? is it same way?

    thanks and regards
    Walt

  42. Mark Says:

    I’m getting error message: Oracle BI Scheduler Error: [nQSError: 12008] Unable to connect to port 9705 on machine DAMCO-ORACLE. [nQSError: 12010] Communication error connecting to remote end point: address = DAMCO-ORACLE; port = 9705. [nQSError: 12002] Socket communication error at call=: (Number=-1) ???
    Error Details
    Error Codes: GYFPI8RN

    Please Help…. how do I start the scheduler service?

    Thanks

  43. SreeHarsha G S Says:

    Hi,

    I have the OBI EE 10.1.3.3.2 Platform. When I try to run the cryptotools utility to add the scheduler and impersonator credentials to the credentialstore.xml file, it asks for the Credential store file… When I give the path for credentialstore.xml file, the command exits out of the loop without asking for any other inputs like alias, username and password.

    I tried one more thing. I just copied the backup of credentialstore.xml file I had from another server into the D:/OracleBIData/Web/Config and re-started the services. Then The SSO was set to true in instanceconfig.xml file. when I tried to login tot he applicatiob, it showed the message “NOT LOGGED IN”.

    Any suggestion would be of great help.

    Thanks,
    SreeHarsha G S

  44. Nick Says:

    Hi,

    Thank you this is very helpful. I have an additional complexity in that my environment has mulitple presentation services deployed on the same box using multiple instanceconfigs, etc. Can I create multiple credential stores and name them in each of my instanceconfig files that belong to my different presentation services? Do you think there would be more involved than that?

    Thank you,
    Nick

  45. Debashis Says:

    Hi Venkat,

    One of the threads here from Somnath talks about the similar type of log file generated from BI 10g presentation service while scheduling one iBot job from web :

    I have tried to get any reply from forum without luck. Do you really have any idea of what is the reason behind the below error :

    Type: Error

    Severity: 42

    Time: Thu May 08 20:04:21 2008

    File: project/websubsystems/ssremote.cpp Line: 1515

    Properties: ThreadID-928;HttpCommand-IBotPicker;RemoteIP-10.123.xxx.x;User-Administrator

    Location:

    saw.httpserver.request

    saw.rpc.server.responder

    saw.rpc.server

    saw.rpc.server.handleConnection

    saw.rpc.server.dispatch

    saw.threadPool

    saw.threads

    ***kmsgNoDisconnectedApplicationFound: message text not found ***

    —————————————

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>