Category Archives: Phil

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.

 

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

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.

Phil 12/6/13

8:00 – 4:00 SR

  • Backups
  • Deployed new RA and DB updates
  • Need to do status report!
  • Don’t refresh RA display unless an update is made.
  • Lenny will provide a whitelist of Cognos columns to use for row compare on ingest.
  • RQ is double-counting on pre-process
  • Obligation not showing up for FY14
  • Finished adding en errors to fake data as per customer spec
    • Multiple obligation dates
    • Disappearing commitment and/or obligation dates
    • Committed Amount greater than Req Allocation
    • Obligated Amount greater than Committed Amount
    • Obligated Amount greater than Req Allocation
    • Outlay Amount greater than Committed Amount
    • Outlay Amount greater than Obligated Amount
    • Outlay Amount greater than Req Allocation

Phil 12.5.13

8:00 – 4:00 SR

  • Two years ago I broke my femur, so it’s as good as it’s going to get. Which is actually pretty good. Just some low-level aches.
  • Backups
  • Meeting with the full financial and project team
  • The user object in RA is not working correctly. Wrong user id’s are being written into the query log. FA is ok.
  • Meeting with Tim E. at 1:30?

Phil 12.4.13

8:00 – 4:00

  • Backups
  • Server paperwork
  • Fixing bugs in the generation program
    • Filling in data only until “today”
    • Allowing varying numbers of lines up to the requested amount, based on if the project is at its end year.
    • All bugs appear fixed. Now we need to break things. Burning a copy of the spreadsheet for Lenny to look at.
  • Next step is to create a Swing(?) app that will let the user determine what errors to inject.

Phil 12.3.13

8:00 – 4:00 SR

  • Backups
  • SQL changes
  • Changes made to queries in query builder are not updating correctly
  • Obligations may only be appearing in the month that they occurred. They need to carry forward, then overwrite as the next obligation comes in.
  • Still a problem with EAs. Req assistent shows correct outlays through September of the first year, but is blank in October of the second year, then roughly four times the amount that it should be. Queries are wrong, with no discernible pattern. MIPRs are ok.
  • Change “Committed Amount” to REQ Funded Amount”
  • Got spreadsheets ingesting
  • Found a date bug that may have had something to do with ints vs. longs. Adding more lines fixed the problem.