Hi , While running the IBOTS , I am getting below error:-
error :-
+++ ThreadID: 1760 : 2011-08-15 13:25:13.265 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: 1760 : 2011-08-15 13:25:13.390 ...Trying main loop again.
+++ ThreadID: 1760 : 2011-08-15 13:25:13.515 ... Sleeping for 4 seconds. +++ ThreadID: 1760 :
2011-08-15 13:25:18.515 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: 1760 : 2011-08-15 13:25:18.625 Terminal Error: Exceeded number of retries.
I have followed the below setps:-
1) In Job manager, Provided the Scheduler Administartor(User/pwd) - Administrator/Blank (I have given same RPD Administrator but left blank, since with pwd
I am not able save the Ibot (these instructions I saw in othr forums)
Provided all other information in Job magaer & save it.
2) Run the cryptoutility..
C:\OracleBI\web\bin>cryptotools credstore -add -infile C:\OracleBIData\web\config\credentialstore.xml
Credential Alias: Admin
Username: Administrator
Password: *************
Do you want to encrypt the password? y/n (y): y
Passphrase for encryption: ******
Do you want to write the passphrase to the xml? y/n (n): n
File "C:\OracleBIData\web\config\credentialstore.xml" exists. Do you want to overwrite it? y/n (y): y
In this also I have given same Administrator user id /pwd tht I have given in Job manager- Administrator/Administrator
My credention xml got updated after running the Crypto utiltity:-
- <sawcs:credential type="usernamePassword" alias="Admin">
<sawcs:username>Administrator</sawcs:username>
- <sawcs:password>
- <xenc:EncryptedData>
...
...
other things
3) Updated the Intance config xml file..
- <CredentialStore>
<CredentialStorage type="file" path="C:\OracleBIData\web\config\credentialstore.xml" passphrase="sceret"/>
</CredentialStore>
4) scusessfuly run the all services ( BI server, Presentation server, Scheduler server , Java host, Oc4j)
5) Created a test Ibot & save it but that IBOT not come as alerts not not sent to recipient & i have recived a above mention error in show Ibots acting on My Behalf.
Please do let me know if I need to do some other steps that I have missed or I have done something wrong.
One more point, When I am providing Administrator password in Job manager that time I am not able to save my Ibot but when I left that password blank in the
Job manager I am bale to save but not able to run & getting above authentication error.
I have followed these forumns :
http://oraclebizint.wordpress.com/2007/09/13/oracle-bi-ee-10133-configuring-delivers-ibots/
501157
Please suggest!!
Thanks in Advance