Discussion Forum: Thread 349703 |
|
|
| | Author: | Brickfest.store | Posted: | Nov 8, 2023 14:48 | Subject: | Can't close store | Viewed: | 172 times | Topic: | Technical Issues | |
|
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
|
| | | | | |
| | | | Author: | peregrinator | Posted: | Nov 8, 2023 14:52 | Subject: | Re: Can't close store | Viewed: | 61 times | Topic: | Technical Issues | |
|
| In Help, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Maybe your terms are very long?
|
|
| | | | | | | | | |
| | | | | | Author: | SylvainLS | Posted: | Nov 8, 2023 14:55 | Subject: | Re: Can't close store | Viewed: | 58 times | Topic: | Technical Issues | |
|
| In Technical Issues, peregrinator writes:
| In Help, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Maybe your terms are very long?
|
With 16bit integers, 65536 = -1. So maybe they went up to 32bits somewhere along
the way.
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | peregrinator | Posted: | Nov 8, 2023 14:58 | Subject: | Re: Can't close store | Viewed: | 46 times | Topic: | Technical Issues | |
|
| In Technical Issues, SylvainLS writes:
| In Technical Issues, peregrinator writes:
| In Help, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Maybe your terms are very long?
|
With 16bit integers, 65536 = -1. So maybe they went up to 32bits somewhere along
the way.
|
I'm thinking they went down in size and now people can't update if something
is larger than the configured size
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | Author: | SylvainLS | Posted: | Nov 8, 2023 15:27 | Subject: | Re: Can't close store | Viewed: | 37 times | Topic: | Technical Issues | |
|
| In Technical Issues, peregrinator writes:
| […]
| With 16bit integers, 65536 = -1. So maybe they went up to 32bits somewhere along
the way.
|
I'm thinking they went down in size and now people can't update if something
is larger than the configured size
|
Duh, I was off by one anyway: -1 = 65535 (0xffff), not 65536 (0x10000).
Hmm, unless there’s a +1 somewhere….
|
|
| | | | | |
| | | | Author: | Brixe | Posted: | Nov 8, 2023 14:59 | Subject: | Re: Can't close store | Viewed: | 53 times | Topic: | Technical Issues | |
|
| In Technical Issues, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Same here. I want to open my store ant get the message:
"There was an error while processing your request. Please try to refresh
this page and check settings. If the error persists, contact Help Desk with following
error code: [3] Failed to load data: SP Error : Length of LOB data (101624) to
be replicated exceeds configured maximum 65536. Use the stored procedure sp_configure
to increase the configured maximum value for max text repl size option, which
defaults to 65536. A configured value of -1 indicates no limi"
I do not understand anything.
|
|
|
| | | | | |
| | | | Author: | tiger24 | Posted: | Nov 8, 2023 15:02 | Subject: | Re: Can't close store | Viewed: | 60 times | Topic: | Technical Issues | |
|
| In Technical Issues, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Here the same!
Please, dear admins - it was not funny to see, that against your promis our shop
was opend and not closed. Now it is important for us, to close the shop for some
hours, but it is not possible.
|
|
| | | | | | | | | |
| | | | | | Author: | Admin_Russell | Posted: | Nov 8, 2023 15:09 | Subject: | Re: Can't close store | Viewed: | 94 times | Topic: | Technical Issues | |
|
|
BrickLink ID CardAdmin_Russell
|
Location: USA, California |
Member Since |
Contact |
Type |
Status |
May 9, 2017 |
|
Admin |
|
|
BrickLink Administrator |
|
| In Technical Issues, tiger24 writes:
| In Technical Issues, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Here the same!
Please, dear admins - it was not funny to see, that against your promis our shop
was opend and not closed. Now it is important for us, to close the shop for some
hours, but it is not possible.
|
I have closed your store for you.
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | tiger24 | Posted: | Nov 8, 2023 15:14 | Subject: | Re: Can't close store | Viewed: | 51 times | Topic: | Technical Issues | |
|
| In Technical Issues, Admin_Russell writes:
| In Technical Issues, tiger24 writes:
| In Technical Issues, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Here the same!
Please, dear admins - it was not funny to see, that against your promis our shop
was opend and not closed. Now it is important for us, to close the shop for some
hours, but it is not possible.
|
I have closed your store for you.
|
Thank you, Admin Russell.
When will we be able to manage the shopsettings ourselves again?
We're a little bit irritated.
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | Author: | Admin_Russell | Posted: | Nov 8, 2023 15:17 | Subject: | Re: Can't close store | Viewed: | 103 times | Topic: | Technical Issues | |
|
|
BrickLink ID CardAdmin_Russell
|
Location: USA, California |
Member Since |
Contact |
Type |
Status |
May 9, 2017 |
|
Admin |
|
|
BrickLink Administrator |
|
| In Technical Issues, tiger24 writes:
| In Technical Issues, Admin_Russell writes:
| In Technical Issues, tiger24 writes:
| In Technical Issues, Brickfest.store writes:
| If I try to close my store I get an error message:
3] Failed to load data: SP Error : Length of LOB data (114352) to be replicated
exceeds configured maximum 65536. Use the stored procedure sp_configure to increase
the configured maximum value for max text repl size option, which defaults to
65536. A configured value of -1 indicates no limi
|
Here the same!
Please, dear admins - it was not funny to see, that against your promis our shop
was opend and not closed. Now it is important for us, to close the shop for some
hours, but it is not possible.
|
I have closed your store for you.
|
Thank you, Admin Russell.
When will we be able to manage the shopsettings ourselves again?
We're a little bit irritated.
|
You should be. That part of the site should not have been touched. Please let
us know if you can't control your store.
|
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | Author: | peregrinator | Posted: | Nov 8, 2023 15:31 | Subject: | Re: Can't close store | Viewed: | 74 times | Topic: | Technical Issues | |
|
| In Technical Issues, Admin_Russell writes:
| You should be. That part of the site should not have been touched. Please let
us know if you can't control your store.
|
It's possible some database configs were changed without touching the actual
web site code
|
|
|
|
|
|