Dong Shin 06.13.2012

  • issues at the site
    • using sub projects to limit what users can see
    • copy project generates error – some cascading error, but can’t duplicate it on mine.
    • users having problems viewing projects assigned to – fixed
  • getting error when logged out and try to log back in… and the login screen locks up
    • Error logggin in!
      [FaultEvent fault=[RPC Fault faultString=”[MessagingError message=’Destination ‘PPMUserService’ either does not exist or the destination has no channels defined (and the application does not define any default channels.)’]” faultCode=”InvokeFailed” faultDetail=”Couldn’t establish a connection to ‘PPMUserService'”] messageId=”C6D2C3B1-E087-9059-0A89-E669D5CDC239″ type=”fault” bubbles=false cancelable=true eventPhase=2]
  • fixed projects not showing for users in PPM
    • SELECT projects.*, projects.uid as ID, projects.project_number as ‘Project ID’, projects.title as ‘Project Name’, begin_year as ‘Start FY’, end_year as ‘End FY’, begin_year as startYear, IF(ISNULL(lock_id), if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), IF (lock_id=’dongshin’, if (total_budget = 0, ‘INCOMPLETE’, ‘EDITABLE’), ‘LOCKED’)) as Status, (end_year – begin_year) as duration, CONCAT(o.first_name, ‘ ‘, o.last_name) AS ‘Project Mgr’, CONCAT(a.first_name, ‘ ‘, a.last_name) AS ‘Portfolio Admin’,  CONCAT(o.first_name, ‘ ‘, o.last_name) AS projMgrName, CONCAT(b.first_name, ‘ ‘, b.last_name) AS ‘Project Admin’, CONCAT(c.first_name, ‘ ‘, c.last_name) AS ‘Portfolio Mgr’, services, o.unclass_phone as projMgrPhone, o.unclass_phone_ext as projMgrPhoneExt, o.JWICS_email as projMgrJWICSemail, o.SIPR_email as projSIPRemail, o.unclass_email as projUnClassEmail, CONCAT(c.first_name, ‘ ‘, c.last_name) AS projSupervisorName,  c.unclass_phone as projSupervisorPhone, c.unclass_phone_ext as projSupervisorPhoneExt, c.JWICS_email as projSupervisorJWICSemail, c.SIPR_email as projSupervisorSIPRemail, c.unclass_email as projSupervisorUnClassEmail, projects.total_budget as ‘Total Budget’, sub.project_id as parent_project_id, sub.sub_project_id FROM projects
      LEFT JOIN _project_sub_projects as sub ON uid = sub_project_id
      LEFT JOIN users AS o ON projects.proj_mgr_login = o.login
      LEFT JOIN users AS a ON portfolio_mgr_login = a.login
      LEFT JOIN users AS b ON proj_admin_login = b.login
      LEFT JOIN users AS c ON portfolio_admin_login = c.login
      WHERE (projects.proj_mgr_login = ‘dongshin’ OR projects.portfolio_mgr_login = ‘dongshin’ OR projects.proj_admin_login = ‘dongshin’ OR projects.portfolio_admin_login = ‘dongshin’)
      OR (projects.uid in (SELECT project_id FROM _projects_portfolio_mgrs WHERE login = ‘dongshin’))
      OR (projects.uid in (SELECT project_id FROM _projects_portfolio_admins WHERE login = ‘dongshin’))
      OR (projects.uid in (SELECT project_id FROM _projects_service_finance_pocs WHERE login = ‘dongshin’))
      OR (projects.uid in (SELECT project_id FROM _projects_service_project_mgrs WHERE login = ‘dongshin’))
  • fixed View Comments button not enabling after adding comments