Disconnecting users via Promon (Vantage 6.1)

system · February 2, 2012, 11:31am

Tamara,

Try logging in to the server as the local administrator and then launch
Promon.

Mike

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tamara Blatny
Sent: Thursday, February 02, 2012 8:30 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Disconnecting users via Promon (Vantage 6.1)

I deal with this same issue inconsistently, consistently. And, I used to
be able to 'kill' that users session, but now I'm unable to 'kill' that
session.

Any suggestions would greatly help this minor issue, instead of
'stopping the dB'.

Thank you for posing this question.

Tamara

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of shraderc
Sent: Thursday, February 02, 2012 10:19 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Disconnecting users via Promon (Vantage 6.1)

Good morning!

Once in a while some of our users will start getting 'Error 0' in
Vantage; when this happens now I'll go into Promon and I will see a
*bunch* of licenses being tied up by old ODBC sessions - many having a
lock open for several days or even a week. The logins are not 'in
limbo'. I've already gone down the 'check-list' of issues that can cause
'error 0' and am reasonably certain we are experiencing a 'number of
connections' issue.

Rather than shut down the Progress server and restart it, is the general
concensus that I can kill old sessions using Promon to release the
connections? The ODBC sessions are easily identified by the user name
(and the fact that they have been open for several days, opened at
varying times *following* the last Progress server restart) so I know
I'm not closing 'special' system logins such as 'apw', etc.

Does anyone know of a fix to allow the release of licenses once an ODBC
session is completed? Or perhaps there's some process one can run to get
the Progress server to re-check and clear out old logins? I've heard of
a reference to 'allowing ODBC license re-use' and I'm wondering if
perhaps I have this setting turned on, causing my problem? (I recently
rebuilt our Vantage server so there may be some 'tweaking' left to
do)...

Chuck Shrader
Oak Ridge, TN

Reply to sender
<mailto:charles.shrader@... <mailto:charles.shrader%40gmail.com>
?subject=Re%3A%20Disconnecting%20users%
20via%20Promon%20%28Vantage%206%2E1%29> | Reply to group
<mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
?subject=Re%3A%20Disconnecting%20users%20
via%20Promon%20%28Vantage%206%2E1%29> | Reply via web post
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwMzNjM2U2BF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMDcyNDEEc2V
jA2Z0cgRzbGsDcnBseQRzdGltZQMxMzI4MTk5NTQ3?act=reply&messageNum=107241>
| Start a New Topic
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjYWZkc2h2BF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHB
jBHN0aW1lAzEzMjgxOTk1NDc->

Messages in this topic
<http://groups.yahoo.com/group/vantage/message/107241;_ylc=X3oDMTM2ZzVwN
jJhBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxM
DcyNDEEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzI4MTk5NTQ3BHRwY0lkAzEwNzI0MQ-->
(1)

Recent Activity:

* New Members
<http://groups.yahoo.com/group/vantage/members;_ylc=X3oDMTJkY2U0MjYwBF9T
Azk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2
bWJycwRzdGltZQMxMzI4MTk5NTQ3?o=6> 5

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjZXJsanFrBF9TAzk3MzU5
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzEzMjgxOTk1NDc->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJicGxoczhpBF9TAzk3MzU5NzE0BGdycElkA
zIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTMyODE5O
TU0Nw-->

Switch to: Text-Only
<mailto:vantage-traditional@yahoogroups.com
<mailto:vantage-traditional%40yahoogroups.com>
?subject=Change%20Delivery%20
Format:%20Traditional> , Daily Digest
<mailto:vantage-digest@yahoogroups.com
<mailto:vantage-digest%40yahoogroups.com>
?subject=Email%20Delivery:%20Diges
t> * Unsubscribe
<mailto:vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe%40yahoogroups.com> ?subject=Unsubscribe> *
Terms of Use <http://docs.yahoo.com/info/terms/>

[Non-text portions of this message have been removed]

______________________________________________________________________
This email has been scanned by the Connor Manufacturing Services Email
Security System.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

[Non-text portions of this message have been removed]

system · February 2, 2012, 11:19am

Good morning!

Once in a while some of our users will start getting 'Error 0' in Vantage; when this happens now I'll go into Promon and I will see a *bunch* of licenses being tied up by old ODBC sessions - many having a lock open for several days or even a week. The logins are not 'in limbo'. I've already gone down the 'check-list' of issues that can cause 'error 0' and am reasonably certain we are experiencing a 'number of connections' issue.

Rather than shut down the Progress server and restart it, is the general concensus that I can kill old sessions using Promon to release the connections? The ODBC sessions are easily identified by the user name (and the fact that they have been open for several days, opened at varying times *following* the last Progress server restart) so I know I'm not closing 'special' system logins such as 'apw', etc.

Does anyone know of a fix to allow the release of licenses once an ODBC session is completed? Or perhaps there's some process one can run to get the Progress server to re-check and clear out old logins? I've heard of a reference to 'allowing ODBC license re-use' and I'm wondering if perhaps I have this setting turned on, causing my problem? (I recently rebuilt our Vantage server so there may be some 'tweaking' left to do)...

Chuck Shrader
Oak Ridge, TN

system · February 2, 2012, 11:29am

I deal with this same issue inconsistently, consistently. And, I used to
be able to 'kill' that users session, but now I'm unable to 'kill' that
session.

Any suggestions would greatly help this minor issue, instead of
'stopping the dB'.

Thank you for posing this question.

Tamara

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of shraderc
Sent: Thursday, February 02, 2012 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Disconnecting users via Promon (Vantage 6.1)

Good morning!

Once in a while some of our users will start getting 'Error 0' in
Vantage; when this happens now I'll go into Promon and I will see a
*bunch* of licenses being tied up by old ODBC sessions - many having a
lock open for several days or even a week. The logins are not 'in
limbo'. I've already gone down the 'check-list' of issues that can cause
'error 0' and am reasonably certain we are experiencing a 'number of
connections' issue.

Rather than shut down the Progress server and restart it, is the general
concensus that I can kill old sessions using Promon to release the
connections? The ODBC sessions are easily identified by the user name
(and the fact that they have been open for several days, opened at
varying times *following* the last Progress server restart) so I know
I'm not closing 'special' system logins such as 'apw', etc.

Does anyone know of a fix to allow the release of licenses once an ODBC
session is completed? Or perhaps there's some process one can run to get
the Progress server to re-check and clear out old logins? I've heard of
a reference to 'allowing ODBC license re-use' and I'm wondering if
perhaps I have this setting turned on, causing my problem? (I recently
rebuilt our Vantage server so there may be some 'tweaking' left to
do)...

Chuck Shrader
Oak Ridge, TN

Reply to sender
<mailto:charles.shrader@...?subject=Re%3A%20Disconnecting%20users%
20via%20Promon%20%28Vantage%206%2E1%29> | Reply to group
<mailto:vantage@yahoogroups.com?subject=Re%3A%20Disconnecting%20users%20
via%20Promon%20%28Vantage%206%2E1%29> | Reply via web post
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJwMzNjM2U2BF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxMDcyNDEEc2V
jA2Z0cgRzbGsDcnBseQRzdGltZQMxMzI4MTk5NTQ3?act=reply&messageNum=107241>
| Start a New Topic
<http://groups.yahoo.com/group/vantage/post;_ylc=X3oDMTJjYWZkc2h2BF9TAzk
3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNudHB
jBHN0aW1lAzEzMjgxOTk1NDc->

Messages in this topic
<http://groups.yahoo.com/group/vantage/message/107241;_ylc=X3oDMTM2ZzVwN
jJhBF9TAzk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRtc2dJZAMxM
DcyNDEEc2VjA2Z0cgRzbGsDdnRwYwRzdGltZQMxMzI4MTk5NTQ3BHRwY0lkAzEwNzI0MQ-->
(1)

Recent Activity:

* New Members
<http://groups.yahoo.com/group/vantage/members;_ylc=X3oDMTJkY2U0MjYwBF9T
Azk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2
bWJycwRzdGltZQMxMzI4MTk5NTQ3?o=6> 5

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjZXJsanFrBF9TAzk3MzU5
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzEzMjgxOTk1NDc->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Yahoo! Groups
<http://groups.yahoo.com/;_ylc=X3oDMTJicGxoczhpBF9TAzk3MzU5NzE0BGdycElkA
zIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MQRzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTMyODE5O
TU0Nw-->

Switch to: Text-Only
<mailto:vantage-traditional@yahoogroups.com?subject=Change%20Delivery%20
Format:%20Traditional> , Daily Digest
<mailto:vantage-digest@yahoogroups.com?subject=Email%20Delivery:%20Diges
t> * Unsubscribe
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe> *
Terms of Use <http://docs.yahoo.com/info/terms/>

[Non-text portions of this message have been removed]