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

Error in logs while running ETL for RTC & RI

Hi,

In our environment, we are setting up an integration between Rational Insight 1.0.1.1 and RTC 3.0.1. We have done the necessary configurations as per the link below:
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.rational.rcpr.help.doc%2Ftopics%2Ft_postinstall_upgrade_rrdi_ri.html

While we run the ETL Jobs its says the job succeeded but no data is loaded. Also, we get the below error in the logs:

11/17/2011 16:50:30,984 INFO com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRRRE1219I: Initial URL Request => https://vianmaru.in.ibm.com:9443/jts/rpt/repository/foundation?size=100&jts=true&fields=foundation%2Fcontributor%2F%28%40href%7CuserId%7CuniqueId%7CemailAddress%7CcontextId%7Cmodified%7CitemId%7Cname%7Carchived%29&modifiedsince=2011-11-16T00:00:00.000%2B0530
11/17/2011 16:50:34,421 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
11/17/2011 16:50:34,421 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:522)
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: The reference to entity "etag" must end with the ';' delimiter.
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:472)
... 1 more
Caused by:
org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:440)
... 1 more


When I try posting the URL request sent by RI to RTC in a broweser, it runs fine and gives the right data as given below:

----------------------------------------------------

<foundation>

<contributor>
<userId>vijay</userId>
<uniqueId>7bbe45f7f142d3a11bcdf9e63f314e9b</uniqueId>
<emailAddress>vijay@demo.com</emailAddress>
<contextId>_8lNyYNwSEd2pIJ5QVwgQGg</contextId>
<modified>2011-11-22T15:32:19.640+0530</modified>
<itemId>_gvPLOga4EeGQwcTpRyVYbg</itemId>
<name>vijay</name>
<archived>false</archived>
</contributor>

<contributor>
<userId>admin_user</userId>
<uniqueId>df71e353fcd6ce8970498493c15ad9a4</uniqueId>
<emailAddress>admin_user@in.ibm.com</emailAddress>
<contextId>_8lNyYNwSEd2pIJ5QVwgQGg</contextId>
<modified>2011-11-16T16:42:52.041+0530</modified>
<itemId>_6_C26xBDEeGbc5G_2Y7IfQ</itemId>
<name>admin_user</name>
<archived>false</archived>
</contributor>
</foundation>

Please help in resolving this issue.

Regards
Vinay

0 votes



One answer

Permanent link
Vinay

I'd suggest opening a workitem and attaching logs so that development can take a look.

I assume you are running the Data Manager ETLs and not the out of the box Java ETLs that run by default with RTC 3.0.1.

Have all the ETLs been run? When you say 'no data is loaded', where are you looking exactly? Provide screenshots when writing the workitem against RTC.

Hi,

In our environment, we are setting up an integration between Rational Insight 1.0.1.1 and RTC 3.0.1. We have done the necessary configurations as per the link below:
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=%2Fcom.ibm.rational.rcpr.help.doc%2Ftopics%2Ft_postinstall_upgrade_rrdi_ri.html

While we run the ETL Jobs its says the job succeeded but no data is loaded. Also, we get the below error in the logs:

11/17/2011 16:50:30,984 INFO com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRRRE1219I: Initial URL Request => https://vianmaru.in.ibm.com:9443/jts/rpt/repository/foundation?size=100&jts=true&fields=foundation%2Fcontributor%2F%28%40href%7CuserId%7CuniqueId%7CemailAddress%7CcontextId%7Cmodified%7CitemId%7Cname%7Carchived%29&modifiedsince=2011-11-16T00:00:00.000%2B0530
11/17/2011 16:50:34,421 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
11/17/2011 16:50:34,421 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:522)
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: The reference to entity "etag" must end with the ';' delimiter.
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:472)
... 1 more
Caused by:
org.xml.sax.SAXParseException: The reference to entity "etag" must end with the ';' delimiter.
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:440)
... 1 more


When I try posting the URL request sent by RI to RTC in a broweser, it runs fine and gives the right data as given below:

----------------------------------------------------

<foundation>

<contributor>
<userId>vijay</userId>
<uniqueId>7bbe45f7f142d3a11bcdf9e63f314e9b</uniqueId>
<emailAddress>vijay@demo.com</emailAddress>
<contextId>_8lNyYNwSEd2pIJ5QVwgQGg</contextId>
<modified>2011-11-22T15:32:19.640+0530</modified>
<itemId>_gvPLOga4EeGQwcTpRyVYbg</itemId>
<name>vijay</name>
<archived>false</archived>
</contributor>

<contributor>
<userId>admin_user</userId>
<uniqueId>df71e353fcd6ce8970498493c15ad9a4</uniqueId>
<emailAddress>admin_user@in.ibm.com</emailAddress>
<contextId>_8lNyYNwSEd2pIJ5QVwgQGg</contextId>
<modified>2011-11-16T16:42:52.041+0530</modified>
<itemId>_6_C26xBDEeGbc5G_2Y7IfQ</itemId>
<name>admin_user</name>
<archived>false</archived>
</contributor>
</foundation>

Please help in resolving this issue.

Regards
Vinay

0 votes

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
× 10,938

Question asked: Nov 23 '11, 1:53 p.m.

Question was seen: 5,457 times

Last updated: Nov 23 '11, 1:53 p.m.

Confirmation Cancel Confirm