It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,230

question asked: Dec 10 '10, 6:27 a.m.
question was seen: 6,436 times
last updated: Dec 10 '10, 6:27 a.m.

Related questions

Insight for RQM, problem on customizing RQM fact builds

0
Nikolaus Utomo (11●3) | asked Dec 10 '10, 6:27 a.m.
Hi,

I tried to configure my Rational Insight for RQM. I'm following this document http://jazz.net/library/article/431/ . All the setting process works well until section 4.4. But I have a problem with section 4.5 (page 21 of 37) Customizing the RQM Fact Builds. I Change "{$RQMRESOURCE}" to "{$RESOURCEGROUP}". When I invoke the test on step 8, I get error message.

1. ERROR
DM-DBM-0400 UDA driver reported the following on connection Rational Quality Manager:
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "open result".
CRREE9000E: Internal Java error, check ri_jdbc.log for details

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

There are 2 types of ri_jdbc.log:

12/13/2010 04:49:19,571 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1224I: Start initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:49:20,914 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1223I: Finished initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:50:16,664 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1224I: Start initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:50:16,742 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1223I: Finished initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:50:16,899 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : Creating a new instance of RDSStatement.
12/13/2010 04:50:16,899 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRREE1227I: Preparing the query => SELECT "category_value",
"id",
"category_term",
"DATASOURCE_ID"
FROM "SAM"."RQMTestCase_Category_Lookup"
12/13/2010 04:50:17,227 INFO com.ibm.rational.etl.database.services.util.SQLRowFactoryHandler : Initialize XML handler
12/13/2010 04:50:17,227 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRREE1228I: Finished preparing the query => SELECT "category_value",
"id",
"category_term",
"DATASOURCE_ID"
FROM "SAM"."RQMTestCase_Category_Lookup"
12/13/2010 04:50:17,289 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRREE1229I: Executing the query => SELECT "category_value",
"id",
"category_term",
"DATASOURCE_ID"
FROM "SAM"."RQMTestCase_Category_Lookup"
12/13/2010 04:50:17,305 INFO com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRREE1231I: Initial URL Request => https://tcbdb.tivlab.raleigh.ibm.com:9444/jazz/web/console/ISAM/testcase?metadata=UUID&abbreviate=false
12/13/2010 04:50:42,680 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : Operation timed out: connect:could be due to invalid address
12/13/2010 04:50:42,680 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : http error dump END
12/13/2010 04:50:42,680 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: java.net.SocketException: Operation timed out: connect:could be due to invalid address
12/13/2010 04:51:24,789 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : Close this statement

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

The second one is below:

12/13/2010 04:57:57,586 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1224I: Start initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:57:58,821 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1223I: Finished initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:58:06,821 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1224I: Start initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:58:06,852 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1223I: Finished initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:58:34,055 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1224I: Start initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:58:34,071 INFO com.ibm.rational.drivers.jdbc.xml.RDSConnection : CRREE1223I: Finished initializing the connection to => jdbc:rds://C:\Program Files\IBM\Rational Insight\dataconfig\configs\Configurations\rqm.xdc
12/13/2010 04:58:34,196 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : Creating a new instance of RDSStatement.
12/13/2010 04:58:34,196 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRREE1227I: Preparing the query => SELECT "category_value",
"id",
"category_term",
"DATASOURCE_ID"
FROM "SAM"."RQMTestCase_Category_Lookup"
12/13/2010 04:58:34,399 INFO com.ibm.rational.etl.database.services.util.SQLRowFactoryHandler : Initialize XML handler
12/13/2010 04:58:34,399 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRREE1228I: Finished preparing the query => SELECT "category_value",
"id",
"category_term",
"DATASOURCE_ID"
FROM "SAM"."RQMTestCase_Category_Lookup"
12/13/2010 04:58:34,461 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRREE1229I: Executing the query => SELECT "category_value",
"id",
"category_term",
"DATASOURCE_ID"
FROM "SAM"."RQMTestCase_Category_Lookup"
12/13/2010 04:58:34,477 INFO com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRREE1231I: Initial URL Request => https://tcbdb.tivlab.raleigh.ibm.com:9444/jazz/web/console/ISAM/testcase?metadata=UUID&abbreviate=false
12/13/2010 04:59:32,055 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : The declaration for the entity "ContentType" must end with '>'.
12/13/2010 04:59:32,071 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : http error dump END
12/13/2010 04:59:32,071 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.etl.common.exception.ETLException: org.xml.sax.SAXParseException: The declaration for the entity "ContentType" must end with '>'.
12/13/2010 05:00:01,242 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : Close this statement

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

Can someone help or advice about this problem? Thank you

Regards
Nikolaus

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Dang En Ren (31) | answered Jan 19 '11, 10:51 p.m.
JAZZ DEVELOPER
Hi utomon,

What if you retrieve the data directly from Firefox?

https://tcbdb.tivlab.raleigh.ibm.com:9444/jazz/web/console/ISAM/testcase?metadata=UUID&abbreviate=false

not sure why this leads to invalid address, but expected URL should look like this:

https://<RQM_Server>/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/<ProjectAreaName>/testcase

so, please check you RQM xdc config.

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.