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 Posted / 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 |
Post New Answer View All Answers
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what is the difference between slice and dice and cross tab report?
What is Indexing? how did u implement indexing?
Can more than 1 metric be applied on an analytic in business objects?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What is difference between webi and infoview?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain about a task that really tested your analytical abilities?
What task is 98% of the required work of a business analyst?
Explain difference between zabo and webi?
Which versions are used in the bo dashboard work?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How to create Index to the table in the universe designer and how it improves the Query performence
What are the steps to be taken to schedule the report?