Maximum BLOB size exceeded[DEFQUERY]

Last Published: April 25, 2020

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

    Article ID:000010120

    • Legacy Products
    • ArcMap 9 x

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic