Category Archives: VISIBILITY

Dong Shin 05.31.2011

  • PPM Changes
    • add performance_location to contracts table – ALTER TABLE `contracts` ADD `performance_location` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `location`
    • add additional_info, title_task_name to funding_request table –
      • ALTER TABLE `funding_requests` ADD `additional_info` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `statement_of_work`
      • ALTER TABLE `funding_requests` ADD `title_task_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `uid`
    • contract add/remove now working
    • modify Contract Form Window to save contracts data with new field – performace_location
  • talked to Christina/Phil about the Recruiting App, ingested the latest spreadsheet.

    Kristi 05.31.2011

    Hope everyone had a nice holiday! 😉

    A few minor items:

    1.  Projects – Create Project – Services – “Marine” should be “Marines”

    2. Projects – Create Project – Services – Center Name – When double clicking empty field, New box no longer opens… Update Budget Center Datawindow is now opening in all fields – can this bug be fixed?

    Thanks!

    Phil 5.27.11

    7:30 – 4:30 VISIBILITY

    • I have a UPS! And Service Pack 7! It’s almost like Christmas – maybe Hogswatchnight.
    • Going over Trish’s new requests with Dong:
    • Discovered PortQuery, just what I wanted! Burning a copy to CD.
    • Tried out portquery. It turns out that there is someting between my desktop box and the VM that Tomcat is running on. Regardless of whether or not I have Tomcat running, ports 443 and 80 read as LISTENING from my desktop. Running from the VM, turning Tomcat on and off chage the ports from LISTENING to NOT LISTENING. Trying to track that down.

    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:

    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

    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!