Dong Shin 12.19.2013

  • deployed FinancialAssistant.jar, FA, RA,Req – all is well
  • discussed hot to handle multiple Commitments for a Requisition with Lenny
  • working on FA
    • added Financial Data datagrid to Requisition Editor
    • working on adding Committed Amount and Date to the Requisition Editor
    • added committed_amounts table to the database – DBUpdateEnhancements.sql
    • created CommittedAmount.as and CommittedAmountsTable.as for DB access
      • CREATE TABLE IF NOT EXISTS `committed_amounts` (
        `uid` int(11) NOT NULL AUTO_INCREMENT,
        `budget_center_id` int(11) NOT NULL,
        `committed_amount` decimal(10,2) NOT NULL,
        `committed_date` date NOT NULL,
        PRIMARY KEY (`uid`),
        KEY `budget_center_id` (`budget_center_id`)
        ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Phil 12.18.13

Phil 8:00 – 4:00 SR

  • Backups
  • Discussions with Lenny about how to handle bad cognos data
  • Talked to Tim E. We’ll meet on monday
  • We may have a bead on an SA…
  • Deployed new FA, RA and RQ, and a new FA jar.

 

Dong Shin 12.18.2013

  • deployed new FA server jars… all is well.
  • few notes from Lenny this morning @ Phil’s blog
  • my Flex workspace is behaving bad, again.!
  • working on FA/RA
    • added query description to Reqonciler’s Pre-Processing window
    • fixed Req Funded Amount not displaying correctly…
    • changed FMP title to Monthly Status Report

Phil 12.18.13

8:00 – 4:00 SR

  • Backups
  • People with permissions on parent projects should be visible in the child project
  • Put the name of the step in the title bar in Reqonciler
  • Change title from Financial Mitigation Plan to Monthly Status Report
  • Multiple obligation dates shouldn’t be flagged if they share the same date. Only different dates should be flagged.
  • If there is a blank or a dash in the req ID, don’t show.

Dong Shin 12.17.2013

  • deployed new FA/RA
  • working on COGNOS Data white list columns
    • columns should be compared to
      • Budget Center, Budget Center Name,Sub-Budget Center,Sub-Budget Center Name,Executing Budget Center,EBC Name,Appropriation Year,Requisition ID,PO Reference,ACR,Committed Date,Committed Amount,Obligation Date,Obligation Amount,Expensed Date,Expensed Amount
    • added congos.whitelist to FinancialAssistant.properties
    • modified the FA server to compare with the specified fields using hash map of column names and column headers
    • files to deploy – FinancialAssistant.jar, commons-lang-2.5.jar, FinancialAssistant.properties
  • fixed contrancts_cognos_history not updating..
  • working on Presentation Queries…

Dong Shin 12.16.2013

  • deployed new Pre-Processing queries, Lenny will review
  • changed Project Description to Project BLUF in FA
  • changed the way how FMP’s are handled
    • created mitigationPlanConfig.xml to describe the questions
    • FMP fields are dynamically created

Phil 12.16.13

8:00 – 4:00 SR

  • Backups
  • Deployed the preprocessing code that fixes all the bugs in our test data. Let’s see how it works on the real thing.
  • Going to spend the day making some reports from our fake data, then auto-updating the dates.
  • Working on updating Flexichart so that it will sort on column names. Done.
  • Spent some time with Dong remembering that CDATA exists and is useful.
  • Continued my slow-motion dialog with Andrea C.

Phil 12.13.13

8:00 – 12:00 SR

  • Backups
  • Meeting with Tim next week, probably Wednesday afternoon
  • Deployed new FA, RA and RQ
  • Installed a new truststore. We’ll see if it fixes the new login problems

Dong Shin 12.12.2013

  • working on queries for pre-processing (COGNOS conflicts)
    • find multiple obligation dates
      SELECT * FROM contracts_cognos WHERE uid IN (SELECT a.uid FROM contracts_cognos a INNER JOIN contracts_cognos b ON a.requisition_id = b.requisition_id AND a.sub_budget_center = b.sub_budget_center AND NOT ISNULL(a.obligation_date) AND NOT ISNULL(b.obligation_date) WHERE a.uid <> b.uid ORDER BY a.uid)
    • Committed Amount greater than Req Allocation
      SELECT * FROM contracts_cognos cco WHERE FIND_IN_SET (uid, (SELECT GROUP_CONCAT(cc.uid) FROM contracts_cognos cc LEFT JOIN budget_centers AS bc ON SUBSTR(cc.requisition_id, 5) = bc.req_id WHERE cco.requisition_id = cc.requisition_id AND cco.sub_budget_center = cc.budget_center AND cco.po_reference = cc.po_reference GROUP BY cc.requisition_id, cc.sub_budget_center, cc.po_reference HAVING SUM(committed_amount) > SUM(total_budget)))
    • Obligated Amount greater than Req Allocation
      SELECT * FROM contracts_cognos cco WHERE FIND_IN_SET (uid, (SELECT GROUP_CONCAT(cc.uid) FROM contracts_cognos cc LEFT JOIN budget_centers AS bc ON SUBSTR(cc.requisition_id, 5) = bc.req_id WHERE cco.requisition_id = cc.requisition_id AND cco.sub_budget_center = cc.budget_center AND cco.po_reference = cc.po_reference GROUP BY cc.requisition_id, cc.sub_budget_center, cc.po_reference HAVING SUM(obligated_amount) > SUM(total_budget)))
      SELECT * FROM contracts_cognos WHERE FIND_IN_SET (uid, (SELECT GROUP_CONCAT(cc.uid) FROM contracts_cognos cc LEFT JOIN budget_centers AS bc ON SUBSTR(cc.requisition_id, 5) = bc.req_id GROUP BY requisition_id, sub_budget_center, po_reference HAVING SUM(obligated_amount) > SUM(total_budget)))
    • Outlay Amount greater than Req Allocation
      SELECT * FROM contracts_cognos cco WHERE FIND_IN_SET (uid, (SELECT GROUP_CONCAT(cc.uid) FROM contracts_cognos cc LEFT JOIN budget_centers AS bc ON SUBSTR(cc.requisition_id, 5) = bc.req_id WHERE cco.requisition_id = cc.requisition_id AND cco.sub_budget_center = cc.budget_center AND cco.po_reference = cc.po_reference GROUP BY cc.requisition_id, cc.sub_budget_center, cc.po_reference HAVING SUM(expenseded_amount) > SUM(total_budget)))
      SELECT * FROM contracts_cognos WHERE FIND_IN_SET (uid, (SELECT GROUP_CONCAT(cc.uid) FROM contracts_cognos cc LEFT JOIN budget_centers AS bc ON SUBSTR(cc.requisition_id, 5) = bc.req_id GROUP BY requisition_id, sub_budget_center, po_reference HAVING SUM(expenseded_amount) > SUM(total_budget)))
    • Obligated Amount greater than Committed Amount
      SELECT * FROM contracts_cognos WHERE obligated_amount > committed_amount
    • Outlay Amount greater than Committed Amount
      SELECT * FROM contracts_cognos WHERE expensed_amount > committed_amount
    • Outlay Amount greater than Obligated Amount
      SELECT * FROM contracts_cognos WHERE expensed_amount > obligated_amount

Dong Shin 12.11.2013

  • FMP’s and Invoice updates are not recorded in query_logs – fixed
    • added REPLACE to supported types in recordQuery()
  • copy previous month’s FMP doesn’t work properly, especially from the previous year -fixed

Phil 12.11.13

8:00 – 4:00 SR

  • Backups
  • Deployed new Reqonciler and updated the queries
  • Created a new adminUtils.html page. This now has links to all the admin tools, and I took them off the index.html page.

Phil 12.9.13

8:30 – 2:30 SR

  • Two words without redeeming value: “Wintery mix”.
  • Backups
  • Verified that RA was recording user info in the query logs. It does not seem to be recording info about FMPs though.
  • Deploying new RA, but not the RQ updates, since Dong was stuck at home.

Dong Shin 12.06.2013

  • deployed new RA and DB updates – forgot to check for query_logs!
  • went over the pre-processing query with Lenny, duplicate duplicates are showing in the result window!
    • SELECT * FROM contracts_cognos
      WHERE uid IN (SELECT a.uid FROM contracts_cognos a INNER JOIN contracts_cognos b ON a.obligated_amount = b.obligated_amount
      WHERE a.uid <> b.uid ORDER BY a.uid)
  • disabled auto-refresh of projects data in RA
  • updates for cognos data views!