I was recently at a client site configuring scheduler on their development environment to set up ibots . The scheduler was configured as per the documentation and the Scheduler service started up just fine. We then went on to create ibots and selected multiple users as the recipients of the Ibot. 
However, the ibots executed successfully only for the Administrator and threw the following error for all other recipients.
+++ ThreadID: 334 : 2009-04-12 21:44:43.359
[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:U9IM8TACOdbc 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 emp 1 in repository Star: invalid user/password. (08004)
I should point out at this point that we had External Table Authentication configured for authenticating users into the application using the following initialization block:
select login from employee_d where login=’:USER’ and auth_id= ‘:PASSWORD’
The fix for this issue though available in the documentation, could be easily overlooked.
The solution is to modify your Authentication initialization block as follows:
select login from employee_d where login=’:USER’ NQS_PASSWORD_CLAUSE (and auth_id= ‘:PASSWORD’)NQS_PASSWORD_CLAUSE
It is important that you use the NQS_PASSWORD_CLAUSE term in order to successfully schedule Ibots for users who are authenticated using external table authentication.
Posts
