Our purchase requisition workflow is failing with a "Stopped (error)" status. The workflow cannot complete due to SQL database permission errors when trying to access the model security policy runtime view. We haven't customized the workflow it is the standard workflow.
Full Error Stack Trace:
Stopped (error): Stack trace: Call to TTSCOMMIT without first calling TTSBEGIN. session 27657 (Admin) SELECT T1.ELEMENTHANDLE,T1.LAYERID,T1.NAME,T1.PRIMARYTABLEAOTNAME,T1.QUERYOBJECTAOTNAME,T1.CONSTRAINEDTABLE,T1.CONTEXTTYPE,T1.CONTEXTSTRING,T1.ISMODELED,T1.MODELEDQUERYDEBUGINFO,T1.ISDIRTY,T1.OPERATION,T1.RECVERSION,T1.RECID,T1.MODELEDQUERYPACKDATA FROM [CompanyDynamicsAX_model].[dbo].MODELSECPOLRUNTIMEVIEW T1 WHERE (CONSTRAINEDTABLE=?) [Microsoft][SQL Server Native Client 10.0][SQL Server]The SELECT permission was denied on the object 'MODELSECPOLRUNTIMEVIEW', database 'CompanyDynamicsAX_model', schema 'dbo'.
Any guidance on resolving this SQL permission issue would be greatly appreciated. Thank you in advance for your assistance!
2
Share
Report
All responses (
Answers (
