Hi!

I used this SQL to get info from sessions - in my program:

select * from Configuration.ServerSessions order by created

it is working.

When I tried to use this script in my EDBManager (b13), I got this error:

ElevateDB Error #700 An error was found in the statement at line 1 and column 15 (ElevateDB Error #401 The table or view ServerSessions does not exist in the schema Default)

What I do wrong?

I was in the remote database, in tables.

It is working:
select * from Configuration.Users

Thanks:
 dd

<< When I tried to use this script in my EDBManager (b13), I got this error:

ElevateDB Error #700 An error was found in the statement at line 1 and
column 15 (ElevateDB Error #401 The table or view ServerSessions does not
exist in the schema Default) >>

Send me a copy of the script that you're using.  You're most likely doing
something wrong, but I can't tell what it is without seeing the script.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Tim!

<< When I tried to use this script in my EDBManager (b13), I got this error:
ElevateDB Error #700 An error was found in the statement at line 1 and
column 15 (ElevateDB Error #401 The table or view ServerSessions does not
exist in the schema Default)

Send me a copy of the script that you're using.  You're most likely doing
something wrong, but I can't tell what it is without seeing the script. >>

There is no script!

I will detail, what happened in two times. But everytime we have bigger problems, and I forget to make a screenshot from this... May somebody else also see this.
TOday I cannot reproduce it, may this is depend on place/site.

1.)
We installed a new server to intranet. We published it (no firewall, etc), and we can log in with application.

2.)
After this somebody spoken from another city that he is logged in into this server.

3.)
My boss asked me that I check this logging is ok or not.
Because I have not rights to use rdesktop there, I thhougth that I see the sessions on the server from SQL script.

4.)
I created a remote session with remote db, pointed to the server.

5.)
I selected the remote session's database.

6.)
I copied the SQL from my logread application (see the prior msg), and I started it.

7.)
I got error that serversessions is not exists in DEFAULT scheme.
It is interesting, because I used the remote DB, and I used "Configuration." pretag.

Interesting, because this script is working in my application, and if I points to local session, it is returns only null row, but none of errormessages. ".users" is worked!
May something confused...

So I don't understand, how this happened!

This problem I experienced in two times, but I cannot reproduce it again today...

May it is dependent on any thing. If I can see this again, I will send a screen report about it.

Hope you understand, why I report this (for help you in debug).

(I tried to search this message in the log, but I forget that is remote log, a corporation have this file... )

Thanks for your read:
  dd

<< There is no script! >>

You said "script", so I assumed that meant that you were using a script.

<< I got error that serversessions is not exists in DEFAULT scheme. It is
interesting, because I used the remote DB, and I used "Configuration."
pretag. >>

Yes, I know, which is why I asked for the SQL that you were using.  I could
test this a 1000 times here and not have it fail, and I say this because
I've never seen such a query fail.  It even, as you say, works in a local
session, returning an empty result set.

--
Tim Young
Elevate Software
www.elevatesoft.com