Author Archives: gvr4wd

Unknown's avatar

About gvr4wd

...hmmm

Dong Shin 06.20.2014

  • deployed new FA with the reworked Query Builder – all is well.
  • experimented with MariaDB and some database performance testing on-site.
  • working on Query Builder
    • added Obligation, Outlay, PM Actuals columns back…. still need % values
    • required columns added to queryBuilderConfig.xml

Dong Shin 06.19.2014

  • did some performance testing of the temporary table, __view_project_detailed_data
    • data generation took 90 sec
    • query is faster
    • need Update button in Query Builder when data generation is needed
    • installed MariaDB and compared the performance
      • data generation too 20 sec
      • some error running stored procedure… may need to run – mysql_upgrade.exe -uroot -p –force 
        • #1728 - Cannot load from mysql.proc. The table is probably corrupted 
  • working on Query Builder
    • added Update Data in Query Builder to update project detailed data
    • added _table_last_update_status to keep track of tables status
    • added triggers to update the _table_last_update_status – obligations_outlays, budget_centers, committed_amount, and contracts_cognos for now
    • modified users queries to match new structure of __view_project_detailed_data

Dong Shin 06.17.2014

  • installed MariaDB, works with the current MySQL data! little performance improvements… . 3.04 vs 2.72
    • mysqld –datadir=<directory to data>
  • experimenting with Triggers/Store Procedures to generate summary data
    • drop and create tables not allowed
    • delete and insert takes 5 sec on RA/RA data entry

Dong Shin 06.13.2014

  • checked out projects from new SVN repo
    • builds, but cannot check in…. permission issues
    • org.apache.subversion.javahl.ClientException: Permission denied
      svn: Commit failed (details follow):
      svn: Can’t move ‘/home/vectr/svn/307519/db/txn-protorevs/3263-2iv.rev’ to ‘/home/vectr/svn/307519/db/revs/3/3264’: Permission denied

Dong Shin 06.12.2014

  • working on Query Builder
    • converted old queries to new format
    • reworked __view_total_committed_amount_by_budget_center
      • CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `__view_total_committed_amount_by_budget_center` AS select `committed_amounts`.`budget_center_id` AS `budget_center_id`,sum(`committed_amounts`.`committed_amount`) AS `total_committed_amount`,MAX(`committed_amounts`.`committed_date`) AS `max_committed_date`, group_concat(`committed_amounts`.`committed_date` separator ‘,’) AS `committed_dates` from `committed_amounts` group by `committed_amounts`.`budget_center_id`;
    • reworked __view_project_detailed_data to include obligation date and committed date
    • going through the user queries….
  • svn migration complete – trying to check out…

Dong Shin 06.11.2014

  • working on Query Builder
    • adding Lenny’s queries to database
      • Overdue Acceptances
      • Overdue Obligations
      • Under performing obligations
      • FY14 Financial Status
      • FY14 Outlay Plan
      • FY13 Financial Status
      • FY14 current month Planned vs. PM Actuals
      • FY13 TST Financial Status
      • FY14 TST Financial STatus
      • FY14 ISR-PMO Financial Status
      • FY14 Financial Status (duplicate?)

Dong Shin 06.03.2014

  • working on Query Builder (6 hours)
    • cleaned up database views – _view_project_detailed_data
  • working on scripts to add parent project users to children… (2 hours)
    • INSERT INTO _projects_portfolio_mgrs
      (SELECT sub_project_id, login FROM _projects_portfolio_mgrs ppa
      LEFT JOIN _project_sub_projects psp
      ON psp.project_id = ppa.project_id WHERE (sub_project_id, login) NOT IN (SELECT * FROM (_projects_portfolio_mgrs)))
    • INSERT INTO _projects_portfolio_admins
      (SELECT sub_project_id, login FROM _projects_portfolio_admins ppa
      LEFT JOIN _project_sub_projects psp
      ON psp.project_id = ppa.project_id WHERE (sub_project_id, login) NOT IN (SELECT * FROM (_projects_portfolio_admins)))

Dong Shin 05.30.2014

  • working on other stuff (6 hours)
    • trouble shooting incorrect outlay calculation in cognos summary data
      • cannot duplicate outlay problem for Req 198874, need to clear budget_center_contracts entry and run post processing on-site.
    • created project_portfolio_enh_clean for testing
    • trouble shooting obligations stored in a month behind for 206756…. cannot duplicate.. need to look at __view_monthly_obligations_by_contract and __view_monthly_obligations_by_req_id on-site
  • added hierarchical filtering to DGSearchTextInput (2 hours)