rtc and rqm integration issue
i integrated the rtc 2.0.0.2 with rqm 2.0.0.1 ifix2. i followed all the steps on rqm info center and everything looks ok. after integration i successfully linked the project. Now i m getting 2 issues
1. from RQM when i try to open defect in RTC project, state and resolution fields are disabled. although i m succesfully able to submit the defect in rtc project
2. when i try to link test cases in rtc workitems, Test Case Selection popup appears in rtc client but keep showing "Loading........."
I looked at the rqm server log and found few errrors
ERROR 42Y07: Schema 'RESOURCE0' does not exist
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 110 more
15:14:06,996 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
15:14:36,387 WARN net.jazz.ajax.service.internal.http.ProxyHandler - Attempt made to make a remote request to URI https://192.168.2.121:9443/jazz/oslc_qm/catalog, but no whitelist is configured
15:22:27,230 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
15:30:47,371 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
15:39:08,262 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
1. from RQM when i try to open defect in RTC project, state and resolution fields are disabled. although i m succesfully able to submit the defect in rtc project
2. when i try to link test cases in rtc workitems, Test Case Selection popup appears in rtc client but keep showing "Loading........."
I looked at the rqm server log and found few errrors
ERROR 42Y07: Schema 'RESOURCE0' does not exist
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source)
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source)
... 110 more
15:14:06,996 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
15:14:36,387 WARN net.jazz.ajax.service.internal.http.ProxyHandler - Attempt made to make a remote request to URI https://192.168.2.121:9443/jazz/oslc_qm/catalog, but no whitelist is configured
15:22:27,230 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
15:30:47,371 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.
15:39:08,262 WARN com.ibm.rqm.defects - Couldn't retrieve latest states from remote url - https://192.168.2.221:9443/jazz, please check your server or network configuration.
The detail exception is
CRJAZ1247I The request to the server failed. The server returned the http error 500 with error text "Internal Server Error". Examine any further details here or look in the server log files for more information on how to resolve the issue.