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.