While trying to open an analysis from library or trying to execute an Information link, the user gets the following error message in Spotfire Analyst or Spotfire Web Player:

The data table "MyExampleDataTable" could not be opened. The data source may be missing or has been changed.
OR
You are not logged in to the server with sufficient permissions. Contact an administrator for assistance.


Symptoms:
User is unable to open analysis from library.
User is unable to execute Information links.

The following error and stack trace are seen in the Spotfire Analyst or Web Player:
====================
Error message: You are not logged in to the server with sufficient permissions. Contact an administrator for assistance.
InformationModelException at Spotfire.Dxp.Data:
The spotfireuser principal has insufficient privileges. (HRESULT: 80131500)
Stack Trace:
   at Spotfire.Dxp.Data.InformationModel.InternalInformationModelManager.OpenJob(InformationLinkElement informationLink, IList`1 parameters, Boolean isReferenced)
   .......
InformationModelServiceException at Spotfire.Dxp.Services:
The spotfireuser principal has insufficient privileges. (HRESULT: 80131509)
Stack Trace:
   at Spotfire.Dxp.Services.WebServiceBase`1.InvokeService[T](ServiceMethod`1 serviceMethod, ExceptionFactoryMethod exceptionFactoryMethod)
   ........
You are not logged in to the server with sufficient permissions. Contact an administrator for assistance.
====================

The  Spotfire Server logs shows following error message:
====================
ERROR 2014-10-10T13:12:16,887+0800 [spotfireuser, #4] api.common.InformationModelServiceCommon: The spotfireuser  principal has insufficient privileges.
com.spotfire.ws.api.common.InformationModelWebServiceException: The spotfireuser principal has insufficient privileges.
at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:135)
.........
at java.lang.Thread.run(Thread.java:744)
Caused by: com.spotfire.ws.im.IMException: No execute permission for query or one of its references
at com.spotfire.ws.im.QueryPipe.checkPermissions(QueryPipe.java:801)
.........
... 73 more
====================

Cause:
This error message is due to the user not having "Access" permission on the Spotfire library folders where any of the following items are located:

  1. The Information Link used in the analysis.
  2. All elements used in the Information Link (column elements, filter elements, join elements).
  3. The Spotfire data source(s) used in creating any of the elements used in building the Information link.

Error message "The data table 'MyExampleDataTable' could not be opened" OR "You are not logged in to the server with sufficient permissions" in Spotfire.

Give the "Access" permission on the Spotfire library folders where any of the following items are located:
    1. The Information Link used in the analysis.
    2. All elements used in the Information link (column elements, filter elements, join elements).
    3. The Spotfire data source(s) used in creating any of the elements used in building the Information link.