OOTBE2E - RQM_ODS2.0.1 -> HTTP 410 (GONE) Error returned

Hi,

Im using OOTBE2E from Rational Insight 1.0.1 script.
When we launch the RQM_ODS2.0.1 process there are many errors on the script execution. The job I executed is: RQM_ODS2.0.1_FullLoad.

There are 3 builds that return me an error (Contributor, Requirement and BuildRecord):

Build Node 2 'Contributor'; Pending -> Executing
Build Node 2 'Contributor'; initializing
Build Node 2 'Contributor'; executing (pid 6528)
Build Node 2 'Contributor'; component 'Contributor', RunId 6, AuditId 159
pid 6528 Build Node 2 'Contributor'; reported the following:
DM-DBM-0400 UDA driver reported the following on connection Rational Quality Manager:
UDA-SQL-0107 A general exception has occurred during the operation "fetch".
CRRRE9000E: Error interno de Java, compruebe ri_jdbc.log para obtener detalles
(for details, see Build_Contributor_0006.log)
Build Node 2 'Contributor'; Executing -> Failed
Build Node 2 'Contributor'; failed but continuing
RESULT4 = FALSE


Build Node 4 'Requirement'; Pending -> Executing
Build Node 4 'Requirement'; initializing
Build Node 4 'Requirement'; executing (pid 7536)
Build Node 4 'Requirement'; component 'Requirement', RunId 6, AuditId 161
pid 7536 Build Node 4 'Requirement'; reported the following:
DM-DBM-0400 UDA driver reported the following on connection Rational Quality Manager:
UDA-SQL-0107 A general exception has occurred during the operation "fetch".
CRRRE9000E: Error interno de Java, compruebe ri_jdbc.log para obtener detalles
(for details, see Build_Requirement_0006.log)
Build Node 4 'Requirement'; Executing -> Failed
Build Node 4 'Requirement'; failed but continuing
RESULT6 = FALSE


Build Node 48 'BuildRecord'; Pending -> Executing
Build Node 48 'BuildRecord'; initializing
Build Node 48 'BuildRecord'; executing (pid 4424)
Build Node 48 'BuildRecord'; component 'BuildRecord', RunId 6, AuditId 179
pid 4424 Build Node 48 'BuildRecord'; reported the following:
DM-DBM-0400 UDA driver reported the following on connection Rational Quality Manager:
UDA-SQL-0107 A general exception has occurred during the operation "fetch".
CRRRE9000E: Error interno de Java, compruebe ri_jdbc.log para obtener detalles
(for details, see Build_BuildRecord_0006.log)

When I check the ri_jdbc.log file the errors are motivated by the same problem:

04/15/2011 01:57:17,107 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1226I: Ha finalizado la ejecucin de la consulta => SELECT
"userid",
"name",
"id",
"DATASOURCE_ID",
"url"
FROM "RQM"."RQMContributor"
where modifiedsince='1899-12-31 00:00:00'
04/15/2011 01:57:17,123 INFO com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRRRE1219I: Solicitud de URL inicial => https://rqm-sal.insags.com:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/PSICAP/contributor?metadata=UUID&abbreviate=false&modifiedsince=1899-12-31T00:00:00.000%2B0100
04/15/2011 01:57:20,599 INFO com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : CRRRE1220I: La pgina siguiente est disponible en https://rqm-sal.insags.com:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/PSICAP/contributor?modifiedsince=1899-12-31T00%3A00%3A00.000%2B0100&abbreviate=false&metadata=UUID&token=_fasqIGdXEeCbe7Ju3RNDog&page=1
04/15/2011 01:57:20,863 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : HTTP/1.1 410 Gone
04/15/2011 01:57:20,863 ERROR com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread : com.ibm.rational.dataservices.client.auth.oauth.OAuthCommunicatorException: HTTP/1.1 410 Gone
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.dataservices.client.auth.oauth.OAuthCommunicatorException: HTTP/1.1 410 Gone
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:345)
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.run(PageFetcherThread.java:126)
Caused by:
com.ibm.rational.dataservices.client.auth.oauth.OAuthCommunicatorException: HTTP/1.1 410 Gone
at com.ibm.rational.dataservices.client.auth.oauth.OAuthCommunicator.execute(OAuthCommunicator.java:447)
at com.ibm.rational.dataservices.client.util.URLDataProvider.execute(URLDataProvider.java:142)
at com.ibm.rational.dataservices.client.util.URLDataProvider.openDataStream(URLDataProvider.java:125)
at com.ibm.rational.dataservices.client.util.URLDataProvider.openDataStream(URLDataProvider.java:84)
at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:275)
... 1 more
04/15/2011 01:57:20,894 INFO com.ibm.rational.drivers.jdbc.xml.RDSStatement : CRRRE1228I: Cerrar esta sentencia



If I test the urls on Internet explorer I get this results:

https://rqm-sal.insags.com:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/PSICAP/contributor?metadata=UUID&abbreviate=false&modifiedsince=1899-12-31T00:00:00.000%2B0100 OK, server response is ok. Contains a feed with the information requested.

https://rqm-sal.insags.com:9443/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/PSICAP/contributor?modifiedsince=1899-12-31T00%3A00%3A00.000%2B0100&abbreviate=false&metadata=UUID&token=_fasqIGdXEeCbe7Ju3RNDog&page=1 HTTP 410 (GONE) Error returned.


What should I check to avoid the error?

I also read a couple of articles about this error. Those tell us that this could be happening because a low value on the Feed Cache Expiry on RQM server. IBM default value is 30 and we set it to 60. This workaround did not work.

Regards,
Sanfe

Hi Jeff,

I`m not sure about the origin of the problem. If I try to query, for example, the requirement entity from RQM in a Datasource of Data Manager Application I get the same error.

The OOTBE2E catalog is not related to Insight? Every project makes his own part of the OOTBE2E catalog? I mean, RQM team builds the part of the ETL Catalog related to RQM?

Its quite possible that we open a PMR to try to resolve this issue.

Thanks