CLM 4.0.4 - Tables missing in Data Warehouse after using manual DDL scripts to setup
Sean G Wilbur (872●2●24●21)
| asked Nov 18 '13, 11:37 p.m.
JAZZ DEVELOPER edited Nov 18 '13, 11:38 p.m.
Setting up a new 4.0.4 instance on SQL Server 2008 and followed the guide at
to generate the DDLs, setup was happy and I was able to proceed without errors. (Only setting up JTS and CCM here)
1-setupCoreSpace.sql 2-createCoreSchema.sql ( too big for one pastebin: part1 , part2 ) 3-grantCoreSchemaReadAccess.sql (not used only one user here) 4-populateDateDimension.sql (7 MB of dimensional data) 5-setupCalmSpace.sql (empty file) 6-createCalmSchema.sql 7-grantCalmSchemaReadAccess.sql (not used only one user here)
Now when I trigger the ETLs, I get errors in both JTS and CCM.
JTS
Repository - invalid object REPOSITORY_SNAPSHOT.INTEGRAL_RANGE
CCM
* Build -invalid object BUILD_SNAPSHOT.BUILD_RESULTS
* SCM - HTTP 500
* APT - invalid object APT_SNAPSHOT.TEAM_CAPACITY
* Repository - invalid object REPOSITORY_SNAPSHOT.INTEGRAL_RANGE
Reviewing the DDLs generated, I don't see any mention of these tables or views so not sure where they were supposed to get created ? Let me know if this is expected and I missed a step somewhere or if this is a defect ?
-Sean
|
Accepted answer
Sean, please try repotools -addTables on both the JTs and CCM. Also please check that all the server services are activated and no errors are listed in the server diagnostics page. To check that all services are activated for e.g., on the JTS, try: https://server:port/jts/admin?internal=true#action=com.ibm.team.repository.admin.componentStatus for CCM: https://server:port/ccm/admin?internal=true#action=com.ibm.team.repository.admin.componentStatus Sean G Wilbur selected this answer as the correct answer
Comments Both componentStatus pages were showing all green before, stopped the server and run the addTables and restarted, Success! Now the ETLs work!
I have not tried to reproduce this but shouldn't all the tables have been created by the original call to createTables as this is a vew instance not an upgrade ? Either way this may be something to follow up on in the future.
Thank you for your help!
Sean, internally the server is composed of many plugins. The schema is contributed by multiple plugins. Each plugin contributes its own tables. My guess during the initial addTables run, the plugins contributing the datamart schema did not activate correctly. |
2 other answers
Hi Wilbur, I follow below procedure... hope it helps you. (I have multiple DWs on same DB so, I use schema prefix.)
1. Create user by name RPTUSER_PRD10 on the DB. - With default privileges.
2. Create the user DWETLUSER_DEV with less permission's as below for running data collection (ETL) jobs.
GRANT DBA TO DWETLUSER_PRD10;
GRANT CREATE SESSION TO DWETLUSER_PRD10;
NOTE: DBA PRIVILEGE WILL BE GRANTED UNTIL CONFIGURATION IS COMPLETED. SINCE WE HAVE RESTRICTIONS ON SCHEMA USER HAVING DBA PREVILEGE.
3. Start jts/setup, configure the DataWarehouse with above details. (Select the Checkbox the "Do not configure DW at this time" option)
CREATE
CREATE USER RICMUSER_PRD10 PROFILE DEFAULT
GRANT CREATE SESSION TO RICMUSER_PRD10;
NOTE: PROVIDE DBA PRIVILEGE TO DWETLUSER_PRD10 & RICMUSER_PRD10 UNTIL RRDI CONFIGURATION IS COMPLETED.
Ensure that the user RICMUSER_PRD10 account that accesses the database has permission to do the following:
5. Stop RTC instance & generate DDLs [ ./repotools-jts.sh -generateWarehouseDDLScripts ]
6. Once above SQLs are executed, execute below statements.
ALTER USER DWETLUSER_PRD10 TEMPORARY TABLESPACE RIS_TEMP;
BEGIN
BEGIN
7. Go through jts setup & configure above DW details. (uncheck the the "do not configure DW at this time" option)
Regards, Nagesh S |
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.