« Most PQA Issues resolved... | Main | AddListMember »

enable_ldap/Another PQA Merge

  • Wrote and enable_ldap Perl script
  • Vinh Ton has provided me with yet another schema and corresponding databases

Another Merge

Performing yet another merge so I will once again document the steps I take:

  • Restored the databases CQSchema03, CQ_Controller_Test and CQ_Controller_Prod. Doing so wipes out the old data
  • When importing you must go into the CQSchema03 tables for master_dbs and change the server to p4test. Otherwise you will be effecting the data on the other server!
  • Enter Clearquest Designer and mark the following fields as optional:
    • Submitter
    • Submit_Date
    • Audit_Log
    • old_id
  • Change commitmentLevel_Value_Changed hook to simply return
  • Test Work, Check in Schema and Upgrade Database
  • Import OEMUsers.cqu and Users.cqu
  • Upgrade Database
  • Run pqamerge
  • Test
  • Reverse the schema changes performed above and apply the changes
  • Backup new CQSchema03, CQ_Controller_Test and CQ_Controller_Prod

Use the following for a Check in Comment:

Changing Submitter, Submit_Date, Audit_Log and old_id to be optional for data conversion

Also changed commitmentLevel_ValueChanged hook to return before sending email.