It's all about the answers!

Ask a question

How long can executed CLOB migration after update Build Forge?


ruslan luchnikov (111) | asked Jul 15 '13, 5:11 a.m.
edited Jul 15 '13, 5:16 a.m. by Vladimir Amelin (70472226)
Hi, all
 I trying to update Build Forge from 7.1.1.4 to 7.1.3.5. Update completed Ok. But CLOB migration  is performed already 5 days. How to define how many it will go?

Thanks for advice!

One answer



permanent link
Ryan Ruscett (1.0k413) | answered Jul 15 '13, 7:43 a.m.
The Character Large Object (CLOB) conversion is dependent on many different factors. This process runs in the background and depending on the amount of data and the all around production load of your Build Forge Server. This could take a very long time. The data is being moved from the bf_logs table and re-instantiated using CLOB methods.  The transfer is done 100 bf_log rows at a time 

Since all new data is recorded in the new format and since rows are deleted from bf_logs after they are transferred the number of rows in bf_logs, as determined by:
SELECT COUNT(bf_id) FROM bf_logs;
should get smaller over time. (this is a way to check the progress) 

This overall process can take days and or weeks. 5 days is not uncommon and not a cause for concern.

Thanks!

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.