topic Re: sdemon users list is empty in Data Management Questions

sdemon users list is empty

BillyBuerger — Mon, 29 Aug 2011 20:35:06 GMT

I've ran into a problem recently where using sdemon -o info -I users -i 5151 will return "There are no ArcSDE users logged in." even though we know there are people connected to the database. In happened on one server and we just got by using other methods of determining users. But now it's happened on a second server.

Only thing I can think of that's different in these cases is that because the data we're working in is broken down into small sets, we have a large number of data users on each ArcSDE instance. On the one server we have 40. The second server has 4 SDE instances each with 10 data users. We did this so that each set of data can remain separate (they can all have a feature class with the same name) but without having to have 40 SDE databases. The second server only recently was bumped up to 10 data users each and just started having this problem. Other SDE databases where we generally only have one data user have not had this problem yet.

Has anyone else seen this before? Do you think it has anything to do with the multiple data users? I've been looking at other ways to save on resources and licenses by running multiple smaller sets of data on one database. Such as installing the ArcSDE service as the data user and not as the sde user. Maybe doing that differently will help. Any suggestions there as well?

Re: sdemon users list is empty

AJR — Mon, 29 Aug 2011 21:54:44 GMT

What version of SDE are you using?

Re: sdemon users list is empty

BillyBuerger — Mon, 29 Aug 2011 23:29:05 GMT

Right, completely forgot to mention versions...

ArcSDE 9.3.1
Oracle 11g (maybe Oracle 10g on one of them)
Windows Server 2008 R2

Re: sdemon users list is empty

AJR — Tue, 30 Aug 2011 00:56:30 GMT

I haven't seen this as a real issue since 9.1.

Silly question, but are you sure you are connecting to the correct server(s)? I don't see the -s option specified in your examples.

Re: sdemon users list is empty

BillyBuerger — Tue, 30 Aug 2011 02:35:39 GMT

I've always been running this command on the server I'm checking.

Re: sdemon users list is empty

VinceAngelo — Tue, 30 Aug 2011 10:05:40 GMT

Are you using Direct Connect or application server connections?

Have you restarted the server recently?

Have you done a DELETE or TRUNCATE on the SDE.PROCESS_INFORMATION table?

- V

Re: sdemon users list is empty

BillyBuerger — Tue, 30 Aug 2011 21:53:31 GMT

No direct connections. Only through the ArcSDE service.

I don't think the servers have been restarted in a while. They're used 24/7 so I would have to schedule a time to do something like this.

I haven't done anything to the PROCESS_INFORMATION table... But there are others who do maintenance on the databases who may possibly have. But I don't expect that they would have any reason to.

Re: sdemon users list is empty

mvisekru — Wed, 31 Aug 2011 19:51:34 GMT

Has the database been shutdown and restarted while the appliation server remained running? I've seen the same issue when this has occured.

Re: sdemon users list is empty

VinceAngelo — Wed, 31 Aug 2011 20:03:49 GMT

I generally get a different error if the database has been bounced, but 'giomgr' start will
truncate the process information table, so if a manual service start was made against
the wrong database instance, then this would explain it...

- V

Re: sdemon users list is empty

BillyBuerger — Wed, 31 Aug 2011 20:18:28 GMT

Thanks for the ideas. I won't be able to do anything until the 11th. I'll try out your thoughts at that time.