When trying to run any report, error shows up: "Error occurred during the generation of the result set"

Document ID : KB000031340
Last Modified Date : 14/02/2018
Show Technical Document Details

When trying to run any report, error shows up: "Error occurred during the generation of the result set"

 

TRC_REPORTER_*.log contain messages similar to:

041214-12:45:27.5458944L|005760|00001700|REPORTER |DbImplAdo |DbImpl_Ado.cpp |002358|NOTIFY | evalSQLInfo class: 14 state: 5 server: NT80 

041214-12:45:27.5459382L|005760|00001700|REPORTER |CDb |DbImpl_Ado.cpp |002644|NOTIFY | Error Message: ADO Version 6.1 - COM Error: ErrorCode:-2147217911,WordErrorCode:3081, IDispatch error #3081, The INSERT permission was denied on the object 'R00228E_M', database 'mdb', schema 'ca_itrm'., Microsoft SQL Server Native Client 10.0, (null) 

041214-12:45:27.5463167L|005760|00001700|REPORTER |DbImpl_Ado |DbImpl_Ado.cpp |002311|NOTIFY | evalSQLInfo sqlstate: 42000 native error: 229 0xe5 

 

ca_itrm apparently has no rights to write to the ROxx tables which are temporary tables created when running a report. 

When such error shows up, check following:

properties of user ca_itrm: Owned Schemas: ca_itrm 

 Capture.JPG

In the Database Role Membership following role members need to be checked:

ca_itrm_group 

db_ddladmin 

db_securityadmin 

 

 

Also check the ca_itrm_ams user: Owned Schemas: ca_itrm_ams; Database Role Membership : ca_itrm_group_ams 

 

 Capture1.JPG