Forum Stats

  • 3,836,871 Users
  • 2,262,199 Discussions
  • 7,900,132 Comments

Discussions

iBot fails on init block

Hi, I have configured authentification against LDAP. User Administrator is defined at BI Server. When I create and run (as Administrator) an iBot it fails at init block - LDAP authentification. Can somebody help me what is wrong? I might have entered wrong password somewhere in configuration of Scheduler I try to reenter it everywhere where I found it.

Error Message:
+++ ThreadID: 506 : 2008-09-17 08:21:01.220 [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 'sib_Authentication LDAP' is required.* (08004) Error Codes: . Error Codes: AGEGTYVF
+++ ThreadID: 506 : 2008-09-17 08:21:01.254 iBotID: /users/administrator/_ibots/Test1 ...Trying iBot RunCR loop again.
+++ ThreadID: 506 : 2008-09-17 08:21:01.272 ... Sleeping for 8 seconds.
+++ ThreadID: 506 : 2008-09-17 08:21:09.799 [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 'sib_Authentication LDAP' is required. (08004) Error Codes: . Error Codes: AGEGTYVF
+++ ThreadID: 506 : 2008-09-17 08:21:09.830 iBotID: /users/administrator/_ibots/Test1 ...Trying iBot RunCR loop again.
+++ ThreadID: 506 : 2008-09-17 08:21:09.845 ... Sleeping for 6 seconds.
+++ ThreadID: 506 : 2008-09-17 08:21:16.399 [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 'sib_Authentication LDAP' is required. (08004) Error Codes: . Error Codes: AGEGTYVF
+++ ThreadID: 506 : 2008-09-17 08:21:16.419 iBotID: /users/administrator/_ibots/Test1 Exceeded number of request retries.
+++ ThreadID: 1376 : 2008-09-17 08:21:16.437 iBotID: /users/administrator/_ibots/Test1 No Content for user : Administrator
Tagged:

Answers

  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    Could it be that Delivers is running the iBot as Administrator and hence the Init Block kicks in and tries to authenticate the BI Administrator user, which only exists in the BI Server and not in your LDAP server?
  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    It will worth checking if you change the Delivers configuration to use a user name and a password that exists in your LDAP server. You will need to make this user a member of the Administrators group in the BI Server in order to be able to run iBots.
  • 588708
    588708 Member Posts: 117
    The Administrator exists in BI Server only. It is not in LDAP. I am logged in and run iBot in as Administrator.
  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    Could you try running an iBot as a regular user insteasd? Is the problem only happening with the Administrator user?
  • 588708
    588708 Member Posts: 117
    Yes, I can run iBot as regular (LDAP) user. It is not working for Administrator. I am not able to add Administrator to LDAP. The Administrator is able to login to BI server and BI presentation services (web interface).
  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    I don't think it is going to work unless you create the user in LDAP server. I am afraid this is the way your system is setup. If you want LDAP authentication then all your users need to exist there. Delivers runs iBots "on behalf" of users therefore the BI Server will try to authenticate them uding your defined LDAP authentication methods. I will suggest you don't use your OBIEE Administrator user to schedule iBots. Instead create a new user, which should exist in your LDAP server, and make this user part of the BI Server Administrator group. You should have the same priviledges as the Administrator.
    Turribeach
  • 588708
    588708 Member Posts: 117
    Yes, you are right. But I don't understand why I am able to log in as Administrator (LDAP of course fails, but user is logged in) and I am to able to use Administrator with iBots.
    I have already created a user which exists in my LDAP and I use him for iBots.

    Thank you for your answers.
  • Turribeach
    Turribeach Member Posts: 2,019 Silver Trophy
    I think this is because the Administrator user is always login in via the standard authentication method. This is because you need to have at least one user that can login regardless of the authentication method you use. Otherwise you could be locked out of your system if your authentication server is gone and you will not be able to login to change it to something else. It seems, however, that Delivers executes the Init block though so Delivers is not that "smart" in this case...
  • 599618
    599618 Member Posts: 30
    Vlada,

    Try this option on the init block which gets the user information uncheck required for authenication option and restart the services and try to run the ibot.
    Arjun
  • 588708
    588708 Member Posts: 117
    Yes, when I uncheck "required for authentication" then iBot works for Administrator. But I must have this option checked. I solve my problem by creating user wich exists in LDAP, add him to Administrative group and use him for iBots instead of Administrator.

    Have a nice day!
This discussion has been closed.