Configuring the ArcFM Solution Overview > ArcCatalog Tools > Troubleshooting ArcCatalog Tools > Troubleshooting: A runtime error occurs when saving property changes |
The following error occurs:
Run-Time Error '-2147216043 (80041555)': frmMMConfig.SaveFeatureClass Automation Error Error at line: 1416
This indicates that the MAXBLOBSIZE and MAXBUFSIZE parameters in SDE have been met. The MAXBLOBSIZE SDE setting restricts the amount of the data you can save to that field. The MAXBUFSIZE SDE setting restricts the amount of data that can be transferred. Both settings default to 65K when SDE is installed, but may be increased up to 2GB (maximum) if the field is an Oracle field type Long Raw and up to 4GB (maximum) if the field is an Oracle field type Blob.
There are two ways to change these parameters, depending on your version of ArcSDE.
ArcSDE 8.3 and earlier:
Increase the MAXBLOBSIZE and MAXBUFSIZE parameters in your giomgr.defs file (which is located in SDEHOME\etc). Below is an example of the portion of giomgr.defs that should be modified.
MAXBLOBSIZE 10000000 # Maximum BLOB size allowed for storage MAXBUFSIZE 10000000 # Maximum BUF size allowed for transferAfter you've made changes to this file, you must "import" the new parameters into your Oracle server table with the following command. Adjust for your SDE service, server name, and SDE password.
sdeconfig -o import -f full_path_and_file_name_of_giomgr.defs -i sde_service
-s server_name -u sde -p sde_password
ArcSDE 9.0 and later:
In a DOS command window, use the SDE line command "sdeconfig". Telvent recommends setting the parameter to 10Mb-20Mb. The example below shows how a user might increase the parameter to 20Mb. Adjust for your SDE service, server name, and SDE password.
sdeconfig -o alter -v MAXBLOBSIZE=20000000 -i sde_service -s server_name -u sde -p sde_password sdeconfig -o alter -v MAXBUFSIZE=20000000 -i sde_service -s server_name -u sde -p sde_password
There are also settings in Oracle that may cause size errors when saving to system tables. You can set a maximum number of extents either on a table in Oracle or on a tablespace. The tablespace may just simply have run out of space. These space settings should be checked by a DBA in Oracle prior to making the above modification.