After Derby 2 DB2 data Migration:Project area not saved.

Hi

I am using RQM2.0, I have migrate data from RQM 2.0/Derby to RQM/DB2 on TOMCAT.

Both RQM installed on different Windows 2003 Server platform.

Tried repotools import/export option,I have not got any showstopper error after migration.

Data migrated in DB2 too.
But while tried to add some new team member/ admin in existing project.
Getting following error and because of that not able to save project area in RQM/DB2 system.

Anybody face this issue ? Any suggestions/Tips to solve this issue.

Error message:


Saving project area failed.

Duplicate permissions operation id specified:

com.ibm.rqm.planning.objective.save

Show Details Hide Details
com.ibm.team.process.common.service.ProcessDataValidationExcep

tion:at

com.ibm.team.process.internal.common.util.ProcessValidationUtil.vali

datePermissions(ProcessValidationUtil.java:332)at

com.ibm.team.process.internal.common.util.ProcessValidationUtil.vali

dateProjectConfiguration(ProcessValidationUtil.java:231)at

com.ibm.team.process.internal.common.util.ProcessValidationUtil.vali

dateProcessSpecification(ProcessValidationUtil.java:99)at

com.ibm.team.process.internal.service.DefaultProcessDataValidator.v

alidateProcessData(DefaultProcessDataValidator.java:101)at

com.ibm.team.process.internal.service.DelegatingProcessDataValidat

or.validateProcessData(DelegatingProcessDataValidator.java:74)at

com.ibm.team.process.internal.service.ProcessService.validateProject

AreaPostSave(ProcessService.java:2099)at

com.ibm.team.process.internal.service.ProcessService.validatePostS

ave(ProcessService.java:1781)at

com.ibm.team.process.internal.service.ProcessService.doTransaction

alSaveProcessItem(ProcessService.java:1427)at

com.ibm.team.process.internal.service.ProcessService$3.run

(ProcessService.java:1338)at

com.ibm.team.repository.service.internal.TransactionService$1.run

(TransactionService.java:99)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runT

ransaction(RepositoryDatabase.java:320)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runI

nTransaction(RepositoryDatabase.java:244)at

com.ibm.team.repository.service.internal.TransactionService.runInTran

saction(TransactionService.java:74)at

com.ibm.team.repository.service.internal.TransactionService.runInTran

saction(TransactionService.java:63)at

sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in

voke(ExportProxyServiceRecord.java:378)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.a

ccess$0(ExportProxyServiceRecord.java:364)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$

ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:56)at $Proxy45.runInTransaction

(Unknown Source)at

com.ibm.team.process.internal.service.ProcessService.runInTransacti

on(ProcessService.java:3341)at

com.ibm.team.process.internal.service.ProcessService.transactionalS

aveProcessItem(ProcessService.java:1336)at

com.ibm.team.process.internal.service.ProcessService.doSaveProce

ssItem(ProcessService.java:1330)at

com.ibm.team.process.internal.service.ProjectAreaSaveOperation.run

(ProjectAreaSaveOperation.java:84)at

com.ibm.team.process.internal.common.advice.runtime.OperationAdvi

ceManager.runOperation(OperationAdviceManager.java:1245)at

com.ibm.team.process.internal.common.advice.runtime.OperationAdvi

ceManager.advise(OperationAdviceManager.java:284)at

com.ibm.team.process.internal.common.util.AbstractProcess.doAdvis

e(AbstractProcess.java:181)at

com.ibm.team.process.internal.service.ServerProcess.access$1

(ServerProcess.java:1)at

com.ibm.team.process.internal.service.ServerProcess$2.run

(ServerProcess.java:130)at

com.ibm.team.repository.service.internal.TransactionService$1.run

(TransactionService.java:99)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runT

ransaction(RepositoryDatabase.java:320)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runI

nTransaction(RepositoryDatabase.java:244)at

com.ibm.team.repository.service.internal.TransactionService.runInTran

saction(TransactionService.java:74)at

com.ibm.team.repository.service.internal.TransactionService.runInTran

saction(TransactionService.java:63)at

sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in

voke(ExportProxyServiceRecord.java:378)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.a

ccess$0(ExportProxyServiceRecord.java:364)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$

ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:56)at $Proxy45.runInTransaction

(Unknown Source)at

com.ibm.team.process.internal.service.ProcessService.runInTransacti

on(ProcessService.java:3341)at

com.ibm.team.process.internal.service.ProcessService.runInTransacti

on(ProcessService.java:3348)at

com.ibm.team.process.internal.service.ServerProcess.adviseAndExec

ute(ServerProcess.java:128)at

com.ibm.team.process.internal.service.ProcessService.executeProce

ssItemSaveOperation(ProcessService.java:1142)at

com.ibm.team.process.internal.service.ProcessService.doSaveProce

ssItemsWithOverride(ProcessService.java:823)at

com.ibm.team.process.internal.service.ProcessService$1.run

(ProcessService.java:779)at

com.ibm.team.repository.service.internal.TransactionService$1.run

(TransactionService.java:99)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Tra

nsaction.run(RepositoryDatabase.java:466)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.r

un(RepositoryDatabase.java:292)at

com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.

withCurrentConnection(ConnectionPoolService.java:328)at

sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in

voke(ExportProxyServiceRecord.java:378)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.a

ccess$0(ExportProxyServiceRecord.java:364)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$

ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:56)at

$Proxy20.withCurrentConnection(Unknown Source)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runT

ransaction(RepositoryDatabase.java:288)at

com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runI

nTransaction(RepositoryDatabase.java:244)at

com.ibm.team.repository.service.internal.TransactionService.runInTran

saction(TransactionService.java:74)at

com.ibm.team.repository.service.internal.TransactionService.runInTran

saction(TransactionService.java:63)at

sun.reflect.GeneratedMethodAccessor153.invoke(Unknown Source)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in

voke(ExportProxyServiceRecord.java:378)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.a

ccess$0(ExportProxyServiceRecord.java:364)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$

ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:56)at $Proxy45.runInTransaction

(Unknown Source)at

com.ibm.team.process.internal.service.ProcessService.runInTransacti

on(ProcessService.java:3341)at

com.ibm.team.process.internal.service.ProcessService.saveProcessIt

emsWithOverride(ProcessService.java:777)at

com.ibm.team.process.internal.service.ProcessService.saveProcessIt

ems(ProcessService.java:728)at

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at

sun.reflect.NativeMethodAccessorImpl.invoke

(NativeMethodAccessorImpl.java:79)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in

voke(ExportProxyServiceRecord.java:378)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.a

ccess$0(ExportProxyServiceRecord.java:364)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$

ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:56)at $Proxy182.saveProcessItems

(Unknown Source)at

com.ibm.team.process.internal.service.web.ProcessRestService.post

ProjectArea(ProcessRestService.java:1487)at

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at

sun.reflect.NativeMethodAccessorImpl.invoke

(NativeMethodAccessorImpl.java:79)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.in

voke(ExportProxyServiceRecord.java:378)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.a

ccess$0(ExportProxyServiceRecord.java:364)at

org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$

ExportedServiceInvocationHandler.invoke

(ExportProxyServiceRecord.java:56)at $Proxy359.postProjectArea

(Unknown Source)at sun.reflect.NativeMethodAccessorImpl.invoke0

(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke

(NativeMethodAccessorImpl.java:79)at

sun.reflect.DelegatingMethodAccessorImpl.invoke

(DelegatingMethodAccessorImpl.java:43)at

java.lang.reflect.Method.invoke(Method.java:618)at

com.ibm.team.repository.servlet.AbstractTeamServerServlet.doModell

edRestService(AbstractTeamServerServlet.java:555)at

com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRe

quest(AbstractTeamServerServlet.java:1655)at

com.ibm.team.repository.servlet.AbstractTeamServerServlet.service

(AbstractTeamServerServlet.java:1471)at

javax.servlet.http.HttpServlet.service(HttpServlet.java:803)at

org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrap

per.service(ServletManager.java:180)at

org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleReq

uest(ServletRegistration.java:90)at

org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias

(ProxyServlet.java:111)at

org.eclipse.equinox.http.servlet.internal.ProxyServlet.service

(ProxyServlet.java:75)at javax.servlet.http.HttpServlet.service

(HttpServlet.java:803)at

org.eclipse.equinox.servletbridge.BridgeServlet.service

(BridgeServlet.java:121)at

com.ibm.team.repository.server.servletbridge.JazzServlet.service

(JazzServlet.java:54)at javax.servlet.http.HttpServlet.service

(HttpServlet.java:803)at

org.apache.catalina.core.ApplicationFilterChain.internalDoFilter

(ApplicationFilterChain.java:269)at

org.apache.catalina.core.ApplicationFilterChain.doFilter

(ApplicationFilterChain.java:188)at

org.apache.catalina.core.StandardWrapperValve.invoke

(StandardWrapperValve.java:210)at

org.apache.catalina.core.StandardContextValve.invoke

(StandardContextValve.java:174)at

org.apache.catalina.authenticator.AuthenticatorBase.invoke

(AuthenticatorBase.java:525)at

org.apache.catalina.core.StandardHostValve.invoke

(StandardHostValve.java:127)at

org.apache.catalina.valves.ErrorReportValve.invoke

(ErrorReportValve.java:117)at

org.apache.catalina.core.StandardEngineValve.invoke

(StandardEngineValve.java:108)at

org.apache.catalina.connector.CoyoteAdapter.service

(CoyoteAdapter.java:151)at

org.apache.coyote.http11.Http11Processor.process

(Http11Processor.java:870)at

org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHan

dler.processConnection(Http11BaseProtocol.java:665)at

org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket

(PoolTcpEndpoint.java:528)at

org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt

(LeaderFollowerWorkerThread.java:81)at

org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run

(ThreadPool.java:685)at java.lang.Thread.run(Thread.java:810)

We had the same issue - we edited the offending xml file and removed the duplicates. Then we were all set.

Hi

I am using RQM2.0, I have migrate data from RQM 2.0/Derby to RQM/DB2 on TOMCAT.

Both RQM installed on different Windows 2003 Server platform.

Tried repotools import/export option,I have not got any showstopper error after migration.

Data migrated in DB2 too.
But while tried to add some new team member/ admin in existing project.
Getting following error and because of that not able to save project area in RQM/DB2 system.

Anybody face this issue ? Any suggestions/Tips to solve this issue.

Error message:


Saving project area failed.

Duplicate permissions operation id specified:

com.ibm.rqm.planning.objective.save

Show Details Hide Details
com.ibm.team.process.common.service.ProcessDataValidationExcep

tion:at

com.ibm.team.process.internal.common.util.ProcessValidationUtil.vali

datePermissions(ProcessValidationUtil.java:332)at

com.ibm.team.process.internal.common.util.ProcessValidationUtil.vali

dateProjectConfiguration(ProcessValidationUtil.java:231)at

com.ibm.team.process.internal.common.util.ProcessValidationUtil.vali

dateProcessSpecification(ProcessValidationUtil.java:99)at