Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Josh G 12 posts 53 karma points
    Aug 15, 2017 @ 23:35
    Josh G
    0

    CMS Import Very Slow

    Its taking a good 5 - 10minutes between steps when using the CMS import.

    I'm using the free version importing a csv file with 1 record.

    Umbraco 7.6.4 on Azure

    any ideas on why this is so slow?

  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    Aug 16, 2017 @ 06:30
    Richard Soeteman
    0

    Normally only the datasource could cause a delay. Anything in the log files?

    Best,

    Richard

  • Josh G 12 posts 53 karma points
    Aug 16, 2017 @ 11:38
    Josh G
    0

    Something is leading to the import wizard timing out, but I have no idea what..

    I can increase the timeout but its unusable as it is, so would be wanting to try and figure out what is causing the timeout.

    any ideas?

    2017-08-16 12:35:44,201 [P20976/D37/T59] ERROR CMSImport.Controls.CMSImport - CMSImport:Error during load of wizard The thread has been aborted, because the request has timed out. System.Threading.ThreadAbortException: Thread was being aborted. at SNIReadSyncOverAsync(SNIConnWrapper* , SNIPacket** , Int32 ) at SNINativeMethodWrapper.SNIReadSyncOverAsync(SafeHandle pConn, IntPtr& packet, Int32 timeout) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) at System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.System.Data.IDbConnection.BeginTransaction(IsolationLevel isolationLevel) at Umbraco.Core.Persistence.Database.OpenSharedConnection() at Umbraco.Core.Persistence.Database.

Please Sign in or register to post replies

Write your reply to:

Draft