Troubleshooting
Problem
When trying to connect to a specific TM1 server by using Performance Modeler, it is failing with this error message:
Could not connect to planning service
Unable to connect to the planning service
The present document covers only the case when this error occurs for one specific TM1 Server.
If this error happens for any TM1 servers, then contact IBM Support and provide the fpmsvc_config.xml file from "C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml" and the cogstartup.xml from "C:\Program Files\ibm\cognos\tm1_64\configuration".
Cause
Invalid value for a CUBE_TYPE attribute
Diagnosing The Problem
In the "tm1s-log.properties" file that resides in the same folder as "tm1s.cfg" file, add the following line:
log4j.logger.TM1.NGAPI.REST = DEBUG
Next step is to reproduce the problem and check "tm1server.log".
The last TM1.NGAPI.REST requests give an indication about the nature of the object that is causing the issue in Performance Modeler.
In that case, le last requests are beginning like this:
TM1.NGAPI.REST GET: /v1/cubeAttributes
This indicates there is probably an issue with some attributes.
Resolving The Problem
In Architect, open any cube in cube viewer, go to "Edit" menu, and select "Edit Cube Attributes".
Check that the CUBE_TYPE attribute does not contain any invalid values.
The only valid value is "METRICS". The only purpose of the CUBE_TYPE attribute is to indicate whether a cube is a metrics cube or not.
After all wrong values are removed, click OK and try to open Performance Modeler again.
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"ARM Category":[{"code":"a8m3p000000PC7RAAW","label":"Planning Analytics-\u003EPerformance Modeler"},{"code":"a8m3p000000PC7YAAW","label":"Planning Analytics-\u003EPerformance Modeler-\u003EModel and Reporting"},{"code":"a8m3p000000PC7XAAW","label":"Planning Analytics-\u003EWeb Contributor Application"},{"code":"a8m3p000000PC7hAAG","label":"Planning Analytics-\u003EWeb Contributor Application-\u003EModel and Reporting"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
16 April 2022
UID
ibm16572873