End a Users session

Yahoo Archive
1
Here is everything they sent me when I had this question.



Summary: How can I disconnect users from the database?

Book: Support Solutions

Page: 2700MPS



PROBLEM DESCRIPTION:



How can I disconnect users from the database?



PROBLEM RESOLUTION:



PROMON NEEDS TO BE SETUP ON THE SERVER



Progress Monitor (PROMON) displays performance and usage information about
database status and activity. This utility also allows you to disconnect
individual users.



PROMON can be invoked at the DOS prompt or invoked through a Windows icon.





To run Promon from a DOS prompt:



1. At the server, open a DOS session.

2. Change directory to: c:\epicor\prgs91D\bin (Where 'C' is the physical
drive letter where Progress is installed)

3. Type: promon c:\epicor\mfgsys61\db\mfgsys.db and press enter

You will see the Promon menu.



To Run From Windows Icon (Version 6.1)



1. Creating a PROMON Icon

2. Right Mouse click on the server desktop and create a new shortcut.

3. Click the Browse button and map to c:\epicor\prgs91d\bin\_mprshut.exe

4. Click Next

5. Rename the shortcut to Promon

6. Click Finish

7. Right mouse click on the new icon and choose properties.

8. In the Target line click the cursor after the text

"C:\epicor\prgs91D\bin\_mprshut.exe" and type:

-0 C:\epicor\mfgsys61\db\mfgsys

9. In the Startinline change the path from c:\epicor\prgrs91d\bin and

type: C:\epicor\prowk91D 10. Save the changes. (Again, 'C' is whatever
physical drive you have installed progress and Vista to)





======================

USING the PROMON MENU

======================

--------------------------------

PROGRESS MONITOR

Database: c:\epicor\mfgsys61\db\mfgsys.db

--------------------------------

MENU OPTIONS:

1. User Control

2. Locking and Waiting Statistics

3. Block Access

4. Record Locking Table

5. Activity

6. Shared Resources

7. Database Status

8. Shut Down Database

T. Transactions Control

L. Resolve Limbo Transactions

C. Coordinate Information

M. Modify Defaults

Q. Quit

Enter Your Selection:__



=======================

TO DISCONNECT A USER

=======================

Choose Menu Option 8, 'Shutdown Database'. This will not actually shut down
your database but will give you access to another screen. In this second
screen choose option 1 'Disconnect a user'. Find the number that corresponds
to the user you wish to disconnect.





Chris Stover

Business Control Engineer

Deaver Industries

205-426-4309 Voice

205-426-4364 Fax

cstover@...

www.deaverind.com



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dan Ernst
Sent: Thursday, June 09, 2005 10:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: End a Users session



I tried this method and I noticed that the disconnect function is
greyed out so I am unable to use that method.
Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com

--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)"
<jmoore@d...> wrote:
> What about under System Management > Utilities > Connected Users ,
high
> light the user you wish to disconnect and then under users click
disconnect.
> Promon should work if this doesn't.
>
> Jim Moore
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Thursday, June 09, 2005 9:16 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] End a Users session
>
>
>
>
> Do you have an icon on the server for Promon? Allow stopping
individual
> sessions - in particular "ghost sessions" after a client PC
failure. There
> are instructions on the Epicor Support web site. -Todd C.
>
> -----Original Message-----
> From: Dan Ernst [mailto:dernst@c...]
> Sent: Thursday, June 09, 2005 9:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] End a Users session
>
>
> Is there a way to end a user's session when they get locked up in
> Vantage 6.1 Right now the only way I know how to end their
session is
> to stop and restart the database. But when I do that I have to get
all
> of the other users out and was hoping there was an easier way to
> accomplish this.
>
> Thanks
> Dan Ernst
> Computer Services
> Correct Craft, Inc.
> (407) 855-4141
> http://www.correctcraft.com





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 Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
<http://docs.yahoo.com/info/terms/> Service.



[Non-text portions of this message have been removed]
2
Is there a way to end a user's session when they get locked up in
Vantage 6.1 Right now the only way I know how to end their session is
to stop and restart the database. But when I do that I have to get all
of the other users out and was hoping there was an easier way to
accomplish this.

Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com
3
Do you have an icon on the server for Promon? Allow stopping individual sessions - in particular "ghost sessions" after a client PC failure. There are instructions on the Epicor Support web site.
-Todd C.

-----Original Message-----
From: Dan Ernst [mailto:dernst@...]
Sent: Thursday, June 09, 2005 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] End a Users session


Is there a way to end a user's session when they get locked up in
Vantage 6.1 Right now the only way I know how to end their session is
to stop and restart the database. But when I do that I have to get all
of the other users out and was hoping there was an easier way to
accomplish this.

Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com




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/.
(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 Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
What about under System Management > Utilities > Connected Users , high
light the user you wish to disconnect and then under users click disconnect.
Promon should work if this doesn't.

Jim Moore

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, June 09, 2005 9:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] End a Users session




Do you have an icon on the server for Promon? Allow stopping individual
sessions - in particular "ghost sessions" after a client PC failure. There
are instructions on the Epicor Support web site. -Todd C.

-----Original Message-----
From: Dan Ernst [mailto:dernst@...]
Sent: Thursday, June 09, 2005 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] End a Users session


Is there a way to end a user's session when they get locked up in
Vantage 6.1 Right now the only way I know how to end their session is
to stop and restart the database. But when I do that I have to get all
of the other users out and was hoping there was an easier way to
accomplish this.

Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com
5
I do have Promon on my server desktop. But I was unable to locate
any documents on how to use this program on Epicor's website.
Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com

--- In vantage@yahoogroups.com, "Todd Caughey" <caugheyt@h...> wrote:
> Do you have an icon on the server for Promon? Allow stopping
individual sessions - in particular "ghost sessions" after a client
PC failure. There are instructions on the Epicor Support web site.
> -Todd C.
>
> -----Original Message-----
> From: Dan Ernst [mailto:dernst@c...]
> Sent: Thursday, June 09, 2005 9:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] End a Users session
>
>
> Is there a way to end a user's session when they get locked up in
> Vantage 6.1 Right now the only way I know how to end their
session is
> to stop and restart the database. But when I do that I have to get
all
> of the other users out and was hoping there was an easier way to
> accomplish this.
>
> Thanks
> Dan Ernst
> Computer Services
> Correct Craft, Inc.
> (407) 855-4141
> http://www.correctcraft.com
>
>
>
>
> 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/.
> (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 Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com <mailto:vantage-
unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
6
Add a new shortcut to your DB with the following command. You may have
installed to a different drive so change that.

After double clicking the new shortcut select option "8" to shutdown
database. Dont worry it will not shutdown, but will give you a list of
connected users. You can select the one you want and disconnect them via
their user number on the left of the screen.

C:\EPICOR\PRGS91D\bin\_mprshut.exe -0 C:\EPICOR\mfgsys61\Db\mfgsys

Best Regards,
Paul Lipham
Information Systems Manager
Alabama Specialty Products, Inc.
256-358-4202

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Dan Ernst
Sent: Thursday, June 09, 2005 9:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] End a Users session


Is there a way to end a user's session when they get locked up in
Vantage 6.1 Right now the only way I know how to end their session is
to stop and restart the database. But when I do that I have to get all
of the other users out and was hoping there was an easier way to
accomplish this.

Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com




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/.
(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 Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
7
I tried this method and I noticed that the disconnect function is
greyed out so I am unable to use that method.
Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com

--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)"
<jmoore@d...> wrote:
> What about under System Management > Utilities > Connected Users ,
high
> light the user you wish to disconnect and then under users click
disconnect.
> Promon should work if this doesn't.
>
> Jim Moore
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Thursday, June 09, 2005 9:16 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] End a Users session
>
>
>
>
> Do you have an icon on the server for Promon? Allow stopping
individual
> sessions - in particular "ghost sessions" after a client PC
failure. There
> are instructions on the Epicor Support web site. -Todd C.
>
> -----Original Message-----
> From: Dan Ernst [mailto:dernst@c...]
> Sent: Thursday, June 09, 2005 9:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] End a Users session
>
>
> Is there a way to end a user's session when they get locked up in
> Vantage 6.1 Right now the only way I know how to end their
session is
> to stop and restart the database. But when I do that I have to get
all
> of the other users out and was hoping there was an easier way to
> accomplish this.
>
> Thanks
> Dan Ernst
> Computer Services
> Correct Craft, Inc.
> (407) 855-4141
> http://www.correctcraft.com
8
Per Help file, that only works when running Vantage from the server.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Dan Ernst
Sent: June 09, 2005 11:11 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: End a Users session

I tried this method and I noticed that the disconnect function is
greyed out so I am unable to use that method.
Thanks
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com

--- In vantage@yahoogroups.com, "Moore, Jim (Anniston)"
<jmoore@d...> wrote:
> What about under System Management > Utilities > Connected Users ,
high
> light the user you wish to disconnect and then under users click
disconnect.
> Promon should work if this doesn't.
>
> Jim Moore
>
> -----Original Message-----
> From: Todd Caughey [mailto:caugheyt@h...]
> Sent: Thursday, June 09, 2005 9:16 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] End a Users session
>
>
>
>
> Do you have an icon on the server for Promon? Allow stopping
individual
> sessions - in particular "ghost sessions" after a client PC
failure. There
> are instructions on the Epicor Support web site. -Todd C.
>
> -----Original Message-----
> From: Dan Ernst [mailto:dernst@c...]
> Sent: Thursday, June 09, 2005 9:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] End a Users session
>
>
> Is there a way to end a user's session when they get locked up in
> Vantage 6.1 Right now the only way I know how to end their
session is
> to stop and restart the database. But when I do that I have to get
all
> of the other users out and was hoping there was an easier way to
> accomplish this.
>
> Thanks
> Dan Ernst
> Computer Services
> Correct Craft, Inc.
> (407) 855-4141
> http://www.correctcraft.com





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/.
(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 Links
9
Thanks, this method worked. I did see it earlier but thought it
would immediately shut down the database. But now I see it will
allow me to select who I want to disconnect.
Thanks all
Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com


--- In vantage@yahoogroups.com, "Paul Lipham" <pml@a...> wrote:
> Add a new shortcut to your DB with the following command. You may
have
> installed to a different drive so change that.
>
> After double clicking the new shortcut select option "8" to
shutdown
> database. Dont worry it will not shutdown, but will give you a
list of
> connected users. You can select the one you want and disconnect
them via
> their user number on the left of the screen.
>
> C:\EPICOR\PRGS91D\bin\_mprshut.exe -0 C:\EPICOR\mfgsys61\Db\mfgsys
>
> Best Regards,
> Paul Lipham
> Information Systems Manager
> Alabama Specialty Products, Inc.
> 256-358-4202
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf Of
> Dan Ernst
> Sent: Thursday, June 09, 2005 9:04 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] End a Users session
>
>
> Is there a way to end a user's session when they get locked up in
> Vantage 6.1 Right now the only way I know how to end their
session is
> to stop and restart the database. But when I do that I have to
get all
> of the other users out and was hoping there was an easier way to
> accomplish this.
>
> Thanks
> Dan Ernst
> Computer Services
> Correct Craft, Inc.
> (407) 855-4141
> http://www.correctcraft.com
>
>
>
>
> 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/.
> (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 Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> b.. To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms
of Service.
>
>
>
> [Non-text portions of this message have been removed]