Datawarehouse schema not created.
One answer
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:
Hope it helps,
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,