Error when upgrading the Process Engine "The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_start',database 'master', schema 'dbo' "

Symptom

Error: com.filenet.api.exception.EngineRuntimeException: FNRCE0016E: E_DATABASE_
ERROR: The operation was unable to read from or write to the database. Property:
"JNDIXADataSource", Value: "PEDBDSXA" failedBatchItem=0 errorStack={
at com.filenet.engine.persist.CmDatabaseConnectionPersister.verifyProper
ties(CmDatabaseConnectionPersister.java:187)
at com.filenet.engine.persist.BaseGCDPersister.preExecuteChange(BaseGCDP
ersister.java:421)
at com.filenet.engine.persist.CmDatabaseConnectionPersister.preExecuteCh
ange(CmDatabaseConnectionPersister.java:81)
at com.filenet.engine.persist.BaseGCDPersister.executeChangeWork(BaseGCD
Persister.java:220)
at com.filenet.engine.persist.IndependentPersister.executeChange(Indepen
dentPersister.java:339)
at com.filenet.engine.persist.BaseGCDPersister.executeChange(BaseGCDPers
ister.java:129)
at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestB
rokerImpl.java:1487)
at com.filenet.engine.jca.impl.RequestBrokerImpl.executeChanges(RequestB
rokerImpl.java:1345)
at com.filenet.engine.ejb.EngineCoreBean._executeChanges(EngineCoreBean.
java:619)
at com.filenet.engine.ejb.EngineCoreBean.executeChanges(EngineCoreBean.j
ava:586)
at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.executeCh
anges(Unknown Source)
at com.filenet.engine.ejb.EngineBean.executeChanges(EngineBean.java:913)

at com.filenet.apiimpl.transport.ejbstubs.EJSLocalStatelessEngine_2e64c3
74.executeChanges(Unknown Source)
at com.filenet.apiimpl.transport.ejb.EnginePortLocal.executeChanges(Engi
nePortLocal.java:53)
at com.filenet.apiimpl.wsi.ServiceSessionNst$2.run(ServiceSessionNst.jav
a:1360)
at java.security.AccessController.doPrivileged(AccessController.java:452
)
at javax.security.auth.Subject.doAs(Subject.java:573)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:196)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:153)
at sun.reflect.GeneratedMethodAccessor17.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:239)
at com.filenet.apiimpl.wsi.ServiceSessionNst.sMakeInternalEJBCall(Servic
eSessionNst.java:1223)
at com.filenet.apiimpl.wsi.ServiceSessionNst.sHandleIncomingRequest(Serv
iceSessionNst.java:1067)
at com.filenet.engine.wsi.ListenerNst.service(ListenerNst.java:179)
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(ServletW
rapper.java:781)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletW
rapper.java:480)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(Serv
letWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebA
ppFilterManager.java:1114)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(Cac
heServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:
940)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.j
ava:1817)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.jav
a:200)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimina
tion(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(H
ttpInboundLink.java:316)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(Htt
pICLReadCallback.java:88)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted
(AioReadCompletionListener.java:175)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFutu
re.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChanne
lFuture.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.j
ava:775)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by: com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERRO
R: The database access failed with the following error: ErrorCode 0, Message 'en
list: caught Exception' failedBatchItem=0
at com.filenet.engine.dbpersist.DBMSSQLContext.throwEngineException(DBMS
SQLContext.java:396)
at com.filenet.engine.dbpersist.DBContext.throwEngineException(DBContext
.java:1301)
at com.filenet.engine.dbpersist.DBStatementBase.buildSingleExecution(DBS
tatementBase.java:536)
at com.filenet.engine.dbpersist.DBStatementBase.execute(DBStatementBase.
java:271)
at com.filenet.engine.persist.ObjectStorePersister.getDefaultSchemaName(
ObjectStorePersister.java:652)
at com.filenet.engine.persist.CmDatabaseConnectionPersister.verifyProper
ties(CmDatabaseConnectionPersister.java:180)
... 47 more
Caused by: java.sql.SQLException: enlist: caught Exception failedBatchItem=0
at com.ibm.ws.rsadapter.AdapterUtil.toSQLException(AdapterUtil.java:1699
)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessar
y(WSJdbcConnection.java:815)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcCon
nection.java:2832)
at com.filenet.engine.dbpersist.DBStatementBase.buildSingleExecution(DBS
tatementBase.java:507)
... 50 more
Caused by: javax.resource.ResourceException: enlist: caught Exception failedBatc
hItem=0
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java
:832)
at com.ibm.ejs.j2c.ConnectionManager.lazyEnlist(ConnectionManager.java:2
697)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.lazyEnlist(WSRdbM
anagedConnectionImpl.java:2653)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessar
y(WSJdbcConnection.java:745)
... 52 more
Caused by: javax.transaction.SystemException: XAResource start association error
:XAER_RMERR failedBatchItem=0
at com.ibm.tx.jta.impl.RegisteredResources.startRes(RegisteredResources.
java:1088)
at com.ibm.ws.tx.jta.RegisteredResources.enlistResource(RegisteredResour
ces.java:1161)
at com.ibm.ws.tx.jta.TransactionImpl.enlistResource(TransactionImpl.java
:2231)
at com.ibm.tx.jta.embeddable.impl.EmbeddableTranManagerSet.enlist(Embedd
ableTranManagerSet.java:157)
at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java
:733)
... 55 more
Caused by: javax.transaction.xa.XAException: com.microsoft.sqlserver.jdbc.SQLSer
verException: The EXECUTE permission was denied on the object 'xp_sqljdbc_xa_sta
rt', database 'master', schema 'dbo'. failedBatchItem=0
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.DTC_XA_Interface(SQL
ServerXAResource.java:647)
at com.microsoft.sqlserver.jdbc.SQLServerXAResource.start(SQLServerXARes
ource.java:679)
at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImp
l.java:1531)
at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:
1479)
at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java
:157)
at com.ibm.tx.jta.impl.RegisteredResources.startRes(RegisteredResources.
java:1037)
... 59 more
}
stack:
com.filenet.apiimpl.wsi.serialization.core.ExceptionSerialization.deseri
alize(ExceptionSerialization.java:196)
com.filenet.apiimpl.wsi.ServiceSessionNst.cDeserializeSoapFault(ServiceS
essionNst.java:693)
com.filenet.apiimpl.wsi.ServiceSessionNst.cReqRespPath(ServiceSessionNst
.java:223)
com.filenet.apiimpl.wsi.ServiceSessionNst.executeChanges(ServiceSessionN
st.java:85)
com.filenet.apiimpl.util.SessionHandle.executeChanges(SessionHandle.java
:112)
com.filenet.apiimpl.core.Session.callExecuteChanges(Session.java:146)
com.filenet.apiimpl.core.Session.executeChanges(Session.java:532)
com.filenet.apiimpl.core.Session.executeChange(Session.java:850)
com.filenet.apiimpl.core.IndependentlyPersistableObjectImpl.save(Indepen
dentlyPersistableObjectImpl.java:76)
com.filenet.apiimpl.core.IndependentlyPersistableObjectImpl.save(Indepen
dentlyPersistableObjectImpl.java:67)
filenet.pe.ejb.client.EJBGCDHelper$LocalActionUpgradeProcessStoreConfigu
ration.run(EJBGCDHelper.java:716)
filenet.pe.ejb.client.EJBGCDHelper$LocalActionUpgradeProcessStoreConfigu
ration.run(EJBGCDHelper.java:664)
java.security.AccessController.doPrivileged(AccessController.java:492)
javax.security.auth.Subject.doAs(Subject.java:572)
com.filenet.apiimpl.util.J2EEUtil.doAs(J2EEUtil.java:79)
com.filenet.api.util.UserContext.doAs(UserContext.java:142)
filenet.pe.ejb.client.EJBGCDHelper.upgradeProcessStoreConfiguration(EJBG
CDHelper.java:950)
filenet.pe.ejb.client.PEEJBSession.upgradeProcessStoreConfiguration(PEEJ
BSession.java:3592)
filenet.vw.api.VWClassFactory.ShortCircuit_upgradeProcessStoreConfigurat
ion(VWClassFactory.java:1905)
filenet.jpe.peupgrade.PEUpgrade.upgradeGCDInformation(PEUpgrade.java:366
)
filenet.jpe.peupgrade.PEUpgrade.performUpgrade(PEUpgrade.java:331)
filenet.jpe.peupgrade.PEUpgrade.execute(PEUpgrade.java:232)
filenet.jpe.peupgrade.PEUpgrade.main(PEUpgrade.java:78)