Board12 Add-In Office WebApi Login error

data_analytics

Hi,

I'm trying to connect to an on-prem Board 12 server using SAML authentication via WebApi.

In the connection configurations I entered "https://myserver.com/" as hostname and I selected SAML.

When I try to connect (using Excel) the browser opens regularly on the login page, I enter the credentials and the browser displays the message "Please return to the app."

At this point however, when I go back to Excel the connection screen indicates a failure like:

Connection failed. An unhandled error occurred [cod_ref: 1690554725127]

cod_ref changes with each attempt.

ps. Server and Add-in version: 12.5.0

any suggestions?

Samson Sunny

Hi,

That particular error code reference should be logged in the web logs. The web logs and the diagnostic logs should give us more information on the error.

Web log location- C:\Program Files (x86)\Board\Board WebApi Server\App_Data\log

Diagnostic Logs- C:\Board\Dataset\Log

Also can you paste the app settings config here to better understand the configuration.

Thanks,

Samson.

data_analytics

Thanks for the quick reply, I am attaching what I found on the logs and the configuration.

Thanks again.

#######
webapi log
#######
2023-07-28 15:14:03.251 +00:00 [Error] LogEntry { Feature: NotDefined, Username: "myuser@mydomain.com", ConnectionId: "00000000-0000-0000-0000-000000000000", ProductVersion: "12.5.0.0.80037", Message: "https://myserver.com/api/wcfproxy", Exception: InvalidOperationException { Message: "This message cannot support the operation because it has been written.", Data: [DictionaryEntry { Key: "MS_LoggedBy", Value: [ApiExceptionLogger { }] }], InnerException: null, TargetSite: Byte[] SendMessagethroughWCFClient(System.ServiceModel.Channels.Message), StackTrace: "
Server stack trace:
at System.ServiceModel.Channels.Message.EnsureWriteMessageState(XmlDictionaryWriter writer)
at System.ServiceModel.Channels.BufferedMessageWriter.WriteMessage(Message message
at System.ServiceModel.Channels.BinaryMessageEncoderFactory.BinaryMessageEncoder.WriteMessage(Message message
at System.ServiceModel.Channels.FramingDuplexSessionChannel.EncodeMessage(Message message)
at System.ServiceModel.Channels.FramingDuplexSessionChannel.OnSendCore(Message message
at System.ServiceModel.Channels.TransportDuplexSessionChannel.OnSend(Message message
at System.ServiceModel.Channels.OutputChannel.Send(Message message
at System.ServiceModel.Dispatcher.DuplexChannelBinder.Request(Message message
at System.ServiceModel.Channels.ServiceChannel.Call(String action
at System.ServiceModel.Channels.ServiceChannel.Request(Message message
Exception rethrown at [0]:
at Board.Web.Controllers.WCFProxy.WCFProxy.SendMessagethroughWCFClient(Message msg)
at Board.Web.Controllers.WCFProxy.WCFProxy.ReadAndSendMessage(Byte[] msg)
at Board.Web.Controllers.WCFProxy.WCFProxyController.<Post>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Threading.Tasks.TaskHelpersExtensions.<CastToObject>d__1`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Filters.AuthorizationFilterAttribute.<ExecuteAuthorizationFilterAsyncCore>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__15.MoveNext()"
#######
diagnostic log
#######
2023-07-28 15:14:03.251 +00:00 INFO myuser@mydomain.com fd36db04-0e65-495a-8d90-7c2ed18fa62a NET_Connect [OFFICE_ADDIN] Starting action.
2023-07-28 15:14:03.251 +00:00 INFO myuser@mydomain.com fd36db04-0e65-495a-8d90-7c2ed18fa62a NET_Connect [OFFICE_ADDIN] Action completed. 0
#######
app settings
#######
<appSettings>
<add key="host" value="https://myserver.com/"/>
<add key="boardEngine" value="localhost" />
<add key="port" value="9700" />
<add key="localAuthEnabled" value="true" />
<add key="winAuthEnabled" value="true" />
<add key="anonymousAuthEnabled" value="false" />
<add key="anonymousAuthUsername" value="" />
<add key="anonymousAuthPassword" value="" />
<add key="useSSL" value="true" />
<add key="headerTitleHidden" value="false" />
<add key="chatEnabled" value="true" />
<add key="presentationEnabled" value="true" />
<add key="cognitiveSearchEnabled" value="true" />
<add key="cognitiveAnalysisEnabled" value="true" />
<add key="cognitiveCapsulesEnabled" value="true" />
</appSettings>

Samson Sunny

Hi,

Thanks for the additional info.

It would be great if you could open a case on our support portal support.board.com with these additional information so we can take a look at this in detail and keep track of the analysis.

Thanks,

Samson.