It's all about the answers!

Ask a question

TestCases custom attributes update using RQMExcelImporterForDotNET45


Rajanikanth Kakarla (112) | asked Mar 12 '18, 7:07 p.m.
edited Mar 17 '18, 5:04 p.m. by Geoffrey Clemm (30.1k33035)

 Hi,

  I am trying to update all my TestCases Custom Attributes using  RQMExcelImporterForDotNET45 but it is giving below message in MSO2rqm_debug.txt file.

Can someone guide me on this issue to resolve.

3/12/2018 3:43:13 PM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Destroyed commands


3/12/2018 3:43:13 PM: INFO: <Unknown Caller Context>: caption : RQM


3/12/2018 3:43:14 PM: INFO: <Unknown Caller Context>: ExcelApplicationContext: Created commands


3/12/2018 3:43:44 PM: INFO: <Unknown Caller Context>: response from project contained <?xml version="1.0" encoding="UTF-8"?><feed xmlns="http://www.w3.org/2005/Atom"><title type="text">projects ATOM feed for all project areas</title><ns2:settingid>com.ibm.rqm.planningpreference</ns2:settingid></ns2:settingsids></ns2:project></content></entry></feed>


3/12/2018 3:43:44 PM: INFO: <Unknown Caller Context>: response from project has response content key 


3/12/2018 3:43:44 PM: INFO: <Unknown Caller Context>: response has keys: System.Collections.Hashtable+HashtableEnumerator

Thanks,
Raj


Comments
Don Yang commented Mar 12 '18, 8:52 p.m.
  • what is your RQM, RQMExcelImporter version and Excel version/bit?
  • are you able to import any samples(under your installed directory)?
  • what is the symptom/UI messages you see during export?(what leads you to check with the debug log)

Rajanikanth Kakarla commented Mar 12 '18, 10:01 p.m. | edited Mar 12 '18, 11:50 p.m.

 Hi Don,

 Here is the details
  1.  My RQM is : 5.0.2,    RQMExcelImporter version : 5.0.2 ,   Excel version : 2013/32 bit
  2. No
  3.  initializing...
       Reading Configuration file....
       Warning: Exporting completed, but no artifacts were found !
       Details log file at :  local location

Thanks,
Raj
   
 


Don Yang commented Mar 12 '18, 10:11 p.m.

Hi, Raj

Do you mean you haven't tried any samples or it has the same issue as you got in this post? It is important to find out if the tool itself has problem or it is your xls/cfg leading to the issue. Can you please have a try with the sample if you haven't done so?


Rajanikanth Kakarla commented Mar 13 '18, 1:42 p.m. | edited Mar 13 '18, 6:41 p.m.

 Yes i tried other examples but giving same errors. 


Thanks,
Raj


Rajanikanth Kakarla commented Mar 13 '18, 1:50 p.m. | edited Mar 13 '18, 6:41 p.m.

 Do you think i am using wrong RQMExcelImporter  Version? 

 Do you  have any simple example for  Test Case update using RQMExcelImporter ?

Thanks,
Raj


Rajanikanth Kakarla commented Mar 13 '18, 6:07 p.m. | edited Mar 13 '18, 8:34 p.m.

 Hi Don,

     I am seeing some progress on  uploading my .cfg file to RQM server but  it is taking a new test case(Error throwing Another test case is already named "stage_cli_09.")

My requirement is i have to update the Test Case custom attributes for all the Test cases. So i have added 3 Test cases with config files for testing in stage env.

 This is the error i am seeing.  Is there a separate way for update? Please suggest me for next steps...


3/13/2018 2:21:58 PM: 
SESSION: 3/13/2018 2:21:58 PM


3/13/2018 2:21:58 PM: Getting artifacts from current document TestCases 002 with custom attributes.xls

3/13/2018 2:21:59 PM: Created 3 artifacts, sending to server

3/13/2018 2:21:59 PM: INFO: <Unknown Caller Context>: ExportRepositoryDialog.reqUrl : 


3/13/2018 2:21:59 PM: sending testcase0 named TestCases_002_with_custom_attributes_DDR_3.xml



3/13/2018 2:21:59 PM: ERROR: <Unknown Caller Context>: The remote server returned an error: (500) Internal Server Error.


3/13/2018 2:21:59 PM: EXCEPTION: : The remote server returned an error: (500) Internal Server Error.


3/13/2018 2:21:59 PM:    at System.Net.HttpWebRequest.GetResponse()
   at Mso2Rqm_Common.RQMConnector.PutToServer(String url, String data)


3/13/2018 2:21:59 PM: ERROR: <Unknown Caller Context>: <?xml version="1.0" encoding="UTF-8" standalone="yes"?><ns2:Error xmlns:ns20="http://jazz.net/xmlns/alm/qm/styleinfo/v0.1/" xmlns:ns21="http://www.w3.org/1999/XSL/Transform" xmlns:ns10="http://open-services.net/ns/core#" xmlns:ns11="http://open-services.net/ns/qm#" xmlns:ns12="http://jazz.net/xmlns/prod/jazz/rqm/process/1.0/" xmlns:ns13="http://www.w3.org/2002/07/owl#" xmlns:ns14="http://jazz.net/xmlns/alm/qm/qmadapter/v0.1" xmlns:ns15="http://jazz.net/xmlns/alm/qm/qmadapter/task/v0.1" xmlns:ns16="http://jazz.net/xmlns/alm/qm/v0.1/executionresult/v0.1" xmlns:ns17="http://jazz.net/xmlns/alm/qm/v0.1/catalog/v0.1" xmlns:ns18="http://jazz.net/xmlns/alm/qm/v0.1/tsl/v0.1/" xmlns:ns1="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:ns2="http://jazz.net/xmlns/alm/qm/v0.1/" xmlns:ns3="http://schema.ibm.com/vega/2008/" xmlns:ns4="http://purl.org/dc/elements/1.1/" xmlns:ns5="http://jazz.net/xmlns/prod/jazz/process/0.6/" xmlns:ns6="http://jazz.net/xmlns/alm/v0.1/" xmlns:ns7="http://purl.org/dc/terms/" xmlns:ns8="http://jazz.net/xmlns/alm/qm/v0.1/testscript/v0.1/" xmlns:ns9="http://jazz.net/xmlns/alm/qm/v0.1/executionworkitem/v0.1"><ns2:statusCode>500</ns2:statusCode><ns2:message>Internal server error</ns2:message><ns2:trace>com.ibm.team.repository.common.TeamRepositoryException: AQXPL5009E Another test case is already named "stage_cli_09."
at com.ibm.rqm.planning.service.internal.TestArtifactCommon.getUniquessNameContraintErrorMessage(TestArtifactCommon.java:1991)
at com.ibm.rqm.planning.service.internal.TestArtifactCommon.nameUniquenessConstraint(TestArtifactCommon.java:1953)
at sun.reflect.GeneratedMethodAccessor1059.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy952.nameUniquenessConstraint(Unknown Source)
at com.ibm.rqm.planning.service.internal.rest.TestCaseRestService$1.run(TestCaseRestService.java:793)
at com.ibm.rqm.planning.service.internal.rest.TestCaseRestService$1.run(TestCaseRestService.java:1)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService$3.run(PrimitiveTransactionService.java:169)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:386)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:291)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:103)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:98)
at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy173.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:37)
at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy249.runInTransaction(Unknown Source)
at com.ibm.rqm.common.service.internal.BucketLockService.runInTransactionWrapper(BucketLockService.java:146)
at com.ibm.rqm.common.service.internal.BucketLockService.runInTransactionWrapperRetry(BucketLockService.java:179)
at sun.reflect.GeneratedMethodAccessor1477.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy437.runInTransactionWrapperRetry(Unknown Source)
at com.ibm.rqm.planning.service.internal.rest.TestCaseRestService.postTestCase(TestCaseRestService.java:892)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy1002.postTestCase(Unknown Source)
at com.ibm.rqm.oslc.service.internal.integration.handler.put.TestcasePutHandler$2.run(TestcasePutHandler.java:579)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService$3.run(PrimitiveTransactionService.java:169)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:386)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:291)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:103)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:98)
at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy173.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:37)
at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy249.runInTransaction(Unknown Source)
at com.ibm.rqm.oslc.service.internal.integration.handler.put.TestcasePutHandler.createOrUpdate(TestcasePutHandler.java:572)
at com.ibm.rqm.oslc.service.internal.integration.handler.put.TestcasePutHandler.unmarshal(TestcasePutHandler.java:139)
at com.ibm.rqm.oslc.service.internal.integration.handler.put.TestcasePutHandler.unmarshal(TestcasePutHandler.java:1)
at com.ibm.rqm.integration.handler.AbstractPutHandler.handle(AbstractPutHandler.java:161)
at com.ibm.rqm.integration.handler.AbstractPostHandler.handle(AbstractPostHandler.java:83)
at sun.reflect.GeneratedMethodAccessor255.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy1301.handle(Unknown Source)
at com.ibm.rqm.integration.service.internal.IntegrationService$2.run(IntegrationService.java:638)
at com.ibm.rqm.common.service.internal.BucketLockService$1.run(BucketLockService.java:70)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService$3.run(PrimitiveTransactionService.java:169)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:570)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$2.run(RepositoryDatabase.java:354)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:476)
at sun.reflect.GeneratedMethodAccessor62.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy138.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:351)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runInTransaction(RepositoryDatabase.java:291)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:103)
at com.ibm.team.repository.service.internal.PrimitiveTransactionService.runInTransaction(PrimitiveTransactionService.java:98)
at sun.reflect.GeneratedMethodAccessor152.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy173.runInTransaction(Unknown Source)
at com.ibm.team.repository.service.internal.TransactionService.runInTransaction(TransactionService.java:37)
at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy249.runInTransaction(Unknown Source)
at com.ibm.rqm.common.service.internal.BucketLockService.runInTransaction(BucketLockService.java:63)
at com.ibm.rqm.common.service.internal.BucketLockService.runInTransactionS(BucketLockService.java:203)
at sun.reflect.GeneratedMethodAccessor980.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy437.runInTransactionS(Unknown Source)
at com.ibm.rqm.integration.service.internal.IntegrationService.handleRequestInConfiguration(IntegrationService.java:633)
at com.ibm.rqm.integration.service.internal.IntegrationService.access$0(IntegrationService.java:464)
at com.ibm.rqm.integration.service.internal.IntegrationService$1.call(IntegrationService.java:369)
at com.ibm.rqm.integration.service.internal.IntegrationService$1.call(IntegrationService.java:1)
at com.ibm.team.repository.service.AbstractService.runWithActiveConfiguration(AbstractService.java:1061)
at com.ibm.rqm.integration.service.internal.IntegrationService.handleRequest(IntegrationService.java:365)
at com.ibm.rqm.integration.service.internal.IntegrationService.perform_PUT(IntegrationService.java:230)
at com.ibm.team.repository.service.TeamRawService.service(TeamRawService.java:96)
at sun.reflect.GeneratedMethodAccessor254.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:361)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:347)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at com.sun.proxy.$Proxy872.service(Unknown Source)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.doRestService(AbstractTeamServerServlet.java:971)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2520)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2315)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1794)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3761)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:975)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:459)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:526)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:312)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:87)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1784)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1815)
</ns2:trace></ns2:Error>


Don Yang commented Mar 13 '18, 6:51 p.m.

Hi, Raj

There are many things unclear in your comments.
- you mentioned you have tried the other examples but the same issue. Have you try the samples such as TestCases 001 with custom attributes.cfg/TestCases 001 with custom attributes.xls from the RQMExcelImporter install(under install directroy\RQMExcelImporter\Samples)? If you changed some values of custom attributes in the 2nd export, do you see the update or not?
This is how you may try to get familiar with the tool and cfg file and update your own cfg/xls to have your own use cases

- RQMExcelImporterForDotNET45 is a version for TLS2 support. If that is not required, usually we use other version but RQMExcelImporterForDotNET45 should also have all the features other installer has.

- it seems you have manually created some test cases with custom attributes and you want to update those test cases, is that right?
what is your cfg file like?
what is your xls like?



Rajanikanth Kakarla commented Mar 13 '18, 7:08 p.m. | edited Mar 13 '18, 7:25 p.m.

 Hi Don,

    Here is the details.
1. you mentioned you have tried the other examples but the same issue. Have you try the samples such as TestCases 001 with custom attributes.cfg/TestCases 001 with custom attributes.xls from the RQMExcelImporter install(under install directroy\RQMExcelImporter\Samples)?
  Ans: yes i tried but getting this error "The field "Automation Priority" is REQUIRED." because some of the fields  mandatory in my rqm. 

2.  If you changed some values of custom attributes in the 2nd export, do you see the update or not? 
Ans: No I am not seeing the update . the Same excel i used and modified with My 3 existing Test cases but getting this error. " Another test case is already named stage_cli_09. "  Here it should take as update but it is not taking.

3. what is your cfg file like? what is your cfg file like?
Ans:  These 2 files same like under RQMExcelImporter  install (directroy\RQMExcelImporter\Samples).

Thanks,
Raj


Don Yang commented Mar 13 '18, 7:30 p.m.

>>>Same excel i used and modified with My 3 existing Test cases

-- how the 3 existing test cases were created: through UI or by ExcelImporter
-- obviously you modified the samples to accommodate your own use case(such as working around mandatory fields), what is your update cfg file like?
what is your xls like?
it is impossible for anyone to try any suggestions without knowing your cfg and xls but only an error message in your use case.


Rajanikanth Kakarla commented Mar 13 '18, 7:44 p.m. | edited Mar 13 '18, 8:33 p.m.

  My Existing Test Cases are created by UI.  We have 20K test cases now and i have to update these test cases Custom attribute. So RQM UI is not giving option to update custom attribute value at one time for all the test cases.


Here is my cfg  file.

//testsuite.dc:title=C1
//testsuite.dc:description=A4
//testsuite.testcases=testcase

testcase.XLSStartRow=7
testcase.dc:title=B
testcase.dc:description=E
testcase.jzalm:owner=C

//testcase.customAttributes.type="SMALL_STRING"
//testcase.customAttributes.identifier=M
//testcase.customAttributes.name=N
//testcase.customAttributes.value=O

//testcase.customAttributes identifier=M.name=N.value=O
//testcase.customAttributes identifier="CA1".name="CA1".value=O
testcase.customAttributes identifier=M3.name=N3.type=M4.value=O
testcase.customAttributes identifier=O3.name=P3.type=O4.value=P
//if custom attribute type is not specified. the default is "SMALL_STRING"
testcase.customAttributes identifier=Q3.name=R3.type=Q4.value=Q

//testcase.customAttributes identifier="CA2".name="CA2".type="".value=O
testcase.category term="Category".value=M


testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCaseDesign","RQM-KEY-TC-DESIGN-TITLE")=F
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePreCondition","RQM-KEY-TC-PRE-COND-TITLE")=K
testcase.Section("myns:com.ibm.rqm.planning.editor.section.testCasePostCondition","RQM-KEY-TC-POST-COND-TITLE")=L

Here is the excel image :
I am not able to upload excel or excel image here. Is there a way i can send you directly?


Thanks,
Raj


showing 5 of 10 show 5 more comments

2 answers



permanent link
Don Yang (7.7k21114139) | answered Mar 13 '18, 8:50 p.m.
edited Mar 13 '18, 8:51 p.m.

Hi, Raj

In your xls file, I suppose you have 3 existing test case related info in 3 rows(you want to update those 3 rows) and one of them I guess should have named "stage_cli_09".

In your cfg file, add a line
testcase.XLSArtifactID=S

in xls's 'S' column, for each row of existing test case, please add existing test case internal id there:
urn:com.ibm.rqm:testcase:xx

here xx should be the id of test case you see on test case UI.
You may want to create a brand new testcases over UI for a testing purpose.
For example your new test cases have id: 100, 101,102
you set

urn:com.ibm.rqm:testcase:100
for the row of test case 100
urn:com.ibm.rqm:testcase:101 for row test case101 and urn:com.ibm.rqm:testcase:102 for row test case 102

Then try to export and see if 3 of them got updated or not.
You would need to be careful here that the update means update those you specified in cfg file only and those not specified, it could be erased. For example, the testcase has a testscript linking to it. Since cfg file has no testscript specified, that link will be removed. Basically this is like a process to "recreate" the testcase using the existing testcase id only. Therefore, you may want to create some new testcase similar to your existing test cases and test with this approach and see how to update your cfg file to "preserve" those you want to keep and update only those you want.
I hope this helps you start with.


Comments
Rajanikanth Kakarla commented Mar 14 '18, 5:59 p.m. | edited Mar 14 '18, 6:27 p.m.

 Thanks Don. I will try this and let you know the updates.


Rajanikanth Kakarla commented Mar 16 '18, 6:18 p.m. | edited Mar 18 '18, 9:04 p.m.

 Hi Don,

  I implemented sample test cases update based on your notes and it is working.
Now i have to try with update custom attribute value without loosing data for other attributes. Any inputs appreciated.

Thanks,
Raj


Don Yang commented Mar 18 '18, 9:09 p.m.

I don't know the details of existing test cases. You may want to test case view and export to csv file and see what are there and see what need to be preserved and try with Samples(for syntax of various features) modification and see how to achieve that. Also need to notice the links(test script etc) It may require trial and errors.
If there is a new scenario(such as linking to existing test script etc) and you can not make it work. You can create a new post with the details on what you have tried and what the result is like so that the community may help you further.


permanent link
Rajanikanth Kakarla (112) | answered Mar 22 '18, 2:05 p.m.

 Hi Don,

   Thanks for your inputs..I am successfully updated custom attributes for Test cases but i am seeing one issue.I am using Generic userid and pwd for updating the test cases but Owner field is taking this userd id after update.

I want to Keep same userid  when Test case was created but not this updated  generic userid. Any idea how to fix this?

Thanks,
Raj


Comments
Don Yang commented Mar 23 '18, 12:47 a.m.

In that case, you may need to set the owner to existing owner as well.
from
https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter
syntax is:
 testcase.alm:owner

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.