Only members of the SysAdmin role are permitted to use Query Service

Hi,

(Not sure if I've tagged this post correctly.)

We're experiencing an issue integrating a Third Party Web Content Management system with iMIS.

Issue summary
Occasionally the QueryService, when accessed as the "Seamless" user, throws an exception instead of returning results.

Steps to reproduce

1. Acquire a Login cookie for the seamless user using the MembershipWebService LoginUserAndProvideCookies action
2. Acquire a Login cookie for the web user using the MembershipWebService LoginUserAndProvideCookies action
3. Using the seamless Login cookie from (1) to authenticate, query the QueryService, GetResultsWithParameters action, using the queryPath of '$/ContactManagement/DefaultSystem/Queries/Advanced/Contact/Entitlements' and a parameter of the web username
4. Result
a. Expected The set of entitlements associated with the web username are returned
b. Actual A SOAP exception is thrown:
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Only members of the SysAdmin role are permitted to use Query Service.

We have checked the security of the user in (1) that is being used and they are a "full" user and they have the "SysAdmin" role attached.

The issue doesn't happen all the time, but it does happen enough to concern me.

I've escalated to technical support but not getting any love.

Anyone else seen this, or have any advice on the above process.

Thanks,

Scott

 

 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

iMIS Version

What version of iMIS are you using?

Also can you check the security of the query itself. More likely it is set for sysadmin only.

 

Nazer Mohamed

We're currently on

We're currently on 15.2.1.3282.

Even with the account using the Web Services set as SysAdmin, we're still seeing the issue, but we've modified our logic to retry if it fails with the error.