iVend Alert Error: VIEW SERVER STATE permission was denied on object 'server', database 'master'.
Environment:
iVend 6.6 with SAP B1
Problem Statement:
iVend Alert Notification displays the error:
CreateSendDumpDataJob : error: VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action. : Site ID 1
Issue Details: iVend Alert Notification displays the error
CreateSendDumpDataJob : error: VIEW SERVER STATE permission was denied on object 'server', database 'master'. The user does not have permission to perform this action. : Site ID 1
Symptoms:
Replication Send dump seems to be problematic
Resolution:
We have updated the VIEW SERVER STATE permission was denied on object 'server', database 'master'.
And also started the replication service.
Related Articles
ISSUES WHEN INTIALIZING MASTER TABLES FROM SAP: "iVend 6.*.*.* add-on failed to update the database"
Product version 6.5 Update 6 Problem statement Getting Error "iVend 6.*.*.* add-on failed to update the database" when initializing master tables from SAP Reason CXSINTEGRATION DATABASE IS DELETED SAP database, already initialized with iVend database ...User permission in SAPB1 for Integrating SAPB1 data
Environment : iVend 6.6 and SAP HANA Problem Statement : Data updated in the SAP but it not integrating to the iVend. Symptoms : Updated data not showing in the iVend and event is also not showing in the Integration Monitor. Resolution/workaround: ...Cannot open database 'CXSIntegration' login failed
Environment: iVend 6.6 Problem Statement: Cannot open database 'CXSIntegration' login failed Symptoms: Environment Specific Resolution/Work Around: It seems wrong SQL password is entered for user "sa". So need to check correct password for SQL login ...Found error while login MC "Error encountered found in application"
Environment: 6.6.7989 Short Description: Error found in the application Product Query: While login in Management Console found error “Error found in the application” Resolution/Work Around: Not Applicable Recommendations /Suggestion: Ivend Database ...Remove Customer Master which has transaction and also remove those customer which has no transaction
Environment: Ivend 6.6 Problem statement: Need to Remove Customer Master which has transaction and also need to remove those customers which has no transaction details. Resolution/Work Around: 1. Remove customer master which has no transaction ...