8:00 – 5:00 SR

• Db backups
• Look into truncating queries for querylog script and how it’s keeping tables from being made.
• …and my Eclipse server went kablooey again. Spent the morning rebuilding that. Still no real idea what broke or how it was fixed. Grr.
• The truncated queries work fine here.
• Asked Dong to look into extending the query-log with additional information that can be the basis of some auditing/alerts. The idea is that after one or more queries are run to produce a result such as adding a MIPR or inputting PM_Actuals or even FMPs that additional lines are added to the query_log immediately after to add more directly usable information that we can use for reports.
  • All of these additional ittems use the table name “META%” so they can easily be pulled in a query.
  • The “type” field has an overall name for the activity like “ADD PROJECT”
  • The query contains useful text, rather than a query: i.e. “Added Project Carla Demo”. Short enough to keep the text string under 255 chars.
• JavaScript
  • Working through the Module pattern and having issues with either typeof or my debugger.