ArcFM Tools in ArcCatalog
Troubleshooting: Why can't I save changes to the ArcFM Properties Manager?

Resource Center Home

There are some initialization parameters for SDE. They can be found in the file called 'giomgr.defs' in the 'etc' folder in the SDEHOME directory. You may modify the MAXBLOBSIZE and MAXBUFSIZE parameters. These parameters default to 65K when SDE is installed. This amount may not be enough if you make extensive use of stored displays and documents. This setting 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 transfer

After 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.

 

 


Send Comment to documentation@schneider-electric.com