Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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".

0 votes



3 answers

Permanent link
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.

0 votes


Permanent link
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

0 votes


Permanent link
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

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,938

Question asked: Dec 15 '08, 6:18 p.m.

Question was seen: 8,149 times

Last updated: Dec 15 '08, 6:18 p.m.

Confirmation Cancel Confirm