Question

I ran the FogBugz diagnostics and the Rogue Case Check step gave me a list of cases with invalid ixBugEventLatest values. How do I fix them?

• Case 17788 (RE: Volocity 5.3 - Registration Correction problem {35797}) has a bad ixBugEventLatest value (It is set to "NULL")
• Case 16391 (Ludl Mac 6000: Volocity hang when moving between filter positions) has a bad ixBugEventLatest value (It is set to "NULL")
• Case 17015 (RE: Volocity 5.3 - Registration Correction problem {35797}) has a bad ixBugEventLatest value (It is set to "NULL")
• Case 17546 (RE: Volocity 5.3 - Registration Correction problem {35797}) has a bad ixBugEventLatest value (It is set to "NULL")
• Case 17038 (RE: Volocity 5.3 - Registration Correction problem {35797}) has a bad ixBugEventLatest value (It is set to "NULL")
• Case 17361 (RE: Volocity 5.3 - Registration Correction problem {35797}) has a bad ixBugEventLatest value (It is set to "NULL")
...

Answer 1

This is NOT thoroughly tested

    update Bug
       set ixBugEventLatest = be.ixBugEvent
      from Bug b
inner join (  select BugEvent.ixBug,
                     MAX(BugEvent.ixBugEvent) as ixBugevent
                from BugEvent
            group by BugEvent.ixBug) be
        on b.ixBug = be.ixBug
     where b.ixBugEventLatest is null