Solution ID: prim84154
How To: Manually Configure Jackrabbit Content Repository for use with Contract Management
Status: Reviewed
Version(s): 13.0

Problem: How To: Manually Configure Jackrabbit Content Repository for use with Contract Management
Problem: What are the default Jackrabbit adminconfig settings?
Problem: Jackrabbit configuration settings are not populated when creating a new EXPADMIN database after Contract Management 13 has already been installed.
Problem: Was using Oracle as the database server type, but recently migrated to MS SQL.  What are the settings for Content Repository using Jackrabbit with MS SQL?
Problem: Was using MS SQL as the database server type, but recently migrated to Oracle.  What are the settings for Content Repository using Jackrabbit with Oracle?
Fix:

1. Launch the Primavera Administrator, also called the Admin Config, via <drive letter>:\Program Files\Oracle\ContractManagement\utility\CMAdminConfig\admincm.cmd


2. Provide the appropriate user credentials for the Contract Management EXPADMIN database/schema.


The default EXPADMIN username and password depends on the database platform.



  • Oracle expadmin/expadmin

  • MSSQL exp/sql

3. Expand Content Repository and enter CRType: Jackrabbit


4. Expand Apache Jackrabbit and enter the applicable settings which depend on the database server platform in use:


Oracle - Jackrabbit admincm.cmd Settings:


URL: jdbc:oracle:thin:@<database server name or ip address>:<database port>:<Oracle SID>


Example: jdbc:oracle:thin:@localhost:1521:XE


Database User Name: EXPADMIN


Database Password: expadmin


Repository Home: C:/PROGRA~1/Oracle/CONTRA~1//RepositoryHome


Admin User Name: EXPADMIN


Admin Password: expadmin


Note: There are two forward slashes preceding the RepositoryHome folder. This is not a typographical error.


MS SQL Server - Jackrabbit admincm.cmd Settings:


URL: jdbc:sqlserver://<database server name or IP address>:<database port>;database=EXPADMIN;


Example: jdbc:sqlserver://localhost:1433;database=EXPADMIN;


Database User Name: exp


Database Password: sql


Repository Home: c:/PROGRA~1/Oracle/CONTRA~1//RepositoryHome


Admin User Name: exp


Admin Password: sql


Note: There are two forward slashes preceding the RepositoryHome folder. This is not a typographical error.


5. Click Save Changes.


Note: When using Jackrabbit as the Contract Management Repository, the attachment and version files are stored in various tables within the EXPADMIN schema as Binary Large Objects (BLOBS).