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.

About these ads

111 Responses to “Oracle BI EE 10.1.3.3 – Configuring Delivers – iBots”

  1. SA said

    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 said

    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 said

    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 said

    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 said

    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

    • Muhammad Khalid said

      Hi Vikas, go to your Job manager and the data base which you have made for job manager running scripts N_NQ_SCHED, use this database in the database source of the job and give the password which you have defined in the SQL Server 2005, but you have to make a ODBC for that N_NQ_SCHED database. and your tables must be present in that database, restart your system and start schedular services then it will run, i hope it will solve your problem.

      Khalid
      Pakistan
      khalidjatoi1@yahoo.com

  6. Vikas said

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

    Thanks
    Vikas

    • mani said

      plz explain how u solved..i am trying it for long one week….its not yet completed……
      plz help …….

    • Vishwa said

      Hi Venkat, Vikas,

      I am also facing the same issue.
      In my case OBI is installed on Linux machine.

      When I am running ./NQscheduler
      I am getting following error:

      edcad6z:/opt/egobidev/OBIEE/OracleBI/server/Bin> ./nqscheduler
      Oracle BI home directory is not defined
      Incomplete Oracle BI Server Suite configuration

      Incomplete Oracle BI Server Suite configuration

      On running
      edcad6z:/opt/egobidev/OBIEE/OracleBI/setup> ./run-sch.sh start
      Getting following error:
      Oracle BI Scheduler startup initiated.
      Execute the following command to check the Oracle BI Scheduler logfile and see if it started.

      Log file reads as:

      2009-10-26 16:47:25
      [68008] Scheduler Error:
      Current Table: S_NQ_JOB.
      [nQSError: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down.
      Current Table: S_NQ_JOB_PARAM.
      [nQSError: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down.
      Current Table: S_NQ_INSTANCE.
      [nQSError: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down.
      Current Table: S_NQ_ERR_MSG.
      [nQSError: 16023] The ODBC function has returned an error. The database may not be available, or the network may be down.

      Please help me.

      Thanks
      Vishwa

  7. [...] 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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

    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 said

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

  26. Esther said

    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 said

    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 said

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

  29. Rob said

    Venkat,

    Could you show one for BIPublisher?

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

    Rob

  30. anjireddy said

    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 said

    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 said

    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 said

    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 said

    Execuse me,

    after step number eight.

  35. JDSanders said

    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 said

    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 said

    Hi venkat,

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

    Thanks,
    RAGHU

  38. rye said

    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 said

    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 said

    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 said

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

    thanks and regards
    Walt

  42. Mark said

    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 said

    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 said

    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 said

    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 ***

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

  46. learningobiee said

    THis is the error i am getting when i do the 7 step. Plz help.

    C:\OracleBI\web\bin>cryptotools credstore -add -infile OracleBIData/web/config/c
    redentialstore.xml
    >The file: OracleBIData/web/config/credentialstore.xml does not exist. Do you wi
    sh to create it? y/n (y): y
    >Credential Alias: admin
    >Username: Administrator
    >Password: *************
    >Do you want to encrypt the password? y/n (y): n
    [Util Logger] Exception occured:
    Severity:Not set
    Type:class saw::Exception const *
    File:./project/webbedrock/binaryfile.cpp
    Line:355
    Message:Path not found: OracleBIData/web/config/credentialstore.xml
    The system cannot find the path specified.

  47. Lively said

    For the above error;
    when typing the path for your credentialstore.xml you must specify the full path….

    (i.e. in your case it would be cryptotools credstore -add -infile C:/OracleBIData/web/config/c
    redentialstore.xml)

    Hope this helps!

  48. Gagan said

    Venkat, Anamika
    I’m trying to pen Job manager but it’s not coming up. Any thoughts?
    Thanks
    Gagan

  49. Gagan said

    One important thing to note is that the user mentioned during cryptotool setup should exist in the RPD and the password should be the password for the user ID in RPD.
    Thanks,
    Gagan

  50. deepthi said

    +++ ThreadID: a54 : 2008-07-07 15:59:43.249 Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Assertion failure: ((t32 == 0) && (m_nResponseCode != RPCSysMessage::kSuccess)) || (t32 == 2) at line 127 of ./project/webcomm/rpc.cpp Error Codes: OQ78YWIW +++ ThreadID: a54 : 2008-07-07 15:59:43.265 …Trying main loop again. +++ ThreadID: a54 : 2008-07-07 15:59:43.265 … Sleeping for 9 seconds. +++ ThreadID: a54 : 2008-07-07 15:59:52.265 Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Assertion failure: ((t32 == 0) && (m_nResponseCode != RPCSysMessage::kSuccess)) || (t32 == 2) at line 127 of ./project/webcomm/rpc.cpp Error Codes: OQ78YWIW +++ ThreadID: a54 : 2008-07-07 15:59:52.265 Terminal Error: Exceeded number of retries.

    I am getting the following error when i am trying to run ibot.
    My scheduler service is running but ibots don’t run. any thoughts?

    thanks
    deepthi

  51. Judhajit said

    After doing the changes in credentialstore.xml and instanceconfig.xml..i have found that my presentation services is not running.More research has made me believe that problem lies in instanceconfig.xml.Follwoing is my changed instance config file,please help me to understand where I went wrong..

    AnalyticsWeb
    C:/OracleBIData/web/catalog/SSA_EBSAnalyticMaster

    S29E001

    XmlP
    XmlP

    http://S29E001:9704/xmlpserver/services/XMLPService

    http://S29E001:9704/xmlpserver

    http://S29E001:9704/xmlpserver/servlet/admin

    bipublisheradmin

    C:\Sun\SDK\jdk
    client/OracleBIOffice.exe
    <!– To configure a limited set of languages to be available to users uncomment the tag below and choose a subset set of language tags from the list. Values must be comma separated. –>
    <!– ar,cs,da,de,el,en,es,fi,fr,hu,it,iw,ja,ko,nl,no,pl,pt,pt-br,ro,ru,sk,sv,th,tr,zh,zh-tw –>
    <!– To configure a limited set of locales to be available to users uncomment the tag below and choose a subset set of locale tags from the list. Values must be comma separated. –>
    <!– ar-dz,ar-bh,ar-dj,ar-eg,ar-iq,ar-jo,ar-kw,ar-lb,ar-ly,ar-ma,ar-om,ar-qa,ar-sa,ar-so,ar-sd,ar-sy,ar-tn,ar-ae,ar-ye,cs-cz,da-dk,de-at,de-ch,de-de,de-li,de-lu,el-gr,en-au,en-ca,en-cb,en-gb,en-hk,en-ie,en-in,en-jm,en-nz,en-ph,en-us,en-za,en-zw,es-ar,es-bo,es-cl,es-co,es-cr,es-do,es-ec,es-es,es-gt,es-hn,es-mx,es-ni,es-pa,es-pe,es-pr,es-py,es-sv,es-uy,es-ve,fi-fi,fr-be,fr-ca,fr-ch,fr-fr,fr-lu,fr-mc,hu-hu,id-id,it-ch,it-it,iw-il,ja-jp,ko-kr,ms-my,nl-be,nl-nl,no-no,pl-pl,pt-br,pt-pt,ro-ro,ru-ru,sk-sk,sv-fi,sv-se,th-th,tr-tr,zh-cn,zh-mo,zh-sg,zh-tw –>
    <!– truedisconnected –>

  52. jit said

    Hi Venkat,

    Thanks for all your info …I have a problem here..although I have configured all teh necessary steps while configure a scheduler server..but still not able to see a active ibots session even after i create a new one a schedule it as “start immidiately”!!!

    any suggetion please…

  53. jit said

    Hi venkat,

    I havn’t created any new user for scheduler admin…but in credentialsstore.xml file i have given user id:Administrator and password i kept blank..Now my doubt is do I need to create a new user for Scheduler admin..i have tried that once..but the moment i am putting a password in job manager n then trying to save a ibot..its saying authentication error.Thus i dint keep any password for scheduler admin and in credential store i put same user id as reposiroty one..like “Administrator”..follwoing is the error code i am getting whiel try to run a ibot

    +++ ThreadID: 15d8 : 2008-07-08 19:19:47.203 Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed. Error Codes: WKY9UVRD: 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 Administrator in repository Star: invalid user/password. (08004) +++ ThreadID: 15d8 : 2008-07-08 19:19:47.223 …Trying main loop again. +++ ThreadID: 15d8 : 2008-07-08 19:19:47.253 … Sleeping for 9 seconds. +++ ThreadID: 15d8 : 2008-07-08 19:19:56.354 Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed. Error Codes: WKY9UVRD: 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 Administrator in repository Star: invalid user/password. (08004) +++ ThreadID: 15d8 : 2008-07-08 19:19:56.374 Terminal Error: Exceeded number of retries.

  54. jit said

    Hi venkat,

    I havn’t created any new user for scheduler admin…but in credentialsstore.xml file i have given user id:Administrator and password i kept blank..Now my doubt is do I need to create a new user for Scheduler admin..i have tried that once..but the moment i am putting a password in job manager n then trying to save a ibot..its saying authentication error.Thus i dint keep any password for scheduler admin and in credential store i put same user id as reposiroty one..like “Administrator”..follwoing is the error code i am getting whiel try to run a ibot

    +++ ThreadID: 15d8 : 2008-07-08 19:19:47.203 Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed. Error Codes: WKY9UVRD: 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 Administrator in repository Star: invalid user/password. (08004) +++ ThreadID: 15d8 :
    2008-07-08 19:19:47.223 …Trying main loop again. +++ ThreadID: 15d8 : 2008-07-08 19:19:47.253 … Sleeping for 9 seconds. +++ ThreadID: 15d8 : 2008-07-08 19:19:56.354
    Global Error: [nQSError: 77006] Oracle BI Presentation Server Error: Authentication failed. Error Codes: WKY9UVRD: 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 Administrator in repository Star: invalid user/password. (08004) +++ ThreadID: 15d8 : 2008-07-08 19:19:56.374 Terminal
    Error: Exceeded number of retries.

  55. jit said

    Someone has suggested me that while installing OBIEE 10.1.3.3.1,I should be giving the domainname\userid in place of LocalSystem,and then providing the password which i am using while login to the system..As per him,it should solve the issue..

    Please share your views..

    Thanks

  56. RichardD said

    Im experiencing the same issue as others in saving ibots.

    Ive got the following:
    BIWEB01/02 – Presentation Servers
    BI-01/02 – BI Servers + Scheduled servers
    BIDB – Oracle database containing schemas/job tables etc

    Answers and repositories are all up and running, services are all running and healthy.

    Ive added the entry to credentialstore.xml

    -
    Administrator
    xxx

    and instanceconfig.xml

    -

    I get this in Answers:
    Oracle BI Scheduler Error: [nQSError: 68019] Authentication Failed.
    Error Details
    Error Codes: GYFPI8RN

    and get the sawlog output:
    ***kmsgNoDisconnectedApplicationFound: message text not found ***
    —————————————
    Type: Error
    Severity: 42
    Time: Thu Jul 24 15:41:17 2008
    File: project/websubsystems/nqscheduler.cpp Line: 80
    Properties: ThreadID-3492;HttpCommand-IBotSave;RemoteIP-194.155.160.247;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

    ***kmsgNQSchedulerErrorMessage: message text not found ***
    —————————————
    Type: Error
    Severity: 40
    Time: Thu Jul 24 15:43:30 2008
    File: project/webodbcaccess/odbcconnectionimpl.cpp Line: 371
    Properties: ConnId-2,2;ThreadID-3224
    Location:
    saw.odbc.connection.open
    saw.connectionPool.getConnection
    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 administrator in repository Star: invalid user/password. (08004)
    —————————————
    Type: Error
    Severity: 42
    Time: Thu Jul 24 15:43:30 2008
    File: project/webconnect/connection.cpp Line: 276
    Properties: ThreadID-3224
    Location:
    saw.connectionPool.getConnection
    saw.threadPool
    saw.threads

    Authentication Failure.
    Odbc driver returned an error (SQLDriverConnectW).
    —————————————

    Any help appreciated. Im sure my password is correct for the rpd.

  57. RichardD said

    as the tags were stripped:

    - sawcs:credential type=”usernamePassword” alias=”admin”
    sawcs:username>Administratorxxx
    CredentialStorage type=”file” path=”c:\OracleBIData\web\config\credentialstore.xml” /
    /CredentialStore>
    /ServerInstance>
    /WebConfig>

    Regards

  58. ashish said

    hi,
    venkat
    i receive following error after scheduling the job please help me out

    +++ ThreadID: 1510 : 2008-09-12 12:30:41.163
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1510 : 2008-09-12 12:30:41.225
    iBotID: /users/administrator/_ibots/practice
    …Trying main iBot loop again.

    +++ ThreadID: 1510 : 2008-09-12 12:30:41.256
    … Sleeping for 3 seconds.

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.265
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.280
    iBotID: /users/administrator/_ibots/practice
    …Trying main iBot loop again.

    +++ ThreadID: 1510 : 2008-09-12 12:30:44.296
    … Sleeping for 5 seconds.

    +++ ThreadID: 1510 : 2008-09-12 12:30:49.299
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
    Error Codes: U9KP7Q94

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1510 : 2008-09-12 12:30:49.346
    iBotID: /users/administrator/_ibots/practice
    Exceeded number of request retries.

    • Srinu B said

      Hi Ashish,,

      I amconfiguring the Ibots on LInux.

      When i try to save the ibot, i am geeting error message:

      nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Path not found (/users/administrator/_ibots/practice)
      Error Codes: U9KP7Q94

      Could you pls help me out this issue.

      Regards,
      Srinu B.

  59. Angii said

    Can´t Start the Service Scheduled
    Why????
    my Error

    ERROR: 1064 and NQSERROR 12008.
    I read post Back. and No Result ..

    Why can´t Start This Service.. pliz help me.

  60. Babu Dass said

    Hi Venkat,
    I am not able to schedule iBots, getting error
    Error Given below:
    Error Codes: GYFPI8RN
    Location: saw.httpserver.request, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.socketServer, saw.threadPool, saw.threadPool, saw.threads
    File: nqscheduler.cpp, Line: 198.

    Pls help on this.

    Regards,
    Babu Dass

  61. Babu Dass said

    Hi Venkat,

    What are the services to be run in Unix box for starting iBots.

    Can you please send out Unix comments which are used for Siebel Analytics 7.8.5

    Thanks & Regards,
    Babu Dass

  62. Jagdeep said

    Well, this configuration is for the installation on Windows. What about UNIX? The configuration xml file on UNIX also contains entries like C:\…. Whereas they should be /app/oracle/OracleBI..

    Please clarify.

    Regards,

    Jagdeep

  63. venkatesh said

    Dear Venkat,

    I had trouble in Starting OBI Scheduler, i did every thing as per your blog and Oracle documentation, but 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, This Solved my problem, i just wanted to share it with you all, Please post this comment in your blog, if you think it will help some Novices like me.

  64. John doe said

    First, Venkatakrishnan, you are a life-saver. Next, I think the alias “admin” needs to be lowercase.In one of the captions you have it uppercased which may have resulted in some confusion. I think this will solve the following error:

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

    Keep up the good work!!!

  65. sri said

    Hi Venkat,

    Nice work. I have a question regarding the ibots,
    lets say if there is a job running on back end for ‘x’ couple of
    hours and crossed the limit, can we use ibots to send an email
    to respective persons.

    So basically based on same value in the report, can we use ibots as triggers to alert the people.

    Thanks
    Sri

  66. Alexis said

    Hi, my system is HPUX Itanium 64bit, i did all the steps in manual includding running cryptotools64 (which is in Bin64 folder and docs dont mention anything about 64 bit part).

    I used admin, connected to Job Manager, did all the steps, but still get an error at save time. tail -100 sawlog0.log returns:
    Type: Error
    Severity: 42
    Time: Thu Feb 5 16:49:34 2009
    File: project/websubsystems/ssremote.cpp Line: 1648
    Properties: ThreadID-5;HttpCommand-IBotPicker;RemoteIP-10.254.90.54;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 ***
    —————————————
    Type: Error
    Severity: 42
    Time: Thu Feb 5 16:49:50 2009
    File: project/websubsystems/ssremote.cpp Line: 1648
    Properties: ThreadID-5;HttpCommand-LoadPickerBrowser;RemoteIP-10.254.90.54;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 ***
    —————————————
    Type: Error
    Severity: 42
    Time: Thu Feb 5 16:52:01 2009
    File: project/websubsystems/nqscheduler.cpp Line: 80
    Properties: ThreadID-5;HttpCommand-IBotSave;RemoteIP-10.254.90.54;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

    ***kmsgNQSchedulerErrorMessage: message text not found ***

    Any help on this please?

  67. Vishal Sharma said

    Hi Venkat,

    I have installed OBIEE on win 2003 server..
    Everything is working fine except for 2 things
    1>I am not able to see any graphs in “Answers”….though i can view the data in tables
    2>I am not able to create an iBot…for iBot i tried too use your guideline…but i am not getting suuccess…
    Since i am using MS-Access as backend i dont know how to create the schema in Access ….
    Can you please help me out….

    Thanks
    Vishal

  68. jaedwein said

    Hi Vishal, I will try to answer your question.

    1> You didn`t start “Oracle BI Java Host” service. It`s necessary to generate the graphs.
    2> Try with MSDE (SQL Server Desktop Engine). It works good for me, and it is lightweight.

    Javier.

  69. Siddhartha said

    Hi venkat

    I am not able to see the alerts on dashboard, i have done all the configuration and everythign is working correct.

    thanks
    Siddhartha P

  70. jaedwein said

    Hi Siddhartha

    Did you check ‘Interactive Dashboard’ on ‘User Destinations’ group on ‘Destinations’ page when you created the iBot?

    Saludos.
    Javier.

  71. Vishal Sharma said

    Hi Venkat,

    I followed all the instructions as you have mentioned but still getting any issue.
    I am not able to start my Scheduler service…i am getting following error:
    Error:1064: An Exception occurred in the service when handling the control request

    For your information
    I am using MS-Access on my Windows 2003 server installed on my VMWare.
    Plz help

  72. jaedwein said

    Hi Vishal

    Take a look at the log file in OracleBI\server\Log\NQScheduler.log to see what is happening.

    Saludos.
    Javier.

  73. Raghu said

    Hi,

    When I try to run iBOT using ‘Run as administrator’ option it runs successfully. But without this option it fails with below error,we are using database authentication using database user login not external table.

    +++ ThreadID: 1060 : 2009-03-13 15:46:47.012

    [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 a467213 in repository Star: invalid user/password. (08004)

    I really really appreciate if someone can pass the solution.

    Thanks
    Raghu

  74. wiprkk said

    Hi Venkat

    I was following the tutorial on the oracle website to setup the mail server

    http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/delivers/delivers.htm

    I did exactly the same but I’m not getting any mails. Currently I’m getting the alerts but its not sending the email. I have few questions on this

    The Steps that were followed by me are:
    1)Downloaded Argosoft mail server
    2) Created users (wiprkk) and password also
    3)Entered user@ in the Return Address text box, where is the name of your machine domain configuration. For this I gave as wiprkk@geeks.
    4)*Question Here is what is my machine name? Is it my computer name?* which is “geeks”
    5) What Should I type in for “Return Address”? The screenshot says “user@yourmachine.us.oracle.com”. In my case will it be wiprkk@geeks.us.oracle.com???
    6) What will be my Local Host and Local Domain?????? Currently the screenshot says “Local host” & “Local Domain” – “yourmachine.us.oracle.com”. So for my case will it be “geeks.us.oracle.com”
    7) What would be the email address in outlook express ??? will it be wipkk@geeks
    8) What would be the email server name for both Incoming and outgoing mail ??? will it be (machinename==geeks?? or machinename.us.oracle.com == geeks.us.oracle.com????

    can you please help me resolve this issue. It would be helpful if anyone can give step by step instructions with the below data.

    Your reply at the earliest would be helpful.

    Just to summarize

    username: wiprkk
    computername = machine name ==”geeks”
    What should be the “Local Host” in my case
    What should be the “Local Domain” in my case
    What is this “.us.oracle.com”?? Do i need to append this with my machine name??? can I use .us.oracle.com????

    Do i need to start any services in my machines other than OBIEE Scheduler servers etc.. (I mean like smtp services etc..)

    SUMMARY:
    NEED HELP on SETTING UP A MAIL SERVER. SO THAT I CAN SEE THE EMAIL

    I CREATED THE IBOTS THEY ARE WORKING FINE AND ICAN SEE THE ALERTS ON THE Presentation Servies.

    I’m having difficulty in setting up the mail server and configure it to see the email notification
    can you please help on this.

  75. Kanchi said

    Can someone help us with the below error.

    Eventually succeeded, but encountered and resolved errors…
    Number of skipped recipients: 1 of 2

    +++ ThreadID: c4c : 2009-05-04 15:41:01.092
    iBotID: /users/administrator/_ibots/Ibot3
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: c4c : 2009-05-04 15:41:01.248
    iBotID: /users/administrator/_ibots/Ibot3
    …Trying SMTP Delivery loop again

    +++ ThreadID: c4c : 2009-05-04 15:41:01.279
    … Sleeping for 8 seconds.

    +++ ThreadID: c4c : 2009-05-04 15:41:09.339
    iBotID: /users/administrator/_ibots/Ibot3
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: c4c : 2009-05-04 15:41:09.401
    iBotID: /users/administrator/_ibots/Ibot3
    …Trying SMTP Delivery loop again

    +++ ThreadID: c4c : 2009-05-04 15:41:09.448
    … Sleeping for 4 seconds.

    +++ ThreadID: c4c : 2009-05-04 15:41:13.525
    iBotID: /users/administrator/_ibots/Ibot3
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: c4c : 2009-05-04 15:41:13.634
    iBotID: /users/administrator/_ibots/Ibot3
    …Trying SMTP Delivery loop again

    +++ ThreadID: c4c : 2009-05-04 15:41:13.744
    … Sleeping for 2 seconds.

    +++ ThreadID: c4c : 2009-05-04 15:41:15.790
    iBotID: /users/administrator/_ibots/Ibot3
    [nQSError: 75003] Failed to open connection to SMTP Server.

    +++ ThreadID: c4c : 2009-05-04 15:41:15.852
    iBotID: /users/administrator/_ibots/Ibot3
    Exceeded number of delivery retries.

    • mg said

      I get the same error as above – [nQSError: 75003] Failed to open connection to SMTP Server.

      Any help is greatly appreciated.

  76. Joab Zuria said

    Venkatakrishnan: Hi, let me ask you if anyone know why i Can´t deliver by Email on conditional request on Recipients. I have a simple report with year, month, date and email fileds and create ibot with this report and the next parameters:
    GENERAL:
    Priority HIGH
    Data Visibility Not Personalized
    Run As ADMINISTRATOR
    RECIPIENTS:
    Determine recipients from conditional request EMAIL
    DESTINATIONS:
    Specific Devices EMAIL

    ——————————————————————————–
    This is the error message:
    + ThreadID: 2510 : 2009-05-11 17:17:56.625
    iBotID: /users/administrator/_ibots/PRUEBA INTELLEGO
    No devices for user: abcdefg@hotmail.com

    + ThreadID: 2510 : 2009-05-11 17:17:56.625
    iBotID: /users/administrator/_ibots/PRUEBA INTELLEGO
    No devices for user: myname@mycompany.com.mx

    ——————————————————————————–
    PD: Let me tell you that if i send with “Me” option check on Recipient, i don´t have any problem.

  77. Alex said

    Venkat,

    Thanks a lot!!
    Very useful!!

    Alex

  78. Andras Szenci said

    hi!

    I’ve got a problem with configuring BI Scheduler. I followed the instructions, and it all seems fine, I can start the service, I can configure iBots, I can save them, they are in the database… but when I try to run one, it gives me this error message in the log file:

    [Util Logger] Exception occured:
    Severity:Not set
    Type:const saw::Exception *
    File:/net/sdcb80a022/vol1/users/anabuild/views/nightly/Sun/10134/AIX/vobs/080726.1900/analytics_web/main/project/ibotapi/ibotrpcproxy.cpp
    Line:145
    Message:Access denied.

    What can be the problem?
    Thx

  79. Reshma said

    Hi Vankatesh,
    If we have 1000 of column in the BMM layer table.. can we drag all the columns in the presentation Layer? If yes.. Then any advantages….
    If No then aany disadvantages?
    Please reply me as soon as possible….

  80. mani said

    i followed this link http://oraclebizint.wordpress.com/2007/09/13/oracle-bi-ee-10133-configuring-delivers-ibots/ every thing is working fine like configuring the scheduler services and the alerts displayed in the dashboard. and these are not reached to the alert-mail inbox.

    the log file is displaying as this:
    C:\OracleBI\server\Log\iBots

    + ThreadID: 1f4 : 2009-06-12 12:57:02.265
    iBotID: /users/administrator/_ibots/new/sheeba_new
    nQSError: 75005 Failed to send AUTH command. authorization failed (#5.7.0)

    + ThreadID: 1f4 : 2009-06-12 12:57:02.281
    iBotID: /users/administrator/_ibots/new/sheeba_new
    …Trying SMTP Delivery loop again

    + ThreadID: 1f4 : 2009-06-12 12:57:02.296
    … Sleeping for 5 seconds.

    + ThreadID: 1f4 : 2009-06-12 12:57:07.718
    iBotID: /users/administrator/_ibots/new/sheeba_new
    nQSError: 75005 Failed to send AUTH command. authorization failed (#5.7.0)

    + ThreadID: 1f4 : 2009-06-12 12:57:07.734
    iBotID: /users/administrator/_ibots/new/sheeba_new
    …Trying SMTP Delivery loop again

    + ThreadID: 1f4 : 2009-06-12 12:57:07.750
    … Sleeping for 8 seconds.

    + ThreadID: 1f4 : 2009-06-12 12:57:15.968
    iBotID: /users/administrator/_ibots/new/sheeba_new
    nQSError: 75005 Failed to send AUTH command. authorization failed (#5.7.0)

    + ThreadID: 1f4 : 2009-06-12 12:57:16.000
    iBotID: /users/administrator/_ibots/new/sheeba_new
    …Trying SMTP Delivery loop again

    + ThreadID: 1f4 : 2009-06-12 12:57:16.000
    … Sleeping for 6 seconds.

    + ThreadID: 1f4 : 2009-06-12 12:57:22.250
    iBotID: /users/administrator/_ibots/new/sheeba_new
    nQSError: 75005 Failed to send AUTH command. authorization failed (#5.7.0)

    + ThreadID: 1f4 : 2009-06-12 12:57:22.281
    iBotID: /users/administrator/_ibots/new/sheeba_new
    Exceeded number of delivery retries.

  81. jaedwein said

    Hi all!
    Has someone used mysql, postgres or informix to

  82. jaedwein said

    Sorry!!

    Hi all!
    Has someone used mysql, postgres or informix to store the jobs?
    I’ve tried with tese databases, and always I see on the log when scheduler starts the name and version of the database:

    2009-06-10 23:15:58
    [16020] Tipo de base de datos de metadatos: ODBC2.00
    Nombre de origen de datos: orclschedulerpg
    Tipo de origen de datos: PostgreSQL 8.3.7
    2009-06-10 23:15:59
    Data Source Name: orclschedulerpg
    Client Driver Version 08.03.0400
    2009-06-10 23:16:00
    [68013] El servicio se ha iniciado.

    and

    2009-06-09 15:50:50
    [16020] Tipo de base de datos de metadatos: Informix IDS 9.4/10.0
    Nombre de origen de datos: orclscheduler
    Tipo de origen de datos: Informix 11.50.0000 TC4TL
    2009-06-09 15:50:50
    Data Source Name: orclscheduler
    Client Driver Version 3.50.TC3
    2009-06-09 15:50:50
    [68013] El servicio se ha iniciado.

    With mysql I can save ibots, but don`t run. With Informix and Postgres I see in the log the following error:

    2009-06-10 23:19:22
    [46008] Error interno: archivo .\Src\DTDbTransaction.cpp, línea 1813.

    The same configuration related to security, users and passwords works fine if I use Oracle 11

    Any idea?
    Thanks in advance.

    Javier

  83. Mahesh said

    Hi venkat

    When we deliver PDF as iBot attachment,its delivering to the the shared folder we are speifying in javascript.But when we try to open the PDF,ith throws an error saying Adobe Reader cannot open the ABC.pdf because either its not a supported file type or the file has been damagaed.(For eg:it was send as an email attachment and wasn’t correctly decoded.

    We are not sending as email,but only publishin to a shared folder.

    Can you help me.Scheduler is running in windows and prsenatation server is in different machine.

  84. [...] http://oraclebizint.wordpress.com/2007/09/13/oracle-bi-ee-10133-configuring-delivers-ibots/ [...]

  85. deepika said

    Hi,
    When I am trying to start job manager from all programs\obiee\job manager
    the window does not open so i am not able to configure the scheduling options

    when i checked for the scheduler log file i have this error

    [68008] Scheduler Error: [nQSError: 67042] The Scheduler Configuration is incorrect.

    [nQSError: 67004] Registry value for SchedulerScriptPath not set.

    can you please tell me how to go about this error

  86. mohan said

    In job scheduler i dint have the Oracle 11g option in Database Type..

    NQScheduler.log file
    2009-08-18 16:51:30

    [16020] Metadata Database Type: Oracle 10g R2
    Data Source Name: ORCL
    Data Source Type: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Pro

    2009-08-18 16:51:30

    [68013] Service started.

    2009-08-18 16:51:30

    Service started.

  87. mano said

    +++ ThreadID: 1378 : 2009-09-05 14:40:25.953
    iBotID: /users/administrator/_ibots/maills
    [nQSError: 75005] Failed to send AUTH command. No supported authentication mechanism found

    +++ ThreadID: 1378 : 2009-09-05 14:40:25.953
    iBotID: /users/administrator/_ibots/maills
    …Trying SMTP Delivery loop again

    +++ ThreadID: 1378 : 2009-09-05 14:40:25.968
    … Sleeping for 3 seconds.

    +++ ThreadID: 1378 : 2009-09-05 14:40:29.812
    iBotID: /users/administrator/_ibots/maills
    [nQSError: 75005] Failed to send AUTH command. No supported authentication mechanism found

    +++ ThreadID: 1378 : 2009-09-05 14:40:29.828
    iBotID: /users/administrator/_ibots/maills
    …Trying SMTP Delivery loop again

    +++ ThreadID: 1378 : 2009-09-05 14:40:29.843
    … Sleeping for 5 seconds.

  88. mano said

    In job scheduler i dint have the Oracle 11g option in Database Type..

    NQScheduler.log file
    2009-08-18 16:51:30

    [16020] Metadata Database Type: Oracle 10g R2
    Data Source Name: ORCL
    Data Source Type: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Pro

    2009-08-18 16:51:30

    [68013] Service started.

    2009-08-18 16:51:30

    Service started.

  89. jer said

    Hi venkat,

    In our case to works fine for all rpd users. But in our security setup we have SSO on top of BI using Impersonator. How to change the scheduler configuration so that it also works for non-rpd users (external authentication)

    Thanks
    jer

  90. Nano said

    Hi Venkata,

    I have Oracle BI Standard Edition One and I need generate a pdf automatically, but not send email, only save in server machine. You Think this is possible? how?.

    Thanks
    Nano

  91. schauw said

    Hello,
    I´m trying to configure the scheduler for a unix installation, does anyone knows how to do it?

  92. OBI User said

    Hi,

    I met the following error when I ran an iBot job:

    +++ ThreadID: 93c : 2009-10-20 15:20:55.679
    [nQSError: 77006] Oracle BI Presentation Server Error: Access denied.
    Error Codes: OKZJNLK4

    +++ ThreadID: 93c : 2009-10-20 15:20:55.679
    iBotID: /users/qsun/_ibots/Test
    …Trying main iBot loop again.

    +++ ThreadID: 93c : 2009-10-20 15:20:55.679
    … Sleeping for 6 seconds.

    +++ ThreadID: 93c : 2009-10-20 15:21:01.679
    [nQSError: 77006] Oracle BI Presentation Server Error: Access denied.
    Error Codes: OKZJNLK4

    +++ ThreadID: 93c : 2009-10-20 15:21:01.679
    iBotID: /users/qsun/_ibots/Test
    …Trying main iBot loop again.

    +++ ThreadID: 93c : 2009-10-20 15:21:01.679
    … Sleeping for 9 seconds.

    +++ ThreadID: 93c : 2009-10-20 15:21:10.678
    [nQSError: 77006] Oracle BI Presentation Server Error: Access denied.
    Error Codes: OKZJNLK4

    +++ ThreadID: 93c : 2009-10-20 15:21:10.678
    iBotID: /users/qsun/_ibots/Test
    Exceeded number of request retries.

    We checked the related security setup and can’t find the cause.

    Thanks
    OBI User

    • Peter said

      Anyone have a solution or clue for the issue OBI User is having? I’m getting the same error message, have no clue how to solve this…..

      Peter

  93. Luntu said

    Hi guys

    can someone help me out with the bellow mentioned error:

    I am able to schedule and run one iBot report and it runs successfully, but when I schedule up more that one iBot i am getting this error.

    +++ ThreadID: 1374 : 2009-11-08 20:30:07.966
    [nQSError: 77006] Oracle BI Presentation Server Error: A fatal error occurred while processing the request. The server responded with: Assertion failure: at line 192 of ./project/websubsystems/ibotruncr.cpp
    Error Codes: OQ78YWIW

    .
    Error Codes: AGEGTYVF

    +++ ThreadID: 1374 : 2009-11-08 20:30:08.013
    iBotID: /shared/_ibots/Sales_Report
    …Trying iBot RunCR loop again.

    +++ ThreadID: 1374 : 2009-11-08 20:30:08.044
    … Sleeping for 8 seconds.

    Can you please tell me how to fix this error.

  94. Ayyappan said

    Is that possible to trigger an iBOt when user login which will alert user ? something like from initialization block ?

    Thanks,
    Ayyappan

  95. Kurt Wolff said

    Wow. I suggest that the number of replies here — the problems Delivers poses in set up and operation — speaks volumes about the product and its documentation.

  96. Mehran said

    Hello Venkat, I have a general question and I like to have your thoughts on that. I am currently desgning a star schema for setpoints. A sepoint Name can have a benefit and loss associated with it. Also a setpoint can have other attributes such as current value, benchmark value, comments etc. Here is my questions. Where should I store those extra attributes. If I store them in the fact table, then they are not really measures and if I store them in dimension tables, they grow as fast as fact tables.

  97. Marie Nagel said

    in Step 6, you don’t say which instanceconfig.xml file you are updating.

    OracleBIData \ scheduler \config \ instanceconfig.xml
    OracleBIData \ web \ config \ instanceconfig.xml

  98. Sunny said

    HI Venkat,

    I am trying to configure Ibots, when i am trying to start Job Manager it throws me an Java 2 Runtime Environment could not found.

    Please let me know your thoughts.

    Thanks

    Sachin

  99. Raaz said

    Guys, it’s a known bug posted as…

    Bug 7232631: REQUIRED FOR AUTHENTICATION CHECKED: CANNOT RUN JOB IN JOB MANAGER

    Currently, it’s not resolved yet but hopefully will be fixed in v11. Pls note this only happens with LDAP authentication.

  100. Sridhar said

    Hi,
    I’m very new to OBIEE and I have been given a question to solve in OBIEE.
    We are using Fmaps image files (Gifs/Jpeg) to show on OBIEE reports.
    Here, the image files are needed to copy in 2 locations OC4j path and WebPath.
    I want to know how we can keep image at ONE LOCATION and point both OC4J and WEB paths point to that?
    Is there any way to do that? Your answer really helps me alot!!

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

 
Follow

Get every new post delivered to your Inbox.

Join 158 other followers

%d bloggers like this: