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.







October 8, 2007 at 5:49 pm
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
October 8, 2007 at 6:07 pm
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.
October 11, 2007 at 12:18 pm
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
October 11, 2007 at 12:43 pm
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
October 12, 2007 at 12:17 pm
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
October 12, 2007 at 1:56 pm
Hi venkat, i am able to solve this error, and the BI Scheduler service is started now.
Thanks
Vikas
October 18, 2007 at 12:10 pm
[...] 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 [...]
October 24, 2007 at 11:37 am
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
October 24, 2007 at 6:38 pm
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?
October 24, 2007 at 7:15 pm
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.
October 24, 2007 at 11:03 pm
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
October 26, 2007 at 10:44 am
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
October 26, 2007 at 11:07 pm
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?
October 30, 2007 at 4:35 pm
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
November 5, 2007 at 8:25 am
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
November 7, 2007 at 5:17 pm
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.
November 22, 2007 at 11:17 am
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
November 29, 2007 at 12:25 pm
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
December 3, 2007 at 4:44 am
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-
December 14, 2007 at 10:19 pm
hi
we are getting ‘TNS Timed Out’ error when trying to start the scheduler services.
Please advice me how to handle this.
thanks,
babu.
January 3, 2008 at 10:56 am
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
January 14, 2008 at 10:15 pm
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
January 24, 2008 at 12:06 pm
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
February 13, 2008 at 5:03 pm
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
February 13, 2008 at 8:12 pm
I believe you have not run the cryptotools utility. Check the 7th and 8th steps above.
February 14, 2008 at 2:56 pm
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
February 14, 2008 at 7:17 pm
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
February 15, 2008 at 6:20 am
hi Venkat
for me i bot is getting created
what do i have to do for creating an alert
February 19, 2008 at 1:46 pm
Venkat,
Could you show one for BIPublisher?
Does the BIPublisher password have to be the same as the OBIEE Administrator?
Rob
March 4, 2008 at 9:51 am
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
March 5, 2008 at 2:04 pm
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.
March 11, 2008 at 7:28 am
Hi,
Can anybody help me?
When i log in the BI Publisher, “the Admin tab is empty”.
i cannot move further steps in configuration.
March 19, 2008 at 1:33 pm
Hi Mr Venkat,
after step
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?
March 19, 2008 at 1:35 pm
Execuse me,
after step number eight.
March 19, 2008 at 6:57 pm
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.
March 28, 2008 at 6:36 am
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
March 28, 2008 at 7:32 am
Hi venkat,
I need overall Architecture of OBI like all the servers connection related to informatica and DAC.
Thanks,
RAGHU
April 2, 2008 at 6:42 am
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!
April 3, 2008 at 6:47 am
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
April 11, 2008 at 9:19 pm
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
April 16, 2008 at 2:46 pm
how to config this on unix? is it same way?
thanks and regards
Walt
April 17, 2008 at 8:31 pm
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
April 28, 2008 at 7:58 am
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
May 8, 2008 at 2:37 pm
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
May 10, 2008 at 10:19 am
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 ***
—————————————