It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,193

question asked: Mar 16 '11, 1:53 a.m.
question was seen: 5,232 times
last updated: Mar 16 '11, 1:53 a.m.

Related questions

Clearing system messages (autoclean doesn't work)

0
Toby Rahilly (26●2●1) | asked Mar 16 '11, 1:53 a.m.
Hi,

The BF_MESSAGE_TRANSLATED table is currently taking 6GB of space, and build forge has become to slow be usable.

I have tried setting all the autoclean settings to 1 to no effect. Even after waiting a day (is this required?).

How can I clear out the system messages? Is it safe to manually clear the database tables? If so which ones should I clear?

I don't care about keeping any of the history.

I am using Build Forge 7.1.1.0.0.0125 with DB2 on Windows Xp sp3

Thanks for any help,
Toby

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Robert haig (1.0k●1●6) | answered Mar 16 '11, 2:00 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Hi,

The BF_MESSAGE_TRANSLATED table is currently taking 6GB of space, and build forge has become to slow be usable.

I have tried setting all the autoclean settings to 1 to no effect. Even after waiting a day (is this required?).

How can I clear out the system messages? Is it safe to manually clear the database tables? If so which ones should I clear?

I don't care about keeping any of the history.

I am using Build Forge 7.1.1.0.0.0125 with DB2 on Windows Xp sp3

Thanks for any help,
Toby


yes, that is a known issue that was fixed in one of the later 7.1.1.x releases.

there are 3 bf_messages tables that you should clean out if you want to clear these tables before you upgrade (which I highly recommend). Clean out bf_messages, bf_messages_translated, and bf_messagearg. Make sure you have enough transaction log space to do this before your start or it will fail and rollback. (speak with your DBA about that part)

then go look at https://jazz.net/downloads/rational-build-forge/releases/7.1.2.1 and investigate an upgrade.
0
permanent link
Toby Rahilly (26●2●1) | answered Mar 18 '11, 2:58 a.m.
Thanks! that worked well and now Build forge has good performance.

However after the upgrade to 7.1.2.1 I am experiencing a new problem when connecting from a remote machine. I have detailed the issue in a new thread here:

http://jazz.net/forums/viewtopic.php?p=52903

Thanks a ton,
Toby

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.