This information is shared , in case, someone loses the root password for ARIS Business Publisher.
ARIS Business Publisher can be configured/installed in two ways:
1. Using Standard DBMS Mode (Built in database)
2. Utlizing separate Oralce or MS SQL database server
If your organization is using the later configuration (separate database server), and you forget the root password for ARIS Business Publisher, then you can reset the password of root by using these steps:
STEP1: Make backup of your BP Database, by default the database name is ARISBP71 unless you have customized this to some other name during BP Server installation.
STEP2: Stop BP Server (not the database server)
STEP3: Login to the ORACLE/MSSQL/DB2 database and locate BP database ( assuming MS SQL Database with default ARIS BP database name):
- Database for ARIS Business Publisher: <ARISBP71>
- Table Name: ARISBPDATA.bpsysuser
Search for <root> entry and modify the password with this value <dc76e9f0c0006e8f919e0c515c66dbba3982f785>
STEP4: Restart BP Server
The value which you have modified in the password field is the hash code + salt for <root> password (by default root account has <root> password).
Now you can login to the BP Server by using root account with password <root>. Do not forget to change your root account password.
Adnan,
your hack made my day, thank's a lot!
Two points made me curious. For one, the help-manual within the BP states that the default pwd is "BPADMIN"
For the other, ARIS support provided me with an alternative solution(?) that did not work in my case:
- After shutting down all corresponding services, you edit <ARIS-Install-Dir>\server\property\properties.xml.
- There, find the entry starting with "<property key="businesspublisher.BP_PASSWORD..."
- Replace the string there with 799187e5230b2b645b16007564c10eeeb6afc76e.
Unfortunately, ARIS support did not provide the clear text equivalent of this hash code. My first guess was "BPADMIN", I also tried "root", neither worked.
If someone can comment on the two strategies? I am sure that I missed the major part of the solution ARIS support had in mind...
Stefan
P.S. Instead of manually editing DB-entries, you can do it the way it should happen (i.e. it works also without a DB-Management Console).
The SQL is:
UPDATE BPSYS_USER SET PASSWORD = 'dc76e9f0c0006e8f919e0c515c66dbba3982f785' WHERE LOGIN = 'root'
<BPADMIN> is the password for BP Administrator on business architect linking to business publisher so you need this password during publishing. While <root> is the password for <root> account on Business Publisher so that you can login as administrator to configure profiles, user group settings, create users, ldap synchronization.
Hi Adnan Shahab,
Please let me know if there is a way to delete the users information i.e. the details of the users who have already accessed the publisher.
The current process is to login to the ROOT and delete one by one from the users module. But we want to clean up all the users.
Thanks in advance
Hey Rune,
Thank you for your time answering my question!
We need to reset password of the ARIS BP root/root in order to be able to display to users new Profile.
When the user want to logging to the publisher with the url:
and choose the "Anonymous Access" he cant see the new profile that is attached to a new DB.
(we had an earlier issue in the ARIS Designer and we copied the DB to new one but kept the original name, in addition we did export publish and choose the option "Update", We are using LDAP, with built in DB ).
I am in a dead end :( so i will appreciate any help
Best Regard,
Sima