It's all about the answers!

Ask a question

Datawarehouse schema not created.


Edward Scarberry (11010) | asked Oct 31 '13, 6:38 p.m.
When we run repotools-jts -createWarehouse it completes successfully put when we got to the database in Oracle the schema and tablespaces are not there.

One answer



permanent link
Benjamin Silverman (4.1k610) | answered Oct 31 '13, 6:45 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi Edward,

If you're going to use repotools to create the warehouse, you need to have defined the Oracle DB connection string in your teamserver.properties file.  Otherwise a Derby data warehouse will be created by default.  Have you specified the connection string for the Oracle DW in your teamserver.properties as outlined in this InfoCenter topic?

Note, that topic contains the steps for creating both the JTS objects as well as the Data Warehouse objects.  You can skip the steps that reference the JTS database if it already exists paying attention to only these properties:
com.ibm.team.datawarehouse.db.vendor = ORACLE
com.ibm.team.datawarehouse.db.jdbc.location=thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
com.ibm.team.datawarehouse.db.jdbc.password=jazzDBpswd
com.ibm.team.datawarehouse.db.base.folder = /jazzdw
com.ibm.team.datawarehouse.report.user = RPTUSER

Hope it helps,

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.