mforte@us.ibm-dot-com.no-spam.invalid (mforte) writes:

One of my customers is having problems querying defects imported from
Bugzilla. Here is his question:

Hi Maurice,

we have a problem with workitem queries.

Here is the problem:

* We imported all our bugs from Bugzilla to Jazz
* All shpw up nicely - however with a greyed out symbol
* If I try a query with Resolution Defer this bug is not found:

However, I tried another bug (2194). Reopened it, Triaged it and
closed it as deferred.
Now it was found.

How can we fix this ?

What version of RTC client is being used to import the bugs ? We found
lots of fun with imports, but the 1.0.1 client does a pretty decent
job as long as one's mapping file is "good" and the target configuration
doesn't change suddenly.

What we would see is that things like the status would populate, but they
would be un-editable.

Look for a recent post (last week) from bgillan asking a similar question
due to a problem we encountered.

Thanks,
Stephan

--
Kevin Ramer
Tivoli Advisory Software Engineer

I used 1.0.1

let me know if you need more information like my mapping file...

stephan.hesmer@de.ibm-dot-com.no-spam.invalid (shesmer) writes:

I used 1.0.1

let me know if you need more information like my mapping file...

Here's the post I aluded to:

We're using the bugzilla importer to get defects transferred to
RTC. A tweak to the work item workflow resulted in several work
items being imported with "Unitialized" state.
(1) Seems like there should be an option to abort the import if
something doesn't map well.
(2) Is there a way for us to remedy the WIs with uninitialized
states?

I have outlined a possible solution to this problem in
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/64722

HTH,
Patrick
Jazz Work Item Team


Could you post just the mapping xml for the fields that don't import correctly ?



--
Kevin Ramer
Tivoli Advisory Software Engineer

<?xml version="1.0" encoding="UTF-8"?>
<mapping version="1">
<attribute sourceId="bug_status" targetId="com.ibm.team.workitem.attribute.state">
<value sourceId="NEW" targetId="s1"/><!-- Unused -->
<value sourceId="UNCONFIRMED" targetId="s1" accurate="false"/><!-- Unused -->
<value sourceId="ASSIGNED" targetId="s2"/><!-- Unused -->
<value sourceId="RESOLVED" targetId="s3"/><!-- Unused -->
<value sourceId="VERIFIED" targetId="s4"/><!-- Unused -->
<value sourceId="CLOSED" targetId="s5"/>
<value sourceId="REOPENED" targetId="s6"/><!-- Unused -->
</attribute>
<attribute sourceId="resolution" targetId="com.ibm.team.workitem.attribute.resolution">
<value sourceId="UNRESOLVED" targetId="r0"/><!-- Unused -->
<value sourceId="FIXED" targetId="r1"/>
<value sourceId="DUPLICATE" targetId="r2"/>
<value sourceId="WONTFIX" targetId="r3"/><!-- Unused -->
<value sourceId="WORKSFORME" targetId="r4"/><!-- Unused -->
<value sourceId="INVALID" targetId="r5"/>
<value sourceId="REMIND" targetId="r6"/><!-- Unused -->
<value sourceId="LATER" targetId="r7"/><!-- Unused -->
<value sourceId="Deferred" targetId="r7"/>
<value sourceId="Propose to defer" targetId="bugzillaWorkflow.resolution.r9"/>
</attribute>
<attribute sourceId="product/component" targetId="com.ibm.team.workitem.attribute.category"/>
<attributeType targetId="category">
<value sourceId="Builder/base" targetId="Builder/base"/>
<value sourceId="Catalog/base" targetId="Catalog/base"/>
<value sourceId="Enabler/base" targetId="Enabler/base"/>
<value sourceId="Enabler/iWidgetFramework" targetId="Enabler/iWidgetFramework"/>
<value sourceId="Enabler/model" targetId="Enabler/model"/>
<value sourceId="Enabler/testcases" targetId="Enabler/testcases"/>
<value sourceId="Hub/base" targetId="Hub/base"/>
<value sourceId="ID/base" targetId="ID/base"/>
<value sourceId="iWidgets/catalog-widgets" targetId="iWidgets/catalog-widgets"/>
<value sourceId="iWidgets/demo-widgets" targetId="iWidgets/demo-widgets"/>
<value sourceId="iWidgets/greenhouse-widgets" targetId="iWidgets/greenhouse-widgets"/>
<value sourceId="iWidgets/production-3rdParty-widgets" targetId="iWidgets/production-3rdParty-widgets"/>
<value sourceId="iWidgets/production-widgets" targetId="iWidgets/production-widgets"/>
<value sourceId="Portal/base" targetId="Portal/base"/>
<value sourceId="Server/base" targetId="Server/base"/>
<value sourceId="Server/model.api" targetId="Server/model.api"/>
<value sourceId="Server/model.impl" targetId="Server/model.impl"/>
<value sourceId="Server/persistence.db" targetId="Server/persistence.db"/>
<value sourceId="Server/persistence.file" targetId="Server/persistence.file"/>
<value sourceId="Server/proxy.common" targetId="Server/proxy.common"/>
<value sourceId="Server/proxy.servlet" targetId="Server/proxy.servlet"/>
<value sourceId="Server/rest.impl" targetId="Server/rest.impl"/>
<value sourceId="Server/rest.servlet" targetId="Server/rest.servlet"/>
<value sourceId="Server/xml.impl" targetId="Server/xml.impl"/>
<value sourceId="UXDesign/base" targetId="UXDesign/base"/>
</attributeType>
<attribute sourceId="target_milestone" targetId="com.ibm.team.workitem.attribute.target"/>
<attributeType targetId="interval">
<value sourceId="---" targetId=""/>
</attributeType>
<attribute sourceId="version" targetId="com.ibm.team.workitem.attribute.version"/>
<attributeType targetId="deliverable">
<value sourceId="unspecified" targetId=""/><!-- Unused -->
<value sourceId="1.0" targetId="1.0"/>
<value sourceId="1.1" targetId="1.1"/>
<value sourceId="beta 2" targetId="beta 2"/>
<value sourceId="greenhouse" targetId="greenhouse"/>
<value sourceId="catalog-release" targetId="catalog-release"/>
<value sourceId="next" targetId="next"/>
</attributeType>
<attribute sourceId="reporter" targetId="com.ibm.team.workitem.attribute.creator"/>
<attribute sourceId="assigned_to" targetId="com.ibm.team.workitem.attribute.owner"/>
<attribute sourceId="cc" targetId="com.ibm.team.workitem.attribute.subscriptions"/>
<attributeType targetId="contributor">
...
</attributeType>
<attribute sourceId="priority" targetId="com.ibm.team.workitem.attribute.priority"/>
<attributeType targetId="priority">
<value sourceId="High" targetId="priority.literal.l4"/>
<value sourceId="Medium" targetId="priority.literal.l3"/>
<value sourceId="Low" targetId="priority.literal.l2"/>
<value sourceId="Unassigned" targetId="priority.literal.l1"/>
</attributeType>
<attribute sourceId="bug_severity" targetId="com.ibm.team.workitem.attribute.severity"/>
<attributeType targetId="severity">
<value sourceId="Sev1" targetId="severity.literal.l6"/>
<value sourceId="Sev2" targetId="severity.literal.l5"/>
<value sourceId="Sev3" targetId="severity.literal.l4"/>
<value sourceId="Sev4" targetId="severity.literal.l2"/>
</attributeType>
<!--
Platform and OS are not imported unless the corresponding custom attributes already exist in the project area.
Example snippets for the process specification:

<configuration-data xmlns="http://com.ibm.team.workitem/workitemTypes" id="com.ibm.team.workitem.configuration.workItemTypes">
...existing types and custom attributes...
<customAttributes category="com.ibm.team.workitem.workItemType">
<customAttribute id="com.example.workitem.attribute.custom.os" name="Operating System" type="com.ibm.team.workitem.attributetype.custom.os"/>
<customAttribute id="com.example.workitem.attribute.custom.platform" name="Platform" type="com.ibm.team.workitem.attributetype.custom.platform"/>
</customAttributes>
</configuration-data>
<configuration-data xmlns="http://com.ibm.team.workitem/enumerations" id="com.ibm.team.workitem.configuration.enumerations">
...existing enumerations...
<enumeration attributeTypeId="com.ibm.team.workitem.attributetype.custom.os">
<literal id="Windows XP" name="Windows XP"/>
<literal id="Mac OS X" name="Mac OS X"/>
<literal id="Linux GTK" name="Linux GTK"/>
</enumeration>
<enumeration attributeTypeId="com.ibm.team.workitem.attributetype.custom.platform">
<literal id="PC" name="PC"/>
<literal id="Mac" name="Mac"/>
<literal id="Sun" name="Sun"/>
</enumeration>
</configuration-data>
-->
<attribute sourceId="op_sys" targetId="com.example.workitem.attribute.custom.os">
<value sourceId="All" targetId="All"/>
<value sourceId="Linux" targetId="Linux"/>
<value sourceId="Mac OS" targetId="Mac OS"/>
<value sourceId="Other" targetId="Other"/>
<value sourceId="Windows" targetId="Windows"/>
</attribute>
<attribute sourceId="rep_platform" targetId="com.example.workitem.attribute.custom.platform">
<value sourceId="All" targetId="All"/>
<value sourceId="Macintosh" targetId="Macintosh"/>
<value sourceId="Other" targetId="Other"/>
<value sourceId="PC" targetId="PC"/>
</attribute>



<configuration-data xmlns="http://com.ibm.team.workitem/workitemTypes" id="com.ibm.team.workitem.configuration.workItemTypes">
<customAttributes category="com.ibm.team.workitem.workItemType">
<customAttribute id="phase" name="Phase found" type="phase"/>
<customAttribute id="regression" name="Regression" type="boolean"/>
</customAttributes>
</configuration-data>
<configuration-data xmlns="http://com.ibm.team.workitem/enumerations" id="com.ibm.team.workitem.configuration.enumerations">
<enumeration attributeTypeId="phase">
<literal default="true" id="phase.literal.l7" name="unit"/>
<literal id="phase.literal.l1" name="bvt"/>
<literal id="phase.literal.l2" name="fvt"/>
<literal id="phase.literal.l3" name="svt"/>
<literal id="phase.literal.l4" name="gvt"/>
<literal id="phase.literal.l5" name="tvt"/>
<literal id="phase.literal.l6" name="performance"/>
</enumeration>
</configuration-data>

<attribute sourceId="cf_testphase" targetId="phase"/>
<attributeType targetId="phase">
<value sourceId="unit" targetId="phase.literal.l7"/>
<value sourceId="gvt" targetId="phase.literal.l1"/>
<value sourceId="fvt" targetId="phase.literal.l2"/>
<value sourceId="svt" targetId="phase.literal.l3"/>
<value sourceId="gvt" targetId="phase.literal.l4"/>
<value sourceId="tvt" targetId="phase.literal.l5"/>
<value sourceId="performance" targetId="phase.literal.l6"/>
</attributeType>
<attribute sourceId="cf_regression" targetId="regression"/>
<attributeType targetId="boolean">
<value sourceId="---" targetId="false"/>
<value sourceId="Yes" targetId="true"/>
</attributeType>
<attribute sourceId="cf_feature" targetId="com.ibm.team.workitem.attribute.workitemtype"/>
<attributeType targetId="type">
<value sourceId="---" targetId="defect"/>
<value sourceId="yes" targetId="enhancement"/>
</attributeType>
</mapping>

hello ? anybody ?

hello ? anybody ?

Kevin mentioned
https://jazz.net/jazz/resource/itemName/com.ibm.team.workitem.WorkItem/64722
earlier in this thread. Can you confirm that you are seeing a different
problem?

When you say that the bugs show up with a greyed out symbol, do you mean
the Status/Resolution fields? If so, that would point to 64722, too.

What #64722 is basically about: The importer maps the bugzilla state or
resolution to an id which has no meaning in an RTC workflow. It will be
shown, but can't be edited.
The query for 'Defer' in your case would only find the work items that
have the correct resolution set, but not the ones with the unknown id.
Changing the state of the work item resets the resolution, which explains
why you find the work item after the modification.

--
Regards,
Patrick
Jazz Work Item Team