Locked out of SuperVisor (Login Disabled HELP) 1

[Guest_imported]

Some of you may have experienced this in the past, I have fallen victim of the classic 3 failed login attempts disables the SUPERVISOR login.

Does anyone know how to resolve this issue, currently I cannot think of anyway to reset the login for supervisor.

Signed
Locked-Out (brian)

 

[blom0344]

Hello Brian,

There is no easy way out of such a mess. Contact Business Objects so they can reset the account. Alternative would be to start all over again from scratch.

A bit of advice (for you regrettably too late), never ever use Business Objects without having first created at least 2 supervisor accounts. My second account/password is stored in our safe, in case I have a black-out.

 

[wordoftheday]

don't rush into starting from scratch !
By resetting some values in tables you enable the account easily. pls contact your BO support people as also suggested by 'blom0344'. They will give the needed info.

 

[PC017]

You dont need to contact BusinessObjects Support.

You can run an update query on the OBJ_M_ACTOR table in the repoistory to be able to reset the account password and remove the block and reset the password. I'm not in the office today so doing this from memory so the table column names me not be exactly accurate.

Update OBJ_M_ACTOR
Set OBJ_M_PASSWORD='',
Set OBJ_M_STATUS=1
where OBJ_M_ACTORNAME='NAME OF SUPERVISOR LOGIN'

The will reset the password to blank and the obj_m_status will set itself to a "new" user.

If this doesnt work let me know at Paul.Cairns@WarnerBros.com and I'll give you the exact column names and values they should be set to.

Hope this helps
Regards
Paul

 

[somalia]

Paul,
since u seem knowledgable about repository tables could u please help me with a problem I have.
I am trying to retrive users, their groups and their accessible universes from a default uni mapped to the repo tables.For users and groups it seems fine but when I add status its analysing forever without fetching the results.I thought that the repo uni design done by BO people is perfect.Please help.
Is there any other way to retrieve this same data.

 

[blom0344]

Hello Somalia,

A universe on the repository tables can , I imagine cause a bit of self-referencing. Did you give any idea to linking the required tables in Access and then trying to run a query? T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[PC017]

Hi Somalia,

I have a universe that I built to do exactly this. You need to do a decode on the sttus to make it into something meaningful...

Drop me a note at Paul.Cairns@WarnerBros.com and I'll send it on to you.

Cheers
Paul Paul.Cairns@Warnerbros.com

 

[skrandel]

Another option is the print command in Supervisor. If you print to a table, then you can build a report from the resulting text file.

You should experiment with it and see if it does what you looking for.