Status for Andrew DeFaria

• Implemented and tested GetSMTPHost

Continue reading "More CQ Web Email Problems (GetSMTPHost)" »

Posted by at 11:00 PM | Permalink

• Worked with Vinh on small problem with Gating_Item_SW.
• Backed up database to \\p4test\Cont as CQ_Controller_Prod.db.backup
• Copied backup up to \\pcirvd-dshah\CQ

Continue reading "PQA Merge (Part II)" »

Posted by at 2:47 PM | Permalink

This blog entry is to track the PQA merge process. See extended entry for full details...

Continue reading "PQA Merge" »

Posted by at 8:21 AM | Permalink

• Identified a few more bugs with pqamerge
• Changed to handle Open_Close_Status -> Active_Deferred_Status for Prod.
• Changed to correctly handle Gating_Item_SW. This is set from GatingItem from both TO and Prod. Gating_Item_HW is a new field and is set to "No".
• Worked with Vinh finalizing steps for pqamerge

Posted by at 9:15 AM | Permalink

• Added Exit Sub/Function to several validation and initialization functions in order to allow TransferState to work
• Fixed some bugs with Fixed_In_SW_Version and OS values of "Novell 6 Pack Beta 3 ". Not sure how this got by before with the trailing space but it raised it's ugly head in TransferStates
• Change pqamerge to treat the Submit state like the Assigned state
• With implementation of ID equality, I have to constantly regenerate the database from scratch. Experienced some problems with this and had to change the schema by allowing admin to submit. This may have been a different problem in that I now need to subscribe all users and groups to Cont database and Upgrade the database each time I create it a new
• Transitioning through states have reveal some fields that where not initially tranfered from the TO database. The fields missed were ResolvedBy, ResolveNote and VerifyNote

Continue reading "Several PQA Fixes" »

Posted by at 12:17 PM | Permalink

• Implemented TransferStates
• Found final problem with attachments and fixed it
• Implemented ID number equality

Posted by at 1:54 PM | Permalink

• Fixed bug in pqamerge that caused some attachments to not transfer

Continue reading "Finding the missing 261,285,366 bytes" »

Posted by at 11:55 AM | Permalink

• Investigated how to remove databases from a CQ Schema
• Created template files for Clearquest Web Login page to swap in for Phase I and Phase II onto the production web server (under C:\Temp\PQA)
• Discussed the email link problem with Rational. While they can't say definitively what is supported they have stated that the old email link URL will not work in the new schema

Continue reading "Removing DBs from a Schema/Email link concerns" »

Posted by at 3:52 PM | Permalink

• Installed Clearquest 2001A.04.00 and verified that it can access Cont
• Figured out how to modify the login page (Clearquest/Web/logon/default_content.asp) and created default_content1.asp and default_content2.asp
• Wrote How to update my Clearquest Profile to access the new Cont database

  Posted by at 7:54 PM | Permalink

• Enhanced check_attachments to log better

Continue reading "More on attachments" »

Posted by at 10:33 AM | Permalink

• Worked out a plan for how to perform the PQA Merge this weekend
• Concerned about the size discrepancy in the database I wrote a little utility, check_attachments, to total up the size of all attachments in all the databases. This turned up a bug in pqamerge which I fixed. Reperforming pqamerge
• There is a problem with using clearprompt to prompt for list input for bin_merge - You can only have one line of prompting text and only 50 characters in that line. It's gonna be hard to describe a binary merge situation in 50 characters or less. Investigated making a PerlTk list dialog. In theory it can be done as ccperl does support PerlTk.
• Discussed with Naga the email link issue with PQA

Continue reading "check_attachments" »

Posted by at 6:54 PM | Permalink

• Changed enable_ldap to read from and save to an ldap_settings.cfg file
• Helped Ray with some Perl Regex's

Posted by at 4:44 PM | Permalink

• Added a few users to Clearquest
• Set up IIS on pcsjca-ccrmt03
• Set up Clearquest Web on pcsjca-ccrmt03

Continue reading "CQ Users/CQ Web Server Setup" »

Posted by at 9:43 PM | Permalink

• Documented PQA issues
• Installed old Clearquest on pcsjca-ccrmt03
• Investigated more about the DST Clearcase issue

Posted by at 5:15 PM | Permalink

• Documented new URL format
• Investigated the feasibility of accommodating a mapping of old URL link with old ID -> new URL

Continue reading "PQA: URL Link Issue" »

Posted by at 2:00 PM | Permalink

• Worked on trying to test out LDAP Authentication

Posted by at 2:16 PM | Permalink

• Investigating PQA issue regarding email links
• Implementing cleanup of Dynamic Lists
• Handed off test DB backup to Vinh
• Investigated data conversion problems

Continue reading "PQA: More issues" »

Posted by at 4:14 PM | Permalink

• Changed Dynamic Lists to properly handle bad data

Continue reading "PQA Dynamic Lists" »

Posted by at 1:50 PM | Permalink

• Fixed bug in pqamerge so that it now properly adds new entries to dynamic lists

Continue reading "AddListMember" »

Posted by at 1:51 PM | Permalink

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

Continue reading "enable_ldap/Another PQA Merge" »

Posted by at 6:19 PM | Permalink

• Resolved most of the remaining issues with PQA Merge Vinh Ton

Continue reading "Most PQA Issues resolved..." »

Posted by at 5:23 PM | Permalink

• Starting to look into user accounts issues
• Send out form for LDAP Authentication Information
• Coded up pong.sh and pong.tcl to check and see if ccase-rmna-3 is up or down
• Created initial set of PQA User/Group Account files

Continue reading "PQA Merge: User Issues" »

Posted by at 3:22 PM | Permalink

• Documented remaining PQA Conversion Issues
• Audit_Log is not handled properly currently. Querying Vinh
• Resolved problem with Submitter and Submit_Date. Need to change schema to make those fields OPTIONAL as well as add return statements to the Perl action hooks
• Investigated using LDAP authentication with Clearquest
• Wrote a simple expect script (pong) and bash script to verify that a machine is up and send email if it isn't. Problem is ccase-rmna-1 lacks expect!

Continue reading "PQA Merge Issues/Pong" »

Posted by at 8:00 PM | Permalink

• Fixed minor problems with trailing spaces on fields
• Fixed minor problem with space filled Software_Revision
• Fixed problem where field names were reversed.
• Submitter and Submit_Date are set by action hooks to the current username and current date/time. We'll need to turn this off if we want the old Submitter and Submit_Date.
• Implemented Attachment Handling

Continue reading "PQA Clearquest:: Spacing out" »

Posted by at 12:57 PM | Permalink

This is to document all of the issues related with bad data in the source databases that is impeeding the PQA Merge process. Along with the issues I will present what I did to work around the problems and what I suggest we should do to provide a smooth transition of these databases

Continue reading "PQA Clearquest: Resolving remaining issues with bad data" »

Posted by at 6:41 PM | Permalink

• There are action hooks in Cont that send out email. I fear my testing may be generating lots of unnecessary email. Would like to have the Action Hook's email procedures coded to be conditional based on say an env var so we can turn off email during the production merge.
• Attachments are currently not handled because they are different and require special code to iterate through them to copy them to the destination database
• Need to have the delete action available on the defect record so pqaclean can work. I've modified my schema for that
• Changed pqamerge to only get the dbid's then to obtain the entity records when needed. Previously I would build a query with all fields. That query took from 6-40 minutes to run before I could even obtain the first record! Also the memory size of Perl grew very big. This algorithm is much faster with the query taking under 1 second!
• Working on problems with the source data.

Continue reading "PQA Merge - Action Hooks & Attachments" »

Posted by at 11:14 AM | Permalink

• Added Display, Logger and new TimeUtils to pqaclean and pqamerge
• Finally got ProjectExists() to work. Turns out I was using the wrong CQPerlExt constant causing pqamerge to blow up
• Received guidance from Vinh regarding certain field transformations. Incorporated them into pqamerge
• Pqamerge now merging all of TO:defect records with a few exceptions that I'm fixing

Posted by at 4:09 PM | Permalink

• Started coding TransferDefects(). This is where the rubber hits the road

Continue reading "PQA Clearquest: Project fields" »

Posted by at 11:40 AM | Permalink

• Resolved problems being able to log into the new Cont database by redoing the importation of CQSchema, CQ_Controller_Prod and CQ_Controller_Test
• Imported user accounts database from old schema to new schema. This was done by simply setting all users to all databases. While this is not what we will do for the production move it allows me to continue coding and testing
• Started coding pqamerge. Got to the point of being able to transfer Customer and Project records
• Coded pqaclean. This is a little script to effectively erase the destination database. This allows me to run pqamerge over and over from a clean slate. Had to add a delete action to the defect record

Posted by at 9:15 PM | Permalink

• Hooked up new PQA schema database and data database
• Starting to code merge routines
• Created PQA Schedule (See below)

Continue reading "PQA Clearquest" »

Posted by at 12:11 PM | Permalink

• Converted Code Page routines into a PQA.pm Perl Module
• Changed routines to check all fields. Clearquest returns character data for fields such as DATE_TIME fields. These record definitions are now complete and will be useful when it comes time to perform the conversion
• Waiting for new schema to start coding/testing conversion process. Contacted David Shaw who had helped us last time to get the databases onto our test server
• Finally get adm VOB working and am starting to add my stuff into this VOB in a controlled fashion. This is not just a place to dump all of our scripts rather it's a place to start centralizing our code in a manner consistent with proper software engineering principals (Structured coding, code reuse, generalization, object oriented design principals, etc.)

Posted by at 11:28 PM | Permalink

• Changed CheckCodePage to use HTML character equivalents
• Derived a plan of redistributing VOBs between VOB servers based on VOB database size

Continue reading "HTML Characters/VOB Distribution" »

Posted by at 4:29 PM | Permalink

Clearquest 2003.06.15 now uses Code Pages to insure that data entered into Clearquest databases are correct. When incorrect data is encountered there is a problem. The question is, which code page should we use?

Continue reading "Clearquest Code Pages" »

Posted by at 6:32 PM | Permalink

• Attended meeting regarding SJ/Irvine Vob move. Shivdutt is investigating doing vob moves instead of replication. Briefly discussed Disaster Recover options.
• Got Chris' scripts that check for invalid characters in string data for the ASCII character set to work on our test PQA database. Found invalid characters.

Continue reading "PQA Code Page/SJ Vob move" »

Posted by at 5:16 PM | Permalink

• Set up CQ Web Server on p4test. Web client has been updated. Seems a little sluggish
• Investigated CQ Web Performance tweaking
• Looked into Chris's scripts for handling CQ code page problems

Posted by at 2:26 PM | Permalink