Features with an attachment larger than 1GB fail to publish as hosted feature layers and leave orphaned tables in the ArcGIS Data Store.

Additional Information

Workaround

Reduce the attached item size to less than 1GB.

If the item size is less than 2GB, publish the service as a referenced service using a SQL Server Enterprise Geodatabase. PostgreSQL's native column type can store up to 1GB (for example, 1024 MB). Check the BYTEA_OUTPUT setting in postgresql.conf. This parameter specifies the DB underlying storage format, which determines how much data can be stored.

Hex: (default) store each byte of data as a 2 hex (for example, require 2 bytes). It has the capacity to store a maximum of 512 MB, which is equivalent to 536,870,912 bytes. Escape requires one byte for each byte of data. It has the capacity to store a maximum of 1029 MB, which is equivalent to 1,073,741,824 bytes.

Refer to the following links for additional information: https://postgresqlco.nf/doc/en/param/bytea_output/ and https://www.postgresql.org/docs/16/runtime-config-client.html#GUC-BYTEA-OUTPUT.

Steps to Reproduce