BOMain.key issue

system · August 8, 2008, 5:58am

Hi guys.

At my work we have multiple Business Objects environments (5.1, 6.5 and BoXi sp2r2).

From my work PC I have Designer installed for all three environments and Supervisor installed for 5.1 and 6.5.

I have been working using this setup for a couple of years.

A few weeks ago I started getting the error, “Cannot retrieve the time reference for the security domain. (USR0014)” when attempting to log into Business Objects Full Client/Supervisor or Designer in my 5.1 environment.

The 5.1 repository is setup on a SQL Server 2000 database.
No other administrators are currently experiencing the same issue.

I have seen many posts regarding this issue I am having, but none of the resolutions (that I have found) have been able to resolve my particular issue.

Amongst other things I have tried:

Deleting and re-installing the 5.1 Supervisor module.
Copying the BOMain.key file from a working machine.
Running a Safe Recovery from the Installer application.
After Defining the Repository Connection (and testing successfully) I click next and get the error message “No security domain exists for this connection. {ADW0010)”.
I have compared my ODBC setup multiple times with other machines that work and even checked that the ODBC drivers are the same, which they are.
I have run the BOLOGAPP.exe application. Attached below is the complete output of that.

Module <<General Module>> Type <<Miscellaneous>> Level <<File System Information>>
    8/08/2008 3:47:56 PM    0)
Module <<General Module>> Type <<Configuration Info>> Level <<Language Settings>>
   8/08/2008 3:47:56 PM    Language Id:17742 / postfix:EN / long name:English / dir - C:\Program Files\Business Objects\BusinessObjects 5.0\Language
Module <<General Module>> Type <<Miscellaneous>> Level <<File System Information>>
    8/08/2008 3:47:56 PM    2)
Module <<General Module>> Type <<Miscellaneous>> Level <<Agent Information>>
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>kagtdac.dll<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>$kagtldb.dll$cube50.dll$<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>kagtuser.dll<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>kagtres.dll<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>kagtsess.dll<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>kagtsbo.dll<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>#kbus.dll#kgtrep50.dll#REPOSITORY#Agent Reposit#<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>!kbus.dll!kagtunv.dll!UNIVERS!Universe!UNVRES!Universe Resource!USEROBJECTS!Universe User Objects!<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>#kbus.dll#kagtux50.dll#UX#Universe Export#<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>kagtsecu.dll<<
   8/08/2008 3:47:56 PM    From Bus Registered Agent: >>#kbus.dll#kagtbcli.dll#BATCHCLIENT#Batch Client#<<
Module <<SQLBO Module>> Type <<Manager SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [SQLBO Manager ] Entering GetNewNetwork FunctionODBC
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Connection ]0XA5AB10    Alloc Connect returned:0
Module <<Debug Module>> Type <<>> Level <<>>
    8/08/2008 3:47:56 PM    
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=1,SQLBOConnect=0,RDBMSConnect=0  :  Entering Connect Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Connection ]0XA5AB10    Driver Connect returned:1
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Connection ]0XA5AB10   Txn capable:2
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Connection ]0XA5AB10   Txn isolation asked:0
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=1,SQLBOConnect=1,RDBMSConnect=1  :  The connection is successful.
Module <<SQLBO Module>> Type <<Manager SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [SQLBO Manager ] Entering GetNewCursor Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Cursor ]0X0       ,0X34E460    Entering Open Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8    Alloc statement returned:0
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8   User : BOSystem
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Cursor ]0XA751A8  ,0X34E460    Entering CursorGetOption Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Cursor ]0XA751A8  ,0X34E460    Entering Free Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Cursor ]0XA751A8  ,0X34E460    Entering GetRDBMS_Date Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8   select {fn convert({fn curdate()},SQL_TIMESTAMP)} from OBJ_M_MAGICID
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8    Prepare statement returned:0
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8    Exec statement returned:-1
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8   select {fn convert({fn curtime()},SQL_TIMESTAMP)} from OBJ_M_MAGICID
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8    Prepare statement returned:0
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Driver Cursor ]0XA751A8    Exec statement returned:-1
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Cursor ]0XA751A8  ,0X34E460    Entering Close Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Cursor ]0XA751A8  ,0X34E460    Entering Free Function
Module <<SQLBO Module>> Type <<Manager SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [SQLBO Manager ] Entering FreeCursor Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=1,SQLBOConnect=1,RDBMSConnect=1  : InCleanUp
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=1,SQLBOConnect=1,RDBMSConnect=1  : InCleanUp : After MustBeDisconnected
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=1,SQLBOConnect=1,RDBMSConnect=1  :  Entering Disconnect Function
Module <<SQLBO Module>> Type <<Manager SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [SQLBO Manager ] Entering FreeConnection Function
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=0,SQLBOConnect=0,RDBMSConnect=1  : InCleanUp
Module <<SQLBO Module>> Type <<SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [Generic Connection]0XA5AB10  ,0X34F500   bUsed=0,SQLBOConnect=0,RDBMSConnect=1  : InCleanUp : After MustBeDisconnected
Module <<SQLBO Module>> Type <<Manager SQLBO>> Level <<Others>>
    8/08/2008 3:48:00 PM    [SQLBO Manager ] Entering FreeNetwork Function

From the above it appears to me to be a problem running a select statement on the database when attempting to log in.
“select {fn convert({fn curdate()},SQL_TIMESTAMP)} from OBJ_M_MAGICID”

When I log into query analyser from my machine using the same Key logon credentials I can run the statement fine.

After this analysis it would appear to me that my problems are ODBC related, but I am out of ideas as to what else I can configure with an ODBC connection.

Does anybody have any other suggestions they could offer?

Thanks in advance for any help provided with this issue.

Cheers!

veybo (BOB member since 2006-08-22)

system · August 8, 2008, 8:07am

Hi

It sounds like youve already been exhaustive with your investigation in to the problem youre describing

Its clutching at straws a little, but have you tried to ping the repository database from your pc? The other thing to look at would be removing your hosts file and replacing it with a copy from another machine you know to work :?

Good luck

ShaneB (BOB member since 2005-02-25)

system · August 11, 2008, 1:12am

Thanks for the suggestions ShaneB.

I can ping the BO server successfully from my machine.
I tried mucking around with the hosts file also, but to no avail.

Does anybody have any other suggestions that they think I could try?

Cheers!

veybo (BOB member since 2006-08-22)

system · August 11, 2008, 10:23pm

Just to be sure you aren’t using terms differently - pinging the BO server (where Infoview/WebIntelligence is running) is not likely to be the same as pinging the database that has the repository.

ShaneB had asked you if you could ping the database where the BusinessObjects 5.x repository exists (which consists of over 50 tables that begin with names such as OBJ_M_, OBJ_X_DOCUMENTS and UNV_ )

Anita Craig (BOB member since 2002-06-17)

system · August 11, 2008, 11:42pm

Thanks Anita, you are right, I meant to say BO Repository, not BO server.

Cheers!

veybo (BOB member since 2006-08-22)

system · May 14, 2009, 12:33am

For what it’s worth I recently had to trash my Windows profile on my machine due to an Outlook issue.

This has resolved my issue with running Business Objects 5.1 using the BoMain.key.

Cheers!

veybo (BOB member since 2006-08-22)