It's all about the answers!

Ask a question

XDC ERROR when create Data Mapping Table


deni sukisno (1166) | asked Aug 01 '12, 5:22 a.m.
 Hi Everyone,

i have a problem when mapping data using XDC from focal point, when i try to get tabel data there is message like this CRRRE2863E Error occurs when parsing the XML data.  but this error not happen in another module

Can any one help me on this plz. 


7 answers



permanent link
Jin Peng (9634) | answered Aug 14 '12, 10:38 p.m.
JAZZ DEVELOPER
Hi,
Can you provide ri_jdbc.log file for the investigation?

permanent link
deni sukisno (1166) | answered Aug 14 '12, 11:08 p.m.
 Hi, Jin Peng

i have search for ri_jdbc.log in windows server 2008 but i can not found it. can you give me info where i can find it?
FYI: i use windows server 2008 , Insight 1.1

please help me to solve this issue. thanks
       


permanent link
Jin Peng (9634) | answered Aug 15 '12, 12:08 a.m.
JAZZ DEVELOPER
It is C:\Documents and Settings\Administrator\logs\ri_jdbc.log
After configured XDC, you need to run OOTBE2E job, then you will find this log. 

permanent link
deni sukisno (1166) | answered Aug 15 '12, 2:37 a.m.
hi Jin Peng,
i could not find it after run OOTBE2E job but when i run the jobs it show error about connection refused

please help me to solve this issue. thanks

permanent link
Jin Peng (9634) | answered Aug 15 '12, 2:54 a.m.
JAZZ DEVELOPER
Would you provide the log for running OOTBE2E? For the connection refused issue, have you set the "Rational Data Warehouse" connection?
An alternate way to generate the log is: in DataManager, click menu "Tools"-> "SQLTerm", in top left, select "FocalPoint" for database select box, then expand "FocalPoint" in left Database objects list, then right click a object such as "Projects", click "add table select statement", at last click execute button in the bottom. 

permanent link
deni sukisno (1166) | answered Aug 15 '12, 5:55 a.m.
edited Aug 15 '12, 6:40 a.m.
 hi Jin Peng,

i have set  "Rational Data Warehouse" connection .maybe it because i run all jobs where the is no xdc file like clearquest.so can't connect to data source. 
08/15/2012 17:16:46,676 INFO  com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1226I: Finished executing the query => SELECT "global_id",
"url",
"full_name",
"md5_url",
"DATASOURCE_ID"
FROM   "FocalPoint"."Member"
where modifiedsince=''
08/15/2012 17:16:46,696 INFO  com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRRRE1219I: Initial URL Request => http://localhost:8080/fp/resources/workspaces/3/modules/10/elements/?includeAttributes=true
08/15/2012 17:19:02,334 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: java.net.ConnectException: Connection refused: connect
08/15/2012 17:19:02,340 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: java.net.ConnectException: Connection refused: connect
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: java.net.ConnectException: Connection refused: connect
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:554)
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.run(PageFetcherThread.java:133)
Caused by: 
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: java.net.ConnectException: Connection refused: connect
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:504)
... 1 more
Caused by: 
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.AuthenticationException: java.net.ConnectException: Connection refused: connect
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:408)
... 1 more
Caused by: 
com.ibm.rational.dataservices.client.auth.AuthenticationException: java.net.ConnectException: Connection refused: connect
at com.ibm.rational.dataservices.client.auth.BasicAuthentication.getContent(BasicAuthentication.java:45)
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:399)
... 1 more
Caused by: 
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:391)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:252)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:239)
at java.net.Socket.connect(Socket.java:543)
at java.net.Socket.connect(Socket.java:493)
at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:403)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:521)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:246)
at sun.net.www.http.HttpClient.New(HttpClient.java:320)
at sun.net.www.http.HttpClient.New(HttpClient.java:337)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:822)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:774)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:699)
at com.ibm.rational.dataservices.client.auth.BasicAuthentication.getContent(BasicAuthentication.java:43)
... 2 more
08/15/2012 17:19:02,354 INFO  com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1228I: Close this statement

the the data source in from must be " telkomfp "."Member"  not "FocalPoint"."Member"

please help me to solve this issue. thanks


Comments
Jin Peng commented Aug 15 '12, 11:17 p.m.
JAZZ DEVELOPER

From the log, the connection is refused, is the FocalPoint install in the localhost as the XDC? If not, you need to open the focalpoint xdc file, change the URL of resource group "FocalPoint", and click "Test Connection" to make sure the connection is okay.


permanent link
deni sukisno (1166) | answered Aug 15 '12, 6:00 a.m.
Hi kacuina, 
 
Documents and settings is not a real folder. It is called a junction point and is used for legacy program interface.
Your data will be in C:\USERS\<your user name>\Appdata. This is a hidden folder in windows server 2008
		

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.