We have Progress 9.1D on a win2k server serving 25 databases. To back up the data every morning at 2:45am a scheduled task shuts down the db's with "pccmd.exe proservice stop" which worked fine. Then at 4:00am the db's were started again with "pccmd.exe proservice start" which also worked fine. Both scripts are being called by the task scheduler and worked fine. Then came change 
.
In order to connect Crystal Reports to the databases for supplemental reporting I created 25 sql brokers, one for each db, and changed the startup parameters for the databases as follows:
4gl: -m3 -Mpb 5 -N tcp -S [service name] -L 100000
sql: -Mn 9 -Mpb 4 -N tcp -S [service name] -L 100000
All db's are set to autostart and the sql brokers are all higher in the list than the 4gl brokers. Unfortunately now at 4:00am when the start task executes the sql brokers will start but the 4gl brokers will either not start or will fail without producing any errors in the logs. The only way to get the db's to start properly is to reboot the server, which is not terribly desirable.
The only difference in the logs from the 4:00am start command and the 8:30am reboot are a few PID's, and the following lines:
04:00:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
08:36:08 BROKER 0: Begin Physical Redo Phase at 192 . (5326)
04:00:07 BROKER 0: Physical Redo Phase Completed at blk 68 off 326 upd 770. (7161)
08:36:11 BROKER 0: Physical Redo Phase Completed at blk 68 off 326 upd 1281. (7161)
Oddly enough when only the sql broker starts 4gl clients can still connect, albeit after a great deal of time has passed, and in limited numbers. I see that the sql broker is allowing both 4gl and sql connections "This broker supports both 4GL and SQL server groups. (8865)".
How can I get the databases to start up properly after the "pccmd.exe proservice start" command has been executed?
In the event viewer I do see several of these at 2:45am:
"Application popup: _mprshut.exe - Application Error : The application failed to initialize properly (0xc0000142). Click on OK to terminate the application. "
Maybe it's the stop command that's failing? It looks like broker 0 shuts down but there's nothing saying broker 1 shuts down.
Full 2:45am log:
Thu Feb 03 02:45:06 2005
02:45:06 SHUT 9: Server shutdown started by Administrator on CON:. (542)
02:45:07 BROKER 0: Begin normal shutdown (2248)
02:45:07 SRV 2: Stopped. (2520)
02:45:08 BROKER : Multi-user session end. (334)
Full 4:00am log:
Thu Feb 03 04:00:06 2005
04:00:06 BROKER 0: Multi-user session begin. (333)
04:00:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
04:00:07 BROKER 0: Physical Redo Phase Completed at blk 68 off 326 upd 770. (7161)
04:00:08 BROKER 0: Started for ap2servsql using tcp, pid 4140. (5644)
04:00:08 BROKER 0: PROGRESS Version 9.1D on WINNT. (4234)
04:00:08 BROKER 0: Server started by Administrator on CON:. (4281)
04:00:08 BROKER 0: Started using pid: 4140. (6574)
04:00:08 BROKER 0: Physical Database Name (-db): c:\keane\keane\db\ap2\ap. (4235)
04:00:08 BROKER 0: Database Type (-dt): PROGRESS. (4236)
04:00:08 BROKER 0: Force Access (-F): Not Enabled. (4237)
04:00:08 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
04:00:08 BROKER 0: Number of Database Buffers (-B): 168. (4239)
04:00:08 BROKER 0: Maximum private buffers per user (-Bpmax): 42. (9422)
04:00:08 BROKER 0: Excess Shared Memory Size (-Mxs): 16390. (4240)
04:00:08 BROKER 0: The shared memory segment is not locked in memory. (10014)
04:00:08 BROKER 0: Current Size of Lock Table (-L): 100000. (4241)
04:00:08 BROKER 0: Hash Table Entries (-hash): 43. (4242)
04:00:08 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
04:00:08 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
04:00:08 BROKER 0: Crash Recovery (-i): Enabled. (4244)
04:00:08 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
04:00:08 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
04:00:08 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
04:00:08 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
04:00:08 BROKER 0: Before-Image Cluster Size: 524288. (4250)
04:00:08 BROKER 0: Before-Image Block Size: 8192. (4251)
04:00:08 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
04:00:08 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
04:00:08 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
04:00:08 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
04:00:08 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
04:00:08 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
04:00:08 BROKER 0: Maximum Number of Clients Per Server (-Ma): 2. (4257)
04:00:08 BROKER 0: Maximum Number of Servers (-Mn): 9. (4258)
04:00:08 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
04:00:08 BROKER 0: Maximum Number of Users (-n): 21. (4260)
04:00:08 BROKER 0: Host Name (-H): accounting. (4261)
04:00:08 BROKER 0: Service Name (-S): ap2servsql. (4262)
04:00:08 BROKER 0: Network Type (-N): tcp. (4263)
04:00:08 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
04:00:08 BROKER 0: Parameter File: Not Enabled. (4282)
04:00:08 BROKER 0: Maximum Servers Per Broker (-Mpb): 3. (5647)
04:00:08 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
04:00:08 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
04:00:08 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
04:00:08 BROKER 0: Created shared memory with segment_id: 7798784 (9336)
04:00:19 BROKER 1: Started for ap2serv using tcp, pid 3820. (5644)
04:00:19 BROKER 1: This is an additional broker for this protocol. (5645)
04:00:19 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)
.In order to connect Crystal Reports to the databases for supplemental reporting I created 25 sql brokers, one for each db, and changed the startup parameters for the databases as follows:
4gl: -m3 -Mpb 5 -N tcp -S [service name] -L 100000
sql: -Mn 9 -Mpb 4 -N tcp -S [service name] -L 100000
All db's are set to autostart and the sql brokers are all higher in the list than the 4gl brokers. Unfortunately now at 4:00am when the start task executes the sql brokers will start but the 4gl brokers will either not start or will fail without producing any errors in the logs. The only way to get the db's to start properly is to reboot the server, which is not terribly desirable.
The only difference in the logs from the 4:00am start command and the 8:30am reboot are a few PID's, and the following lines:
04:00:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
08:36:08 BROKER 0: Begin Physical Redo Phase at 192 . (5326)
04:00:07 BROKER 0: Physical Redo Phase Completed at blk 68 off 326 upd 770. (7161)
08:36:11 BROKER 0: Physical Redo Phase Completed at blk 68 off 326 upd 1281. (7161)
Oddly enough when only the sql broker starts 4gl clients can still connect, albeit after a great deal of time has passed, and in limited numbers. I see that the sql broker is allowing both 4gl and sql connections "This broker supports both 4GL and SQL server groups. (8865)".
How can I get the databases to start up properly after the "pccmd.exe proservice start" command has been executed?
In the event viewer I do see several of these at 2:45am:
"Application popup: _mprshut.exe - Application Error : The application failed to initialize properly (0xc0000142). Click on OK to terminate the application. "
Maybe it's the stop command that's failing? It looks like broker 0 shuts down but there's nothing saying broker 1 shuts down.
Full 2:45am log:
Thu Feb 03 02:45:06 2005
02:45:06 SHUT 9: Server shutdown started by Administrator on CON:. (542)
02:45:07 BROKER 0: Begin normal shutdown (2248)
02:45:07 SRV 2: Stopped. (2520)
02:45:08 BROKER : Multi-user session end. (334)
Full 4:00am log:
Thu Feb 03 04:00:06 2005
04:00:06 BROKER 0: Multi-user session begin. (333)
04:00:06 BROKER 0: Begin Physical Redo Phase at 0 . (5326)
04:00:07 BROKER 0: Physical Redo Phase Completed at blk 68 off 326 upd 770. (7161)
04:00:08 BROKER 0: Started for ap2servsql using tcp, pid 4140. (5644)
04:00:08 BROKER 0: PROGRESS Version 9.1D on WINNT. (4234)
04:00:08 BROKER 0: Server started by Administrator on CON:. (4281)
04:00:08 BROKER 0: Started using pid: 4140. (6574)
04:00:08 BROKER 0: Physical Database Name (-db): c:\keane\keane\db\ap2\ap. (4235)
04:00:08 BROKER 0: Database Type (-dt): PROGRESS. (4236)
04:00:08 BROKER 0: Force Access (-F): Not Enabled. (4237)
04:00:08 BROKER 0: Direct I/O (-directio): Not Enabled. (4238)
04:00:08 BROKER 0: Number of Database Buffers (-B): 168. (4239)
04:00:08 BROKER 0: Maximum private buffers per user (-Bpmax): 42. (9422)
04:00:08 BROKER 0: Excess Shared Memory Size (-Mxs): 16390. (4240)
04:00:08 BROKER 0: The shared memory segment is not locked in memory. (10014)
04:00:08 BROKER 0: Current Size of Lock Table (-L): 100000. (4241)
04:00:08 BROKER 0: Hash Table Entries (-hash): 43. (4242)
04:00:08 BROKER 0: Current Spin Lock Tries (-spin): 0. (4243)
04:00:08 BROKER 0: Number of Semaphore Sets (-semsets): 1. (6526)
04:00:08 BROKER 0: Crash Recovery (-i): Enabled. (4244)
04:00:08 BROKER 0: Database Blocksize (-blocksize): 4096. (6573)
04:00:08 BROKER 0: Delay of Before-Image Flush (-Mf): 3. (4245)
04:00:08 BROKER 0: Before-Image File I/O (-r -R): Reliable. (4247)
04:00:08 BROKER 0: Before-Image Truncate Interval (-G): 60. (4249)
04:00:08 BROKER 0: Before-Image Cluster Size: 524288. (4250)
04:00:08 BROKER 0: Before-Image Block Size: 8192. (4251)
04:00:08 BROKER 0: Number of Before-Image Buffers (-bibufs): 5. (4252)
04:00:08 BROKER 0: BI File Threshold size (-bithold): 0.0 Bytes. (9238)
04:00:08 BROKER 0: BI File Threshold Stall (-bistall): Disabled. (6552)
04:00:08 BROKER 0: After-Image Stall (-aistall): Not Enabled. (4254)
04:00:08 BROKER 0: Number of After-Image Buffers (-aibufs): 5. (4256)
04:00:08 BROKER 0: Storage object cache size (-omsize): 1024 (8527)
04:00:08 BROKER 0: Maximum Number of Clients Per Server (-Ma): 2. (4257)
04:00:08 BROKER 0: Maximum Number of Servers (-Mn): 9. (4258)
04:00:08 BROKER 0: Minimum Clients Per Server (-Mi): 1. (4259)
04:00:08 BROKER 0: Maximum Number of Users (-n): 21. (4260)
04:00:08 BROKER 0: Host Name (-H): accounting. (4261)
04:00:08 BROKER 0: Service Name (-S): ap2servsql. (4262)
04:00:08 BROKER 0: Network Type (-N): tcp. (4263)
04:00:08 BROKER 0: Character Set (-cpinternal): ISO8859-1. (4264)
04:00:08 BROKER 0: Parameter File: Not Enabled. (4282)
04:00:08 BROKER 0: Maximum Servers Per Broker (-Mpb): 3. (5647)
04:00:08 BROKER 0: Minimum Port for Auto Servers (-minport): 3000. (5648)
04:00:08 BROKER 0: Maximum Port for Auto Servers (-maxport): 5000. (5649)
04:00:08 BROKER 0: This broker supports both 4GL and SQL server groups. (8865)
04:00:08 BROKER 0: Created shared memory with segment_id: 7798784 (9336)
04:00:19 BROKER 1: Started for ap2serv using tcp, pid 3820. (5644)
04:00:19 BROKER 1: This is an additional broker for this protocol. (5645)
04:00:19 BROKER 1: This broker supports both 4GL and SQL server groups. (8865)
