Error fetching information about the imported data. Please check the data being imported. Details
com.Strategy.webapi.MSTRWebAPIException: (You do not have Read access to the Table object ‘Custom Query’.)
CAUSE:This is a known issue in Strategy Web 10.
When a freeform SQL cube is created a logical table object and a physical table object are created in the backend. In Strategy 9.3.x - 9.4.x, the Access Control List (ACL) of both two tables is blank by default. When users modify the freeform SQL cubes in Strategy 9.3.x - 9.4.x, this error does not occur because the backend bypasses the security check for the ACL on the two tables. However, in Strategy 10, the security check is not bypassed, causing the users to see the error message above due to the missing ACL.
By default in Strategy 10, logical and physical tables created from freeform SQL sources have the Everyone group added with Full Control. For newly created freeform SQL cubes, the ACLs will include the Everyone group, therefore the error will not occur. However, for migrated objects from previous versions Strategy 10 does not override the ACLs of the logical and physical tables which means users can encounter the error above if the ACLs are not manually updated.
ACTION:Contact Strategy Technical Support for the latest update on this issue.
WORKAROUND:There are two workarounds as shown below:
Workaround 1: Manually add the Everyone group with View access to the ACL of the logical and physical table.
- To find the logical table of the freeform SQL cube, follow the steps below:
- Log into Strategy Developer as an Administrator and connect to the project.
- Navigate to the freeform SQL Cube and right-click to select ‘Search for components’
- In the search window, navigate to Tools > Options and enable the option ‘Display Managed Objects’ then hit OK.
- In the search, locate the Logical Table and right-click to select the ‘Properties’ menu
- In the Properties menu, navigate to Security > Permissions
- Add the Everyone group with View permission, like shown below:
