topic Re: SDEVERBOSE in Data Management Questions

SDEVERBOSE

ScottNoldy — Mon, 21 Apr 2014 16:34:59 GMT

In 10.0 and below, when creating a direct connection to the database you could specify ;SDEVERBOSE=TRUE at the end of the instance line to create a local SDE log file for troubleshooting.

I can't seem to find anything similar for 10.2.1. Anyone know of any way to get verbose logs out of direct connections to SDE in 10.2.1?

Re: SDEVERBOSE

EmadAl-Mousa — Tue, 22 Apr 2014 05:10:12 GMT

Hi,

it should be the same procedure as in previous releases, adding the parameter in your dbinit.sde file

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n00000017000000

Regards,

Re: SDEVERBOSE

ScottNoldy — Tue, 22 Apr 2014 16:16:26 GMT

Hi,

it should be the same procedure as in previous releases, adding the parameter in your dbinit.sde file

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n00000017000000

Regards,

That's for a server with SDE installed, not for a client.

Re: SDEVERBOSE

WilliamCraft — Tue, 22 Apr 2014 19:20:04 GMT

Direct connections produce a client log file named sdedc_<RDBMS>.log (substitute something like 'oracle' or 'sqlserver' in place of <RDBMS>). The file is typically generated and stored under the profile directory for the logged-in user on machines using a Microsoft Windows operating system. For example:

For Windows 2008 R2, usually C:\users\<userID>\AppData\Local\Temp

Since you didn't provide your OS, I'm going to assume Windows for the time being. I don't believe you can change the type of logging that gets recorded in this file; in other words, I don't think it is configurable to something more verbose than it already is. What specifically are you trying to capture? There are other methods of capturing events, calls, etc. besides the direct connect log file. Sometimes a session trace using RDBMS tools might be sufficient (e.g., Oracle trace or SQL profiler trace), but other times you might need something more Esri-centric. Have you considered using an SDETRACE or an SDEINTERCEPT? I'm not sure what exactly you're trying to do, but these are all methods of capturing events between different parts of the system which include some that interact directly with the client.

Re: SDEVERBOSE

ScottNoldy — Wed, 23 Apr 2014 16:39:24 GMT

I ended up asking ESRI. Turns out it is the same for 10.2 as it is in 10.0 and below, just add ;SDEVERBOSE=TRUE to the end of the server name in the instance field of the geodatabase connection window.

Re: SDEVERBOSE

RandyKreuziger — Mon, 06 Oct 2014 21:59:05 GMT

How do you turn off the SDEVERBOSE?

I followed your instructions for setting SDEVERBOSE to true. After testing I went back into the database connection but the ;SDEVERBOSE=TRUE section was gone SDE layers added to lyr files still show it as TRUE therefore I added ;SDEVERBOSE=FALSE to the connection and resourced the feature class in the lyr file, but now it reads ;SDEVERBOSE=FALSE;SDEVERBOSE=TRUE

I;m running 10.1 SP1

Re: SDEVERBOSE

DrewDowling — Tue, 09 May 2017 22:50:38 GMT

Does anybody know how to do this oracle instaclient connections? When I try to add ;SDEVERBOSE=TRUE using an oracle connection it give me an error message about server not being found.

Re: SDEVERBOSE

SidneiRodrigues_dos_Santos — Thu, 19 Oct 2017 18:31:35 GMT

Hi,
Check the following key in regedit
to 10.5.1:
HKEY_CURRENT_USER\Software\ESRI\Desktop10.5\SDE Workspace Factory

10.2.1
HKEY_CURRENT_USER\Software\ESRI\SDE Workspace Factory
Edit key INSTANCE. Remove VERBOSE=TRUE