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]".


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