It's all about the answers!

Ask a question

RTCi repotools.qsh -createTables fails for provisioning


Aaron Allsbrook (161) | asked Aug 13 '09, 3:44 p.m.
retagged Jun 23 '12, 5:35 p.m. by Arne Bister (2.6k12832)
I am getting a failure when attempting to install my followup action onto RTCi. I used the provisioning instructions found in the url below.

https://jazz.net/wiki/bin/view/Main/UsingJazzProvisioner

During my tests the deploy worked fine for my local windows installation but fails for when I try to deploy to production RTCi. I am reasonably confident that my provision profile ini file is correct based on previous errors I had prior to this one.

Any thoughts or recommendations are greatly appreciate.

There error coming back is

/qibm/proddata/rtci/v1.0/standard/jazz/server/repotools.qsh -addTables
Repo Tools, Version 1.0.1.1 - M20090225-1543
Provisioning using "./provision_profiles".
Rational Jazz Team Server for i - Standard
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //ABC.XYZ.COM;hold statements=true;user=xxxxxxxx;password=xxxxxxxx;
Initial database connection successful
Db Product Name: DB2 UDB for AS/400
Db Product Version: 05.04.0000 V5R4m0
Db URL: jdbc:as400://ABC.XYZ.COM;hold statements=true;user=xxxxx;password=xxxxxxxxx;
Jdbc Driver Name: AS/400 Toolbox for Java JDBC Driver
Jdbc Driver Version: 8.8
CRJAZ8192E: Fulltext Index Location: workitemindex/fulltext_index/
The user "ADMIN" has logged in to the database "//ABC.XYZ.COM;hold statements=true;user=xxxxxxxx;password=xxxxxxxx;".
Adding tables to the database "//ABC.XYZ.COM;hold statements=true;user=xxxxxxxx;password=xxxxxxxx;".
Syntax error or access rule violation
SQL: CREATE SCHEMA JAZZREPO01
SQL Exception #1
SQL Message: JAZZREPO01 in *N type *LIB already exists.
SQL State: 42710
Error Code: -601

com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE SCHEMA JAZ
ZREPO01
com.ibm.team.repository.service.internal.db.util.JdbcDB$2: CRJAZ0577I Error preparing or executing statement => CREATE SCHEMA JAZ
ZREPO01
CRJAZ0489I Failed to build the schema "APT_SNPSHT" contributed by bundle "com.ibm.team.datawarehouse.service".
The user "ADMIN" has logged out of the database "//ABC.XYZ.COM;hold statements=true;user=xxxxxxxx;password=xxxxxxxx;".
CRJAZ0489I Failed to build the schema "APT_SNPSHT" contributed by bundle "com.ibm.team.datawarehouse.service".

One answer



permanent link
Aaron Allsbrook (161) | answered Aug 19 '09, 6:53 p.m.
Never really figured out the issue but thanks to support we decided that a repotools -addTables was not required for this simple work item save customization.

Resetting the server had everything up and running. https://abc.xyz.ca:31001/jazz/admin/cmd/requestReset

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.