Dong Shin 08.21.2012

  • attempted to deploy new PPM/PA with the database updates removing users in projects table that resulted in confusion….
    • ALTER TABLE projects DROP proj_mgr_login
    • ERROR 1025 (HY000) : Error on rename of ‘.project_portfolio#sql-6f4_5f3a’ to ‘.project_portfolioprojects’ (errno: 150
    • this is cause by existing foreign key set up on the column and command line solution is
      1. show create table projects;
      2. remove all the foreign keys by ALTER TABLE `projects` DROP FOREIGN KEY `projects_ibfk_7` ;
  • added Change Password capability to PA and PPM server
    • modified LoginScreen.mxml to have changePassword states and associated text fields/validators
    • added changePassword method to PPMUserService.java