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.5k6171190) | 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.5k6171190) | 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.