Developer forum

Forum » Integration » Users import issue - timeout

Users import issue - timeout

E-mail notifications
Ricardo Pereira
Ricardo Pereira
Reply
Posted on 07/07/2021 18:04:45

Hi,

I’m experiencing some issues when trying to import users from an XML file provided by Business Central.
The process seems to fail due to Timeout after 1 hour. Maybe it’s related to the huge number of user addresses.

Below you can see the log with the query that is taking too long:
Job Failed with the following message: Exception: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. Sql query: update AccessUserAddressTempTableForBulkImport2 set AccessUserAddressUserID='181467' where AccessUserAddressUserID='E006193';  …

I saw an old post saying UserDestination has a timeout of 60 minutes. Could this be the problem?
https://doc.dynamicweb.com/forum/integration/integration/userprovider-limits

 

Has anyone run into this issue?
 

DW version: 9.10.7


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 07/07/2021 22:32:49
Reply

Hi Ricardo,

yes, the User provider sql command has a timeout set to 1 hr. As a workaround you can try to split your source xml file with users and addresses into several chunks
and import them. Another solution could to use the Dynamicweb provider instead of the User provider.
BR, Dmitrij

 

You must be logged in to post in the forum