XDC ERROR when create Data Mapping Table
7 answers
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.
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.
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
