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 |
One answer
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, |
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.