topic Re: ArcSDE geodatabase in Data Management Questions

ArcSDE geodatabase

ValeryKemelman — Thu, 10 Mar 2016 17:37:47 GMT

What parameters must be in SDE.SERVER_CONFIG table?

Re: ArcSDE geodatabase

VinceAngelo — Thu, 10 Mar 2016 18:12:52 GMT

To some extent, that may differ by the release (or even patch level) of the installed geodatabase, as well as the RDBMS in use. What release and RDBMS are you using? Has something unfortunate happend to your geodatabase instance?

- V

Re: ArcSDE geodatabase

MelissaJarman — Thu, 17 Mar 2016 16:30:37 GMT

Just as Vince asked I am wondering what situation you are running into where you would need to modify one of these parameters. There are parameters that are modified through the use of user interface menus and tools within this table and no manual manipulation should be done. At 10.3 there was a new tool released to configure logfile types/settings.

Re: ArcSDE geodatabase

ValeryKemelman — Mon, 28 Mar 2016 12:27:35 GMT

Thanks Vince for responding. The question I've raised related to issues with many errors coming from ArcSDE when we working with Cadastral Fabric Editor in ArcMap. In ArcSDE log we can see a lot of errors like:

load buffer -51 on CADASTRAL_POINTS

It affects ArcMap stop display or identify point features sublayer. I was thinking that it may be related to the parameters in SERVER_CONFIG table that control sending data from server side to the client.

We are working on Oracle 11g Release 11.2.0.4.0 on Unix Solaris 10, ArcSDE 10.0, Geomtry storage - Oracle SDO

Re: ArcSDE geodatabase

ValeryKemelman — Mon, 28 Mar 2016 12:29:37 GMT

Unfortunately we are still in 10 for a while.

Re: ArcSDE geodatabase

VinceAngelo — Mon, 28 Mar 2016 13:15:16 GMT

-51 is SE_DB_IO_ERROR, meaning the database failed to read the data. That doesn't have anything to do with anything in SDE.SERVER_CONFIG. ArcSDE 10.0 (which is now Retired) was certified with Oracle 11gR2 (11.2.0.1), but there isn't much data on how it will perform with 11.2.0.4. There have been eight major releases of ArcGIS since 10.0sp5 (counting 10.1sp1). I doubt there's anything you can do to make 40-month old application software work flawlessly with 30 month old database software (which is what Vince's First Law of Compatibility is about). Unfortunately, you need to shorten the "while" before those errors can be resolved.

- V