It's all about the answers!

Ask a question

unable to tag to artifacts in RM v6.0.3 after migrating from v3 to v6


John Le (612) | asked May 02 '17, 3:28 p.m.


If I modify artifacts before year 2016 and save it so the modified date is up-to-date, I will be able to tag it.  If I don't do that, I could not tag to any artifacts created after 2016 (the date we migrated from v3 to v6)

=============================================================================

This is error RM log file:


I got error 400 
ID CRRRW7223E  The server request that updates a tag could not be completed.
===========================================
2017-05-02 14:26:47,263 [             WebContainer : 10] ERROR m.ibm.rdm.fronting.server.services.tags.TagService  - CRRRS1007E  A problem occurred in the Requirements Management (RM) server: Entry [db7e09eaae572454]
com.ibm.rdm.fronting.server.exception.BadRequestException: Propagated exception; original message [BadRequestException: Process Area must not be null]
at com.ibm.rdm.fronting.server.exception.RRSException.newException(RRSException.java:250)
at com.ibm.rdm.fronting.server.exception.RRSException.newException(RRSException.java:800)
at com.ibm.rdm.fronting.server.exception.RRSException.capture(RRSException.java:804)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalServiceExchange.checkError(InternalServiceExchange.java:54)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalServiceExchange.getResponse(InternalServiceExchange.java:37)
at com.ibm.rdm.fronting.server.core.spi.BaseServiceRequest.execute(BaseServiceRequest.java:118)
at com.ibm.rdm.fronting.server.services.process.permissions.PermissionsHandler.handlePermissions(PermissionsHandler.java:60)
at com.ibm.rdm.fronting.server.services.tags.internal.TagPostRequest.checkPermissions(TagPostRequest.java:175)
at com.ibm.rdm.fronting.server.core.internal.request.RRSPostRequest.validate(RRSPostRequest.java:163)
at com.ibm.rdm.fronting.server.core.internal.request.RRSCommandBase.call(RRSCommandBase.java:265)
at com.ibm.rdm.fronting.server.services.tags.internal.TagServiceInternal.doPostInternal(TagServiceInternal.java:41)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase$RRSRestServiceBaseMappingChangeSetAwareExecutor.execute(RRSRestServiceBase.java:951)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.executeInMappingChangeSet(RRSRestServiceBase.java:919)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.runInternalMethodVVC(RRSRestServiceBase.java:899)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.runInternalMethod(RRSRestServiceBase.java:680)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.handleMethod(RRSRestServiceBase.java:579)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.doPost(RRSRestServiceBase.java:143)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.performService(RRSRestServiceBase.java:364)
at com.ibm.rdm.fronting.server.core.internal.RRSRestServiceBase.service(RRSRestServiceBase.java:206)
at com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:155)
at com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:282)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleAppSdkRestServiceRequest2(AbstractTeamServerServlet.java:2004)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.access$2(AbstractTeamServerServlet.java:1959)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet$2.service(AbstractTeamServerServlet.java:264)
at com.ibm.team.repository.service.internal.compatibility.auth.DelegatedAuthHandlerService$1.run(DelegatedAuthHandlerService.java:263)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleAuthentication(AbstractTeamServerServlet.java:2060)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleAppSdkRestServiceRequest(AbstractTeamServerServlet.java:1935)
at com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1662)
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:128)
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:152)
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:1232)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:480)
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:967)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1107)
at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3951)
at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:304)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1014)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:463)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:530)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88)
at com.ibm.ws.ssl.channel.impl.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1820)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
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:1892)
Caused by: com.ibm.rdm.fronting.server.exception.BadRequestException: Process Area must not be null
at com.ibm.rdm.fronting.server.exception.RRSException.newException(RRSException.java:250)
at com.ibm.rdm.fronting.server.exception.RRSException.newBadRequestParametersException(RRSException.java:132)
at com.ibm.rdm.fronting.server.exception.RRSException.newBadRequestException(RRSException.java:140)
at com.ibm.rdm.fronting.server.rrs.operations.internal.CheckPermissions.executeServiceRequest(CheckPermissions.java:87)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalDefaultPartitionerFactory$1ExecuteServiceRequest.call(InternalDefaultPartitionerFactory.java:29)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalDefaultPartitionerFactory$1ExecuteServiceRequest.call(InternalDefaultPartitionerFactory.java:1)
at com.ibm.rdm.fronting.server.core.spi.DefaultPartitionerFactory$1DefaultExecutor.call(DefaultPartitionerFactory.java:76)
at com.ibm.rdm.fronting.server.core.spi.DefaultPartitionerFactory$1DefaultExecutor.call(DefaultPartitionerFactory.java:1)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.handleExecutables(InternalCoreServices.java:711)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.execute(InternalCoreServices.java:408)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.executeRequestSequences(InternalCoreServices.java:1142)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.handleRequestSequences(InternalCoreServices.java:1090)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.execute(InternalCoreServices.java:363)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.execute(InternalCoreServices.java:259)
at com.ibm.rdm.fronting.server.core.jpi.internal.InternalCoreServices.execute(InternalCoreServices.java:252)
at com.ibm.rdm.fronting.server.core.spi.BaseServiceRequest.execute(BaseServiceRequest.java:112)
... 62 more
Request
--Not Provided--

3 answers



permanent link
Daniel Moul (4.9k1318) | answered May 02 '17, 3:33 p.m.
FORUM MODERATOR / JAZZ DEVELOPER

I suggest you open a support ticket (PMR). This doesn't seem like something we could solve here in the forum.


permanent link
John Le (612) | answered May 02 '17, 3:51 p.m.

 I try to look at RM database for "Process Area" must not be null and thinking to change the value "null" to "not null" or "true but I have many column. I don't know which one I should change. ratl105:ratl105:/data/bkup2/store/ratl105/FPSW_decommission > db2 describe table PROCESS.PROCESS_AREA

 

                                Data type                     Column <o:p> </o:p>

Column name                     schema    Data type name      Length     Scale Nulls <o:p> </o:p>

------------------------------- --------- ------------------- ---------- ----- ------ <o:p> </o:p>

STATE_ID                        SYSIBM    CHARACTER                   23     0 No <o:p> </o:p>

ITEM_ID                         SYSIBM    CHARACTER                   23     0 No <o:p> </o:p>

CONTEXT_ID                      SYSIBM    CHARACTER                   23     0 No <o:p> </o:p>

MODIFIED                        SYSIBM    TIMESTAMP                   10     6 No <o:p> </o:p>

MODIFIED_BY_ITEM_ID             SYSIBM    CHARACTER                   23     0 No <o:p> </o:p>

ARCHIVED                        SYSIBM    SMALLINT                     2     0 No <o:p> </o:p>

NAME_COL                        SYSIBM    VARCHAR                    250     0 No <o:p> </o:p>

UNIQUE_NAME                     SYSIBM    VARCHAR                    250     0 No <o:p> </o:p>

PROJECT_AREA_ITEM_ID            SYSIBM    CHARACTER                   23     0 No <o:p> </o:p>

JZ_DISCRIMINATOR                SYSIBM    INTEGER                      4     0 No <o:p> </o:p>

PROJECT_AREA_PROCSS_DFNTN_TM_D  SYSIBM    CHARACTER                   23     0 Yes <o:p> </o:p>

PROJECT_AREA_IS_INITIALIZED     SYSIBM    SMALLINT                     2     0 Yes <o:p> </o:p>

PROJECT_AREA_INTERNAL_PUBLIC    SYSIBM    SMALLINT                     2     0 Yes <o:p> </o:p>

PROJECT_AREA_RED_CCSS_LST_TM_D  SYSIBM    CHARACTER                   23     0 Yes <o:p> </o:p>

PRJCT_R_NTRNLPRJCTDVLPMNTLNTMD  SYSIBM    CHARACTER                   23     0 Yes <o:p> </o:p>

PROJECT_AREA_OWNING_APPLICTN_K  SYSIBM    VARCHAR                   1000     0 Yes <o:p> </o:p>

PRJCT_R_NTRNL_PRCSS_PRVDR_TM_D  SYSIBM    CHARACTER                   23     0 Yes <o:p> </o:p>

PROJECT_AR_NTRNL_S_PRCSS_PRVDR  SYSIBM    SMALLINT                     2     0 Yes <o:p> </o:p>

PRJCT_R_NTRNL_RMT_PRCSSPRVDRRL  SYSIBM    VARCHAR                    250     0 Yes <o:p> </o:p>

 

  19 record(s) selected. <o:p> </o:p>

 

ratl105:ratl105:/data/bkup2/store/ratl105/FPSW_decommission > <o:p> </o:p>

ratl105:ratl105:/data/bkup2/store/ratl105/FPSW_decommission > <o:p> </o:p>

ratl105:ratl105:/data/bkup2/store/ratl105/FPSW_decommission > db2 list tables for all | grep -i process_area <o:p> </o:p>

PROCESS_AREA                    PROCESS         T     2012-12-13-14.17.28.020002 <o:p> </o:p>

PROCESS_AREA_BIG_DECIMAL_EXTEN> PROCESS         T     2012-12-13-14.17.29.141938 <o:p> </o:p>

PROCESS_AREA_BOOLEAN_EXTENSION> PROCESS         T     2012-12-13-14.17.28.441058 <o:p> </o:p>

PROCESS_AREA_CONTRIBUTORS       PROCESS         T     2012-12-13-14.17.29.504158 <o:p> </o:p>

PROCESS_AREA_INTERNAL_ADMINS    PROCESS         T     2012-12-13-14.17.29.370389 <o:p> </o:p>

PROCESS_AREA_INTERNAL_PROCESS_> PROCESS         T     2012-12-13-14.17.29.246843 <o:p> </o:p>

PROCESS_AREA_INT_EXTENSIONS     PROCESS         T     2012-12-13-14.17.28.298223 <o:p> </o:p>

PROCESS_AREA_LARGE_STRING_EXTE> PROCESS         T     2012-12-13-14.17.28.831551 <o:p> </o:p>

PROCESS_AREA_LONG_EXTENSIONS    PROCESS         T     2012-12-13-14.17.28.703989 <o:p> </o:p>

PROCESS_AREA_MEDIUM_STRING_EXT> PROCESS         T     2012-12-13-14.17.28.984816 <o:p> </o:p>

PROCESS_AREA_STRING_EXTENSIONS  PROCESS         T     2012-12-13-14.17.28.204958 <o:p> </o:p>

PROCESS_AREA_TIMESTAMP_EXTENSI> PROCESS         T     2012-12-13-14.17.28.560691 <o:p> </o:p>

ratl105:ratl105:/data/bkup2/store/ratl105/FPSW_decommission > <o:p> </o:p>

 


Comments
Donald Nong commented May 03 '17, 12:20 a.m.

The issue is much more complicated than that. The error message may be misleading as well so you cannot take it for granted. As Daniel suggested, please contact Support.


Bas Bekker commented May 03 '17, 2:19 p.m.
JAZZ DEVELOPER

Yes, as said, looks like the issue is something else, so don't even think of changing db tables. Work with IBM Support.


permanent link
John Le (612) | answered May 03 '17, 2:35 p.m.

our Rational DOOR v6.0.3 license maintainance expired in April 31.  However we still have CCM and QM license maintainance so I can not open PMR and get support.  That is why I go here to see if anyone has the same error and solution.

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.