Mail link Archiving not working.

Our customer is trying to archive an email / document to on-premise 8.5R15 installation via Mail link with web client settings.

After a while the dialog gets closed and there's message saying that error occured while saving the document.

Noteworthy is that CRM web client works fine, and that URL http://louise/SuperOffice/Services/MailLinkService.svc is accessable from browser, no errors there.

Below is a debug log from Mail link during that document saving. This was still working few weeks ago, now it does not.

Is there anything particular that can be done to resolve this issue? We can force mail link to use Windows Client, but that option doesn't seem to stick, it defaults to web client soon after.

[2020.09.08 09:10:11] OUTLOOK.EXE: OUTLOOK EVENT: Explorer_Activate (+85621ms)
[2020.09.08 09:10:11] OUTLOOK.EXE: OUTLOOK EVENT: Triggering handler. (+3ms)
[2020.09.08 09:10:11] OUTLOOK.EXE: Dialog closed. (+23ms)
[2020.09.08 09:10:11] OUTLOOK.EXE: User-action completed. (+2ms)
[2020.09.08 09:10:11] OUTLOOK.EXE: ComSafeHelper: Releasing object. (+34ms)
[2020.09.08 09:10:11] OUTLOOK.EXE: ComSafeHelper: Releasing object. (+3ms)
[2020.09.08 09:10:13] OUTLOOK.EXE: Applying saved positioning. (+1426ms)
[2020.09.08 09:10:13] OUTLOOK.EXE: Applied positioning - Left: 77, Top: 189, Width: 720, Height: 760. (+2ms)
[2020.09.08 09:10:13] OUTLOOK.EXE: Showing dialog with Left: 77, Top: 189, Width: 720, Height: 760. (+1ms)
[2020.09.08 09:10:13] OUTLOOK.EXE: Showing modal child with repositioning = False, offScreen = False. (+1ms)
[2020.09.08 09:10:13] OUTLOOK.EXE: Showing dialog with startup-location Manual. (+2ms)
[2020.09.08 09:10:13] OUTLOOK.EXE: Showing dialog. (+1ms)
[2020.09.08 09:10:25] OUTLOOK.EXE: OUTLOOK EVENT: Inbox_ItemAdd (+12242ms)
[2020.09.08 09:10:25] OUTLOOK.EXE: OUTLOOK EVENT: Triggering MailReceived-handler. (+2ms)
[2020.09.08 09:10:25] OUTLOOK.EXE: ComSafeHelper: Releasing object. (+4ms)
[2020.09.08 09:10:46] OUTLOOK.EXE: Showing dialog with startup-location CenterOwner. (+20728ms)
[2020.09.08 09:10:46] OUTLOOK.EXE: Showing dialog. (+3ms)
[2020.09.08 09:10:52] OUTLOOK.EXE: Dialog closed. (+6657ms)
[2020.09.08 09:10:53] OUTLOOK.EXE: Asiakirjan tallennusvirhe SuperOffice.MailLink.Exceptions.SoTimeOutException: MailLinkRemoteExecute timed out! ---> System.TimeoutException: Pyyntökanavan aikakatkaisu odotettaessa vastausta, kun oli kulunut 00:01:59.9990016. Suurenna Request-kutsuun siirrettyä aikakatkaisuarvoa tai Binding-määrityksen SendTimeout-arvoa. Tälle toiminnolle osoitettu aika voi olla osa pidemmästä aikakatkaisusta. ---> System.TimeoutException: HTTP-pyyntö kohteeseen http://louise/SuperOffice/Services/MailLinkService.svc on ylittänyt asetetun aikakatkaisuarvon 00:02:00. Tähän toimintoon osoitettu aika voi olla pitemmän aikakatkaisun osa. ---> System.Net.WebException: Pyyntö keskeytettiin: Toiminto aikakatkaistiin.
kohteessa System.Net.HttpWebRequest.GetResponse()
kohteessa System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- Sisäisen poikkeuksen pinon jäljityksen loppu ---
kohteessa System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
kohteessa System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
kohteessa System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
--- Sisäisen poikkeuksen pinon jäljityksen loppu ---

Server stack trace:
kohteessa System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
kohteessa System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
kohteessa System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
kohteessa System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
kohteessa System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
kohteessa System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
kohteessa System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
kohteessa SuperOffice.MailLink.IMailLinkWcfService.WriteDocumentStreamPart(WriteDocumentStreamPartRequest request)
kohteessa SuperOffice.MailLink.Client.MailLinkRemote.<>c.<WriteDocumentStreamPart>b__39_1(IMailLinkWcfService5 server, WriteDocumentStreamPartRequest request)
kohteessa SuperOffice.MailLink.Client.MailLinkRemote.InnerExecute[TRequest,TResponse](IMailLinkWcfService5 server, OnExecute`2 execute, TRequest request, TResponse& response)
kohteessa SuperOffice.MailLink.Client.MailLinkRemote.Execute[TRequest,TResponse](OnPrepareRequest`1 prepare, OnExecute`2 execute)
--- Sisäisen poikkeuksen pinon jäljityksen loppu ---
kohteessa SuperOffice.MailLink.Client.MailLinkRemote.Execute[TRequest,TResponse](OnPrepareRequest`1 prepare, OnExecute`2 execute)
kohteessa SuperOffice.MailLink.Client.MailLinkRemote.WriteDocumentStreamPart(String documentStreamId, Int64 position, Byte[] data)
kohteessa SuperOffice.MailLink.Client.ProgressMailLinkService.WriteDocumentStreamPart(String documentStreamId, Int64 position, Byte[] data)
kohteessa SuperOffice.MailLink.Client.FeatureConfigService.WriteDocumentStreamPart(String documentStreamId, Int64 position, Byte[] data)
kohteessa SuperOffice.MailLink.Client.FileUploadHelper.DoWork(Object sender, DoWorkEventArgs e)
kohteessa System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
kohteessa System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument) (+9ms)
[2020.09.08 09:12:32] OUTLOOK.EXE: OUTLOOK EVENT: Explorer_Activate (+99843ms)
[2020.09.08 09:12:32] OUTLOOK.EXE: OUTLOOK EVENT: Triggering handler. (+1ms)
[2020.09.08 09:12:32] OUTLOOK.EXE: No context detected. Exiting state-update. (+2ms)
[2020.09.08 09:12:32] OUTLOOK.EXE: ComSafeHelper: Releasing object. (+2ms)
[2020.09.08 09:12:32] OUTLOOK.EXE: Dialog closed. (+48ms)

Currently seeing this as well at a customer. They are running 8.5 R14, and the logfiles says there's a timeout when trying to reach the maillinkservice.svc.

Haven't gotten any closer to resolve this yet. Will update here if I do.

//Marius

Av: Marius Gabrielsen 10. sep 2020

What I've gathered so far from the affected customers, we have multiple customers having this issue, is that they all have Office365 as mail service and SuperOffice running as on-premise install in local network with http connection.

They said that the problem started few weeks ago, after updating Outlook.

Will update any other relevant info here.

Av: Jani Sirainen 10. sep 2020

Hi Jani,

 

which version of Maillink is in Use and which Exact version of Outlook?

 

Greetings

 

Alexander

Av: Alexander Wohland 10. sep 2020

I'll throw in the versions for the customer I'm troubleshooting as well here:

8.5 R14 - SuperOffice
11.7.7472 - Maillink
11.7.7472.1704 - Webtools
15.0.4569.1506 - Office2013

I do notice that the msg file is uploaded to the temp folder of the web installation in the maillinkstream folder there.

//Marius

Av: Marius Gabrielsen 10. sep 2020

Hi Marius,

 

can you Update Office2013 to the newest Version?

If i see it correctly your Version has Update Status from March 2014 based on this Side

https://docs.microsoft.com/en-us/officeupdates/update-history-office-2013

 

Greetings


Alex

Av: Alexander Wohland 10. sep 2020

Can confirm aswell that files are uploaded to the server temp folder. From there I can clearly see that when the problem started, every email archived since 27.08.2020 is stuck there with GUID as file name.

Av: Jani Sirainen 11. sep 2020

Hi Jani,

 

did it happend after Updating to Maillink 11.7 or are you still using 11.6?

Really would appreaciate if you could tell use the Outlook Version in use.

 

Greetings


Alex

Av: Alexander Wohland 11. sep 2020

Hi,

I've got the versions now.

Mail Link: WebTools-2020.06.16-03 

Web Tools: WebTools-2020.06.16-03 (11.7.7472.1704)

Outlook: 16.0.0.12527

Av: Jani Sirainen 11. sep 2020

Hi,

I enabled debugging on service calls and found out that the database table EMAIL_ITEM is containing over 8,7GB worth of email data from over 75000 entries. Is this normal?

This causes problems with SQL Server Express since the overall database size exceeds limits given by Express.

I also did reference to our own database and there's below 200 records with around 23MB space used.

What's the proper way to get this issue solved?

Av: Jani Sirainen 11. sep 2020

Hi Jani,

 

this table is sued to Store Mails from the Internal Inbox of SuperOffice.

https://community.superoffice.com/documentation/SDK/SO.Database/html/Tables-email_item.htm

You can see under 

https://community.superoffice.com/documentation/SDK/SO.Database/html/Tables-email_account.htm

Who is using the Internal Inbox at the moment.

 

Greetings


Alex

Av: Alexander Wohland 11. sep 2020

Hi,

My customers actived Internal Inbox as a workaround for the current maillink problem. This just raised another problem.

I adviced them to remove Internal Inbox to no exceed SQL limits.

Sadly this does not give any help for the ongoing failures with the Maillink.

Av: Jani Sirainen 11. sep 2020

Hello,

You can specify how long emails should be stored in the EMAIL_ITEM table, this can be done by setting the following setting <add key="NumberOfDaysToDownload" value="30" /> in the web.config, section Mail > Component. (by default is 180).

The ejournalcron process will do the cleanup at night.

 

Av: David Hollegien 11. sep 2020

Hi,

 

issue got fixed after Updating Office.

It was not only with Maillink 11.7 but also with 11.6.

 

Greetings

 

Alex

Av: Alexander Wohland 21. sep 2020