It's all about the answers!

Ask a question

Error occurred while creating Data warehouse tables in RTC 4.0.0.1


Prasad Annamdasu (15453643) | asked Nov 26 '12, 8:34 a.m.
 An error occurred while creating Data warehouse tables in RTC 4.0.0.1

Using IBM DB2 as database.


ID CRJAZ1745E - An error occurred while creating data warehouse failed.

CRRTC8030E The Creation of the data warehouse failed.

com.ibm.team.repository.common.TeamRepositoryException: Create Temporary Tablespace 32K IN DATABASE  PARTITION GROUP IBMTEMPGROUP PAGESIZE 327688 MANAGED BY SYSTEM USING (" C:\DW") BUFFERPOOLBPTEMP32K at com.ibm.................................




2 answers



permanent link
Kevin Ramer (4.5k8183200) | answered Nov 26 '12, 10:29 a.m.
Hmm.  The "PAGESIZE 327688" I think should be 32768 or 32 K instead.

Also be certain that the ID connecting to the database has SYSADM authority.


Comments
Prasad Annamdasu commented Nov 26 '12, 10:48 a.m.

 Hi Kevin, 


The Database is created with 32K pagesize and the ID has full Permissions.
The other Databases which are created similary are used for JTS & CCM without any errors.


Kevin Ramer commented Nov 26 '12, 10:55 a.m.

So, the 327688 is a typo ?  Is there an SQLXXXXN message in the same vicinity?  If so in a DB2 command window (not for issuing db2 sql) type:  db2 ? SQLXXXXN where the SQL code is the one reported in the log.


Prasad Annamdasu commented Nov 26 '12, 11:21 a.m.

 Hi Kevin, 


There is no SQLXXXXN message in the error.


permanent link
Kevin Ramer (4.5k8183200) | answered Nov 26 '12, 1:53 p.m.
There should be log file somewhere that has the SQL error code and more detail.  Were you doing this via the "setup" page of the Jazz Team Server ?  

Comments
Prasad Annamdasu commented Nov 26 '12, 1:57 p.m.

Hi Kevin, 


Yes. I got this error on the setup page. 


Kevin Ramer commented Nov 26 '12, 2:02 p.m.

Try to find the location of the JTS log file.  Relative to the install I would look at the
files:  server\conf\startup_log4j.properties and server\conf\jts\log4j.properties
Look for this line:

log4j.appender.file.File=

Then locate the file referenced there and open in a text editor.  There should be lots of information there.



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.