Dong Shin 04.29.2014

  • found the culprit that causes the haning/slow queries on obligations/outlays
    • tmp_view_financial_data created by trigger – update_tmp_view_financial_data, 03.21.2014 blog entry for details
    • removed it and update query runs quick!
  • had to manually convert Budget Center, Sub-Budget Center to string using Data->Text to Columns util in Excel