8.7 sp3 server dies with no clear reason
8.7 sp3 server dies with no clear reason
(OP)
Seemingly out of nowhere, my server dies and no one can log in to MAX (our ERP using pervasive) and neither can I on the server. We're running Windows Server 2000 with all available updates, service packs and patches. I've reinstalled the engine and am still having the issue. Out of nowhere, the db becomes unresponsive and new client login attempts time out and MAX throws Btrieve Config.dat file not open errors, even on the server.
The fix is to stop the 2 Pervasive services and start them again. Nothing helpful is in the logs pinpointing the exact problem, but I will post what the logs say after the restart. It seems to only catch the timeout errors when I attempt to start the client MAX application on the server itself. Also, the Control Center on the server doesn't even show its a Pervasive Server when this happens (until I restart the services and open it up again).
Here are the log items that seem to relate to this issue:
08-19-2009 06:32:32 W3CACHE 00000C2C W3DBSMGR.EXE MAX W Resources allocated
08-19-2009 06:33:37 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:34:35 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (5.22.1.10): Error 8520 - A timeout occurred during the initialization of SRDE engine
08-19-2009 06:34:35 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (5.22.1.10): Error 8520 - A timeout occurred during the initialization of SRDE engine
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:36:41 W3CACHE 00000C2C W3DBSMGR.EXE MAX I Resources released
08-19-2009 06:36:46 NTMKDE 00000564 NTDBSMGR.EXE MAX W Resources allocated
08-19-2009 07:33:47 NTMKDE 0000057C NTDBSMGR.EXE MAX W Resources allocated
Here's some error info from a client running xp and the CRD application that automates some crystal reports (going back days.. we have this problem at least once a day and this morning twice already!):
08-13-2009 11:03:44 ECAS_API 00001634 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-13-2009 11:17:18 ECAS_API 0000090C pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-14-2009 17:08:34 W3NSL244 0000096C crd.exe DEPLOY E 3112: Status 10054 returned while receiving a maximum of 40960 bytes.
08-17-2009 07:55:16 W3CACHE 00001A78 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:01:27 W3CACHE 00000448 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:05:56 W3CACHE 00000448 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:22:02 W3CACHE 000017A8 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:27:11 W3CACHE 000017A8 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:32:06 W3CACHE 00000FEC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:49:16 W3CACHE 00000FEC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:49:35 W3CACHE 00000DA4 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:57:04 W3CACHE 00000DA4 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:57:35 W3CACHE 000016AC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:59:04 W3CACHE 000016AC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 09:30:26 W3CACHE 00000620 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 09:50:25 W3CACHE 00000620 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 09:51:44 W3CACHE 000015AC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 09:55:33 W3CACHE 000015AC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:01:18 W3CACHE 0000066C W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:13:37 W3CACHE 0000066C W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:16:21 W3CACHE 000016BC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:29:10 W3CACHE 000016BC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:31:33 W3CACHE 00001608 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:43:32 W3CACHE 00001608 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:46:25 W3CACHE 00001408 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:58:24 W3CACHE 00001408 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:01:33 W3CACHE 00000EDC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:13:42 W3CACHE 00000EDC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:16:30 W3CACHE 000013EC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:27:19 W3CACHE 000013EC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:31:08 W3CACHE 000016C0 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:42:37 W3CACHE 000016C0 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:45:44 W3CACHE 00001778 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:58:23 W3CACHE 00001778 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 12:30:41 W3CACHE 000016A8 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 12:42:10 W3CACHE 000016A8 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 12:45:43 W3CACHE 000008E4 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 12:56:42 W3CACHE 000008E4 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 13:00:47 W3CACHE 00000AD8 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 13:12:16 W3CACHE 00000AD8 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 13:15:51 W3CACHE 0000073C W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 13:30:20 W3CACHE 0000073C W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 13:30:52 W3CACHE 00000850 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 13:49:00 ECAS_API 00001308 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-17-2009 15:07:59 W3NSL244 00001784 crd.exe DEPLOY E 3111: Status 10054 returned while sending 146 bytes.
08-17-2009 15:07:59 W3NSL244 00001784 crd.exe DEPLOY E 3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
08-18-2009 11:17:05 ECAS_API 00000818 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 11:18:31 ECAS_API 0000173C pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 11:21:26 ECAS_API 00001B34 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 12:09:43 ECAS_API 00001110 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 12:16:00 ECAS_API 00001A98 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:26 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
The fix is to stop the 2 Pervasive services and start them again. Nothing helpful is in the logs pinpointing the exact problem, but I will post what the logs say after the restart. It seems to only catch the timeout errors when I attempt to start the client MAX application on the server itself. Also, the Control Center on the server doesn't even show its a Pervasive Server when this happens (until I restart the services and open it up again).
Here are the log items that seem to relate to this issue:
08-19-2009 06:32:32 W3CACHE 00000C2C W3DBSMGR.EXE MAX W Resources allocated
08-19-2009 06:33:37 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:34:35 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (5.22.1.10): Error 8520 - A timeout occurred during the initialization of SRDE engine
08-19-2009 06:34:35 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (5.22.1.10): Error 8520 - A timeout occurred during the initialization of SRDE engine
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:35:39 ECAS_API 00000B40 pcc.exe MAX E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 06:36:41 W3CACHE 00000C2C W3DBSMGR.EXE MAX I Resources released
08-19-2009 06:36:46 NTMKDE 00000564 NTDBSMGR.EXE MAX W Resources allocated
08-19-2009 07:33:47 NTMKDE 0000057C NTDBSMGR.EXE MAX W Resources allocated
Here's some error info from a client running xp and the CRD application that automates some crystal reports (going back days.. we have this problem at least once a day and this morning twice already!):
08-13-2009 11:03:44 ECAS_API 00001634 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-13-2009 11:17:18 ECAS_API 0000090C pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-14-2009 17:08:34 W3NSL244 0000096C crd.exe DEPLOY E 3112: Status 10054 returned while receiving a maximum of 40960 bytes.
08-17-2009 07:55:16 W3CACHE 00001A78 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:01:27 W3CACHE 00000448 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:05:56 W3CACHE 00000448 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:22:02 W3CACHE 000017A8 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:27:11 W3CACHE 000017A8 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:32:06 W3CACHE 00000FEC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:49:16 W3CACHE 00000FEC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:49:35 W3CACHE 00000DA4 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:57:04 W3CACHE 00000DA4 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 08:57:35 W3CACHE 000016AC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 08:59:04 W3CACHE 000016AC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 09:30:26 W3CACHE 00000620 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 09:50:25 W3CACHE 00000620 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 09:51:44 W3CACHE 000015AC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 09:55:33 W3CACHE 000015AC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:01:18 W3CACHE 0000066C W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:13:37 W3CACHE 0000066C W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:16:21 W3CACHE 000016BC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:29:10 W3CACHE 000016BC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:31:33 W3CACHE 00001608 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:43:32 W3CACHE 00001608 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 10:46:25 W3CACHE 00001408 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 10:58:24 W3CACHE 00001408 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:01:33 W3CACHE 00000EDC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:13:42 W3CACHE 00000EDC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:16:30 W3CACHE 000013EC W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:27:19 W3CACHE 000013EC W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:31:08 W3CACHE 000016C0 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:42:37 W3CACHE 000016C0 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 11:45:44 W3CACHE 00001778 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 11:58:23 W3CACHE 00001778 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 12:30:41 W3CACHE 000016A8 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 12:42:10 W3CACHE 000016A8 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 12:45:43 W3CACHE 000008E4 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 12:56:42 W3CACHE 000008E4 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 13:00:47 W3CACHE 00000AD8 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 13:12:16 W3CACHE 00000AD8 W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 13:15:51 W3CACHE 0000073C W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 13:30:20 W3CACHE 0000073C W3DBSMGR.EXE DEPLOY I Resources released
08-17-2009 13:30:52 W3CACHE 00000850 W3DBSMGR.EXE DEPLOY W Resources allocated
08-17-2009 13:49:00 ECAS_API 00001308 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-17-2009 15:07:59 W3NSL244 00001784 crd.exe DEPLOY E 3111: Status 10054 returned while sending 146 bytes.
08-17-2009 15:07:59 W3NSL244 00001784 crd.exe DEPLOY E 3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.
08-18-2009 11:17:05 ECAS_API 00000818 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 11:18:31 ECAS_API 0000173C pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 11:21:26 ECAS_API 00001B34 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 12:09:43 ECAS_API 00001110 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-18-2009 12:16:00 ECAS_API 00001A98 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:26 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:29 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
08-19-2009 07:54:32 ECAS_API 00001950 pcc.exe DEPLOY E ECASAPI (1.21.1.12): Error 8509 - A timeout occurred during the initialization of MKDE
RE: 8.7 sp3 server dies with no clear reason
RE: 8.7 sp3 server dies with no clear reason
I don't think it's a config issue though.
The first thing I would suggest would be to rename the W3DBSMGR.EXE (which is the workgroup/cache engine). When the server engine crashes, the cache engine loads and causes other errors.
The second thing I would suggest would be to stop the PSQL services, rename the PVSW.LOG, and restart the services. This will clear out the PVSW.LOG and give you a better idea of the actual behavior being seen.
PCC doesn't display the server because it things the cache engine is running.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
Yesterday I renamed the cache engine so it'd stop loading (on your suggestion).
I stopped both Pervasive services in the Service manager and moved the old log file to my desktop (on your suggestion).
It took a long time for the transactional service to stop and didn't fully until after Windows complained.
Once completely stopped, I restarted them but still could not get back into Max, same error.
I tried again to stop and start both services, this time it going much faster, and still couldn't get back in.
I changed the cache engine filename back again and attempted the restart 2 or 3 more times with no success getting the Max client to work.
I finally renamed the cache engine once more (tried another time or two to no avail) and restarted the entire server. That worked, so now we're back up and the cache engine is still disabled.
Here's the new log info, which is more informative, thankfully, but still mysterious to me:
Date Time Component Process Process Name Machine Name Type Category Msg ID Message
---------- -------- --------------- -------- --------------- --------------- ---- ---------- -------- --------------------------------------------------
08-20-2009 06:19:22 W3MIF169 00000A90 SYSMAN.EXE MAX E WaitOnIPCControlSem(). WaitForSingleObject failed. OS rc=128.
08-20-2009 06:19:32 ECAS_API 00000A90 SYSMAN.EXE MAX E ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the Workgroup engine
08-20-2009 06:19:32 ECAS_API 00000A90 SYSMAN.EXE MAX E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the Workgroup engine
08-20-2009 06:19:32 ECAS_API 00000A90 SYSMAN.EXE MAX E ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the Workgroup engine
08-20-2009 06:19:32 ECAS_API 00000A90 SYSMAN.EXE MAX E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the Workgroup engine
08-20-2009 06:19:58 NTMKDE 00001230 NTDBSMGR.EXE MAX W Resources allocated
08-20-2009 06:20:01 W3MIF169 00000C40 SYSMAN.EXE MAX E WaitOnIPCControlSem(). WaitForSingleObject failed. OS rc=128.
08-20-2009 06:20:10 ECAS_API 00000C40 SYSMAN.EXE MAX E ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the Workgroup engine
08-20-2009 06:20:10 ECAS_API 00000C40 SYSMAN.EXE MAX E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the Workgroup engine
08-20-2009 06:20:10 ECAS_API 00000C40 SYSMAN.EXE MAX E ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the Workgroup engine
08-20-2009 06:20:10 ECAS_API 00000C40 SYSMAN.EXE MAX E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the Workgroup engine
08-20-2009 06:21:18 NTMKDE 00001230 NTDBSMGR.EXE MAX I Resources released
08-20-2009 06:22:41 W3MIF169 00001254 SYSMAN.EXE MAX E WaitOnIPCControlSem(). WaitForSingleObject failed. OS rc=128.
08-20-2009 06:22:55 W3CACHE 00001360 W3DBSMGR.EXE MAX W Resources allocated
08-20-2009 06:23:34 W3CACHE 00001360 W3DBSMGR.EXE MAX I Resources released
08-20-2009 06:23:39 W3MIF169 00001360 SYSMAN.EXE MAX E WaitOnIPCControlSem(). WaitForSingleObject failed. OS rc=128.
08-20-2009 06:23:48 W3CACHE 00000CDC W3DBSMGR.EXE MAX W Resources allocated
08-20-2009 06:24:21 W3CACHE 00000CDC W3DBSMGR.EXE MAX I Resources released
08-20-2009 06:24:33 W3MIF169 000013A8 pcc.exe MAX E WaitOnIPCControlSem(). WaitForSingleObject failed. OS rc=128.
08-20-2009 06:24:36 ECAS_API 000013A8 pcc.exe MAX E ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the Workgroup engine
08-20-2009 06:24:36 ECAS_API 000013A8 pcc.exe MAX E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the Workgroup engine
08-20-2009 06:30:46 NTMKDE 00000C14 NTDBSMGR.EXE MAX W Resources allocated
08-20-2009 06:30:57 W3MIF169 00000F6C SYSMAN.EXE MAX E WaitOnIPCControlSem(). WaitForSingleObject failed. OS rc=128.
08-20-2009 06:32:19 NTMKDE 00000C14 NTDBSMGR.EXE MAX I Resources released
08-20-2009 06:37:59 NTMKDE 000005E0 NTDBSMGR.EXE MAX W Resources allocated
RE: 8.7 sp3 server dies with no clear reason
(I'm just pasting the tail end starting with the last line that you've already seen from this log in my first post, to show the complete file.)
08-19-2009 07:33:47 NTMKDE 0000057C NTDBSMGR.EXE MAX W Resources allocated
08-19-2009 09:21:33 W3CACHE 000013C0 W3DBSMGR.EXE MAX W Resources allocated
08-20-2009 06:15:12 W3CACHE 000013C0 W3DBSMGR.EXE MAX I Resources released
08-20-2009 06:17:51 ECAS_API 000012F4 pcc.exe MAX E ECASAPI (1.12.1.4083): Error 8505 - An initialization error occurred when trying to establish a session with the Workgroup engine
08-20-2009 06:17:51 ECAS_API 000012F4 pcc.exe MAX E ECASAPI (1.1.1.4083): Error 8517 - An error occurred when closing the session with the Workgroup engine
RE: 8.7 sp3 server dies with no clear reason
I know you don't believe it's a configuration issue, but just in case, here are my settings, exported from the registry:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 8\Settings]
"Splash Screen"="Yes"
"Embedded Spaces"="no"
"Verify Key Length"="yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 8\Settings]
"TCP connect timeout"=dword:0000000f
"Supported protocols"="TCPIP"
"Runtime server"="Yes"
"Enable AutoReconnect"="No"
"Max Multiple Connections"=dword:00000000
"Log Statistics"="No"
"NumSatEntries"=dword:00000001
"SatEntry0"="Max,0,4,3,1,0"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace\{140B1898-B47A-11D3-9194-00A024C8C314}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Pervasive.SQL BCP]
"ExternalTools"=hex(7):4c,00,69,00,63,00,65,00,6e,00,73,00,65,00,20,00,41,00,\
64,00,6d,00,69,00,6e,00,69,00,73,00,74,00,72,00,61,00,74,00,6f,00,72,00,00,\
00,43,00,3a,00,5c,00,50,00,56,00,53,00,57,00,5c,00,42,00,49,00,4e,00,5c,00,\
47,00,55,00,49,00,4c,00,43,00,41,00,44,00,4d,00,2e,00,45,00,58,00,45,00,00,\
00,2f,00,73,00,00,00,52,00,65,00,62,00,75,00,69,00,6c,00,64,00,00,00,43,00,\
3a,00,5c,00,50,00,56,00,53,00,57,00,5c,00,42,00,49,00,4e,00,5c,00,52,00,42,\
00,4c,00,44,00,47,00,55,00,49,00,2e,00,45,00,58,00,45,00,00,00,00,00,4d,00,\
6f,00,6e,00,69,00,74,00,6f,00,72,00,00,00,43,00,3a,00,5c,00,50,00,56,00,53,\
00,57,00,5c,00,42,00,49,00,4e,00,5c,00,57,00,33,00,4d,00,4f,00,4e,00,56,00,\
37,00,35,00,2e,00,45,00,58,00,45,00,00,00,00,00,4d,00,61,00,69,00,6e,00,74,\
00,65,00,6e,00,61,00,6e,00,63,00,65,00,00,00,43,00,3a,00,5c,00,50,00,56,00,\
53,00,57,00,5c,00,42,00,49,00,4e,00,5c,00,57,00,33,00,32,00,4d,00,41,00,49,\
00,4e,00,54,00,2e,00,45,00,58,00,45,00,00,00,00,00,46,00,75,00,6e,00,63,00,\
74,00,69,00,6f,00,6e,00,20,00,45,00,78,00,65,00,63,00,75,00,74,00,6f,00,72,\
00,00,00,43,00,3a,00,5c,00,50,00,56,00,53,00,57,00,5c,00,42,00,49,00,4e,00,\
5c,00,57,00,42,00,45,00,58,00,45,00,43,00,33,00,32,00,2e,00,45,00,58,00,45,\
00,00,00,00,00,00,00
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}]
@="Pervasive Config ECP"
"Name"="Pervasive.SQL Configuration"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}]
@="Pervasive.SQL BCP"
"Name"="Pervasive.SQL Base Content Provider"
"BaseProvider"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 8\Settings]
"DBNamesDirectory"="C:\\WINNT"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 8\Settings]
"Local"="yes"
"Requester"="yes"
"Use IDS"="no"
"IDS Username"="<None>"
"IDS Password"="<None>"
"Compress IDS Data"="no"
"Gateway Durability"="no"
"Use Cache Engine"="no"
"Load Retries"=dword:00000005
"Target Engine"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8\Settings]
"Balanced Trees"="NO"
"File Version"="0800"
"System Data"="YES"
"Max MicroKernel Memory Usage"=dword:0000003c
"Logging"="NO"
"Cache Size"=dword:0006664c
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:00000040
"Transaction Durability"="NO"
"Transaction Log Buffer Size"=dword:00000400
"Transaction Log File Size"=dword:00000800
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Transaction Logging"="YES"
"Background Threads"=dword:00000020
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"Validate Request"="NO"
"Max Pending IO"=dword:00000800
"File Growth Factor"=dword:0000000f
"Page Server Allow Client Cache"="YES"
"Prompt For Client Credentials"="NO"
"Allow Client-Stored Credentials"="YES"
"Enable Watchdog"="YES"
"System Cache"="NO"
"Preallocate"="NO"
"Minimal States"="NO"
"Minimal States Delay"=dword:0000012c
"Worker Threads"=dword:00000004
"Max Remote Communications Buffer Size"=dword:00000040
"Remote Read Buffer Size"=dword:00000004
"Remote Worker Threads"=dword:00000010
"Remote Sessions Enabled"="YES"
"Supported Protocols"=hex(7):54,00,43,00,50,00,2f,00,49,00,50,00,00,00,00,00
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="YES"
"Listen IP Address"="0.0.0.0"
"Home Directory"="C:\\PVSW\\BIN"
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8\Settings\Hook Modules]
"0"="c:\\pvsw\\bin\\cnstring.dll"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8\Settings\Hook Modules\CNString]
@="0"
"Description"="Connection String Hook Module for remote DB Names"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Workgroup Engine]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Workgroup Engine\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Workgroup Engine\Version 8\Settings]
"Balanced Trees"="NO"
"File Version"="0800"
"System Data"="YES"
"Max MicroKernel Memory Usage"=dword:0000003c
"Logging"="NO"
"Cache Size"=dword:00008000
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:00000040
"Transaction Durability"="NO"
"Transaction Logging"="YES"
"Transaction Log Buffer Size"=dword:00000400
"Transaction Log File Size"=dword:00000800
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Background Threads"=dword:00000020
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"Work Space"=""
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"Prompt For Client Credentials"="NO"
"Allow Client-Stored Credentials"="YES"
"System Cache"="YES"
"Preallocate"="NO"
"Worker Threads"=dword:00000004
"Max Remote Communications Buffer Size"=dword:00000040
"Remote Read Buffer Size"=dword:00000004
"Remote Worker Threads"=dword:00000010
"Remote Sessions Enabled"="YES"
"Supported Protocols"=hex(7):53,00,50,00,58,00,49,00,49,00,00,00,54,00,43,00,\
50,00,2f,00,49,00,50,00,00,00,4e,00,45,00,54,00,42,00,49,00,4f,00,53,00,00,\
00,00,00
"Home Directory"="C:\\PVSW\\BIN"
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="YES"
"Listen IP Address"="0.0.0.0"
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
"Validate Request"="NO"
"Max Pending IO"=dword:00000800
"File Growth Factor"=dword:0000000f
"Enable Watchdog"="YES"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MKC]
"UseDelayedSyncClose"="YES"
"SyncCloseDelay(msecs)"="50"
"ThreadsPerConnection"="10"
"UseDelayedSyncCloseForRI"="YES"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 8.70]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 8.70\Settings]
"Save Settings"="Yes"
"Refresh Rate"=dword:00000004
"MKDE Resource Usage Window AutoRefresh"="Yes"
"MKDE Communication Statistics Window AutoRefresh"="Yes"
"MKDE Active Files Window AutoRefresh"="Yes"
"MKDE Active Users Window AutoRefresh"="Yes"
"SQL Connection Manager Window AutoRefresh"="Yes"
"Save Layout"="Yes"
"Main Window X"=dword:000000a0
"Main Window Y"=dword:00000060
"Main Window Width"=dword:00000300
"Main Window Height"=dword:00000219
"Show MKDE Resource Usage Window"="No"
"Show MKDE Communication Statistics Window"="No"
"Show MKDE Active Files Window"="No"
"Show MKDE Active Users Window"="No"
"Show SQL Connection Manager Window"="No"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer\8.0]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer\8.6]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer\8.7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive System Analyzer]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive System Analyzer\InstallInfo]
"InstallDir"="C:\\Program Files\\Common Files\\Pervasive Software Shared\\PSA"
"VersionLevel"="8.7"
"PatchLevel"="3"
"BuildLevel"="014"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL NT Server]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL NT Server\InstallInfo]
"InstallDir"="C:\\PVSW"
"SystemDir"="C:\\WINNT\\system32"
"InstallIniName"="PTKSETUP.INI"
"VersionLevel"="8.70"
"PatchLevel"="3"
"BuildLevel"="014"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Temp]
"InstallDir"="C:\\PVSW\\"
"SystemDir"="C:\\WINNT\\system32\\"
"SupportDir"="C:\\DOCUME~1\\smalcolm\\LOCALS~1\\Temp\\1\\{5CA60F17-0BFA-4854-906C-5A6D31B7199A}"
"Engine"="NTSVR"
"SetupDir"="C:\\kjtemp\\Pervasive.SQL_8.6_complete_Windows"
"CommonDir"="C:\\Program Files\\Common Files\\"
"UILevel"="5"
"WindowsDir"="C:\\WINNT\\"
"myarpcomments"=""
"CommonFilesDir"="C:\\Program Files\\Common Files\\"
"ServicesStart"="Automatic"
"StartMenuDir"="C:\\Documents and Settings\\All Users\\Start Menu\\Programs\\"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Security]
"Wire Encryption"="IF NEEDED"
"Wire Encryption Level"="2"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\Processes]
"W3ODBCEI"="2001"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\SQLManager]
"LogEvent"="1"
"MgrPort"="1583"
"MgrSPXPort"="29320"
"MgrMaxConnections"="2001"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Relational Engine]
"CurrentDateBasedDSTConversion"="NO"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Utilities Interface]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Utilities Interface\Settings]
"Restricted Access On WTS client"=dword:00000000
RE: 8.7 sp3 server dies with no clear reason
Also, I lied, the 2nd nic is .248 not .10
I do get this system event on startup:
Event Type: Error
Event Source: Dhcp
Event Category: None
Event ID: 1002
Date: 8/20/2009
Time: 6:35:11 AM
User: N/A
Computer: MAX
Description:
The IP address lease 192.168.100.248 for the Network Card with network address 000E7FB2CB6A has been denied by the DHCP server 192.168.100.2 (The DHCP Server sent a DHCPNACK message).
but it retries automatically and connects just fine. Not sure why my router gives it an issue on first boot... perhaps it's not releasing properly on shutdown?
Anyway, that's just the 2nd nic, which as I said is not usually used by clients. But should I force Pervasive to just use one nic?
Aside from this after reboot, there are no system event errors or warnings or notices for a week (the 13th).
RE: 8.7 sp3 server dies with no clear reason
Many thanks!
James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
Member of the Project Management Institute® (PMI – Montreal) (PMBOK® Guide)
Member of Microsoft® Project User Group (MPUG – Montreal)
RE: 8.7 sp3 server dies with no clear reason
RE: 8.7 sp3 server dies with no clear reason
I don't see anything in the settings that could cause this.
How long have these crashes been happening (days, weeks, months,etc)?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
Since it's not every time, for example MRP is set to run 4 times during the work day, it's not anything specific MRP is doing that's causing this.
It feels like it's a simultaneous accessing of the database through multiple sources. For example, we use NetVault 8 to backup our data (pretty much a copy operation of the contents of the server's "E:" drive which contains the data files and ddf's for Max). It's pretty quick, under a half an hour to save it to tape, and it runs at night.
Similarly we have MRP running at night (takes about 15 minutes) and we have reports that are run from CRD (a program scheduling crystal reports).
It seems that something happens at night, as all this week I came in to Max being down and this error to be the cause.
That's not last week -- last week the problem seemed more random, but still somehow connected to MRP, as it happened once or twice a day and MRP was set to run each time.
I've now configured CRD to NOT be running at all when MRP is scheduled, but that hasn't stopped it. Also, the backups are set to run hours after MRP is, so I'm not sure that's the issue.
MRP runs 3am, 9am, noon, and 2pm. The backup for Max runs at 9pm.
We have only one report that runs nightly with CRD, and it takes literally 20 seconds to do so.
CRD runs on a client computer (named deploy) and NetVault server is on a different server (named bebe).
So, I really don't see how all these can conflict at night or why. The backups have been successful, but NetVault wouldn't care about the status of Pervasive since it's just copying files.
Could it be a listening issue? Is having 2 NICs troublesome for pervasive? With only 25 clients, I think one gigabit nic can handle the traffic, and the clients refer to max by netbios name instead of ip. The clients refer to max by the ip of only one nic when they ping Max or use \\max
the 2nd nic we use for servicing etc. I should dedicate reports to use the 2nd nic through odbc referring to an ip address instead of a name when I configure the DSN but I don't.
Why the hell is this happening and how do I stop it? How do I find out more as to why this is happening?
RE: 8.7 sp3 server dies with no clear reason
Thanks!
James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
Member of the Project Management Institute® (PMI – Montreal) (PMBOK® Guide)
Member of Microsoft® Project User Group (MPUG – Montreal)
RE: 8.7 sp3 server dies with no clear reason
James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
Member of the Project Management Institute® (PMI – Montreal) (PMBOK® Guide)
Member of Microsoft® Project User Group (MPUG – Montreal)
RE: 8.7 sp3 server dies with no clear reason
http://www.exactamerica.com/max/
It's version 3.7 (which is old now, but we don't have the ability to upgrade due to costs).
MS patches, hrm.
Damn it! It just happened again. MRP set to run at 2pm.
ARG!!!
I tried restarting the services and still nothing. Rebooting now, DURING THE WORK DAY.
RE: 8.7 sp3 server dies with no clear reason
I just don't get it.
I'll report back when it boots up if there's any history of recent patches from MS from the add/remove programs.
RE: 8.7 sp3 server dies with no clear reason
It's finally died and restarting the server isn't helping. There's no more info in any logs, no other error messages to troubleshoot. It simply fails to connect to itself. I cannot even browse the tables in PCC when it goes down like this. When I restart the services it goes back up and it goes back down again. I think there's a rogue system that's corrupting the tables.
RE: 8.7 sp3 server dies with no clear reason
Are NTDBSMGR.EXE and W3DBSMGR.EXE listed in Task Manager (Processes) on the server?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
RE: 8.7 sp3 server dies with no clear reason
The workstation shows file cannot be opened, while the server shows btrieve error 3012... it's like I don't have the right service pack installed on my server, but I'm sure I do!
It's 8.7 sp3... how do I verify?
RE: 8.7 sp3 server dies with no clear reason
RE: 8.7 sp3 server dies with no clear reason
What the 3012 from the Pervasive tools? If not, what did they report? A 3012, means the engine is not accessible. It's either not running or there isn't one installed. Are NTDBSMGR.EXE and W3SQLMGR.EXE running?
> It's 8.7 sp3... how do I verify?
Check the version of NTDBSMGR.EXE, W3DBSMGR.EXE, W3ODBCEI.DLL and on the client W3ODBCCI.DLL.
They should be versioned as 8.70.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
PCC lets me in just fine when I use it on the server and when I use it on the workstation in question. The DSN checks out.
When I try to run a crystal report tho, it fails.
When I try to run it on the server, it fails with that 3012 error. -- more on this, PCC on the server doesn't show the MAXDAT DSN in the clients (the clients is pretty empty) but the client is configured to use the server engine first..
When I try to run it on the workstation in question, it fails with error 171... I don't ever set user/pass in crystal.. why is this happening?
RE: 8.7 sp3 server dies with no clear reason
As for the server, I'm thinking it's a configuration issue with the pervasive client settings... please review and let me know why crystal would fail with 3012:
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Btrieve Requester\Version 8\Settings]
"Splash Screen"="Yes"
"Embedded Spaces"="no"
"Verify Key Length"="yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Communications Requester\Version 8\Settings]
"TCP connect timeout"=dword:0000000f
"Supported protocols"="TCPIP"
"Runtime server"="Yes"
"Enable AutoReconnect"="No"
"Max Multiple Connections"=dword:00000000
"Log Statistics"="No"
"NumSatEntries"=dword:00000001
"SatEntry0"="Max,0,4,3,1,0"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Menu]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}\Namespace\{140B1898-B47A-11D3-9194-00A024C8C314}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Pervasive.SQL BCP]
"ExternalTools"=hex(7):4c,00,69,00,63,00,65,00,6e,00,73,00,65,00,20,00,41,00,\
64,00,6d,00,69,00,6e,00,69,00,73,00,74,00,72,00,61,00,74,00,6f,00,72,00,00,\
00,43,00,3a,00,5c,00,50,00,56,00,53,00,57,00,5c,00,42,00,49,00,4e,00,5c,00,\
47,00,55,00,49,00,4c,00,43,00,41,00,44,00,4d,00,2e,00,45,00,58,00,45,00,00,\
00,2f,00,73,00,00,00,52,00,65,00,62,00,75,00,69,00,6c,00,64,00,00,00,43,00,\
3a,00,5c,00,50,00,56,00,53,00,57,00,5c,00,42,00,49,00,4e,00,5c,00,52,00,42,\
00,4c,00,44,00,47,00,55,00,49,00,2e,00,45,00,58,00,45,00,00,00,00,00,4d,00,\
6f,00,6e,00,69,00,74,00,6f,00,72,00,00,00,43,00,3a,00,5c,00,50,00,56,00,53,\
00,57,00,5c,00,42,00,49,00,4e,00,5c,00,57,00,33,00,4d,00,4f,00,4e,00,56,00,\
37,00,35,00,2e,00,45,00,58,00,45,00,00,00,00,00,4d,00,61,00,69,00,6e,00,74,\
00,65,00,6e,00,61,00,6e,00,63,00,65,00,00,00,43,00,3a,00,5c,00,50,00,56,00,\
53,00,57,00,5c,00,42,00,49,00,4e,00,5c,00,57,00,33,00,32,00,4d,00,41,00,49,\
00,4e,00,54,00,2e,00,45,00,58,00,45,00,00,00,00,00,46,00,75,00,6e,00,63,00,\
74,00,69,00,6f,00,6e,00,20,00,45,00,78,00,65,00,63,00,75,00,74,00,6f,00,72,\
00,00,00,43,00,3a,00,5c,00,50,00,56,00,53,00,57,00,5c,00,42,00,49,00,4e,00,\
5c,00,57,00,42,00,45,00,58,00,45,00,43,00,33,00,32,00,2e,00,45,00,58,00,45,\
00,00,00,00,00,00,00
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}]
@="Pervasive Config ECP"
"Name"="Pervasive.SQL Configuration"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{140B1898-B47A-11D3-9194-00A024C8C314}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}]
@="Pervasive.SQL BCP"
"Name"="Pervasive.SQL Base Content Provider"
"BaseProvider"=dword:00000001
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{A3896D81-BDF8-11d3-BC90-00104B12EF1F}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Control Center\2.0\Providers\{8CDB7CF7-8206-484A-A3FB-CE42CFEFDD8B}\Extendable\{C1273D0E-92A5-4242-BDAB-E945472D13C2}]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Database Names\Version 8\Settings]
"DBNamesDirectory"="C:\\WINNT"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Microkernel Router\Version 8\Settings]
"Local"="yes"
"Requester"="yes"
"Use IDS"="no"
"IDS Username"="<None>"
"IDS Password"="<None>"
"Compress IDS Data"="no"
"Gateway Durability"="no"
"Use Cache Engine"="no"
"Load Retries"=dword:00000005
"Target Engine"=dword:00000000
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8\Settings]
"Balanced Trees"="NO"
"File Version"="0800"
"System Data"="YES"
"Max MicroKernel Memory Usage"=dword:0000003c
"Logging"="NO"
"Cache Size"=dword:0006664c
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:00000040
"Transaction Durability"="NO"
"Transaction Log Buffer Size"=dword:00000400
"Transaction Log File Size"=dword:00000800
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Transaction Logging"="YES"
"Background Threads"=dword:00000020
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"Validate Request"="NO"
"Max Pending IO"=dword:00000800
"File Growth Factor"=dword:0000000f
"Page Server Allow Client Cache"="YES"
"Prompt For Client Credentials"="NO"
"Allow Client-Stored Credentials"="YES"
"Enable Watchdog"="YES"
"System Cache"="NO"
"Preallocate"="NO"
"Minimal States"="NO"
"Minimal States Delay"=dword:0000012c
"Worker Threads"=dword:00000004
"Max Remote Communications Buffer Size"=dword:00000040
"Remote Read Buffer Size"=dword:00000004
"Remote Worker Threads"=dword:00000010
"Remote Sessions Enabled"="YES"
"Supported Protocols"=hex(7):54,00,43,00,50,00,2f,00,49,00,50,00,00,00,00,00
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="YES"
"Listen IP Address"="0.0.0.0"
"Home Directory"="C:\\PVSW\\BIN"
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8\Settings\Hook Modules]
"0"="c:\\pvsw\\bin\\cnstring.dll"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 8\Settings\Hook Modules\CNString]
@="0"
"Description"="Connection String Hook Module for remote DB Names"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Workgroup Engine]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Workgroup Engine\Version 8]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Workgroup Engine\Version 8\Settings]
"Balanced Trees"="NO"
"File Version"="0800"
"System Data"="YES"
"Max MicroKernel Memory Usage"=dword:0000003c
"Logging"="NO"
"Cache Size"=dword:00008000
"Merge Sort Buffer Size"=dword:00000000
"Max Communication Buffer Size"=dword:00000040
"Transaction Durability"="NO"
"Transaction Logging"="YES"
"Transaction Log Buffer Size"=dword:00000400
"Transaction Log File Size"=dword:00000800
"Systrans Bundle Limit"=dword:0000ffff
"Systrans Time Limit"=dword:00002710
"Background Threads"=dword:00000020
"Wait-lock Timeout"=dword:0000000f
"Transaction Log Directory"="C:\\PVSW\\BIN\\MKDE\\LOG"
"Work Space"=""
"Trace"="NO"
"Trace File"="C:\\PVSW\\BIN\\MKDE.TRA"
"Trace Databuf Len"=dword:00000080
"Trace Keybuf Len"=dword:00000080
"Trace Ops"="ALL"
"Prompt For Client Credentials"="NO"
"Allow Client-Stored Credentials"="YES"
"System Cache"="YES"
"Preallocate"="NO"
"Worker Threads"=dword:00000004
"Max Remote Communications Buffer Size"=dword:00000040
"Remote Read Buffer Size"=dword:00000004
"Remote Worker Threads"=dword:00000010
"Remote Sessions Enabled"="YES"
"Supported Protocols"=hex(7):53,00,50,00,58,00,49,00,49,00,00,00,54,00,43,00,\
50,00,2f,00,49,00,50,00,00,00,4e,00,45,00,54,00,42,00,49,00,4f,00,53,00,00,\
00,00,00
"Home Directory"="C:\\PVSW\\BIN"
"Protocol Init Timeout"=dword:0000003c
"TCPIP Multi-Homed"="YES"
"Listen IP Address"="0.0.0.0"
"Enable AutoReconnect"="NO"
"AutoReconnect Timeout"="180"
"Validate Request"="NO"
"Max Pending IO"=dword:00000800
"File Growth Factor"=dword:0000000f
"Enable Watchdog"="YES"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MKC]
"UseDelayedSyncClose"="YES"
"SyncCloseDelay(msecs)"="50"
"ThreadsPerConnection"="10"
"UseDelayedSyncCloseForRI"="YES"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 8.70]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Monitor Utility\Version 8.70\Settings]
"Save Settings"="Yes"
"Refresh Rate"=dword:00000004
"MKDE Resource Usage Window AutoRefresh"="Yes"
"MKDE Communication Statistics Window AutoRefresh"="Yes"
"MKDE Active Files Window AutoRefresh"="Yes"
"MKDE Active Users Window AutoRefresh"="Yes"
"SQL Connection Manager Window AutoRefresh"="Yes"
"Save Layout"="Yes"
"Main Window X"=dword:00000068
"Main Window Y"=dword:0000007f
"Main Window Width"=dword:00000300
"Main Window Height"=dword:00000219
"Show MKDE Resource Usage Window"="No"
"Show MKDE Communication Statistics Window"="No"
"Show MKDE Active Files Window"="Yes"
"Show MKDE Active Users Window"="Yes"
"Show SQL Connection Manager Window"="No"
"MKDE Active Files Window X Coordinate"=dword:000000d4
"MKDE Active Files Window Y Coordinate"=dword:000000c3
"MKDE Active Files Window Width"=dword:00000257
"MKDE Active Files Window Height"=dword:00000179
"MKDE Active Users Window X Coordinate"=dword:000000d5
"MKDE Active Users Window Y Coordinate"=dword:000000b7
"MKDE Active Users Window Width"=dword:00000256
"MKDE Active Users Window Height"=dword:00000191
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer\8.0]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer\8.6]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Pervasive System Analyzer\8.7]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive System Analyzer]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive System Analyzer\InstallInfo]
"InstallDir"="C:\\Program Files\\Common Files\\Pervasive Software Shared\\PSA"
"VersionLevel"="8.7"
"PatchLevel"="3"
"BuildLevel"="014"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL NT Server]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Pervasive.SQL NT Server\InstallInfo]
"InstallDir"="C:\\PVSW"
"SystemDir"="C:\\WINNT\\system32"
"InstallIniName"="PTKSETUP.INI"
"VersionLevel"="8.70"
"PatchLevel"="3"
"BuildLevel"="014"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Products\Temp]
"InstallDir"="C:\\PVSW\\"
"SystemDir"="C:\\WINNT\\system32\\"
"SupportDir"="C:\\DOCUME~1\\smalcolm\\LOCALS~1\\Temp\\1\\{5CA60F17-0BFA-4854-906C-5A6D31B7199A}"
"Engine"="NTSVR"
"SetupDir"="C:\\kjtemp\\Pervasive.SQL_8.6_complete_Windows"
"CommonDir"="C:\\Program Files\\Common Files\\"
"UILevel"="5"
"WindowsDir"="C:\\WINNT\\"
"myarpcomments"=""
"CommonFilesDir"="C:\\Program Files\\Common Files\\"
"ServicesStart"="Automatic"
"StartMenuDir"="C:\\Documents and Settings\\All Users\\Start Menu\\Programs\\"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Security]
"Wire Encryption"="IF NEEDED"
"Wire Encryption Level"="2"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\Processes]
"W3ODBCEI"="2001"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Connection Manager\SERVER.INI\SQLManager]
"LogEvent"="1"
"MgrPort"="1583"
"MgrSPXPort"="29320"
"MgrMaxConnections"="2001"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\SQL Relational Engine]
"CurrentDateBasedDSTConversion"="NO"
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Utilities Interface]
[HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Utilities Interface\Settings]
"Restricted Access On WTS client"=dword:00000000
RE: 8.7 sp3 server dies with no clear reason
I tried reinstalling the pervasive 8.7sp3 client and when it got to the analyzer, I had it run all tests. The transactional tests fail 171. This is on a reinstall! I have that analyzer still open now and I just confirmed that Pervasive SQL Data Manager still lets me read and write data just fine.
What am I missing? My computer and user can read/write data to the max share just fine too, so it's not a file system permissions thing...
RE: 8.7 sp3 server dies with no clear reason
Not sure if this is supposed to be set to "YES"
Why not delete the Crystal ODBC DSN; reboot the server; and create the Crystal ODBC DSN again. It appears that the network setup is the primary concern.
From my Business Decisions notes, I recall that we should reboot a server after creating any ODBC connections (read olde school!!) for Crystal Reports.
Surgite!
James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
Member of the Project Management Institute® (PMI – Montreal) (PMBOK® Guide)
Member of Microsoft® Project User Group (MPUG – Montreal)
RE: 8.7 sp3 server dies with no clear reason
C:\PVSW\BIN\W3DBSMGR.EXE –SRDE
Thanks!
James Keep, PMP
Crystal Reports(tm) Certified Consultant 8.5 (CRCC)
Authorized Crystal Engineer (ACE)
Member of the Project Management Institute® (PMI – Montreal) (PMBOK® Guide)
Member of Microsoft® Project User Group (MPUG – Montreal)
RE: 8.7 sp3 server dies with no clear reason
Besides, most other clients in the office are fine, I'm trying to troubleshoot this one.
I'm sure it's to do with this issue of ddf... I tried creating a new crystal report and accessing the ddf directly, and I got an error 171 then it prompted me for an Access password. This may be due to crystal thinking it's an Access db file I'm trying to open after the error 171.
Either way, how do I solve? I've now reinstalled both the pervasive client and the Max client on this computer, so it's not that..
RE: 8.7 sp3 server dies with no clear reason
gives me error 8520 timeout.
RE: 8.7 sp3 server dies with no clear reason
THe only thing I know of that causes a 171 when security is not enabled is a virus. I've seen where the IPC$ share was deleted and PSQL returned a status 171.
Just to confirm, on the machine getting the 171 from Crystal, you can use the PCC to access data. Can you use the Pervasive Function Executor to open a Btrieve file on the server?
In Crystal, are using UNC or a drive letter to connect to the PSQL files? WHat happens if you create a Client DSN on the client workstation pointing to the server's Engine DSN and then use the DSN in Crystal (and use ODBC rather than the direct Btrieve drivers)?
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
I have the same trouble whether I try unc or a mapped drive letter when using crystal.
Using just ODBC in crystal works fine. Unfortunately the Max client doesn't use ODBC, so it still fails.
RE: 8.7 sp3 server dies with no clear reason
I am running Kaspsersky which is quite good at catching viruses, so I'd be surprised if one got through. Also, I've not made any configuration changes to it in months, so it's not that blocking me...
RE: 8.7 sp3 server dies with no clear reason
AND the Max client now works on the server. So that was a configuration issue there.
Why the heck is it happening on my deploy workstation?
RE: 8.7 sp3 server dies with no clear reason
RE: 8.7 sp3 server dies with no clear reason
RE: 8.7 sp3 server dies with no clear reason
This happens after restarting and re-associating with the domain, etc.
RE: 8.7 sp3 server dies with no clear reason
Use the Function Executor instead. Try to open the FILE.DDF in the MAX data directory. Does it give the 171? What about FILE.DDF in the Pervasive DEMODATA directory on the server.
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
I restarted the transactional service on the server but it didn't seem to help. Same errors, etc.
RE: 8.7 sp3 server dies with no clear reason
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: 8.7 sp3 server dies with no clear reason
In the mean time I've converted all my scheduled reports to run using ODBC and that's working for now.