Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

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

0 votes



One answer

Permanent link
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

1 vote

Comments

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 log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 01 '13, 6:28 a.m.

Question was seen: 4,840 times

Last updated: Sep 11 '13, 11:13 a.m.

Confirmation Cancel Confirm