Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Getting CCM_DATA Table space error

Questions
Tags
Users
Badges
nannette Mori
(50●1●9●85) Sep 12 '18, 1:49 p.m.

We have 3 projects on a ccm server.  We are using an Oracle Database and use RTC 6.0.3.

Users were receiving Tablespace errors when trying to change flow targets and using command line SCM.  The error

was ora-01654:unable to extend index.SCM._COMP_SS_PARENT in tablespace CCM_DATA

Another user was trying to replace a component in his workspace and he received the following error:

ora-01654:unable to extend index.SCM._COMP_SS_STATE by 8192 in tablespace CCM_DATA.

We were able to fix the problem by extending the tablespace.  Our Oracle DBA stated the RTC Tablespace is growing rapidly, the largest is tablespace is 500GB.  We continue to increase the tablespace, however we need to understand what in RTC is causing this rapid growth.

0 votes

1 answer
1,414 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) edited
Sep 13 '18, 3:02 a.m.
My best guess would be that the typical database settings are to allow expansion of tables and table spaces and this is either switched off in your DB or the DB has not enough disk space to do so. You should not see these errors. It should be possible to monitor the DB to see when it needs to be increased or allow it to increase automatically.
 
Please 
1. Contact your DB administrator to have a look at their logs 
2. Check the CCM logs
3. Contact IBM support if 1. does not help - note Support likely have to talk to your DB administrator so don't skip step 1.

With respect to the reason why the database is growing you need to contact support. You are likely adding more and more data. Check for binaries being checked in, attachment uploads to work items and build results with attached files.

0 votes

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Sep 12 '18, 1:49 p.m.

Question was seen: 1,414 times

Last updated: Sep 13 '18, 3:02 a.m.

Confirmation Cancel Confirm