Hi,
One of our developers has been experiencing a strange error. The database can be accessed fine via dbmcli or the DBMGui application but any tool or process using JDBC (via driver rev 19a) hangs without connecting. An attempt at a db_restart showed the following errors:
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\>dbmcli -d ENVOY -u dbm,dbm
dbmcli on ENVOY>db_restart
ERR
-24988,ERR_SQL: sql error
500,Lock request timeout
---
dbmcli on ENVOY>
And this is what was written in the data\wrk\xserver.prt file:
--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2002-04-02 10:44:07 0x578 19705 CONNECT Loading default TCPIP-DLL, ( 'sqltcp.dll')
2002-04-02 10:44:07 0x578 19707 CONNECT WINSOCK: 2.0, SQLTCP-DLL: 7.3.0
2002-04-02 10:44:07 0x578 19751 XSERVER XSERVER started, 'NT/INTEL 7.3.0 Build 015-000-070-423'
============================================ begin of write cycle ==================
2002-04-02 10:44:21 0x4B0 19739 XSERVER 'NELSONJ3' connected to 'ENVOY', T:22
2002-04-02 11:57:17 0x4B0 ERR 18392 CONNECT Socket send error, rc = 10054
2002-04-02 11:57:17 0x4B0 ERR 18651 XSERVER Send packet, Ref:22 - socket send error [10054]
2002-04-02 11:57:17 0x4B0 19740 XSERVER 'NELSONJ3' disconnect from 'ENVOY', T:22
2002-04-02 11:57:17 0x4B0 ERR 18392 CONNECT Socket send error, rc = 10054
-------------------------------------------- current write position ----------------
...and in data\wrk\ENVOY\dbm.prt:
------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message
------------------------------------------------------------------------------
2002-03-12 10:56:34 0x00000374 0 DBM command util_execute init config
2002-03-12 10:56:53 0x00000374 0 DBM command util_activate
2002-03-12 10:56:54 0x00000458 0 DBM command load_systab
2002-03-12 10:57:00 0x00000458 0 DBM command backup_media_put data C:\SapDB\data\ENVOY\datasave FILE DATA 0 8 YES
2002-03-12 10:57:00 0x00000458 0 DBM command backup_media_put auto C:\SapDB\data\ENVOY\autosave FILE AUTO
2002-03-12 10:57:00 0x00000458 0 DBM command backup_save data
2002-03-12 10:57:01 0x00000458 0 DBM command autosave_on
2002-04-02 11:57:16 0x00000550 0 DBM command db_restart
2002-04-02 11:57:17 0x00000550 ERR -24988 DBM ERR_SQL: sql error
0x00000550 ERR -24988 DBM 500,Lock request timeout
I can't find any information on the backup_media_put command in my version of the docs. The data file mentioned above exists but I don't see the autosave file. Don't know if that would have been created automatically or should already exist. In any case, the database is currently unusable for development as we use JDBC for all programmatic access. Any help would be appreciated. I can provide a diagpkg.tgz if needed. Thanks!
ss
Scott Shattuck
SapDB newbie :)
PlanetCAD Inc.
