Author Archives: pgfeldman

Dong Shin 05.27.2011

  • additional fields needed to Funding Request – also in Bug List
    • Title/Task Name
    • Program Element in Budget Center/Funding list
    • Contracts Info: Contract Numbers, Contractor Names, Contractor Place of Performance
    • Additional Info (required so MIPR will not be rejected)
  • PPM Changes
    • fixed Create Project panel showing AddBudgetCenterWindow on double click on empty DG (itemDoubleClick)
    • funding_request table modification so that Appropriation changes reflect…
      1. ALTER TABLE `funding_requests` ADD INDEX ( `appropriation` )
      2. ALTER TABLE `funding_requests` CHANGE `appropriation` `appropriation` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
      3. ALTER TABLE `funding_requests` ADD FOREIGN KEY ( `appropriation` ) REFERENCES `project_portfolio`.`appropriations` (`type`) ON DELETE NO ACTION ON UPDATE CASCADE ;
    • update Appropriations
      1. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘O&M (FY10)’ WHERE `appropriations`.`type` = ‘FY10 O&M’;
      2. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘Procurement (FY10)’ WHERE `appropriations`.`type` = ‘FY10 Procurement’;
      3. UPDATE `project_portfolio`.`appropriations` SET `type` = ‘RDT&E (FY10)’ WHERE `appropriations`.`type` = ‘FY10 RDT&E’;
    • added new fields to Funding Request panel
      • Title/Task Name
      • Program Element
      • Contract Info datagrid
      • Additional Info
    • created _funding_requests_contracts table to support contracts info
      1. CREATE TABLE `_funding_requests_contracts` (`funding_request_id` INT NOT NULL ,`contract_id` INT NOT NULL , INDEX ( `funding_request_id` , `contract_id` )) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
      2. ALTER TABLE `_funding_requests_contracts` ADD INDEX ( `contract_id` );
      3. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `funding_request_id` ) REFERENCES `project_portfolio`.`funding_requests` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;
      4. ALTER TABLE `_funding_requests_contracts` ADD FOREIGN KEY ( `contract_id` ) REFERENCES `project_portfolio`.`contracts` (`uid`) ON DELETE CASCADE ON UPDATE CASCADE ;

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:

Mike 5.25.2011

  • Completed a drag and drop interface for structuring Reports
    • The report structure is represented as a flex Tree object on the left side of the panel
    • A list of available section types is on the right side (Nodes, HTMLText, Image, and Table for now)
    • Users can drag items from the list to the tree to add sections to the report.
    • Users can also rearrange the report by dragging sections around the tree
    • Sections are removed by selecting them in the tree and pressing a ‘Remove’ button
    • The report updates immediately in the background whenever changes are made
  • Now that users can modify reports, I’m starting work on a document management panel modeled after the main screen of Google Docs

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!