2562184 - SELECT permission was denied on 'log_shipping_primary_databases' | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2562184 - SELECT permission was denied on 'log_shipping_primary_databases'

Symptom

  • Agent Administration -- reports an error :
    The SELECT permission was denied on the object 'log_shipping_primary_databases', database 'msdb', schema 'dbo'.
  • Text: Exception while getting database properties.
    [EXCEPTION]
    com.sap.smd.agent.plugin.connectors.webservice.WebServiceInvocationException: [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'log_shipping_primary_databases', database 'msdb', schema 'dbo'.
    at com.sap.smd.agent.plugin.connectors.webservice.JaxWebserviceInvocationHandler.invoke(JaxWebserviceInvocationHandler.java:126)
    at com.sun.proxy.$Proxy29.getDatabaseProperties(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.sap.smd.agent.facade.hostagent.HostAgentSyncProxy$SyncHandler.singleInvoke(HostAgentSyncProxy.java:116)
    at com.sap.smd.agent.facade.hostagent.HostAgentSyncProxy$SyncHandler.invoke(HostAgentSyncProxy.java:74)
    at com.sun.proxy.$Proxy30.getDatabaseProperties(Unknown Source)
    at com.sap.smd.agent.plugins.dcc.job.DatabaseInfoPushJob.getDatabaseProperties(DatabaseInfoPushJob.java:264)
    at com.sap.smd.agent.plugins.dcc.job.DatabaseInfoPushJob.run(DatabaseInfoPushJob.java:159)
    at com.sap.smd.server.exec.TaskRunner.run(TaskRunner.java:47)
    at com.sap.smd.server.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:781)
    at java.lang.Thread.run(Thread.java:763)
    Caused by: javax.xml.ws.soap.SOAPFaultException: [Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'log_shipping_primary_databases', database 'msdb', schema 'dbo'.
    at com.sun.xml.internal.ws.fault.SOAP11Fault.getProtocolException(SOAP11Fault.java:178)
    at com.sun.xml.internal.ws.fault.SOAPFaultBuilder.createException(SOAPFaultBuilder.java:117)
    at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:108)
    at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.invoke(SyncMethodHandler.java:78)
    at com.sun.xml.internal.ws.client.sei.SEIStub.invoke(SEIStub.java:110)
    at com.sun.proxy.$Proxy29.getDatabaseProperties(Unknown Source)
    at sun.reflect.GeneratedMethodAccessor31.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.sap.smd.agent.plugin.connectors.webservice.JaxWebserviceInvocationHandler.invoke(JaxWebserviceInvocationHandler.java:92)
    ... 12 more
  • SELECT permission denied error could also occur on log_shipping_secondary_databases.

Read more...

Environment

Solution Manager SP5
SQL Server 2005 - 2016

Product

SAP Solution Manager 7.2

Keywords

KBA , SV-SMG-DIA-SRV-LSC , OS and DB Host Discovery (Outside Discovery) , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.