Troubleshooting
Problem
When users open Excel and try to connect to Planning Analytics on Cloud, no servers are listed under Connection.
Symptom
If a user clicks on the Connection name, the following error is thrown:
Cannot access a disposed object. Object name: "Tm1AuthBrowser"
System.ObjectDisposedException: Cannot access a disposed object.
Object name: 'Tm1AuthBrowser'.
at System.Windows.Forms.Control.CreateHandle()
at System.Windows.Forms.Form.CreateHandle()
at System.Windows.Forms.Control.get_Handle()
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Cognos.Office.Framework.SingleDialog.ShowDialog(Form form, IWin32Window owner)
at Cognos.Office.Tm1.Security.UILogon.BrowserLogon(String title, String connectURL, String serverPath, CookieCollection cookies, Boolean largeLogonDialog)
at Cognos.Office.Tm1.Tm1DataSource.HostLogon(Tm1AuthenticationProperties properties)
at Cognos.Office.Tm1.Tm1DataSource.Logon(LogonType logonType, DataSourcePropertiesCollection properties)
at Cognos.Office.Framework.Communications.DataSourceManager.LogOn(String dsType, String connectionString, String serverName, IDataSource& source)
Object name: 'Tm1AuthBrowser'.
at System.Windows.Forms.Control.CreateHandle()
at System.Windows.Forms.Form.CreateHandle()
at System.Windows.Forms.Control.get_Handle()
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Cognos.Office.Framework.SingleDialog.ShowDialog(Form form, IWin32Window owner)
at Cognos.Office.Tm1.Security.UILogon.BrowserLogon(String title, String connectURL, String serverPath, CookieCollection cookies, Boolean largeLogonDialog)
at Cognos.Office.Tm1.Tm1DataSource.HostLogon(Tm1AuthenticationProperties properties)
at Cognos.Office.Tm1.Tm1DataSource.Logon(LogonType logonType, DataSourcePropertiesCollection properties)
at Cognos.Office.Framework.Communications.DataSourceManager.LogOn(String dsType, String connectionString, String serverName, IDataSource& source)
Cause
The cause of the issue was an unresponsive pmpsvc service on one of the webtiers.
Diagnosing The Problem
1) Close all Excel sessions
2) Launch Fiddler making sure HTTPs options are set
3) Launch Excel and click on IBM Planning Analytics add-on tab
In the Fiddler trace, you will see there is a called to PMHUB:
https://<environment_name>.planning-analytics.ibmcloud.com/pmhub/pm/tm1/api/v1/Servers
This fails with a http 401 error.
Resolving The Problem
This is a 2 webtier load balanced environment.
A quick check shows webtier 1 is not responding.
Recycling pmpsvc resolved the issue.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSD29G","label":"IBM Planning Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
20 September 2021
UID
ibm10870270