Error after change teamserver.properties in QA folder
HI,
After I went to D:\Program Files\Jazz Team Server\server\conf\qm to configure the filename teamserver.properties as below: # # DB2 configuration # # Comment out above lines, uncomment the following six lines and customize example location to use DB2 com.ibm.team.repository.db.vendor = DB2 com.ibm.team.repository.db.jdbc.location=//csux.esa.dol.gov:50001/QADB:user=zxom;password={password}; com.ibm.team.repository.db.jdbc.password=tiwj134& #com.ibm.team.datawarehouse.db.vendor = DB2 #com.ibm.team.datawarehouse.db.jdbc.location=//localhost:50000/QADB:user=db2admin;password={password}; #com.ibm.team.datawarehouse.db.jdbc.password=db2admin # The path where the warehouse tablespace should be created #com.ibm.team.datawarehouse.db.base.folder = /jazzdw # The database user for whom proper permissions will be granted #com.ibm.team.datawarehouse.report.user = RPTUSER # DB2 requires a path where the content tablespace should be created, examples for Win and Linux follow #com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace # Configure the size of the tablespace to be created, in 4K pages. # This is a hard limit and will need to be raised for a production database. # Your DB2 DBA will need to monitor the utilization of the CONTENTS tablespace and grow it as needed. # Defaulting to 250,000 pages, or 1GB. #500com.ibm.team.repository.db.db2.content.tablespace.numpages=250000 After I finish configuration, I ran the following command to create table and get this error. I did catalog database to connect to database server in AIX server. Please assist me on this. Thanks |
2 answers
I am sorry I forgot to post error message. Here is an error. Anyone knows how to troubleshoot this error or have you seen this before? We have given DB user admin privilege to create table and increase table-size to 16K as error said below; however we still have error. Please help me. Thanks
============================================== D:\Program Files\Jazz Team Server\server>repotools-qm createTables -clean Repo Tools Provisioning using "D:\Program Files\Jazz Team Server\server\conf\qm\provision_p rofiles". Quality Management - Core Libraries, Version 3.0 M10 (I20101008_2208) Change and Configuration Management - Core Libraries, Version 3.0 RC1 (RTC-I20 101008-1724) Jazz Foundation - Core Libraries, Version 3.0 RC1 (RJF-I20101008-1431) CRJAZ1363I Loading the configuration from "file:conf/qm/teamserver.properties". CRJAZ1781W The Public URI Root has not been set for this application. Enter the public URI in the advanced properties of the administration user interface for t his application. Consider setting this URI to enforce consistent URL management in the application. The public URI represents the URL that all clients must use to access the application. This URL can be for the front-end proxy server, or t he application server if a front-end server does not exist. CRJAZ1365I The server is attempting to connect to the following database: "//csu x.xxx.xxx.gov:50003/ENRQ:user=xxxxxxxx;password=xxxxxxxx;" CRJAZ1364I The connection to the following database was successful: Db Product Name: DB2/AIX64 Db Product Version: SQL09054 Db URL: jdbc:db2://csux.xxx.xxx.gov:50003/ENRQ:user=xxxxxxxx;password= xxxxxxxx; Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture Jdbc Driver Version: 3.57.82 CRJAZ8192I: Fulltext Index Location: D:\Program Files\Jazz Team Server\server\co nf\qm\indices\workitemindex\fulltext_index\fulltext_index Creating the tables for the database "//csux.xxx.xxx.gov:50003/ENRQ:user =xxxxxxxx;password=xxxxxxxx;" with indices. CRJAZ1245I The database user does not have the required privileges to perform th e specified operation. Check with your database administrator or your database v endor product documentation and ensure the user account has appropriate authorit y to read, write, and administer tables. CRJAZ1322E The DB2 database was created with 4096 page size. To create Jazz sche ma and tables, the database must be created with at least an 8K page size. You n eed to drop and recreate the database with 8K page size. Refer to the DB2 docume ntation on how to create a database with an 8K page size The database tables were not created. |
Your user that you specified to access the database does not have
authority to create the tables. You need to grant the user sufficient authority to be able to create tables. I generally use the same user that created the database on the server as the one that has access to the database from the RQM side. On 10/21/10 2:52 PM, johnle02 wrote: I am sorry I forgot to post error message. Here is an error. Anyone |
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.