# Cannot list orders after upgrade from 4.6 to 6.2

**URL:** <https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540>\
**Category:** Questions\
**Tags:** litium-6\
**Created:** [January 31, 2019, 2:55pm UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540 "2019-01-31T14:55:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![krilin](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/krilin/32/175_2.png) [@krilin](https://forum.litium.com/u/krilin)\
**Post date:** [January 31, 2019, 2:55pm UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540/1 "2019-01-31T14:55:31Z")

</div>

Hi!

After upgrade I cannot view the list of orders in backoffice. I get this error:

## _Unclosed quotation mark after the character string 'RowSupplement\_859aed30-56e1-4630-9fc3-d2c426dcb467§RowSupplement\_d783b884-5832-49bc-b8e8-e6db2efa616a§RowSupplement\_b7952add-4a75-4d1f-afa4-9e8b306e685c§RowSupplement\_ada3556a-24c9-49fb-9af4-3d789cd43487§RowSupplement\_2b6efe8e-459c-4731-8274-570c180c1f40§CustomerAddress§RowSupplement\_c2e51c22-66db-4727-b766-fac01abeb763§RowSupplement\_ade197db-dd49-42fa-9c1a-03cb37b8f5fe§RowSupplement\_4a03d48e-99a5-4cf8-9177-8e47d08f851f§RowSupplement\_092cbe24-d22d-4b2b-8f1c-c27fe59b2493§RowSupplement\_7a2219fc-fca1-4d35-b01f-7611e5947aae§RowSupplement\_b1052907-ef68-40db-a0c5-cd2dd47c59d4§RowSupplement\_4f0d9396-5b2e-47ea-8016-f768b6650fcd§RowSupplement\_14c822f1-19c2-4894-b4c2-b1078f1b5473§RowSupplement\_f6119ad9-d597-42f9-b312-efd690d0dfda§RowSupplement\_ed6724f9-d6f0-4740-83e9-bdc2b54ce5d1§RowSupplement\_82d460b6-fe39-4dee-906e-c8eb8d2253b1§RowSupplement\_c85d8f21-0c2c-42b3-ae0d-0a652eab7c97§RowSupplement\_eaee0686-8664-4c79-91c8-8b40abe23b61§RowSupplement\_f3249962-c902-4651-b52f-8a5e50b998f1§RowSupplement\_c93a8b61-bd3a-487a-a61e-1b5a30edee5e§RowSupplement\_1c5e0f11-c8fa-4b83-bc30-1ff1c641df47§RowSupplement\_3f1b334d-063a-4e37-866e-eb52c7ced08c§RowSupplement\_a9a4f72b-f007-47a6-88a4-b585a1dd76de§RowSupplement\_f467a766-e5ad-4a86-8da1-ef8b61b4d299§RowSupplement\_f0b09f40-b364-4add-964d-4278730369b4§RowSupplement\_db7b8534-45f6-467d-9bcf-7a8c163da810§RowSupplement\_03993efb-bd76-40b0-9603-f1b37ae9d2d2§RowSupplement\_f627128f-a2b9-438a-ae88-8bd6ef71d4af§RowSupplement\_b0a94756-b410-447c-8f3a-14a246c66f5c§RowSupplement\_d2215e67-d326-4ced-adc9-4620eaf60b95§RowSupplement\_cbf2daef-c9b7-4d8b-85a7-827b183bf00d§RowSupplement\_d6ab79e1-ac8e-4b49-a3f0-81b1660c07ca§RowSupplement\_c63f5cdb-d92e-4484-aad3-b5e0d8ca500a§RowSupplement\_da98c3bb-8170-4808-9fd3-b71177b3ba37§RowSupplement\_30cbbf11-8a51-40c0-921f-44a10303f3dd§RowSupplement\_5f879ee0-7da4-4557-b485-f8e52bf03706§RowSupplement\_68a8efc7-4187-4c5f-966c-91ca2f8b5629§RowSupplement\_3c5eb357-3ef6-4ab3-9b51-ec19ef86b857§RowSupplement\_9da7eb68-cc85-4353-9747-…_

Thanks!

Litium version: 6.2.2.

---

<div class="post-metadata">

**Author:** ![utku](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/utku/32/62_2.png) [@utku](https://forum.litium.com/u/utku)\
**Post date:** [February 1, 2019, 9:31am UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540/2 "2019-02-01T09:31:47Z")

</div>

What is RowSupplement? Is it something you add as AdditionalOrderInfo or Order Comments?

---

<div class="post-metadata">

**Author:** ![krilin](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/krilin/32/175_2.png) [@krilin](https://forum.litium.com/u/krilin)\
**Post date:** [February 1, 2019, 1:17pm UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540/3 "2019-02-01T13:17:13Z")

</div>

I see now that this is something we added to the AdditionalOrderInfo of the order, I thought it was Litium objects.  
The full stack trace is:

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +764 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4243 System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) +253 System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) +295 System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) +344 System.Data.SqlClient.SqlDataReader.NextResult() +33 Litium.Foundation.Modules.ECommerce.Data.OrderDataProvider.GetOrderViewRows(QueryInfo queryInfo, SqlCommand openCommand, Dictionary`2& recordCountByOrderState) +4468

[DALException: Could not get order view rows.]  
Litium.Foundation.Modules.ECommerce.Data.BaseDataProvider.HandleError(Exception e, String title) +272  
Litium.Foundation.Modules.ECommerce.Data.OrderDataProvider.GetOrderViewRows(QueryInfo queryInfo, SqlCommand openCommand, Dictionary`2& recordCountByOrderState) +6727 Litium.Studio.UI.ECommerce.GridServices.OrdersGridService.GetOrders(Int32 startRowIndex, Int32 maximumRows, List`1 sortExpression, CommonStateConstants orderStatus, String fromDate, String toDate, String orderIDs, List`1 orderCountByOrderStatus, Guid webSiteID) +1704 LitiumStudio_ECommerce_Orders.grid_NeedData(Object sender, Int32 startRowIndex, Int32 pageSize, List`1 sortExpressions) in C:\SysData\vsts-agent1\_work\3\s\Src\Web\Litium\ECommerce\Orders.aspx.cs:1102  
Litium.Studio.UI.Common.WebControls.GridHelperAjax.grid\_NeedDataSource(Object source, GridNeedDataSourceEventArgs e) +1875  
Telerik.Web.UI.RadGrid.OnNeedDataSource(GridNeedDataSourceEventArgs e) +168  
Telerik.Web.UI.RadGrid.ObtainDataSource(GridRebindReason rebindReason, Boolean IsBoundUsingDataSourceId) +107  
Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason) +137

What SP runs then? Maybe I can run the SP to see what is happening.

---

<div class="post-metadata">

**Author:** ![krilin](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/krilin/32/175_2.png) [@krilin](https://forum.litium.com/u/krilin)\
**Post date:** [February 1, 2019, 1:49pm UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540/4 "2019-02-01T13:49:10Z")

</div>

Utku, I will send the full SP to you it is 200 000 characters and something like this:

declare @p16 int  
set @p16=4578  
exec ECommerce\_GetOrderViewRows @PageNo=1,@PageSize=25,@OrderBy=N’OrderDate’,@SortOrder=N’DESC’,@StartDate=NULL,@EndDate=NULL,@OrderStatus=NULL,@CustomFilter=N’’,@CustomFilterColumns=N’ExternalOrderID,OrderStatusName,OrderDateFormattedString,FirstName,LastName,CustomerNumber,FormattedCountry,Email,GrandTotalFormattedString,PaymentMethodName,Address1,Address2,City,DeliveryStatusName,MobilePhone,PaymentStatusName,Phone,State,OrganizationName,Zip,Title,CareOf,HouseExtension,HouseNumber,CurrentOrderStateId’,@AdditionalKeys=N’RowSupplement\_859aed30-56e1-4630-9fc3-d2c426dcb467§RowSupplement\_d783b884-5832-49bc-b8e8-e6db2efa616a§RowSupplement\_b7952add-4a75-4d1f-afa4-9e8b306e685c§RowSupplement\_ada3556a-24c9-49fb-9af4-3d789cd43487§RowSupplement\_2b6efe8e-459c-4731-8274-570c180c1f40§CustomerAddress§RowSupplement\_c2e51c22-66db-4727-b766-fac01abeb763§RowSupplement\_ade197db-dd49-42fa-9c1a-03cb37b8f5fe§RowSupplement\_4a03d48e-99a5-4cf8-9177-8e47d08f851f§RowSupplement\_092cbe24-d22d-4b2b-8f1c-c27fe59b2493§RowSupplement\_7a2219fc-fca1-4d35-b01f-7611e5947aae§RowSupplement\_b1052907-ef68-40db-a0c5-cd2dd47c59d4§RowSupplement\_4f0d9396-5b2e-47ea-8016-f768b6650fcd§RowSupplement\_14c822f1-19c2-4894-b4c2-b1078f1b5473§RowSupplement\_f6119ad9-d597-42f9-b312-efd690d0dfda§RowSupplement\_ed6724f9-d6f0-4740-83e9-bdc2b54ce5d1§RowSupplement\_82d460b6-fe39-4dee-906e-c8eb8d2253b1§RowSupplement\_c85d8f21-0c2c-42b3-ae0d-0a652eab7c97§RowSupplement\_eaee0686-8664-4c79-91c8-8b40abe23b61§RowSupplement\_f3249962-c902-4651-b52f-8a5e50b998f1§RowSupplement\_c93a8b61-bd3a-487a-a61e-1b5a30edee5e§RowSupplement\_1c5e0f11-c8fa-4b83-bc30-1ff1c641df47§RowSupplement\_3f1b334d-063a-4e37-866e-eb52c7ced08c§RowSupplement\_a9a4f72b-f007-47a6-88a4-b585a1dd76de§RowSupplement\_f467a766-e5ad-4a86-8da1-ef8b61b4d299§RowSupplement\_f0b09f40-b364-4add-964d-4278730369b4§RowSupplement\_db7b8534-45f6-467d-9bcf-7a8c163da810§RowSupplement\_03993efb-bd76-40b0-9603-f1b37ae9d2d2§RowSupplement\_f627128f-a2b9-438a-ae88-8bd6ef71d4af§RowSupplement\_b0a94756-b410-447c-8f3a-14a246c66f5c§RowSupplement\_d2215e67-d326-4ced-adc9-4620eaf60b95§RowSupplement\_cbf2daef-c9b7-4d8b-85a7-827b183bf00d§RowSupplement\_d6ab79e1-ac8e-4b49-a3f0-81b1660c07ca§RowSupplement\_c63f5cdb-d92e-4484-aad3-b5e0d8ca500a§RowSupplement\_da98c3bb-8170-4808-9fd3-b71177b3ba37§RowSupplement\_30cbbf11-8a51-40c0-921f-44a10303f3dd§RowSupplement\_5f879ee0-7da4-4557-b485-f8e52bf03706§RowSupplement\_68a8efc7-4187-4c5f-966c-91ca2f8b5629§RowSupplement\_3c5eb357-3ef6-4ab3-9b51-ec19ef86b857§RowSupplement\_9da7eb68-cc85-4353-9747-6e5fda62d871§RowSupplement\_c74a3866-bf2d-4790-95ed-e9e7aa72146a§RowSupplement\_9b34b293-a2b9-46b3-adc3-4dfb0551cb2c§RowSupplement\_386245f8-44cb-4305-b55d-5bf48b1636a7§RowSupplement\_0445a387-8ab4-4a2d-afc2-3d1c58138989§RowSupplement\_19ad21ca-e8b9-4c0b-9bc0-082d9caaccd7§RowSupplement\_d3f5f70a-57f4-4109-b6cd-9f28d233bfb7§RowSupplement\_5a230423-6c1c-4d17-bcc8-95de840fffc0§RowSupplement\_b1cd291e-2522-4859-a777-25338a32542e§RowSupplement\_c30d8079-b82c-4a8d-bb3c-e8645ab72103§RowSupplement\_4b7b2991-350b-4a01-b411-1769b81414a4§RowSupplement\_3b0104c8-3a24-40a0-9f3c-ce69d15cc722§RowSupplement\_30e16829-80c7-4d61-b243-cebce0f2c6b5§RowSupplement\_657141c1-bb28-41a6-862f-28dfc7ed4136§RowSupplement\_f7ff186b-a377-4d0b-aa03-7078bbaf8876§RowSupplement\_9d10a76f-ccf3-460c-870f-07452371c71f§RowSupplement\_26342db8-dc3e-4511-9627-09e054aa2f4f§RowSupplement\_7388878b-709d-4ba2-bdf4-6bd31dd94d7a§RowSupplement\_859045b7-e999-4c53-9c46-01dd84f3cbe7§RowSupplement\_c415d262-becf-4cc5-aa41-846d67a4544f§RowSupplement\_eceded0c-d954-457c-a27d-a36b4ef7e21a§RowSupplement\_cbea439a-192e-4979-bb2a-5232a3234b32§RowSupplement\_631ac805-7b0f-43fa-8de7-53d2cea75f6f§RowSupplement\_66c77275-c711-4ca1-8f42-b0fdbe9b2012§RowSupplement\_60362aac-76d6-4eb0-8bf2-16e02f6ef7ad§RowSupplement\_a467824e-7741-433f-a23f-add7cabbe537§RowSupplement\_fdaae264-368d-4a19-82ae-02b569ba2555§RowSupplement\_60c430ea-5e02-4dd1-a4c7-ef03ff02b43b§RowSupplement\_e52aa120-7e92-4f63-a823-78e1273424d6§RowSupplement\_3ece4cee-dc25-41e1-87a6-d26aab7d4f7d§RowSupplement\_8c917a5f-2df6-40ad-ae77-1d4c26cc2d92§RowSupplement\_8810a7f8-838e-4287-bc81-947c86468be8§RowSupplement\_d9654225-ce26-4ac7-9d23-5e1d784235ed§RowSupplement\_8fd27830-2c7c-414e-889b-244891dd334d§RowSupplement\_2435eba8-c077-443a-b9bb-f354520a14d3§RowSupplement\_a1544cab-5bcf-430c-a041-5b51ea7db17d§RowSupplement\_049d3525-b186-4c96-b674-4d58a11ce3f9§RowSupplement\_d07a9f99-7940-41c2-b5bd-be435fea8b42§RowSupplement\_0223ae39-0f52-4db9-98dd-cc6182f65aa1§RowSupplement\_733beb7b-f58b-4082-bd34-bbcc7fd1d9a8§RowSupplement\_b32daa60-3fe9-4550-85b0-21d4ddf66774§RowSupplement\_7a0615cd-7a17-4896-ba38-f1eb9a311411§RowSupplement\_ec1447c5-12de-4b78-be9e-91fc83ee992b§RowSupplement\_937c993d-4936-4952-9a46-14fc23104646§RowSupplement\_06eac0bc-d10a-4890-bb06-9868b686a4a9§RowSupplement\_0d42c364-58ad-46ce-a61c-8d612c0d05d7§RowSupplement\_0be11410-3b98-43ae-a21b-3ce5fee0ff8d§RowSupplement\_368a111d-fac9-4529-a236-ce5c65bb03c5§RowSupplement\_37890496-dc8c-4ada-8299-9bc2093bfe67§RowSupplement\_6e5a6809-7749-492e-9cd0-f0606ca8b5b7§RowSupplement\_2a8bdb7c-34ff-4fa8-96c8-d425eb33eb11§RowSupplement\_2ba0c216-8c75-48c2-bfe7-56ec87ce10b2§RowSupplement\_8342757a-2afb-4c44-a5e5-59b77a3601c5§RowSupplement\_c2fc37a2-443e-4631-9d90-4f33b8b5150f§RowSupplement\_4e93ec8a-423f-426d-8624-f8f44e2bb114§RowSupplement\_c7db5064-6dca-4020-8f4b-64810997ac3a§RowSupplement\_86d373cc-64c9-4c83-a911-369c12fb937c§RowSupplement\_342f20bb-7a74-4cae-b08e-7fde2dad2719§RowSupplement\_d6757e10-3334-4dee-acc8-33234c604597§RowSupplement\_d03f774c-b572-450d-b6a0-1744340288eb§RowSupplement\_f3357c6f-0c58-408d-8580-8d757ae85e0f§RowSupplement\_9b5fd1d5-0ec4-4a7f-8a8c-6e0a8c984abd§RowSupplement\_4fb432fa-c0c8-484c-9354-7ea288b198ac§RowSupplement\_9b6a4a77-2384-43ab-bfe3-ce1a8363f596§RowSupplement\_abeede89-4fb1-4039-baf4-355766a20d4a§RowSupplement\_b7a9afde-85fe-4bea-8d59-48a755a63026§RowSupplement\_d1809b45-ff07-49b3-aa86-ea72c1d4a3b8§RowSupplement\_b0387b67-dcf4-488e-8bf6-f1c160ca0dfe§RowSupplement\_5e007fc0-057f-47cb-b837-8d5aea008f29§RowSupplement\_8af9782d-1dde-4daf-9982-cf3f2b42abcd§RowSupplement\_b048c5f4-58d7-4b7c-924e-24e88f8666e8§RowSupplement\_8c2705ad-837f-46f5-97d2-f3c1acd09ddd§RowSupplement\_89f20415-d8d5-494f-8f76-c4205aac39e3§RowSupplement\_ca412e05-020c-4b69-83d1-cebeca7b4fd2§RowSupplement\_5d058d91-77a1-4134-a52c-89a1d5f7cb2c§RowSupplement\_7fba8a63-0c4d-4762-ba18-34d17c585a43§RowSupplement\_577fd28a-c2e0-464b-986a-40cd297394c9§RowSupplement\_d4abea5b-f9a1-4a69-aa1e-c54b78d44662§RowSupplement\_c4fb0ee4-a4e2-4768-a323-7d5a8c028eec§RowSupplement\_2e2dd1ba-f315-442c-b236-23d78f158945§RowSupplement\_aba70b70-8d20-461c-b497-f2db0dc8a90d§RowSupplement\_ca03c298-b0fa-4bb8-b799-e7c894661ff9§RowSupplement\_feb4dced-1b7c-474b-b42c-8e7afd771b56§RowSupplement\_b4bb7cd4-dc85-4f50-8978-08d8318795e6§RowSupplement\_1b49372b-c4ed-4240-a137-5dd8fe0e6a56§RowSupplement\_8cdf61eb-b4d9-40f1-831f-11e6814002e9§RowSupplement\_fd420a06-04ab-4bd8-bd2e-f78532ae8d61§RowSupplement\_303cba55-4d00-4abb-a46e-16fc95ab634d§RowSupplement\_8a139492-aa1e-4714-99b9-1ccefd0f3572§RowSupplement\_ac1f5a72-189f-4ee1-a393-ed46e75ce0ff§RowSupplement\_1ba0256e-3303-4d1e-b640-180c4992cd3e§RowSupplement\_4e7047b8-da7f-4d2b-a2c0-118be44f3f1c§RowSupplement\_2ff8cc7f-cf5c-4c79-8d25-fe789f2e7b66§RowSupplement\_97735f68-6c8b-4bde-97f0-4d6f781bf04e§RowSupplement\_ca65802c-539f-40c1-ae34-c6c5d3c69638§RowSupplement\_f566a558-059c-4442-8365-6f8297d4f294§RowSupplement\_32f26d46-c42d-4519-894c-7094c9ee65af§RowSupplement\_98a7386a-fa29-485f-b399-c12e62b17b66§RowSupplement\_200d04e1-90f4-462f-8ecc-5b1d4f8679c0§RowSupplement\_98de6340-2df9-4029-9d89-166d13423d71§RowSupplement\_e511c5cf-39a0-4b36-abe3-7ca987ddf3b4§RowSupplement\_8f0c5378-54a5-4d41-85bd-49f82b0df504§RowSupplement\_6d1d442a-5791-44ce-b85a-fb3a3129cbc6§RowSupplement\_ed53a235-9ac7-468a-acc8-81673abf4529§RowSupplement\_fb86e3d5-4533-46f6-88eb-8933b8efe28a§RowSupplement\_ea9cd822-5223-4fba-bf1e-9ae482afefa0§RowSupplement\_4177211d-da68-43f1-a3e3-f30fc4d319bf§RowSupplement\_2348fba3-3c75-406c-beaf-4e3edc16265e§RowSupplement\_dc8b058a-da8b-4ad9-a583-b70ee1d87b3e§RowSupplement\_0820673d-21ba-40cd-a7cb-33a7f1582931§RowSupplement\_5a8d6a0a-fdc8-46c2-abfb-5d545ad622cf§RowSupplement\_4ad8e46f-4049-46b2-a53a-ca1a08666e5a§RowSupplement\_e98b6b05-081e-4775-8577-edabd4243e6b§RowSupplement\_3eb86f08-db24-4be5-b85f-da3a16a5a498§RowSupplement\_ea6596f7-5c23-4c7f-83f4-51648ebfba5e§RowSupplement\_cc5992b7-7737-4c2a-9f1b-ea395ac7f7b3§RowSupplement\_b3a11fea-071b-4613-b8ab-5fc9bf9f0dd5§RowSupplement\_c472f4da-111e-438c-b584-07a01ffb90d1§RowSupplement\_750aa019-7745-4b3d-af70-98b23be3b8f4§RowSupplement\_f8b20a76-8147-4a07-b4de-ff2d02b24839§RowSupplement\_1a7f7b81-a88d-49b9-b712-50fc5847c252§RowSupplement\_e32e3eb3-393b-4f7e-9892-69034baed65e§RowSupplement\_4be370b7-c225-4ef6-aef4-1348dca3493d§RowSupplement\_161ed00e-d3a9-43d5-9c89-3faee6ff2fdf§RowSupplement\_6d836cbb-1202-4ca8-8462-407806b6c8b7§RowSupplement\_f9303c92-497f-4563-8a9e-f9e1445efebb§RowSupplement\_69f940be-5dc9-41f4-877b-87baaae00bd0§RowSupplement\_a51c8a0e-2cb6-4866-888b-1f2bf7a73edf§RowSupplement\_2b549f7b-ee09-43a5-b06e-0f02a5257906§RowSupplement\_8d2c8871-f67e-43d9-900a-ebc7beb9dd61§RowSupplement\_d431f047-9365-4cf6-b407-ee5c633a1fcc§RowSupplement\_058b898c-55b3-4c3b-8790-da3d0a12c93f§RowSupplement\_e99101ed-85cc-4ff4-bceb-fcafdce021aa§RowSupplement\_58c1b8c7-c53f-4a0b-a9eb-9d81b0964d68§RowSupplement\_10997a4b-039f-4993-a6a4-7cab84fc9537§RowSupplement\_1f7b789d-4bc6-4ab8-9123-bc4c4748ef64§RowSupplement\_9c28055c-ef58-4908-979a-57c77d521baf§RowSupplement\_f6968176-1ca7-4aa7-a916-4ea00e0a2f3d§RowSupplement\_fd0cdbce-e6bb-4891-9be5-3437f5f05e7f§RowSupplement\_c5b3a95d-b598-40e4-afb4-eac8b9a00e8e§RowSupplement\_452e9cc3-dcbd-4369-a6a6-1c8b1a68e930§RowSupplement\_6eda45cc-99c4-451a-b105-bdb764582a85§RowSupplement\_57abb3e0-758a-4f02-a92c-4d07aa4b7991§RowSupplement\_0600c1d9-8f3e-4cf7-aa0f-c6b497045a52§RowSupplement\_f0114213-ae5d-4e0f-9ce0-3b5d709a6f90§RowSupplement\_95faf467-8189-4370-816c-8a7e453d60e6§RowSupplement\_dfe335cc-517b-47f2-a5ac-658e54b3a357§RowSupplement\_40d7c217-abeb-4bdd-8cca-d51bdf28533f§RowSupplement\_a9cd3426-aa51-41a3-8f93-f231019b8267§RowSupplement\_e7230a2f-d15c-4bd1-bd34-eebd7cd14e18§RowSupplement\_42161e25-7a67-4f96-b227-dbeb2b2c7ed2§RowSupplement\_b1abd927-e4f5-4b0d-9dbc-68b7d9825fe9§RowSupplement\_d1a7a4e0-ec73-4ae1-b2b9-7c91233c3ab3§RowSupplement\_90a83694-1616-4807-aadf-01697a71681c§RowSupplement\_04323b73-9235-475b-870c-c2285922726f§RowSupplement\_3cd330ed-50d9-44e1-af7b-5bca427b38e4§RowSupplement\_af6aa890-3522-4b5e-ab06-b8662d314c7f§RowSupplement\_6c487015-61c8-4ae2-be32-561ffba9a7d5§RowSupplement\_4bc4f28f-cdd8-488a-a7f9-8e86a3ecfb3f§RowSupplement\_b5ddbc67-27f2-4e57-bed7-4d4f165e526b§RowSupplement\_0928ff4d-7307-43cf-bf63-bd4f2ae4ee5f§RowSupplement\_0c9e06ed-0f0f-4fd7-aefa-f558c45b229c§RowSupplement\_d99d668b-b29c-4fbe-90d2-ec3ee8282724§RowSupplement\_67a5792e-864b-4f3f-b2e1-824ea12fbaac§RowSupplement\_a1b5c2d8-a308-4bd0-8c85-4d2e60e4a689§RowSupplement\_f9669775-bcd8-4d73-8e62-f076ed9a5532§RowSupplement\_897ca839-6155-4817-a90e-1c965ec3cfa8§RowSupplement\_4f204f6e-4e89-41dc-9b4a-a2df7b54abb1§RowSupplement\_2136ba11-eb1e-4d17-b4b2-ec58ca5d5f2d§RowSupplement\_e73e21a0-751c-40dd-81a4-ae20fe21cf6e§RowSupplement\_b636ad35-e8fb-4518-8370-e3eb97b38a44§RowSupplement\_f1d8a783-c77c-43de-a8ce-e3f2731279b6§RowSupplement\_380436d6-7dc7-4bc8-9d8d-8b4670131000§RowSupplement\_93858dc3-79e0-4f30-90b2-f3fae90b7ffa§RowSupplement\_49826d87-db6c-405f-98dc-da5dec2a4589§RowSupplement\_a2912a17-661c-44e0-bdb7-8a527cf38795§RowSupplement\_f61e136e-bda8-4099-a036-a5e05ba76428§RowSupplement\_054a0c5a-6765-491f-93b0-a92d216b7b74§RowSupplement\_1d2773e3-2eef-468e-9719-406b7408c353§RowSupplement\_27d2289a-2cde-4053-9fe0-3980cad64dde§RowSupplement\_26eea8d1-6e11-4c5c-89ab-bdf425313ad2§RowSupplement\_4ce3896b-dec7-43ab-a655-3f202b38aba6§RowSupplement\_73abfe52-e191-43ac-8898-70e3ecca1135§RowSupplement\_fd186b22-7029-4144-90dc-d658e7737807§RowSupplement\_ae5d8394-2ed7-4a19-b3fa-37df91b6b0ea§RowSupplement\_0e17d172-3a69-420f-8526-7da39fb3caf7§RowSupplement\_af85030c-8a5b-41ad-8b19-5f0dfb70781b§RowSupplement\_f360d762-9f87-4686-b8c5-6a06adde46fb§RowSupplement\_49573284-c06c-4d48-b744-2eb09ba678d8§RowSupplement\_714c1a3d-f365-4125-8839-1943a6780ca1§RowSupplement\_6ca79eed-6d78-4578-8f49-b81487f779f5§RowSupplement\_0bc816aa-202c-482a-80e9-ed05f35a7d82§RowSupplement\_3ec547de-c2af-447d-b42a-2532c36d0a96§RowSupplement\_480f6866-a900-4a80-92a4-9baf5365a6bf§RowSupplement\_c4e96366-7634-49ba-8580-f4fc6de836aa§RowSupplement\_c95f354d-c14b-44b2-802f-9087c271c0e8§RowSupplement\_6131a168-2a2f-4724-9f9f-22b616c4474c§RowSupplement\_86ad5824-00e6-4cde-b9a7-3ea5cd55145c§RowSupplement\_0703ad65-231c-4182-b770-15063539bb90§RowSupplement\_b10c07c1-cebe-4d5f-9ba9-9ad8b6999f6b§RowSupplement\_5234cae8-614b-49d9-8e76-0b4ce9eea40b§RowSupplement\_54e1f35a-86fd-4f8a-8eeb-b283c0bc1082§RowSupplement\_37235ffd-283d-4ebb-9d0c-9b99c525acfa§RowSupplement\_0156d609-dde7-4e99-9a17-3dc20a40c61a§RowSupplement\_b904c851-5d79-4672-9198-9194bd65a126§RowSupplement\_4ff60a24-7a4a-4213-81df-d4a835a3877a§RowSupplement\_49ca7ac7-d8ab-4b8b-ae42-a21a71ffcf48§RowSupplement\_814d13d8-4cb1-4a78-b395-66a4ee6e580b§RowSupplement\_fd464e11-c52a-4def-9af3-8739e81b26ea§RowSupplement\_672e2126-1e52-4f23-b7a9-b573a29a1ff4§RowSupplement\_a1f60efa-cdcc-4ff5-8b95-acebab600d4f§RowSupplement\_c7fc1948-cbbe-4452-b539-a70d2f6d798d§RowSupplement\_3031f834-b3d0-4d78-abcc-beb5521c0808§RowSupplement\_37184f46-107d-46aa-99aa-704bd16c977f§RowSupplement\_f18ef595-f35b-415b-baf9-81091f51912a§RowSupplement\_8d4d4f89-42aa-40e8-a822-ce04ee1adf01§RowSupplement\_80c9eac6-40e8-4be6-bc22-b810aa325dc0§RowSupplement\_d5023841-6ffb-4b8b-bdc5-0ec26cb7d325§RowSupplement\_b9f2b5cf-d38d-4af6-8d16-e58c41f0ff2c§RowSupplement\_a2058d98-eab9-4878-977d-f798faf5e44f§RowSupplement\_732923c0-7ab0-4019-a15f-c2d2d60b789d§RowSupplement\_fa2113d5-2956-417e-a168-497da7b04517§RowSupplement\_bdd8158e-1068-42d3-bbb3-65d10b3b6de6§RowSupplement\_c5bda0ff-aa52-4de9-8796-8a2989697add§RowSupplement\_47192e5e-5402-455e-9ac2-2941bab778ac§RowSupplement\_feba0785-1f00-40db-a256-2449f38892f6§RowSupplement\_598a0639-25b4-494c-809e-077477ac7881§RowSupplement\_332fe72b-4ac7-47a0-b3f6-d096dc34e641§RowSupplement\_435581da-5363-4908-a4a1-92757900f0dc§RowSupplement\_7d430552-706a-4a83-b178-a92992e04af7§RowSupplement\_d9998dd8-c1d2-4838-bac7-e00420c2d294§RowSupplement\_97b8e7a1-8f29-4719-89cb-9b36a9f34e81§RowSupplement\_8d2c8f6d-7ecf-453f-b45d-17e49c62a4c6§RowSupplement\_e8e42df5-90a9-4377-8aa0-1a44d19818d8§RowSupplement\_1e36a81f-2afe-407f-ade8-aaf3ce565485§RowSupplement\_59833a04-0407-4629-b88f-cfa9e4227afa§RowSupplement\_51e0ab08-2b2e-4a7a-8afc-93ffa1812257§RowSupplement\_bc45e89a-7e16-40c3-88d2-3950b83b3860§RowSupplement\_7476315d-03fa-4f1c-a7c1-5333eb135bd0§RowSupplement\_f3766680-65a0-441a-8da5-3442f57ca9d0§RowSupplement\_d7c1fc8d-0b27-441a-836e-c5cd07f40571§RowSupplement\_1b6fb021-d75c-4d9a-a121-e00ce9c69399§RowSupplement\_d794d78e-596e-45d1-a156-0935827911d1§RowSupplement\_586384c3-77d2-4483-82e6-099d426bbf2b§RowSupplement\_4ef5d601-30a5-43ed-94cb-fdba42435b10§RowSupplement\_eb419961-60a8-4644-8922-39187cab7652§RowSupplement\_ddd62563-f4e6-4cf9-9971-3f6c06a0b4af§RowSupplement\_387bf885-5cf0-4293-9ae1-37e00c835469§RowSupplement\_3dc9ee71-4484-4b05-9329-7d54ab37af4c§RowSupplement\_95b738f2-ff72-44fe-becf-2ae14ce07050§RowSupplement\_fbd11b19-bac1-41ed-8c53-c6d38d06309e§RowSupplement\_76591c5a-25d9-4327-9cbd-9d9813aefa4d§RowSupplement\_babc85aa-75d0-4a94-8ea0-ec03b484d1b3§RowSupplement\_ef64e501-86d5-4c8a-a00f-c1a728bb7980§RowSupplement\_5b63c91d-0dcc-4dd6-8afc-2993bbbc3b69§RowSupplement\_e83c1041-f321-4e12-8965-96f15ae6781b§RowSupplement\_c19d0863-7bd4-4797-98ee-3ad7bfa15973§RowSupplement\_762794d0-3e77-4252-a459-2acf09b6a8bd§RowSupplement\_d4b07a1e-87de-43e8-b300-b7fde7b022f5§RowSupplement\_54a4fc38-4ce1-40c9-9d92-056db28bfe2b§RowSupplement\_4e001aa2-8aea-49d9-835d-0d0b29d04c14§RowSupplement\_e2146603-e7fc-4e3c-89e0-b294b5ac9e9b§RowSupplement\_b1371292-17bb-4479-adf1-b38430431a6a§CompanyRegistrationNumber§RowSupplement\_98c9c6d4-8f3e-49c5-8d6a-ad68a80bd4a2§RowSupplement\_3c20d03d-a4bc-4e84-9e80-58d377d87dcd§RowSupplement\_f8ac1261-e77b-4228-8624-ce71d24f820d§RowSupplement\_3a7f846d-8a30-40dc-9af8-1b10189953f5§RowSupplement\_307bbf7b-a2cb-4fcb-b5f5-98d78950e3c8§RowSupplement\_b70e5ea3-2c9b-4fe3-b583-4e474521a8dd§RowSupplement\_24d857a8-969d-42c3-8d81-9363e894b5df§RowSupplement\_fa7ca748-decc-486c-b80e-340e735ab5c7§RowSupplement\_6fc62a4e-1eae-4133-a476-5c1c59207b64§RowSupplement\_4da1f501-824d-4698-9bc4-60c4f6d5f872§RowSupplement\_9b404c5d-98dc-4093-8d32-0b5c81262990§RowSupplement\_bd83fb0e-1985-41f9-89fc-f315c16b7437§RowSupplement\_c8953328-7b82-4d66-99d4-810ed97c5a5a§RowSupplement\_e0b4cbf4-d753-4eb8-9ab7-1f7a4e6ed11b§RowSupplement\_5d4b4f27-9c71-4ac1-9149-d0f5601cdb6b§RowSupplement\_84bafa4c-11a8-4b43-9c52-b5aee8e7dbb0§RowSupplement\_01daae58-de9b-4e23-9ce3-0e56ad2ba30c§RowSupplement\_43eddbf2-dc05-4300-bd55-04a79865ce09§RowSupplement\_36528dd2-8dee-429e-95fd-c9ebbba92361§RowSupplement\_6edcc52a-0a63-4dc1-b106-6cb2e0d92266§RowSupplement\_a4975dd4-e417-4890-b004-5053125c2258§RowSupplement\_f679aa5d-dcba-4a16-bd98-ca8f3cb9fef7§RowSupplement\_24927f8f-f767-45de-9d93-bc7e7825e9e7§RowSupplement\_5ae75175-beca-42de-b6ce-82253073e1be§RowSupplement\_5e6cab79-bd40-4676-86aa-2a6b9a800221§RowSupplement\_d3705035-f52b-46b2-9adc-0cc13affdaf6§RowSupplement\_2969938d-685f-4a70-bd34-6f22620780f9§RowSupplement\_308f122e-5d5d-4f1d-9d8a-a00568407f56§RowSupplement\_0b1ffcd6-ae18-4dfe-9d66-a63fc4f3047b§RowSupplement\_1c49c66f-b1ac-4d81-a2a9-5a0c04ce613d§RowSupplement\_d0528c81-1746-4dd3-bbb9-05247697f0d9§RowSupplement\_3e54d4f9-f606-40fd-80fe-735234480ccb§RowSupplement\_304ea049-6f95-4f20-9a5b-7989fca09919§RowSupplement\_8c5b69fb-add4-487e-beef-9c528a5389ee§RowSupplement\_545b1f64-a827-44be-87bf-104e271e531f§RowSupplement\_de1368c5-566f-496c-853c-130de77b2f0b§RowSupplement\_0a407e4f-a467-4c6a-87ca-ffaa98ff9917§RowSupplement\_41930421-7dcc-416a-b436-474ede253e8f§RowSupplement\_63a42f71-93a2-4f31-aa6f-0181d1954377§RowSupplement\_42b1ae41-142f-4fe5-aaa1-0c23d10ee219§RowSupplement\_4003a776-1ecd-43cb-a4ba-640af7331c05§RowSupplement\_3421f8c2-9847-46ba-a4d6-acc74d87681e§RowSupplement\_49ff3c7e-66d3-4d4e-b7f7-326674ff5393§RowSupplement\_b2f11cd9-d08f-44b3-8f08-5a11c6737041§RowSupplement\_2cda5835-a363-4d7a-9a5b-f4b281226212§RowSupplement\_7a4ded4d-9434-4acb-88f3-a2ebef750d45§RowSupplement\_9c9cf1df-bbaa-416d-948c-39bbcf0c3634§RowSupplement\_4b4b45e3-dd12-4e09-a5bc-5f3066ca3c96§RowSupplement\_4e4306dd-2f2d-4e8f-b37c-cc21789670fb§RowSupplement\_1bc8d50d-f1b1-42b2-89f2-451734bc087d§RowSupplement\_cbcb3f20-0fd8-4640-9994-a14230d33759§RowSupplement\_feeb8992-4d52-4435-9fc1-45f65b679dac§CustomerZipCode§RowSupplement\_d57f3deb-d7a6-40f7-9ae8-bb754fa09cb6§RowSupplement\_17c16805-6a1a-48f9-a0a1-ca14618abf2f§RowSupplement\_2d446e74-c779-45fb-a331-3fa75585564c§RowSupplement\_f82f4598-229e-4c79-9ad2-47ff19484154§RowSupplement\_dd558de2-61fb-45aa-8509-dc17d0e81b6f§RowSupplement\_3f0ccc90-810f-4ccc-980c-b8cd5e980c45§RowSupplement\_db1297b7-c5e4-425f-857e-47fc9c02062e§RowSupplement\_b892406f-818f-4d03-8dd7-411bba4b4625§RowSupplement\_933e5687-3496-4c10-9f9b-f2c26e27ac67§RowSupplement\_a15d0993-8d05-4734-950c-2ae0f1107dd7§RowSupplement\_3c72ec69-2fb3-43f7-b771-9dd749fc3119§RowSupplement\_f3f134a8-1bb8-4f22-b1b3-66f2b88571d5§RowSupplement\_40bfd111-56e5-402f-b0df-f94c3175ad35§RowSupplement\_cd1c3128-8525-46e0-b4ab-73289f52d0f7§RowSupplement\_dcd3f51d-d243-4961-83bd-a1d2880388ef§RowSupplement\_6c228429-8f80-421d-9c81-2e9509d0f73d§RowSupplement\_81cd734b-e86b-4e66-8fa0-13f134c43cd0§RowSupplement\_bdf6de2b-d90b-4422-b00e-3d9c9eb2de23§RowSupplement\_161ccf87-2dac-48b6-b4c4-db5c6182c2b6§RowSupplement\_1bde89a0-3fd7-4bcc-947f-df7b51f1e76c§RowSupplement\_a407ab70-9064-47c5-86b4-f4372364d1a9§RowSupplement\_5d8ae792-b6ac-44f9-9681-54731a97db79§RowSupplement\_d644b12b-62f7-4234-841b-eac453cc64ce§RowSupplement\_75fd7e07-8dda-4d26-9192-e6cb4f0bc4b4§RowSupplement\_083a82f1-f146-4db1-b26e-52d17099b8cb§RowSupplement\_76e5883d-fdba-4044-930c-c01467b95353§RowSupplement\_fced20db-c589-4bb9-a2c3-5216ecca7568§RowSupplement\_dd80e9ea-e03b-4e5b-a183-b3d2513fc9de0aa02f6770fd§RowSupplement\_9657fddd-0fcb-4cc3-b8ab-e6fb164ea600’,@AdditionalKeysDelimit=N’§’,@OrderIDs=N’’,@PaymentStatuses=N’’,@DeliveryStatuses=N’’,@WebSiteID=NULL,@Count=@p16 output  
select @p16

---

<div class="post-metadata">

**Author:** ![krilin](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/krilin/32/175_2.png) [@krilin](https://forum.litium.com/u/krilin)\
**Post date:** [February 1, 2019, 1:52pm UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540/5 "2019-02-01T13:52:40Z")

</div>

The parameter:  
@AdditionalKeys nvarchar(4000),

Takes 4000 chars, I guess the string is cut after that generating the error. Why are all this AddtionalInfo sent to the sp?

---

<div class="post-metadata">

**Author:** ![utku](https://yyz2.discourse-cdn.com/flex030/user_avatar/forum.litium.com/utku/32/62_2.png) [@utku](https://forum.litium.com/u/utku)\
**Post date:** [March 5, 2019, 1:32pm UTC](https://forum.litium.com/t/cannot-list-orders-after-upgrade-from-4-6-to-6-2/540/6 "2019-03-05T13:32:44Z")

</div>

Hi,  
This issue is resolved at the latest service release, Litium 6.3.  
FYI