Description:
This article addresses a Spotfire error "ImportException: Failed to execute data query: The <username> principal has insufficient privileges" encountered when a Spotfire user account lacks the necessary library permissions to access a data source folder.
Error as it might appear in Web Player instance log file:
ERROR;2025-09-03T16:27:26,947+00:00;2025-09-03 16:27:26,947;aa89a009-ebf8-417e-9a1f-c9febfe84be3;3107153e5ftrX4;WorkThread 356_20186;<username> WAT 331;bcadab2c2f5762f2f3e109059384d10d;Spotfire.Dxp.Web.WebAnalysis;"Unable to open file '/library_folder/project/analysis_name"
Spotfire.Dxp.Data.Exceptions.ImportException: Failed to execute data query: The <username> principal has insufficient privileges. ---> Spotfire.Dxp.Data.Exceptions.InformationModelException: The <username> principal has insufficient privileges. --->
Solution:
To resolve this issue, follow these steps:
1. *Grant Access Permission*:
- Navigate to the Spotfire library where the data source folder resides.
- Grant Access permission to the affected user (<username> in the error above) for the data source folder.
2. (Optional step) *Create a Parent Group with the same permission*:
- Create a separate parent group in Spotfire.
- Add all relevant user groups under this parent group.
- Assign Access level permissions to the parent group for the data source folder.
By implementing these steps, the permissions issue should be resolved, allowing users to execute data queries successfully.
Comments
0 comments
Please sign in to leave a comment.