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.
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
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.
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
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
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
Muhammad Khalid said
actually the database for Siebel Scheduler should be S_NQ_SCHED.
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
Oracle BI EE 10.1.3.3/2 - Top 10 Common Errors « Business Intelligence - Oracle said
[…] 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 […]
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
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?
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.
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
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
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?
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
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
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.
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
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
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-
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.
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
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
reddy said
HI pradeep Did you above problem got solved.. I am facing same problem too.. please let me know how u fixed it.
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
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
Venkatakrishnan J said
I believe you have not run the cryptotools utility. Check the 7th and 8th steps above.
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
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
Gathatharan said
hi Venkat
for me i bot is getting created
what do i have to do for creating an alert
Rob said
Venkat,
Could you show one for BIPublisher?
Does the BIPublisher password have to be the same as the OBIEE Administrator?
Rob
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
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.
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.
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?
Stepa said
Execuse me,
after step number eight.
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.
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
raghu said
Hi venkat,
I need overall Architecture of OBI like all the servers connection related to informatica and DAC.
Thanks,
RAGHU
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!
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
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
Rajesh J said
Hae you got any solution for this?
Walt said
how to config this on unix? is it same way?
thanks and regards
Walt
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
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
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
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 ***
—————————————
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.
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!
Gagan said
Venkat, Anamika
I’m trying to pen Job manager but it’s not coming up. Any thoughts?
Thanks
Gagan
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
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
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 –>
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…
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.
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.
jer said
hi Jit
Were you able to resolve this. I got the exact same problem. Please share.
thanks,
jer
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
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.
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
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.
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.
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
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
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
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.
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!!!
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
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?
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
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.
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
jaedwein said
Hi Siddhartha
Did you check ‘Interactive Dashboard’ on ‘User Destinations’ group on ‘Destinations’ page when you created the iBot?
Saludos.
Javier.
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
jaedwein said
Hi Vishal
Take a look at the log file in OracleBI\server\Log\NQScheduler.log to see what is happening.
Saludos.
Javier.
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
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.
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.
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.
Alex said
Venkat,
Thanks a lot!!
Very useful!!
Alex
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
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….
mani said
i followed this link https://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.
jaedwein said
Hi all!
Has someone used mysql, postgres or informix to
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
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.
Setting Up OBIEE Delivers/iBots to Send Alerts | Art of Business Intelligence said
[…] https://oraclebizint.wordpress.com/2007/09/13/oracle-bi-ee-10133-configuring-delivers-ibots/ […]
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
Doellinger said
I have the same problem. Do you find solution for that?
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.
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.
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.
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
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
schauw said
Hello,
I´m trying to configure the scheduler for a unix installation, does anyone knows how to do it?
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
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.
Ayyappan said
Is that possible to trigger an iBOt when user login which will alert user ? something like from initialization block ?
Thanks,
Ayyappan
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.
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.
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
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
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.
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!!