Openedge Script Help

Posted by Admin on 24-Aug-2011 08:59

I noticed that when you execute proenv its a batch that sets variables.  Then when you do proserve its also a batch.  I'm needing help to automate the command "proserve bol2 -N tcp -n 24 -S 9900 -H appserver"

I have an automated script run to restart the Windows 2008 Server "Appserver" the reason for this is that the server is not releasing licenses via the promon command when you boot people that have a stale connections aka they didn't exit out of OpenEdge correctly.  It's been a long time since I've had to write a really long batch file so not sure what to do need help.

All Replies

Posted by Admin on 24-Aug-2011 09:05

On Windows batch files calling other batch files should use the CALL statement.

See HELP CALL for details.

Posted by Admin on 24-Aug-2011 09:13

I know about the call command though I didn't think it would be as simple as this.

call "C:\Program Files\progress\openedge\bin\proenv.bat"
call "C:\Program Files\progress\openedge\bin\proserve.bat"
proserve bol2 -N tcp -n 24 -S 9900 -H appserver

??

Posted by Admin on 24-Aug-2011 10:14

@echo off
c:
set DLC=C:\PROGRA~1\progress\openedge
set WRKDIR=D:\APPS\Progress-work
set OEM=C:\Program Files\progress\oemgmt
set OEMWRKDIR=D:\APPS\wrk_oemgmt
set PATH=%DLC%\BIN;%DLC%\PERL\BIN;%PATH%
set LIB=%DLC%\LIB;%LIB%
call "C:\Program Files\progress\openedge\bin\proserve" d:\db\bol\bol2 -N tcp -n 24 -S 9900 -H appserver
exit

Ok this is what I came up with can you anyone see if there might be a problem within the script?

Thanks for any help.

Posted by Admin on 24-Aug-2011 10:20

Ok this is what I came up with can you anyone see if there might be a problem within the script?

In which way is it misbehaving?

Posted by Admin on 24-Aug-2011 10:47

Every morning I was having to go start up proenv.   Then goto promon then use option 8 shutdowm database.  Then I use disconnect users since we have a few that aren't logging out correctly so they are using up a seat license.   Well for some reason even when I do that.  The seat license is not being released.  I would check and only see 8 out of 23 licenses being used. The bol2.lg file would still say there is 23 plus users trying to access OpenEdge. So the only solution I found was to restart the Windows 2008 Server.  Using shutdown /r /f within task scheduler at 11 P.M.  Last night for some reason Progress did not come up.   There was no locked file so the database shutdown correctly.  This is why I'm trying to automate the next part of it to make sure OpenEdge does start after a reboot.

I can not find a solution on why after I boot out users for not logging out correctly that the OpenEdge still thinks there is max amount of licenses being used.

As far as the script I don't want to try it until after hours to when I can actually take down OpenEdge database to see if that will bring up the server once again.

Posted by Admin on 24-Aug-2011 10:55

Anything in the database.lg file?

Rather than rebooting the server, I'd try to stop the DB using

call proshut -by

Posted by Admin on 24-Aug-2011 10:58

Have you ran into the issue I've described above about OpenEdge not releasing the client license even after using promon and removing the users?

Posted by Admin on 24-Aug-2011 11:00

Not that I'm aware of. I'd discuss that with tech support.

Posted by Admin on 24-Aug-2011 11:10

[2011/08/23@23:00:35.135-0400] P-5468       T-5472  I FMAGENT 5: (8848)  Connection to Admin Server lost.
[2011/08/23@23:00:36.679-0400] P-5100       T-2960  I BROKER  0: (9438)  CTRL_SHUTDOWN_EVENT console event received.
[2011/08/23@23:00:36.679-0400] P-5468       T-6900  I FMAGENT 5: (9438)  CTRL_SHUTDOWN_EVENT console event received.
[2011/08/23@23:00:36.679-0400] P-5432       T-7924  I SRV     1: (9438)  CTRL_SHUTDOWN_EVENT console event received.
[2011/08/23@23:00:36.679-0400] P-3636       T-1408  I SRV     2: (9438)  CTRL_SHUTDOWN_EVENT console event received.
[2011/08/23@23:00:36.679-0400] P-5276       T-7688  I SRV     3: (9438)  CTRL_SHUTDOWN_EVENT console event received.
[2011/08/23@23:00:36.679-0400] P-5628       T-636   I SRV     4: (9438)  CTRL_SHUTDOWN_EVENT console event received.
[2011/08/23@23:00:36.866-0400] P-5432       T-4724  I SRV     1: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:36.866-0400] P-5432       T-4724  I SRV     1: (2520)  Stopped.
[2011/08/23@23:00:36.866-0400] P-5628       T-3624  I SRV     4: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:36.866-0400] P-5628       T-3624  I SRV     4: (2520)  Stopped.
[2011/08/23@23:00:36.897-0400] P-5276       T-3512  I SRV     3: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:36.897-0400] P-3636       T-5840  I SRV     2: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:36.897-0400] P-3636       T-5840  I SRV     2: (2520)  Stopped.
[2011/08/23@23:00:38.036-0400] P-5100       T-5104  I BROKER  0: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:38.036-0400] P-5100       T-5104  I BROKER  0: (15192) The database will complete shutdown within approximately 60 seconds.
[2011/08/23@23:00:38.052-0400] P-5100       T-5104  I BROKER  0: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:38.052-0400] P-5100       T-5104  I BROKER  0: (2249)  Begin ABNORMAL shutdown code 2
[2011/08/23@23:00:39.066-0400] P-5100       T-5104  I BROKER  0: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:39.066-0400] P-5100       T-5104  I BROKER  0: (2263)  Resending shutdown request to 2 user(s).
[2011/08/23@23:00:41.671-0400] P-5480       T-5484  I WDOG    6: (453)   Logout by SYSTEM on batch.
[2011/08/23@23:00:41.671-0400] P-5480       T-5484  I WDOG    6: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:46.616-0400] P-5468       T-5472  I FMAGENT 5: (453)   Logout by DB_Agent on batch.
[2011/08/23@23:00:47.178-0400] P-5100       T-5104  I BROKER  0: (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:47.178-0400] P-5100       T-5104  I BROKER  0: (453)   Logout by SYSTEM on batch.
[2011/08/23@23:00:48.192-0400] P-5100       T-5104  I BROKER   : (5179)  Registry error 1717: Could not register 'BOL2_PROGRESS' events with the Event Viewer.
[2011/08/23@23:00:48.192-0400] P-5100       T-5104  I BROKER   : (334)   Multi-user session end.

That's from the log session from last night.  Not sure what to make of it.

Posted by gus on 24-Aug-2011 15:12

aside from the registry errors (which are not causing a problem) this looks perfectly normal. There is nothing here to indicate any clients are using the database.

Posted by Admin on 24-Aug-2011 15:43

That was the restart part of the logs.  When the server didn't come up correctly.   There was no logs at all after the server restarted.

Fri Aug 12 01:00:00 2011
[2011/08/12@01:00:00.535-0400] P-5488       T-772   I BACKUP  7: (-----) Login by administrator.
[2011/08/12@01:00:00.540-0400] P-2376       T-1504  I BACKUP  8: (-----) Login by Administrator.
[2011/08/12@01:00:00.558-0400] P-5488       T-772   I BACKUP  7: (12850) Backup blocks will be written to d:\db\bol\backups\scriptedbackup\oebackup.txt.
[2011/08/12@01:00:00.566-0400] P-5488       T-772   I BACKUP  7: (1362)  Full backup started.
[2011/08/12@01:00:00.567-0400] P-5488       T-772   I BACKUP  7: (6686)  51038 active blocks out of 51087 blocks in d:\db\bol\bol2 will be dumped.
[2011/08/12@01:00:00.568-0400] P-5488       T-772   I BACKUP  7: (6688)  2496 BI blocks will be dumped.
[2011/08/12@01:00:00.576-0400] P-5488       T-772   I BACKUP  7: (9285)  Backup requires an estimated 219.3 MBytes of media.
[2011/08/12@01:00:00.576-0400] P-5488       T-772   I BACKUP  7: (9286)  Restore would require an estimated 56141 db blocks using 54.7K of media.
[2011/08/12@01:00:00.603-0400] P-5488       T-772   I BACKUP  7: (5459)  Begin backup of Before Image file(s).
[2011/08/12@01:00:01.913-0400] P-5488       T-772   I BACKUP  7: (5460)  End backup of Before Image file(s).
[2011/08/12@01:00:01.914-0400] P-5488       T-772   I BACKUP  7: (5461)  Begin backup of Data file(s).
[2011/08/12@01:00:01.914-0400] P-2376       T-1504  I          : (453)   Logout by Administrator on CON:.
[2011/08/12@01:00:25.786-0400] P-5488       T-772   I BACKUP  7: (5462)  End backup of Data file(s).
[2011/08/12@01:00:25.795-0400] P-5488       T-772   I BACKUP  7: (13625) Wrote a total of 1652 backup blocks using 219.4 MBytes of media.
[2011/08/12@01:00:25.884-0400] P-5488       T-772   I BACKUP  7: (1364)  Full backup successfully completed.
[2011/08/12@01:00:25.889-0400] P-5488       T-772   I          : (453)   Logout by administrator on CON:.
[2011/08/12@06:06:35.152-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 28, userid RMILLER client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@06:06:35.243-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@06:06:35.243-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 28, server pid 4312, broker pid 6076. (5512)
[2011/08/12@07:46:09.330-0400] P-5956       T-4664  I SRV     2: (742)   Login usernum 27, userid kseeds client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@07:46:09.350-0400] P-5956       T-4664  I SRV     2: (12699) Database bol Options: 
[2011/08/12@07:46:09.351-0400] P-5956       T-4664  I SRV     2: (14658) Previous message sent on behalf of user 27, server pid 5956, broker pid 6076. (5512)
[2011/08/12@07:57:13.483-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 26, userid ddavis client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@07:57:13.522-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@07:57:13.522-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 26, server pid 4388, broker pid 6076. (5512)
[2011/08/12@08:03:41.970-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 25, userid etsmith client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:03:41.994-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@08:03:41.994-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 25, server pid 4452, broker pid 6076. (5512)
[2011/08/12@08:06:29.741-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 24, userid tpayne client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:06:29.766-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@08:06:29.766-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 24, server pid 4312, broker pid 6076. (5512)
[2011/08/12@08:08:50.895-0400] P-5956       T-4664  I SRV     2: (742)   Login usernum 23, userid mwhetstone client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:08:50.924-0400] P-5956       T-4664  I SRV     2: (12699) Database bol Options: 
[2011/08/12@08:08:50.925-0400] P-5956       T-4664  I SRV     2: (14658) Previous message sent on behalf of user 23, server pid 5956, broker pid 6076. (5512)
[2011/08/12@08:16:11.771-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 22, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:16:11.794-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@08:16:11.794-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 22, server pid 4388, broker pid 6076. (5512)
[2011/08/12@08:22:03.110-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 22, userid cwilliams, on termserver.
[2011/08/12@08:27:00.050-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 22, userid tburnhouse client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:27:00.080-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@08:27:00.080-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 22, server pid 4388, broker pid 6076. (5512)
[2011/08/12@08:37:00.921-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 21, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:37:00.952-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@08:37:00.952-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 21, server pid 4452, broker pid 6076. (5512)
[2011/08/12@08:43:19.144-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 21, userid cvollmer, on termserver.
[2011/08/12@08:43:26.007-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 21, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:43:26.031-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@08:43:26.031-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 21, server pid 4452, broker pid 6076. (5512)
[2011/08/12@08:46:14.794-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 21, userid cvollmer, on termserver.
[2011/08/12@08:51:01.695-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 21, userid ngoetz client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@08:51:01.721-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@08:51:01.721-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 21, server pid 4452, broker pid 6076. (5512)
[2011/08/12@09:17:30.796-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 20, userid kking client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@09:17:30.823-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@09:17:30.823-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 20, server pid 4312, broker pid 6076. (5512)
[2011/08/12@09:21:27.064-0400] P-5956       T-4664  I SRV     2: (742)   Login usernum 19, userid agloeckner client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@09:21:27.084-0400] P-5956       T-4664  I SRV     2: (12699) Database bol Options: 
[2011/08/12@09:21:27.084-0400] P-5956       T-4664  I SRV     2: (14658) Previous message sent on behalf of user 19, server pid 5956, broker pid 6076. (5512)
[2011/08/12@09:29:52.566-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 18, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@09:29:52.589-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@09:29:52.589-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 18, server pid 4388, broker pid 6076. (5512)
[2011/08/12@09:38:02.630-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@09:38:02.654-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@09:38:02.654-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@09:39:52.738-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 18, userid cvollmer, on termserver.
[2011/08/12@09:51:20.123-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid cwilliams, on termserver.
[2011/08/12@09:51:59.707-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 18, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@09:51:59.733-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@09:51:59.734-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 18, server pid 4388, broker pid 6076. (5512)
[2011/08/12@09:53:29.585-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 18, userid cwilliams, on termserver.
[2011/08/12@10:00:27.520-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 18, userid vbaram client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@10:00:27.542-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@10:00:27.542-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 18, server pid 4388, broker pid 6076. (5512)
[2011/08/12@10:09:36.261-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 20, userid kking, on termserver.
[2011/08/12@10:32:26.000-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 20, userid llarson client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@10:32:26.024-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@10:32:26.024-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 20, server pid 4312, broker pid 6076. (5512)
[2011/08/12@10:32:59.430-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 20, userid llarson, on termserver.
[2011/08/12@10:33:18.695-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 20, userid llarson client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@10:33:18.720-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@10:33:18.720-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 20, server pid 4312, broker pid 6076. (5512)
[2011/08/12@10:33:48.370-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid kking client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@10:33:48.389-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@10:33:48.390-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@10:39:54.861-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid alarge client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@10:39:54.883-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@10:39:54.883-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@10:42:06.221-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid alarge, on termserver.
[2011/08/12@10:50:59.066-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 20, userid llarson, on termserver.
[2011/08/12@10:51:55.256-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 20, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@10:51:55.281-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@10:51:55.282-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 20, server pid 4312, broker pid 6076. (5512)
[2011/08/12@11:01:41.192-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 20, userid cvollmer, on termserver.
[2011/08/12@11:03:09.808-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 20, userid lwaltz client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:03:09.831-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@11:03:09.832-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 20, server pid 4312, broker pid 6076. (5512)
[2011/08/12@11:03:32.407-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:03:32.436-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@11:03:32.437-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@11:04:08.120-0400] P-5956       T-4664  I SRV     2: (742)   Login usernum 15, userid llarson client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:04:08.144-0400] P-5956       T-4664  I SRV     2: (12699) Database bol Options: 
[2011/08/12@11:04:08.145-0400] P-5956       T-4664  I SRV     2: (14658) Previous message sent on behalf of user 15, server pid 5956, broker pid 6076. (5512)
[2011/08/12@11:04:24.497-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid cvollmer, on termserver.
[2011/08/12@11:04:26.612-0400] P-5956       T-4664  I SRV     2: (739)   Logout usernum 15, userid llarson, on termserver.
[2011/08/12@11:25:46.935-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 26, userid ddavis, on termserver.
[2011/08/12@11:28:11.286-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 26, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:28:11.308-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@11:28:11.309-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 26, server pid 4388, broker pid 6076. (5512)
[2011/08/12@11:32:11.309-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid tcherubini client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:32:11.334-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@11:32:11.334-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@11:36:33.135-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid tcherubini, on termserver.
[2011/08/12@11:43:22.186-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid kking, on termserver.
[2011/08/12@11:44:13.244-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:44:13.263-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@11:44:13.264-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@11:47:52.845-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid rrandle client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:47:52.888-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@11:47:52.888-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@11:48:34.879-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid cwilliams, on termserver.
[2011/08/12@11:48:42.040-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 26, userid cwilliams, on termserver.
[2011/08/12@11:49:59.288-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 26, userid kking client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:49:59.321-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@11:49:59.322-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 26, server pid 4388, broker pid 6076. (5512)
[2011/08/12@11:50:05.368-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid awemyss client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:50:05.390-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@11:50:05.391-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@11:58:53.752-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid rrandle, on termserver.
[2011/08/12@11:59:03.274-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid rrandle client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@11:59:03.305-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@11:59:03.306-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@12:00:04.130-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid rrandle, on termserver.
[2011/08/12@12:27:20.930-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 26, userid kking, on termserver.
[2011/08/12@12:29:27.082-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 26, userid rrandle client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@12:29:27.098-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@12:29:27.099-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 26, server pid 4388, broker pid 6076. (5512)
[2011/08/12@12:34:53.592-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 26, userid rrandle, on termserver.
[2011/08/12@12:35:19.762-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 26, userid llarson client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@12:35:19.787-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@12:35:19.788-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 26, server pid 4388, broker pid 6076. (5512)
[2011/08/12@12:38:52.353-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid kking client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@12:38:52.378-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@12:38:52.378-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@12:45:39.177-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid awemyss, on termserver.
[2011/08/12@12:58:13.348-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid kking, on termserver.
[2011/08/12@13:00:13.159-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@13:00:13.184-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@13:00:13.185-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@13:02:27.850-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid cvollmer, on termserver.
[2011/08/12@13:09:57.610-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid ddavis client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@13:09:57.633-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@13:09:57.633-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@13:21:38.842-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid rrandle client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@13:21:38.874-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@13:21:38.874-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@13:27:24.348-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid rrandle, on termserver.
[2011/08/12@13:37:31.121-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid ddavis, on termserver.
[2011/08/12@13:57:52.102-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid ccobb2 client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@13:57:52.122-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@13:57:52.123-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@14:19:47.807-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid vbaram client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@14:19:47.832-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@14:19:47.832-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@14:25:30.397-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 18, userid vbaram, on termserver.
[2011/08/12@14:34:01.054-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid ccobb2, on termserver.
[2011/08/12@14:42:42.193-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 18, userid cvollmer client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@14:42:42.221-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@14:42:42.221-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 18, server pid 4388, broker pid 6076. (5512)
[2011/08/12@14:44:30.348-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 18, userid cvollmer, on termserver.
[2011/08/12@14:45:20.967-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid vbaram, on termserver.
[2011/08/12@15:09:32.284-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 18, userid vbaram client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@15:09:32.307-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@15:09:32.308-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 18, server pid 4388, broker pid 6076. (5512)
[2011/08/12@15:12:08.947-0400] P-4452       T-4368  I SRV     4: (742)   Login usernum 17, userid gclark client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@15:12:08.971-0400] P-4452       T-4368  I SRV     4: (12699) Database bol Options: 
[2011/08/12@15:12:08.971-0400] P-4452       T-4368  I SRV     4: (14658) Previous message sent on behalf of user 17, server pid 4452, broker pid 6076. (5512)
[2011/08/12@15:29:38.256-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 16, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@15:29:38.280-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@15:29:38.280-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 16, server pid 4312, broker pid 6076. (5512)
[2011/08/12@15:31:44.744-0400] P-5956       T-4664  I SRV     2: (742)   Login usernum 15, userid ddavis client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@15:31:44.772-0400] P-5956       T-4664  I SRV     2: (12699) Database bol Options: 
[2011/08/12@15:31:44.773-0400] P-5956       T-4664  I SRV     2: (14658) Previous message sent on behalf of user 15, server pid 5956, broker pid 6076. (5512)
[2011/08/12@15:39:38.543-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 14, userid gziegler client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@15:39:38.574-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@15:39:38.575-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 14, server pid 4388, broker pid 6076. (5512)
[2011/08/12@15:40:48.604-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 22, userid tburnhouse, on termserver.
[2011/08/12@15:42:42.857-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 14, userid gziegler, on termserver.
[2011/08/12@15:48:45.482-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 16, userid cwilliams, on termserver.
[2011/08/12@15:55:16.406-0400] P-4388       T-5536  I SRV     3: (742)   Login usernum 22, userid cwilliams client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@15:55:16.430-0400] P-4388       T-5536  I SRV     3: (12699) Database bol Options: 
[2011/08/12@15:55:16.430-0400] P-4388       T-5536  I SRV     3: (14658) Previous message sent on behalf of user 22, server pid 4388, broker pid 6076. (5512)
[2011/08/12@15:58:36.691-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 20, userid lwaltz, on termserver.
[2011/08/12@15:59:02.570-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 22, userid cwilliams, on termserver.
[2011/08/12@16:34:33.528-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 22, userid lwaltz client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@16:34:33.551-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@16:34:33.552-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 22, server pid 4312, broker pid 6076. (5512)
[2011/08/12@16:45:22.942-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 22, userid lwaltz, on termserver.
[2011/08/12@16:46:56.569-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 24, userid tpayne, on termserver.
[2011/08/12@16:51:26.990-0400] P-5956       T-4664  I SRV     2: (739)   Logout usernum 19, userid agloeckner, on termserver.
[2011/08/12@16:51:45.810-0400] P-5956       T-4664  I SRV     2: (739)   Logout usernum 15, userid ddavis, on termserver.
[2011/08/12@16:53:22.751-0400] P-4388       T-5536  I SRV     3: (739)   Logout usernum 26, userid llarson, on termserver.
[2011/08/12@17:05:20.297-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 26, userid tpayne client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@17:05:20.320-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@17:05:20.320-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 26, server pid 4312, broker pid 6076. (5512)
[2011/08/12@17:07:45.864-0400] P-4312       T-5968  I SRV     1: (739)   Logout usernum 26, userid tpayne, on termserver.
[2011/08/12@17:55:13.898-0400] P-5956       T-4664  I SRV     2: (739)   Logout usernum 23, userid mwhetstone, on termserver.
[2011/08/12@18:00:12.496-0400] P-4312       T-5968  I SRV     1: (742)   Login usernum 26, userid abutler client type ABL , on termserver using TCP/IP IPV4 address 192.196.1.9.
[2011/08/12@18:00:12.522-0400] P-4312       T-5968  I SRV     1: (12699) Database bol Options: 
[2011/08/12@18:00:12.522-0400] P-4312       T-5968  I SRV     1: (14658) Previous message sent on behalf of user 26, server pid 4312, broker pid 6076. (5512)
[2011/08/12@18:13:11.698-0400] P-4452       T-4368  I SRV     4: (739)   Logout usernum 17, userid gclark, on termserver.
[2011/08/12@18:42:25.396-0400] P-5956       T-4664  I SRV     2: (739)   Logout usernum 27, userid kseeds, on termserver.

Posted by Admin on 25-Aug-2011 07:46

The shutdown and proserv command worked in the script.

proserve bol2 -N tcp -n 24 -S 9900 -H appserver

I noticed none of the agents are coming up and running.   What other commands do I need to run in order to get them up and running?   Sorry new to OpenEdge just thought the agents would automatically come up if you did the above.

Posted by Admin on 25-Aug-2011 07:50

Agents?

I assume you mean the server processes. They'll be started with the first clients connecting.

Posted by Peter Judge on 25-Aug-2011 07:52

dbarr wrote:

The shutdown and proserv command worked in the script.

proserve bol2 -N tcp -n 24 -S 9900 -H appserver

I noticed none of the agents are coming up and running.   What other commands do I need to run in order to get them up and running?   Sorry new to OpenEdge just thought the agents would automatically come up if you did the above.

If you mean the AppServer agents aren't available, then look at the  asbman command in %DLC%\bin. For example:

%dlc%\bin\asbman.bat -i asbroker1  -start

You can also set up appservers, databases et al to autostart when the Admin Service starts up, which is by default installed as a service on Windows. You can manage all of this stuff using OpenEdge Management (there should be a link in the Start menu/OpenEdge as Management Console, or http://localhost:9090 is the default).

-- peter

Posted by Admin on 25-Aug-2011 07:55

It's set that way but well we had a few issues honestly where it didn't come backup after the server restarted the one time.  So upper management is wanting to make sure that never happens again.  Though my manager is going to be getting ahold of Progress about the other issue why OpenEdge isn't releasing licenses.

Posted by Admin on 25-Aug-2011 07:56

Nope we have 7 people in and I don't see watchdog nor the others.

Posted by Admin on 25-Aug-2011 08:05

Nope we have 7 people in and I don't see watchdog nor the others.

That's the prowdog script.

When the others are the APW and BIW, eventually AIW then

proapw

probiw

proaiw

are the scripts for those.

Posted by Admin on 25-Aug-2011 08:44

Version is 10.2B

Watchdog is up and running without an issue now.

proenv>proapw bol2
Starting background Async Page Writer for bol2
OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009
09:39:38 APW     6: This version of PROGRESS does not support Asynchronous Page
Writers (proapw). (4966)
09:39:38 APW        ** This process terminated with exit code 1. (8619)


proenv>probiw bol2
Starting background Before Image Writer for bol2
OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009
09:39:58 BIW     6: This version of PROGRESS does not support the Before-Image W
riter (probiw). (4967)
09:39:58 BIW        ** This process terminated with exit code 1. (8619)


proenv>proaiw bol2
Starting background After Image Writer for bol2
OpenEdge Release 10.2B as of Mon Dec 14 17:02:01 EST 2009
09:40:07 AIW     6: This version of PROGRESS does not support an After-Image Wri
ter (proaiw). (4968)
09:40:07 AIW        ** This process terminated with exit code 1. (8619)

Is there something else I need to look for?

Posted by Admin on 25-Aug-2011 08:50

Is there something else I need to look for?

Looks like you have a workgroup DB. That does not support the background writers.

Posted by Admin on 25-Aug-2011 09:25

Besides watchdog which other will I need to have fireup until I can get a resolution to the problem?   I added prowdog to the script with a delayed start.   Yes we are running a workgroup I found out.

Posted by Admin on 25-Aug-2011 09:30

Besides watchdog which other will I need to have fireup until I can get a resolution to the problem?  

Depends on what you need. You mentioned agents. In case you are talking about webspeed or AppServer agents, you'll have to start the

asbman or wtbman as Peter suggested.

This thread is closed