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