Category Archives: Projects

Dong Shin 05.26.2011

  • PPM Changes
    • Tweaked YearComboBox to support Full Year, Year #, etc. It can use calendar year (2011 , etc) or year count (0, 1, 2, etc).
    • reworking the query to retrieve all Financial Status data –
      SELECT r.*, c.contract_number, c.name as contractor_name, c.location as contractor_location, d.obligation_amount as dObligationAmount, d.outlay_amount as dOutlayAmount, NULL as rObligationAmount, NULL as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId FROM funding_requests r LEFT JOIN direct_cites d ON r.uid = d.funding_request_id LEFT JOIN contracts c ON d.contract_id = c.uid LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id WHERE b.project_id = 99 AND a.uid = 1335
      UNION
      SELECT r.*, NULL as contract_number, NULL as contractor_name, NULL as contractor_location, NULL as dObligationAmount, NULL as dOutlayAmount, r.reimbursable_amount as rObligationAmount, r.outlay_amount as rOutlayAmount, b.center_number, a.amount, r.uid as fundingRequestId, a.uid as budgetAmountsId FROM funding_requests r LEFT JOIN budget_centers b on r.project_id = b.project_id LEFT JOIN budget_amounts a on b.uid = a.budget_center_id WHERE b.project_id = 99 AND a.uid = 1335

Phil 5.26.2011

7:30 – 4:00 VISIBILITY

  • It’s gonna be *hot* today.
  • Looking into the java.security.cert.CertificateException: java.io.IOException: DerInputStream.getLength(): lengthTag=109, too big.
  • Asked for port 443 to be opened based on Allen’s suggestion.
  • Still not sure if the certs are in correctly. When I was initially checking on Jeff’s machine, the cert came back as unverified when checking from an outside browser. On the machine itself, it was fine. Then later, it was fine. Very confused.
  • One of Jeff’s PKI team is sending be a section of their keystore ‘how to” for Windows Server that might be some help

FP

  • Ordered Tom’s parts
  • Ordered some pressure sensitive resistors to play with

Cool thing for the day:

Dong Shin 05.25.2011

  • lost the script I was working on yesterday… Found that the scripts are not saved on the sever
  • meeting with Trisha
    • list of changes coming
  • PPM Changes
    • changed the Appropriation types – UPDATE `project_portfolio`.`appropriations` SET `type` = 'O&M (FY10)' WHERE `appropriations`.`type` = 'FY10 O&M';
    • Appropriation ComboBox removed from Financial Status panel
    • HeaderRenderer (ComboBox) for Obligation/Outlay types removed
    • added YearComboBox and FYMonthComboBox to Financial Status panel

Phil 5.25.11

7:30 – 5:30 VISIBILITY

  • Meeting with Trish
    • Rename appropriations so that the year is in parens  – i.e. R&D (FY10)
    • Make sure that the change ripples across the tables. It does not change in the Funding Request dialog
    • Have a line for each Direct Cite and for Reimbursable in financial status
      • And clicking on each line should bring up a unique dialog for that line
    • No ComboBox for Appropriation at the top of the Financial Status panel. Instead, on the right-hand side of the panel, have an appropriation year and appropriation month ComboBox. These should default to the correct month year for the project based on today’s date. In other words, if the money for the contract was appropriated (using project create) on Oct 1 2009 (i.e. FY10), and today is Oct 1 2010, then it’s October (month 1) of year 2.
    • Add a global refresh
    • Add an ‘Initiate’ Column and a ‘Commit’ Column to replace the Initiate/Commit’ column currently in the financial status
    • Add an ‘Initiate’ field and a ‘Commit’ field to replace the Initiate/Commit’ field currently in the funding request
    • Percent in financial status needs to be calculated against the goal percentage based on the current month/year in the appropriation cycle
  • Had another power failure last night – still need a UPS
  • Looking through Tomcat documentation to see if I can find what’s going on with my problem child server

Tom De Vito 5.24.2011

  • Passing multiple bytes of data worked but is a little hard to tell if its going in the right places with a scrolling console screen
  • Brought in the dependent classes from RCS system into the sandbox so that the test class will function more like it will in the final product
  • Working on adapting it to the RCS controller format and displaying output on an openGL overlay so I can see everything is working clearer.

Dong Shin 05.24.2011

  • not getting any useful info out of all financial data script
  • few question to convert to script
    1. What projects are under #% under budget?
    2. What managers/Financial people have project > 10%?
    3. What projects are overdue?
  • query to retrieve current year data – year 2012 is for 2011 (year = 2011 + year_count (1…))
    • SELECT p.project_number, c.center_number, a.*, o.* from projects p, budget_centers c, budget_amounts a, obligations_outlays oWHERE p.uid = c.project_id AND c.uid = a.budget_center_id AND p.uid = o.project_idAND year_count = a.year AND (o.year + o.year_count) = 2012

Phil 5.23.11

7:30 – 4:30 VISIBILITY

  • Added default login to RFlexClient – done
  • Write up RFlex description – done
  • Study https tomcat setup – see if there is anything I’m missing.
  • Actually got a Server up! It’s one of Jeff’s but I am not complaining 🙂

Dong Shin 05.23.2011

  • VisibilityScriptingServer
    • changed content field in visibility_scripting.table_publish to LONGBLOB to handle large amount of data
    • modified com.fgm.javaUtils.database.DbTable.java to handle LONGBLOB
    • tweaking query to generate the data in right format….

Phil 5.23.11

7:30 – 5:00 VISIBILITY

  • Deploy VISIBILITY analytics onto fgmdev
    • Write up a description
    • Change the browser tab.
    • Had some wierdness getting all the pieces to work. Some of it was lampp, and some of it was that my VISIBILITY account didn’t have the right permissions.
  • Having some problems with subversion. Trying this: http://subclipse.tigris.org/wiki/JavaHL – nope.
  • Set up Keystore and truststore files for all servers. Still can’t see the test machine from my desk, but firefox running on the server can run https to the IP just fine. Also tried getting Jeff’s machine working, but it seems to be running another server(?). Will look at that in more detail today.

Phil 5.20.11

8:00 – 5:00 VISIBILITY

  • One working day until The Rapture!
  • We had a power failure last night – somehow the windows box kept the windows state and went into hibernate. I am impressed. Still need to get a UPS though.
  • Added a *working* version of precompiled inserts to InfoObjectManager.java
  • Found out that I had put combined the wrong domain name with the right ip address (or was it the other way around?). Anyway, submitted cert requests for the following:
    • Integration VM
    • Production VM
    • Jeff’s infovis7 box

Dong Shin 05.20.2011

  • ran a query to retrieve Financial Data, got empty data. Noticed that the server reports, ERROR [TP-Processor2] (PublishSupportObject.java:130) – Packet for query is too large (4052025 > 1048576). You can change this value on the server by setting the max_allowed_packet’ variable. Tracked it down and found my.cnf needed more than 1M of max_allowed_packet…. set it to 50M and no more error messages
  • XML data shows up in Script Editor, but not published. Got ERROR [TP-Processor3] (PublishSupportObject.java:130) – Data truncation: Data too long for column ‘content’ at row 1 on the server. Trying to track it down….

Dong Shin 05.19.2011

  • revisiting VisibilityScripting for PPM reports, trying to remember where I left off….
    • crashing at PublishedDataPanel/showSelectedData()[/Users/dongshin/Projects/workspace.fgmdev.flex/VisibilityScripting/src/main/flex/PublishedDataPanel.mxml:35]
  • updating SF86 for my clearance. a lot more stuff!

Phil 11.19.11

7:30 – 4:00 VISIBILITY

  • Copied over all the QueryBuilderBase pieces from GenericQueryWidget.
    • Going to alter so that the UserInfoObject and endpoints are [Bindable] variables rather than being pulled in.
    • Altering query result handling so that the data is used to populate statistical arrays rather than launching a new chart panel
      • Getting table names
      • Getting columns
      • Extracting data from columns.
  • Helped Shawna(?) a bit with diagnosing the issue with the S2F server. Ping is blocked too, so I pointer her at this: http://support.microsoft.com/kb/314067
  • Discovered a bug in FLAILS. Changing the input to precompiled queries.

Tom DeVito 5.18.2011

Arduino Sketch:

  • Found out that the write command need an array of type uint8_t.  For some reason this isn’t labeled in the documentation.
  • Changed the basic structure to have the appropriate preProcess(), decisionProcess(), postProcess()
  • Changed it so loop doesn’t start unless initialized is true.
  • add sendData and recieveData methods that work with the command, response, output structs