Troubleshooting
Problem
The following error message is returned, when a Planning Analytics package or module is used in Dashboarding or Reporting:
"MSR-GEN-0002 Error: "XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: DIM-ERR-1007 Failed to query cube information for data source "<dataserver_name>". Please check the connection string and ensure the server availability."
Symptom
"MSR-GEN-0002 Error: "XQE-PLN-0001 Internal error. The query could not be planned by the Query Service: DIM-ERR-1007 Failed to query cube information for data source "<dataserver_name>". Please check the connection string and ensure the server availability."
Cause
This error message can have different root causes. All have in common that the cube, which is part of the package or module, cannot be accessed.
- Users in Cognos Analytics trying to access a cube in Planning Analytics need to have appropriate permissions to access the cube, at least one element in all it´s dimensions and cells. Verify access by logging in with the user to Architect, confirming the cube can be accessed and browsed.
- The package contains a cube, which is no longer available. All cubes part of a package (hidden or not) needs to be accessible for the user
Environment
IBM Cognos Analytics 11.0 or 11.1
Resolving The Problem
- Give the Cognos users appropriate permissions in Planning Analytics
- Remove no longer available cubes from the package or module.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0.x","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
21 February 2020
UID
ibm10875650