Discussion Forum: Thread 349703

 Author: Brickfest.store View Messages Posted By Brickfest.store
 Posted: Nov 8, 2023 14:48
 Subject: Can't close store
 Viewed: 165 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Brickfest.store (1609)

Location:  Germany, Bayern
Member Since Contact Type Status
Aug 21, 2019 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brickfest.store
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 View Messages Posted By peregrinator
 Posted: Nov 8, 2023 14:52
 Subject: Re: Can't close store
 Viewed: 57 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

peregrinator (741)

Location:  USA, New Jersey
Member Since Contact Type Status
Jan 21, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Faber Family Bricks
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 View Messages Posted By SylvainLS
 Posted: Nov 8, 2023 14:55
 Subject: Re: Can't close store
 Viewed: 55 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
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 View Messages Posted By peregrinator
 Posted: Nov 8, 2023 14:58
 Subject: Re: Can't close store
 Viewed: 45 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

peregrinator (741)

Location:  USA, New Jersey
Member Since Contact Type Status
Jan 21, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Faber Family Bricks
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 View Messages Posted By SylvainLS
 Posted: Nov 8, 2023 15:27
 Subject: Re: Can't close store
 Viewed: 36 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
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 View Messages Posted By Brixe
 Posted: Nov 8, 2023 14:59
 Subject: Re: Can't close store
 Viewed: 53 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Brixe (214)

Location:  Germany, Hessen
Member Since Contact Type Status
Sep 8, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Regenbogensteine
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 View Messages Posted By tiger24
 Posted: Nov 8, 2023 15:02
 Subject: Re: Can't close store
 Viewed: 58 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

tiger24 (9758)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Apr 5, 2006 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store: MoreThanBricks
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 View Messages Posted By Admin_Russell
 Posted: Nov 8, 2023 15:09
 Subject: Re: Can't close store
 Viewed: 83 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Admin_Russell

Location:  USA, California
Member Since Contact Type Status
May 9, 2017 Contact Member Admin
Buying Privileges - OKSelling Privileges - OK
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 View Messages Posted By tiger24
 Posted: Nov 8, 2023 15:14
 Subject: Re: Can't close store
 Viewed: 49 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

tiger24 (9758)

Location:  Germany, Niedersachsen
Member Since Contact Type Status
Apr 5, 2006 Member Does Not Allow Contact Seller
Buying Privileges - OKSelling Privileges - OK
Store: MoreThanBricks
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 View Messages Posted By Admin_Russell
 Posted: Nov 8, 2023 15:17
 Subject: Re: Can't close store
 Viewed: 101 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Admin_Russell

Location:  USA, California
Member Since Contact Type Status
May 9, 2017 Contact Member Admin
Buying Privileges - OKSelling Privileges - OK
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 View Messages Posted By peregrinator
 Posted: Nov 8, 2023 15:31
 Subject: Re: Can't close store
 Viewed: 72 times
 Topic: Technical Issues
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

peregrinator (741)

Location:  USA, New Jersey
Member Since Contact Type Status
Jan 21, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Faber Family Bricks
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