RTCi repotools.qsh -createTables fails for provisioning
Aaron Allsbrook (16●1)
| asked Aug 13 '09, 3:44 p.m.
retagged Jun 23 '12, 5:35 p.m. by Arne Bister (2.6k●1●28●32)
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
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
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.