Cannot list orders after upgrade from 4.6 to 6.2

Questions
1

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.

2

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

3

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, Action1 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, Dictionary2& 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, Dictionary2& recordCountByOrderState) +6727 Litium.Studio.UI.ECommerce.GridServices.OrdersGridService.GetOrders(Int32 startRowIndex, Int32 maximumRows, List1 sortExpression, CommonStateConstants orderStatus, String fromDate, String toDate, String orderIDs, List1 orderCountByOrderStatus, Guid webSiteID) +1704 LitiumStudio_ECommerce_Orders.grid_NeedData(Object sender, Int32 startRowIndex, Int32 pageSize, List1 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.

4

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

5

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?

6

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