Product: TIBCO Spotfire®
Anonymous user may come across ERROR: "Failed to execute data query" while opening analysis file in TIBCO Spotfire Web Player.
In case of Anonymous authentication, when anonymous user (ANONYMOUS\guest) tries to open anaysis file in Web Player, this user may come across below error in Web Player log file - Spotfire.Dxp.Worker.Host.Debug.XXXX-XXXX-XXXX-XXXX-XXXXXXXX:
ERROR;2020-03-18T11:05:42,100+01:00;2018-07-20 10:05:42,100;fbab8f9f-e348-4751-8405-72aee5ae9307;181847c655SlOt;WorkThread 57;ANONYMOUS\guest WAT 118;Spotfire.Dxp.Web.Prompting.PromptHandler+PromptItem;"Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data query ---> Spotfire.Dxp.Data.Exceptions.InformationModelException: The guest principal has insufficient privileges. ---> Spotfire.Dxp.Services.Data.InformationModel.InformationModelServiceException: The guest principal has insufficient privileges.
at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod)
at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.OpenJob(InformationLinkElement informationLink, IList`1 parameters, Boolean isReferenced)
========== This error may occur if the anonymous user (ANONYMOUS\guest) account (or the group: 'Anonymous User' group) doesn't have "Access" permission on Spotfire library folders where any of these below library items are located.
- The information links associated with this analysis file.
- Any elements used in building the associated information links (column elements, filter elements, join elements)
- The Spotfire data source(s) used in creating any of the elements used in building the information links
Provide 'Anonymous User' group "Access" permission on all of the Spotfire library folders as mentioned above using Spotfire Library Administration.
Note: The folder that is most frequently overlooked, when granting these permissions, is the folder that contains the data source. Check "Configuring anonymous authentication" in the manual below