in BO module, you forgot all password even all user in
business object, designer, supervisor, gen.supervisor
everythicg, how to you recover your datas?
Answer / ravikumar sajja
You can change supervisor passoward first using below steps
and then change all the users passwords using supervisor.
Warning: Direct manipulation of the repository tables can
cause damage to your repository and will void your support
contract. Do so at your own risk.
If you don't have a second general supervisor, you could
try the following SQL run against the security domain
database:
Code:
Update OBJ_M_ACTOR
Set M_ACTOR_C_PASSWORD = NULL
Where M_ACTOR_C_NAME = <username of general supervisor>;
This will set the password for the general supervisor to
null, and therefore the next time you login, you will not
need to enter a password. It is recommended that a password
is given asap via the supervisor module.
You will also have to set the status of the user login,
otherwise even with a null password BusObj will not let you
log in.
The status column is in OBJ_M_ACTOR and is called
M_ACTOR_N_STATUS. If you set this flag to 1 along with
setting the password to null then you should be okay. If
this still doesn't work, make sure you have commited the
database update
| Is This Answer Correct ? | 7 Yes | 0 No |
Draw the architecture of traps?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
What is BOMain.Key?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is the size of data base?
how to link 3 fact tables
Can Bo generates the Report from the cubical data Explain?
Report have 10000 records,how to restrict the end user to 1000 Records?
How to Implement the the Built-in Strategy Script in BO Designer?
how many micro cubes can a report can have
what is isolated joins in check integrity
Explain difference between zabo and webi?