It's all about the answers!

Ask a question

Insight: ETL fails with org.xml.sax.SAXParseException


Timur Markunin (6495166146) | asked Apr 01 '13, 6:28 a.m.
edited Apr 01 '13, 6:29 a.m.

Hello,

We have added new enumeration to the RTC project area last week and it looks that it caused ETL exception:

04/01/2013 11:43:54,367 INFO  com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1223I: Preparing the query => SELECT "projectAreaItemId",
 "enumerationId",
 "literalId",
 "literalName",
 "DATASOURCE_ID"
FROM "WORKITEM_CCM"."Enumeration"
WHERE modifiedsince='2013-03-26 10:03:54'
04/01/2013 11:43:54,695 INFO  com.ibm.rational.etl.database.services.util.SQLRowFactoryHandler : Initialize XML handler
04/01/2013 11:43:54,695 INFO  com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1224I: Finished preparing the query => SELECT "projectAreaItemId",
 "enumerationId",
 "literalId",
 "literalName",
 "DATASOURCE_ID"
FROM "WORKITEM_CCM"."Enumeration"
WHERE modifiedsince='2013-03-26 10:03:54'
04/01/2013 11:43:55,164 INFO  com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1225I: Executing the query => SELECT "projectAreaItemId",
 "enumerationId",
 "literalId",
 "literalName",
 "DATASOURCE_ID"
FROM "WORKITEM_CCM"."Enumeration"
WHERE modifiedsince='2013-03-26 10:03:54'
04/01/2013 11:43:55,164 INFO  com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1226I: Finished executing the query => SELECT "projectAreaItemId",
 "enumerationId",
 "literalId",
 "literalName",
 "DATASOURCE_ID"
FROM "WORKITEM_CCM"."Enumeration"
WHERE modifiedsince='2013-03-26 10:03:54'
04/01/2013 11:43:55,211 INFO  com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRRRE1219I: Initial URL Request => https://kvhoclm3.delta.internal:9443/ccm/rpt/repository/workitem?size=100&fields=workitem%2FprojectArea%2F%28enumerations%2F%28literals%2F%28id%7Cname%29%7Cid%29%7CitemId%29&modifiedsince=2013-03-26T10:03:54.000%2B0200
04/01/2013 11:44:02,711 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
04/01/2013 11:44:02,711 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : http code: 200
04/01/2013 11:44:02,711 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : http message: OK
04/01/2013 11:44:02,711 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : url: https://kvhoclm3.delta.internal:9443/ccm/rpt/repository/workitem?size=100&fields=workitem%2FprojectArea%2F%28enumerations%2F%28literals%2F%28id%7Cname%29%7Cid%29%7CitemId%29&modifiedsince=2013-03-26T10:03:54.000%2B0200
04/01/2013 11:44:02,727 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
 at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:562)
 at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.run(PageFetcherThread.java:131)
Caused by:
com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
 at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:513)
 ... 1 more
Caused by:
org.xml.sax.SAXParseException: XML document structures must start and end within the same entity.
 at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
 at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:480)

Any ideas how to fix it?

-thanks in advance

One answer



permanent link
Stephanie Bagot (2.1k1513) | answered Sep 11 '13, 10:41 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
This looks like a known defect on CLM 4.0.1, fixed in 4.0.4.
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=265606

Comments
Bo Chulindra commented Sep 11 '13, 11:13 a.m.
JAZZ DEVELOPER

Timur: It's unfortunate that the work item mentioned here has no information in it (since it was created from an escalation). But from the items linked to it, it's clear that the item is related to this problem.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.