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 |
How we can add a comment in universe...?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain is data mart?
How to get top 5 rows of a selected column?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the general issues in migration process?
When is the Repository created?
please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.
Can we Save (save as) WEBI Doc as DESKI?
how to connect the hyperlink in webi reports?
i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
WHAT IS CARDINALITIES OF JOIN?