Category Archives: Dong Shin

Dong Shin 05.27.2014

deployed FA/RA with new filterable combo boxes (2 hours)
- works well, but needs tweaking on Hierarchical data in Project Mgmt
working on Reqonciler Pre-Processing (6 hours)
- removing duplicate rows query sample
  - DELETE n1 FROM test n1, test n2 WHERE n1.uid > n2.uid AND n1.name = n2.name
    AND n1.name2 = n2.name2

working on DGSearchTextInput (8 hours)
- component done! added to QueryBuilder
- adding to RA – done!
- adding to Project Mgmt panel – done!
  - tricky to work with Hierarchical data!

continue working on Search Text Input filtering columns(7 hours)
- moved the component to FGMUtils
- moved filtering to the component from the datagrid

self-assessment for annual review
Add Update Button to Req Info in Query Builder – done (2 hours)
working lockdown rows (5 hours)
- added configuration table entry to configutaion table – not used yet
- added lockdown entry in itemRenderer
- added isLockdown method in FinancialData class

On-site support (2 hours)
- fixed Post-Processing query
- found some bugs and added to the list
working on Reqonciler (4 hours)
- fixed ignore date in Obligations rule
- removed Appropriations from required list
working on Query Builder (2 hours – task 1)

deployed new Reqonciler and db update – pre-processing works! (3 hours)
found some of the obligations are not set correctly (second year?), all the summary data and relations are there. (1 hour)
- have not corrected setting to NULL when obligations/outlays are cleared! it should set to 0, not null because 0+ null = null!
working on VizTool Priority List #1 – adding save to budget/req info (4 hours)

deployed new Reqonciler and the ingest works magically!
fixed post processing queries by removing Appropriations
pre-processing ignore is broken
- added target table name column
  - ALTER TABLE `_reqonciler_processing` ADD `target_table_name` VARCHAR(50) NULL ;
  - set appropriate table names per query

found that the new obligations not are saved to budget_center_contracts table
- post processing query that saves not working correctly?
- tried to replicate it with test data, but no luck, need to compare the queries word by word
added Query Editor to Reqonciler so that editing can easily be done on the app

ran the Java in command line with no problems, but still the same problem through Reqonciler…. ingested COGNOS data (FY13 and FY14) thru command line
pre-processing ran fine, but errors on post-processing. missing views
- created views and sent it off to Bill/Phil for deployment tomorrow
- instruction- There are four views need to be updated/added to the database.
  1. Bring up a command line window and login to mysql database
  2. create views one at a time by copy and paste into mysql command prompt and ensure there is no errors
  3. Login into Reqonciler and run post processing, ensure there is no errors
  4. ask Lenny to verify Obligations/Outlays data!
off to Philadelphia!

having problems with new Reqonciler jar files…. The process would just stop right after reading prop files.
created a runnable jar files with necessary files
packaged up mostly everything from webapp directory for debugging/testing, more than 25MB (limit of gmail?). broke up and sent it off to Bill.

found the culprit that causes the haning/slow queries on obligations/outlays
- tmp_view_financial_data created by trigger – update_tmp_view_financial_data, 03.21.2014 blog entry for details
- removed it and update query runs quick!
had to manually convert Budget Center, Sub-Budget Center to string using Data->Text to Columns util in Excel

continue testing with new Reqonciler
- got updated test data from Phil
- running to through the test file
- update awfully slow – step 1 in post processing…