ERROR
Maximum BLOB size exceeded[DEFQUERY]
Error Message
When creating a replica, the following error displays before the replica creation is complete:"Maximum BLOB size exceeded[DEFQUERY]".
Cause
When a replica is created, information about the replica is stored in the replica geodatabases. This includes the information about feature classes, tables, and relationship classes in the replica. This information is written to a blob column in one of the geodatabase system tables. If the number of features, tables, etc. is large (i.e. more than 1000), it may be larger than the SDE server allows for a blob column. By default, the limit is 1,000,000 bytes.
Solution or Workaround
Use the sdeconfig ArcSDE administration command to increase this limitation. The following command increases the max blob size to 3,000,000 bytes:sdeconfig -o alter -v MAXBLOBSIZE=3000000 -i 5151 -s myserver -u sde -p sde
Article ID:000010120
- Legacy Products
- ArcMap 9 x
Get help from ArcGIS experts
Download the Esri Support App
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback