Ravenbrook / Projects / Perforce Defect Tracking Integration / Issues
Perforce Defect Tracking Integration
| Title: | Migrating jobs to TeamTrack fails if there are many jobs |
| Status: | closed |
| Priority: | essential |
| Assigned user: | gdr |
| Product: | p4dti |
| Organization: | TeamShare |
| Description: | If you have hundreds of jobs then you can't migrate them to TeamTrack because the TeamShare API runs out of memory and hangs. We followed the procedure in section 6.2 of the AG, edited the migrate_teamtrack.py script, checked that it worked on a small number of jobs, and then ran it on the entire set of jobs (around 270). It managed to migrate about 80 jobs, but then it hung. When killed with control-C, the Python traceback showed that it was waiting for the TeamShare API function TSServer::ReadRecordListWithWhere. We tried it again, and this time it managed to migrate about 60 jobs, before hanging (in the same TeamShare API function). |
| Analysis: | The TeamTrack database we were running against was created by modifying the sample database that came with TeamTrack 4509. See the evidence. The underlying cause is the same as job000277. See that job for analysis and proposed solutions. GDR 2001-04-19. |
| How found: | manual_test |
| Evidence: | <http://www.ravenbrook.com/project/p4dti/import/2001-03-23/teamtrack-testcase/tTrackSample.mdb> |
| Observed in: | 1.0.5 |
| Introduced in: | 0.0.0 |
| Test procedure: | none |
| Created by: | gdr |
| Created on: | 2001-03-23 17:49:26 |
| Last modified by: | gdr |
| Last modified on: | 2001-12-10 19:36:00 |
| History: | 2001-03-23 GDR Created. 2001-03-25 RB Downgraded to "essential". Although this doesn't work properly, it doesn't lose or corrupt data. 2001-04-19 GDR Noted that the cause is the same as job000277. |
| Change | Effect | Date | User | Description |
|---|---|---|---|---|
| 12701 | closed | 2001-05-19 12:02:21 | gdr | Merged work from branch/2001-05-15/capacity to version/1.1. |
| 12665 | open | 2001-05-18 10:40:23 | gdr | dt_teamtrack uses cursors whenever it makes a query that could return many results. |
| 12656 | open | 2001-05-17 19:18:01 | gdr | Added cursor implementation to dt_teamtrack. Replicator can now accept lists or cursors as result of all_issues and changed_entities. (As a consequence, it no longer produces messages 844-847 so these are removed from catalog, test_p4dti and Administrator's Guide.) Integrator's Guide specifies that all_issues and changed_entities return cursors. |
Generated at 2008-12-01 21:27:14 by $Id: //info.ravenbrook.com/infosys/cgi/issue.cgi#430 $
Copyright © Ravenbrook Limited. This document is provided "as is", without any express or implied warranty. In no event will the authors be held liable for any damages arising from the use of this document. You may make and distribute verbatim copies of this document provided that you do not charge a fee for this document or for its distribution.