Board12 Add-In Office WebApi Login error

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?

Tagged:

Answers

  • Samson Sunny
    Samson Sunny Employee, Community Captain
    100 Comments Third Anniversary 25 Likes 5 Answers

    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
    data_analytics Customer
    First Comment
    edited July 2023

    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
    Samson Sunny Employee, Community Captain
    100 Comments Third Anniversary 25 Likes 5 Answers

    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.