It's all about the answers!

Ask a question

Error in logs while running ETL for RTC & RI


Vinay Kumar AV (17923437) | asked Nov 23 '11, 1:53 p.m.
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

One answer



permanent link
Rosa Naranjo (2.9k11423) | answered Nov 23 '11, 4:48 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
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

Your answer


Register or to post your answer.