Insight for RQM, problem on customizing RQM fact builds
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
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
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.
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.