It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Fogbugz on demand import broken

We've successfully imported several projects, but we have problems with most important one. Parser breaks and stops at:

2013-02-21 08:25:07,105 INFO - Import started by bartek using com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzHostedDataBean

2013-02-21 08:25:07,246 INFO - ------------------------------

2013-02-21 08:25:07,246 INFO - Importing: Users

2013-02-21 08:25:07,246 INFO - ------------------------------

2013-02-21 08:25:07,246 INFO - Only new items will be imported

2013-02-21 08:25:07,425 INFO - 190 users associated with import.

2013-02-21 08:25:07,494 INFO - ------------------------------

2013-02-21 08:25:07,494 INFO - Finished Importing : Users

2013-02-21 08:25:07,494 INFO - ------------------------------

2013-02-21 08:25:07,494 INFO - 0 users successfully created.

2013-02-21 08:25:07,494 INFO - Retrieving projects...

2013-02-21 08:25:07,494 INFO - Project ExternalProject jiraId=<null>,id=13,externalName=Wikia,name=Wikia Enigneering,key=WE,url=<null>,lead=xxxxxx,description=<null>,projectCategoryName=<null>,avatarUrl=<null>,assigneeType=<null>,versions=<null>,components=<null>,issues=<null>,workflowSchemeName=Product Engineering already exists. Not imported

2013-02-21 08:25:07,495 INFO - ------------------------------

2013-02-21 08:25:07,495 INFO - Importing: Versions

2013-02-21 08:25:07,495 INFO - ------------------------------

2013-02-21 08:25:07,495 INFO - Only new items will be imported

2013-02-21 08:25:07,626 INFO - ------------------------------

2013-02-21 08:25:07,626 INFO - Finished Importing : Versions

2013-02-21 08:25:07,626 INFO - ------------------------------

2013-02-21 08:25:07,626 INFO - ------------------------------

2013-02-21 08:25:07,626 INFO - Importing: Components

2013-02-21 08:25:07,626 INFO - ------------------------------

2013-02-21 08:25:07,626 INFO - Only new items will be imported

2013-02-21 08:25:07,779 INFO - ------------------------------

2013-02-21 08:25:07,779 INFO - Finished Importing : Components

2013-02-21 08:25:07,779 INFO - ------------------------------

2013-02-21 08:25:07,779 INFO - Retrieving custom fields...

2013-02-21 08:25:07,779 INFO - ------------------------------

2013-02-21 08:25:07,779 INFO - Importing: Issues

2013-02-21 08:25:07,779 INFO - ------------------------------

2013-02-21 08:25:07,780 INFO - Only new items will be imported

2013-02-21 08:31:25,447 INFO - ------------------------------

2013-02-21 08:31:25,448 INFO - Finished Importing : Issues

2013-02-21 08:31:25,448 INFO - ------------------------------

2013-02-21 08:31:25,448 ERROR - Unexpected failure occurred. Importer will stop immediately. Data maybe in an unstable state

java.lang.RuntimeException: com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzRemoteException: org.jdom.input.JDOMParseException: Error on line 20: Open quote is expected for attribute width associated with an element type hr.

at com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzHostedDataBean.getIssuesIterator(FogBugzHostedDataBean.java:182)

at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.importIssues(DefaultJiraDataImporter.java:741)

at com.atlassian.jira.plugins.importer.imports.importer.impl.DefaultJiraDataImporter.doImport(DefaultJiraDataImporter.java:354)

at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:27)

at com.atlassian.jira.plugins.importer.imports.importer.impl.ImporterCallable.call(ImporterCallable.java:16)

at com.atlassian.jira.task.TaskManagerImpl$TaskCallableDecorator.call(TaskManagerImpl.java:365)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at com.atlassian.jira.task.ForkedThreadExecutor$ForkedRunnableDecorator.run(ForkedThreadExecutor.java:249)

at java.lang.Thread.run(Thread.java:662)

Caused by: com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzRemoteException: org.jdom.input.JDOMParseException: Error on line 20: Open quote is expected for attribute width associated with an element type hr.

at com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzClient.getWithToken(FogBugzClient.java:230)

at com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzClient.getCases(FogBugzClient.java:275)

at com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzHostedDataBean.getIssuesIterator(FogBugzHostedDataBean.java:132)

... 12 more

Caused by: org.jdom.input.JDOMParseException: Error on line 20: Open quote is expected for attribute width associated with an element type hr.

at org.jdom.input.SAXBuilder.build(SAXBuilder.java:468)

at org.jdom.input.SAXBuilder.build(SAXBuilder.java:770)

at com.atlassian.jira.plugins.importer.imports.fogbugz.hosted.FogBugzClient.getWithToken(FogBugzClient.java:223)

... 14 more

Caused by: org.xml.sax.SAXParseException: Open quote is expected for attribute width associated with an element type hr.

at org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown Source)

at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown Source)

at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)

at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)

at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown Source)

at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown Source)

at org.apache.xerces.impl.XMLScanner.scanAttributeValue(Unknown Source)

at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanAttribute(Unknown Source)

at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)

at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)

at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)

at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)

at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)

at org.jdom.input.SAXBuilder.build(SAXBuilder.java:453)

... 16 more

2013-02-21 08:31:25,566 INFO - No issues need to be reindexed.

1 answer

Hi,

unfortunately FogBugz REST API sometimes does not escape data correctly. So if you have an issue that has XML or HTML attachments it serves it unescaped and JIRA Importers Plugin is not able to parse it.

Solution in this case would be to track down the issue(s) and migrate them manually. You'd have to catch the failing request to see what query to FogBugz is not parsed.

I think the request that failed was http://your.fogbugz/fogbugz/api.asp?cmd=search&q=project:=13&cols=ixBug,tags,fOpen,sTitle,sArea,sComputer,ixPersonAssignedTo,ixPersonOpenedBy,sStatus,ixPriority,sPriority,sFixFor,sVersion,sCustomerEmail,dtOpened,dtClosed,dtResolved,hrsOrigEst,hrsElapsed,hrsCurrEst,sCategory,events

In case I'm wrong you can catch it using a network sniffer (or just analyze logs on FogBugz server).

Cheers,

Pawel

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Teamwork

Listening out loud: how Fabian Lopez works on distributed teams

The start of the COVID-19 pandemic served as a forcing function to re-evaluate the way teams worked together. In fact, many companies are re-learning how to collaborate with their teams. As some move...

58 views 2 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you