Extending the data warehouse
Hi,
I've been using the guidance in this wiki page https://jazz.net/wiki/bin/view/Main/DataWarehouseExtending to create my own snapshot. In the "Administer Data Warehouse" page, I can see my new snapshot in the drop down list box and if I select the snapshot and click "List All Tables", the only table in the snapshot is listed correctly with all the fields. But when I click on "Update Snapshot Data", I get the exception below. 14:22:01,447 WARN sqlExceptionLogger - Syntax error or access rule violation SQL: SELECT MAX(FACT_ID) FROM CM_BM_TM_WRKTM_PM_NMRTNSSNPSHT.ENUMERATIONS Parameter 0: SELECT MAX(FACT_ID) FROM CM_BM_TM_WRKTM_PM_NMRTNSSNPSHT.ENUMERATIONS SQL Exception #1 SQL Message: Schema 'CM_BM_TM_WRKTM_PM_NMRTNSSNPSHT' does not exist SQL State: 42Y07 Error Code: 20000 java.sql.SQLException: Schema 'CM_BM_TM_WRKTM_PM_NMRTNSSNPSHT' does not exist at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) I also ran "repotools -addTables" but from the exception it seems that the table is not being created. Here is the output from "repotools": C:\Rational\Customers\CountyLA\jazz\server>repotools -addTables Repo Tools, Version 1.0.1 - I20081024-1335 Provisioning using "C:\Rational\Customers\CountyLA\jazz\server\\provision_profil es". Rational Jazz Team Server - Standard Loading configuration from "file:teamserver.properties". Attempting Initial Database Connection Using Db Name/Location: repositoryDB Initial database connection successful Db Product Name: Apache Derby Db Product Version: 10.3.3.1 - (677131) Db URL: jdbc:derby:repositoryDB Jdbc Driver Name: Apache Derby Embedded JDBC Driver Jdbc Driver Version: 10.3.3.1 - (677131) Fulltext Index Location: workitemindex\fulltext_index\ The user "ADMIN" has logged in to the database "repositoryDB". Adding tables to the database "repositoryDB". Database tables were added successfully. The user "ADMIN" has logged out of the database "repositoryDB". |
3 answers
Hi Luis, can you please tell me the actual names of the snapshot and the table that you were trying to use. We have an algorithm that mangles the names, so they would comply with the name length constraints of the underlying data base engine. In the mean while, can you please try shorter names.
|
|
Hi Rafik, I was including the namespace I've been using for all the custom ids in the snapshot name, so it was in fact big. I changed it now to ENUMERATIONS_SNAPSHOT but I still get the same error:
08:55:44,200 WARN sqlExceptionLogger - Syntax error or access rule violation SQL: SELECT MAX(FACT_ID) FROM ENUMERATIONS_SNAPSHOT.ENUMERATIONS Parameter 0: SELECT MAX(FACT_ID) FROM ENUMERATIONS_SNAPSHOT.ENUMERATIONS SQL Exception #1 SQL Message: Schema 'ENUMERATIONS_SNAPSHOT' does not exist SQL State: 42Y07 Error Code: 20000 java.sql.SQLException: Schema 'ENUMERATIONS_SNAPSHOT' does not exist at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) Thanks |
|
The issue was that the plug-in to create the snapshot had not been deployed to the Jazz server. Once I deployed the plug-in and ran "repotools -addTables", the snapshot was created and I was able to update the snapshot.
Thanks |