BusinessObjects Board

Repository Storage

building reports desktopintelligence
#1

Hi

This is Raghu.

In XIR2 How the repository stored. and when ever i forgot all the pwds of business objects, including admin. then how can i get those passwors back.

adv thanks

ragupothineni (BOB member since 2007-07-15)

Bo Passwords
#2

XIR2 CMS repository DB is denormalised and most things are in binary or encoded.
CI_SYSTEMOBJECTS has info about Groups, Users and Servers etc.
You cannot use normal SQL tools to retrieve data. Use Query Builder to translate the sql and return data.
Get the objectid first as

select SI_NAME, SI_ID from CI_SYSTEMOBJECTS where SI_NAME= 'Administrator' and SI_KIND= 'User'

Then access the CMS database and delete ObjectID returned by the above query from the CMS_INFOOBJECTS5 table and restart CMS.

.

haider :es: (BOB member since 2005-07-18)

#3

Thanks for ur reply.

as per ur reply all the repository is strored in the forms of tables.

by these table u can gt the any data from the data base itself .

rpothineni :india: (BOB member since 2008-01-02)

#4

Please spell your words completely. What is your question? Please take some time and read it yourself and let me know if it is making sense to you.

zack :us: (BOB member since 2007-08-02)