Troubleshooting
Problem
After connecting to Cognos Analytics for Microsfot Excel, the user uses the Task Pane to access the model (they have multiple models (TM1 Servers)). Clicking on the folder to show the cubes and dimensions of this model, does nothing.
Environment
Cognos Analytics for Microsoft Excel
IntegratedSecurityMode = 5
Diagnosing The Problem
A Fiddler trace will record this error:
HTTP/1.1 500 Internal Server Error
Server: Apache-Coyote/1.1
SET-COOKIE: _ga=GA1.2.1528453756.1509760680; httponly
SET-COOKIE: PMSessionID=b87f8690-80ae-45fb-aa2c-e9c815697dbf; path=/; httponly
SET-COOKIE: _gid=GA1.2.547267178.1509760680; httponly
Content-Type: application/json
Content-Length: 338
Date: Sat, 04 Nov 2017 12:45:49 GMT
Connection: close
{"errorCode":"AuthorizedConnectionFailed","errorMessage":"http://servername.domain.com:9510/pmhub/pm/security/login?securityProvider=CAMbibus&providerURL=http%3A%2F%2F.com%3A9300%2Fp2pd%2Fservlet%2Fdispatch&OReq=db7279a8-fc15-4701-9c77-53eab549dd86&PMses=b87f8690-80ae-45fb-aa2c-e9c815697dbf&origLocale=en_US"}
Tested the same url in internet browser, results in HTTP 500:
http://servername.domain.com:9510/pmhub/pm/tm1/api/Planning_Sample/v1/cubes
Resolving The Problem
In this particular case, the model(s) that were not accessible in Cognos Analytics for Microsoft Excel were missing the end forward slash '/' on the ServerCAMURI in the tm1s.cfg. The models that were accessible, had it.
We added it, restarted the server and issue is resolved.
Was: ServerCAMURI=http://BIServerName.domain.com:9305/p2pd/servlet/dispatch
Change it to: ServerCAMURI=http://BIServerName.domain.com:9305/p2pd/servlet/dispatch/
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg22013712