8 Replies Latest reply on Feb 1, 2013 12:18 AM by hazelnut

    After upgrading vCenter from 5.0 to 5.1 Could not find stored procedure 'purge_stat1_proc'.

    GregoryVV Lurker

      Hi all.

      After upgrading vCenter from 5.0 to 5.1 found this error in MS SQL 2008 R2 when executing job "Past Day stats rollup":

      Message
      Executed as user: xx\yyyy. Could not find stored procedure 'purge_stat1_proc'. [SQLSTATE 42000] (Error 2812).  The step failed.
      and http://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=2006097 there are no stored procedure purge_stat1_proc in vCenter 5.1 installation but job Past Day stats rollup exist...
      Also there are no SQL script for this procedure in the vCenter Server installation folder in C:\Program Files\VMware\Infrastructure\VirtualCenter Server\sql.
      Does anyone has some suggestion? Maybe this is a bug???