IBM Support

Error Connecting to Planning Analytics Server in Planning Analytics for Excel - PublicKeyToken not Serializable Error

Troubleshooting


Problem

After logging in to a TM1 server instance, the following error occurs: "Type 'Cognos.Office.Tm1.Connections.Tm1WebException' in Assembly 'TM1.Common, Version=11.0.50.5, Culture=neutral, PublicKeyToken=d6e6d7d808b7e5b7' is not marked as serializable"
Error
 

Symptom

Details of the message:
System.Runtime.Serialization.SerializationException: Type 'Cognos.Office.Tm1.Connections.Tm1WebException' in Assembly 'TM1.Common, Version=11.0.50.5, Culture=neutral, PublicKeyToken=d6e6d7d808b7e5b7' is not marked as serializable.
Server stack trace: 
   at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter, SerializationBinder binder)
   at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.Serialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter, SerializationBinder binder)
   at System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck)
   at System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck)
   at System.Runtime.Remoting.Channels.CrossAppDomainSerializer.SerializeMessageParts(ArrayList argsToSerialize)
   at System.Runtime.Remoting.Messaging.SmuggledMethodReturnMessage..ctor(IMethodReturnMessage mrm)
   at System.Runtime.Remoting.Messaging.SmuggledMethodReturnMessage.SmuggleIfPossible(IMessage msg)
   at System.Runtime.Remoting.Channels.CrossAppDomainSink.DoDispatch(Byte[] reqStmBuff, SmuggledMethodCallMessage smuggledMcm, SmuggledMethodReturnMessage& smuggledMrm)
   at System.Runtime.Remoting.Channels.CrossAppDomainSink.DoTransitionDispatchCallback(Object[] args)
Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Cognos.Office.Reporting.Domain.IShareTM1XLL.SetActiveServerName(String serverName, String uri)
   at Cognos.Office.Reporting.TM1.ShareManager.CommManager_OnLogOn(Object sender, LogOnEventArgs e)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at Cognos.Office.Framework.Communications.DataSourceManager.ds_LogOnEvent(Object sender, LogOnEventArgs e)
   at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
   at Cognos.Office.Tm1.Tm1DataSource.On_LogOn(String server)
   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

-This error can occur if your Planning Analytics for Excel is configured for a PMHub connection, and the PMHub service is unavailable

Resolving The Problem

-Ensure that the TM1 WebTier is running correctly and PMHub is access via http(s)://server.domain.com:9510/pmhub/pm/admin
-If the above doesn't fix the issue, then something may be wrong with the application server configuration.

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCTEW","label":"IBM Planning Analytics Local"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
21 September 2021

UID

ibm11957455