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.
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 file.  Otherwise a Derby data warehouse will be created by default.  Have you specified the connection string for the Oracle DW in your 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: = ORACLE{password}@// = /jazzdw = 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.