# Exporting products **URL:** \ **Category:** Questions\ **Tags:** litium-7\ **Created:** [September 10, 2020, 10:59am UTC](https://forum.litium.com/t/exporting-products/1631 "2020-09-10T10:59:16Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 10, 2020, 10:59am UTC](https://forum.litium.com/t/exporting-products/1631/1 "2020-09-10T10:59:16Z")
How long can I expect this export to take? I have never used the export before, but it has been frozen like this for 15 minutes now. It’s just price, and 4 textoption fields, and 1 decimal field. ![image](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/187e693129c3c46e352d1ef088241c7550defd17.png) Litium version: 7.4.3 ---
**Author:** ![aram](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/aram/32/19_2.png) [@aram](https://forum.litium.com/u/aram)\ **Post date:** [September 10, 2020, 11:13am UTC](https://forum.litium.com/t/exporting-products/1631/2 "2020-09-10T11:13:51Z")
An export of 8000 products with ~60 fields (mostly text) takes about 10 secs for me to export. Is it in PROD? have you tried on different servers to see if it makes difference? ---
**Author:** ![NilsN](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/nilsn/32/302_2.png) [@NilsN](https://forum.litium.com/u/NilsN)\ **Post date:** [September 10, 2020, 12:21pm UTC](https://forum.litium.com/t/exporting-products/1631/3 "2020-09-10T12:21:16Z")
Are there any errors in the console or bad requests responses in the Network tab? ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 10, 2020, 12:28pm UTC](https://forum.litium.com/t/exporting-products/1631/4 "2020-09-10T12:28:51Z")
No, not seeing any errors anywhere, it’s still frozen. It’s on a test environment. Don’t have a prod yet. It’s the same locally ---
**Author:** ![erlin93](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@erlin93](https://forum.litium.com/u/erlin93)\ **Post date:** [September 10, 2020, 12:35pm UTC](https://forum.litium.com/t/exporting-products/1631/5 "2020-09-10T12:35:35Z")
Had the problem before with the export freezing, you could try unselecting some of the fields and see if it works, could be some error. ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 10, 2020, 12:47pm UTC](https://forum.litium.com/t/exporting-products/1631/6 "2020-09-10T12:47:07Z")
Just tried 3k products, with only articleNumber and Variant of. Still froze ---
**Author:** ![NilsN](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/nilsn/32/302_2.png) [@NilsN](https://forum.litium.com/u/NilsN)\ **Post date:** [September 10, 2020, 1:01pm UTC](https://forum.litium.com/t/exporting-products/1631/7 "2020-09-10T13:01:09Z")
Nothing in the event log either? Which pre-release are you using for 7.4.3? ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 10, 2020, 1:06pm UTC](https://forum.litium.com/t/exporting-products/1631/8 "2020-09-10T13:06:07Z")
Can’t find anyting in the logs. 7.4.3-patch-2007111155 ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 10, 2020, 8:47pm UTC](https://forum.litium.com/t/exporting-products/1631/9 "2020-09-10T20:47:09Z")
The 7.4.3-patch-2007111155 pre-release contains a [bug](https://docs.litium.com/support/bugs/bug_details?id=51579) that make slow performance and you are probably experience that, we are working for an updated version. ---
**Author:** ![samuel](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/samuel/32/479_2.png) [@samuel](https://forum.litium.com/u/samuel)\ **Post date:** [September 11, 2020, 10:46am UTC](https://forum.litium.com/t/exporting-products/1631/10 "2020-09-11T10:46:54Z")
Is there an estimation for when a fix will be released? ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 11, 2020, 12:36pm UTC](https://forum.litium.com/t/exporting-products/1631/11 "2020-09-11T12:36:42Z")
I can only guess and that will be during next week that we can provide and updated version, if this is a pre-release (as the one that you using now) or the final service release is to early to say. ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 14, 2020, 12:40pm UTC](https://forum.litium.com/t/exporting-products/1631/12 "2020-09-14T12:40:47Z")
Today a new pre-release was published, please try that out instead of your current version. ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 14, 2020, 1:51pm UTC](https://forum.litium.com/t/exporting-products/1631/13 "2020-09-14T13:51:41Z")
It made the export work. But going over 4k products takes time. And trying to export 60k products causes this: 2020-09-14 15:47:08.2741 [App:02] [cc23238d-bd0d-4b4f-a4f9-25bf070010ce] [TRACE] [] Litium.Web.Administration.Products.Export.ExcelExportEngine.Processor - Export d3fdefcb-f1d3-4bf9-b408-84bbd16f9ae7, products loaded. 2020-09-14 15:47:08.5051 [App:02] [cc23238d-bd0d-4b4f-a4f9-25bf070010ce] [TRACE] [] Litium.Web.Administration.Products.Export.ExportToExcel - Exporting 69788 products. 2020-09-14 15:47:08.5051 [App:02] [cc23238d-bd0d-4b4f-a4f9-25bf070010ce] [TRACE] [] Litium.Web.Administration.Products.Export.ExportToExcel - Export products 2020-09-14 15:47:39.2174 [App:02] [] [ERROR] [] Litium.Application.ServiceBus.LocalServiceBusFactoryImpl - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Microsoft.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. —\> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlConnection.cs:line 2205 at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\TdsParser.cs:line 1668 at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\TdsParser.cs:line 0 at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlDataReader.cs:line 1333 at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlDataReader.cs:line 283 at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 5638 at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 5404 at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 4988 at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 4842 at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) in H:\tsaagent1\_work\21\s\src\Microsoft.Data.SqlClient\netfx\src\Microsoft\Data\SqlClient\SqlCommand.cs:line 2442 at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Microsoft.EntityFrameworkCore.Storage.ExecutionStrategy.ExecuteImplementation[TState,TResult](Func`3 operation, Func`3 verifySucceeded, TState state) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at Litium.Application.Data.Queryable.DbQueryBuilder`2.ExecuteInDbContext[TItem](Func`1 action) at Litium.Web.Administration.Products.Export.ExportToExcel.GetExportProducts(List`1 products, Action`1 notifyProduct) at Litium.Web.Administration.Products.Export.ExportToExcel.GetExportProductsTable(List`1 products, Action`1 notifyProcessed) at Litium.Web.Administration.Products.Export.ExportToExcel.GetWorkbook(PredefinedExportSettings exportSettings, List`1 products, Action`1 notifyProcessed) at Litium.Web.Administration.Products.Export.ExcelExportEngine.Processor.OnMessage(PredefinedExportSettings exportSettings) at Litium.Application.Common.FifoExecution.WorkItem.\<\>c.\<.cctor\>b\_\_7\_0(Object s) at Litium.Application.Common.FifoExecution.WorkItem.Execute() at Litium.Application.Common.FifoExecution.ProcessQueuedItems(Object ignored) ClientConnectionId:3bd6ebc4-5be9-48be-913d-db33ce9e3682 Error Number:-2,State:0,Class:11 ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 14, 2020, 1:59pm UTC](https://forum.litium.com/t/exporting-products/1631/14 "2020-09-14T13:59:06Z")
This is an timeout from the SQL server, how is the memory, cpu and disc activity time when this happen? ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 14, 2020, 2:05pm UTC](https://forum.litium.com/t/exporting-products/1631/15 "2020-09-14T14:05:10Z")
It was around this the entire time, the disk went up to 21% and then down again. Im running this locally with a local db right now. The timeout happends after around 1min/1.5min Is it possible to increese the timeout? ![image](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/bd2540f783eed50553dbf1bb72d51ab747553112.png) ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 14, 2020, 2:31pm UTC](https://forum.litium.com/t/exporting-products/1631/16 "2020-09-14T14:31:05Z")
When I running large databases and having to less memory on the computer the SQL server is blocking itself during the time it is waiting for more memory to be free. This can be visible in the activity monitor inside SSMS and will be notified as below image. ![image](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/3778bd6e32ca8a066fa692d3b9b173a87a036678.png) This image was captured during export of 140 000 products and I was getting the same error message. Please, report this as a bug on the docs site and we can investigate the issue. ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 14, 2020, 2:40pm UTC](https://forum.litium.com/t/exporting-products/1631/17 "2020-09-14T14:40:18Z")
I could not replicate that exactly, but i guess we get the same issue. I reported this as a bug, please try to prioritize it, it’s blocking testing for a go live deadline ![image](https://canada1.discourse-cdn.com/flex030/uploads/litium/original/1X/369b959145fd183be50a9cf89db79dc81bac654d.png) ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 17, 2020, 9:05pm UTC](https://forum.litium.com/t/exporting-products/1631/18 "2020-09-17T21:05:34Z")
Today we published a new pre-release, we have tried to export 100 000 products without problem. ---
**Author:** ![Ericsj11](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/ericsj11/32/899_2.png) [@Ericsj11](https://forum.litium.com/u/Ericsj11)\ **Post date:** [September 18, 2020, 6:20am UTC](https://forum.litium.com/t/exporting-products/1631/19 "2020-09-18T06:20:32Z")
Awesome! Will try it today 🙂 ---
**Author:** ![patric.forsgard](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/patric.forsgard/32/10_2.png) [@patric.forsgard](https://forum.litium.com/u/patric.forsgard)\ **Post date:** [September 18, 2020, 2:46pm UTC](https://forum.litium.com/t/exporting-products/1631/20 "2020-09-18T14:46:25Z")
Did that pre-release solve the export problem for you? [Next page](https://forum.litium.com/t/exporting-products/1631.md?page=2)