<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.5730.11" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=207215917-15012007>Hi
All</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=207215917-15012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=207215917-15012007>We recently done an
upgrade from 4.0 to 4.2 it all seemed to be successfully until a couple of days
later when we noticed the publisher CPU creeping up. After some
investigation we found this was due to bad CMR records which where due to a
missing varVQMetrics column. We found some SQL posted by Wes
(thanks for all the good work) which we used to add the appropriate
column which was great and all the CMR records now insert and we have no more
CPU issues. What we do have now though is the failing of the 'Monitor Disk
Space' job in enterprise manager with the error:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=207215917-15012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=207215917-15012007>Executed as user:
XXXX\SQLSvc. Cannot insert the value NULL into column 'owner', table
'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100033BE2';
column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515)
The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step
failed.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=207215917-15012007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=207215917-15012007>Has anyone seen this
issue before or should we just go to 4.2(3)SR1.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>provista ip communications</FONT></DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2><A
href="http://www.provista-uk.com">www.provista-uk.com</A></FONT></DIV>
<DIV> </DIV></BODY></HTML>