A single SQL statement that use to work in PostgresQL is forcing a manual
shutdown and restart of the SAP DB (7.4.3.7 Build 007-000-155-373) database.
I get the following error:
Native error: 800
Text: [SAP AG][SQLOD32 DLL][SAP DB]General error;800 Implicit ServerDB
restart (connection arborted).
This is the SQL statement that is causing it. If I remove the area enclosed
in [ ] it will work without crashing. :
SELECT AO.op_id, AO.first_name, AO.last_name, D.name AS dept_name,
D.dept_id, (SELECT count(OPFPOW.op_id) FROM OPS_FPO_WORKLOAD OPFPOW WHERE
OPFPOW.op_id=AO.op_id) AS fpo_count, [(SELECT OM.msg_queue FROM OP_MESSAGING
OM WHERE OM.sender_op_id=AO.op_id AND OM.receiver_op_id=1) AS op_msg_queue]
FROM ACCOUNTS_OPS AO, OPS_ONLINE OO, DEPARTMENTS D, DEPARTMENTS_ROSTER DR
WHERE AO.master_id=1 AND AO.op_id<>1 AND AO.op_id=OO.op_id AND
AO.op_id=DR.op_id AND DR.dept_id=D.dept_id ORDER BY D.name ASC
After getting the error above. ANY attempt to work with the database gives:
-807 Connection down, session released (SQL Studio
-708 SERVERDB system not available (JDBC)
I have to shutdown and restart manually to work with the database again.
Please let me know if you have any near-term solution for this. If not I
guess I will have to do a work around somehow. Thanks
Here is the knldiag.err:
--------------------------------------------------------------------------------
Date Time TID(hex) Typ MsgID Label Message-Text
--------------------------------------------------------------------------------
2003-01-11 22:51:19 --- Starting GMT
2003-01-11 22:51:19 7.4.3 Build 007-000-155-373
2003-01-11 22:52:11 0x888 ERR 18006 EXCEPT EXCEPTION:0xc0000094
Addr:0x5744cc ( 0:0:0:0 )
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SymbolSearchPath:
c:\apps\coding\sapdb\indep_data\wrk\DPCHUB;C:\APPS\CODING\SAPDB\DEPEND\pgm;C:\APPS\CODING\SAPDB\
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
DEPEND\symbols;C:\APPS\CODING\SAPDB\DEPEND\sap;C:\WINDOWS
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE ----> Register Dump <----
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Eax=0x00002710
Ebx=0x0399e240 Ecx=0x7fac2978 Edx=0x00000000 Esi=0x0398c728 Edi=0x00000000
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Eip=0x005744cc
Esp=0x0398bef4 Ebp=0x0398bfcc
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Cs=0x001b Ss=0x0023
Ds=0x0023 Es=0x0023 Fs=0x0038 Gs=0x0000 Efl=0x10a12
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE ----> Module List <----
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE |.text Start |.text End
| Module File Name
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x00400000 | 0x008d8000
| C:\APPS\CODING\SAPDB\DEPEND\pgm\kernel.exe
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x10000000 | 0x10059000
| C:\APPS\CODING\SAPDB\DEPEND\pgm\liboms.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x6d510000 | 0x6d58c000
| C:\WINDOWS\system32\DBGHELP.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x71950000 | 0x71a34000
|
C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.0.0_x-ww_1
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE |
382d70a\comctl32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x71aa0000 | 0x71aa8000
| C:\WINDOWS\system32\WS2HELP.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x71ab0000 | 0x71ac5000
| C:\WINDOWS\system32\WS2_32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x76000000 | 0x76009000
| c:\apps\coding\sapdb\indep_prog\pgm\sqltcp.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x76c90000 | 0x76cb2000
| C:\WINDOWS\system32\imagehlp.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x76f20000 | 0x76f45000
| C:\WINDOWS\system32\DNSAPI.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x76f90000 | 0x76fa0000
| C:\WINDOWS\system32\Secur32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x76fc0000 | 0x76fc5000
| C:\WINDOWS\system32\rasadhlp.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x771b0000 | 0x772ca000
| C:\WINDOWS\system32\ole32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x772d0000 | 0x77333000
| C:\WINDOWS\system32\SHLWAPI.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77340000 | 0x773cb000
| C:\WINDOWS\system32\comctl32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x773d0000 | 0x77bc4000
| C:\WINDOWS\system32\SHELL32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77c00000 | 0x77c07000
| C:\WINDOWS\system32\VERSION.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77c10000 | 0x77c63000
| C:\WINDOWS\system32\msvcrt.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77c70000 | 0x77cb0000
| C:\WINDOWS\system32\GDI32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77cc0000 | 0x77d35000
| C:\WINDOWS\system32\RPCRT4.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77d40000 | 0x77dc6000
| C:\WINDOWS\system32\USER32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77dd0000 | 0x77e5b000
| C:\WINDOWS\system32\ADVAPI32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77e60000 | 0x77f45000
| C:\WINDOWS\system32\kernel32.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE | 0x77f50000 | 0x77ff9000
| C:\WINDOWS\System32\ntdll.dll
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE ----> Stack Back Trace
<----
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a67_sel3_second_part + 556 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:005744cc
RA:00573e25 FP:0398bfcc SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399e240
02:0398c728 03:0398c2d4 04:0398c6fc
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a67_s_sel_second_part + 245 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:00573e25
RA:0058e222 FP:0398bff0 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399e240
02:0398c728 03:0098c2d4 04:0398c6fc
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a660_query_execute + 5810 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0058e222
RA:0059cad7 FP:0398c36c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399e240
02:0398c728 03:00000020 04:00000000
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak661a_corr_subquery + 167 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0059cad7
RA:0059d631 FP:0398c44c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:0398c728 03:0398c560 04:0398c6fc
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak661s_corr_start + 449 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0059d631
RA:0059e218 FP:0398c490 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:00000000
02:0398c73c 03:0398c560 04:0398c6fc
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel!_a661a_subquery +
200 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0059e218
RA:00588dc9 FP:0398c56c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:0398c728 03:0398c6fc 04:00000001
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel!_ak660subquery +
393 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:00588dc9
RA:0058fd68 FP:0398c6cc SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0199e240
02:0398c728 03:0398c6fc 04:00000001
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel!_a660select + 344
bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0058fd68
RA:0058f8a0 FP:0398c704 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399e240
02:01000001 03:0398c728 04:0399da7a
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel!_a660_select +
768 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0058f8a0
RA:004b6ede FP:0399da7c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:00000001 03:00000000 04:0399e240
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak35call_semantik + 1278 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:004b6ede
RA:004b581f FP:0399dab4 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:00000000 03:00000000 04:0399e240
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a35_asql_statement + 3823 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:004b581f
RA:00565e35 FP:0399db08 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:003f01c8 03:00000000 04:0399e240
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak92not_only_execute + 1157 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:00565e35
RA:00566781 FP:0399dbb8 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:0299dcd0 03:0399dcca 04:0399dca8
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak92analyze_messagetype + 1105 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:00566781
RA:00567297 FP:0399dcd4 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399e240
02:00000000 03:00000000 04:00000000
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a92_mode_analyzer + 215 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:00567297
RA:0057b74e FP:0399dd1c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399e240
02:00000000 03:00000000 04:00000000
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel!_ak93one_command
+ 958 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0057b74e
RA:0057a7da FP:0399dd80 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0199e240
02:00000001 03:003f01c8 04:00000001
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a93_user_commands + 762 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0057a7da
RA:004382a5 FP:0399de0c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:0399e22f 03:0399e23b 04:0399ff1c
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak91run_sql_process + 85 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:004382a5
RA:004383ab FP:0399e230 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0099e240
02:0399ff1c 03:003f01a8 04:003f05f0
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_ak91run_user_process + 219 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:004383ab
RA:0043843d FP:0399f7c0 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399ff1c
02:00000003 03:0399ff1c 04:0399ff04
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_a91mainprogam_with_allocator + 61 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:0043843d
RA:006aafdc FP:0399f7d4 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399ff03
02:7fec1698 03:7fec1698 04:007b466c
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_gg941CreateAllocatorAndCallMainprog + 124 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:006aafdc
RA:004383e8 FP:0399ff04 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:0399ff03
02:0399ff64 03:0000000c 04:0399ff1c
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel!_a91mainprogram +
40 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:004383e8
RA:006ffc3f FP:0399ff7c SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:7fec1698
02:7fee72a0 03:7fee72a0 04:039a0000
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE
kernel!_sql88k_kernel_fiber@4 + 191 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:006ffc3f
RA:77e802ed FP:0399ffb4 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:7fee72a0
02:7fec1698 03:7fee72a0 04:7fee72a0
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel32!OpenConsoleW +
184 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:77e802ed
RA:77e997df FP:0399ffec SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:006ffb80
02:7fee72a0 03:00000000 04:6d52c1a0
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE kernel32!CreateFiberEx +
178 bytes
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:77e997df
RA:03990033 FP:0399fee8 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:006d710d
02:7fee72a0 03:00000101 04:7fee72a0
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SymGetModuleInfo()
failed, rc = 126
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE ?!03990033 <nosymbols>
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SFrame: IP:03990033
RA:00000000 FP:31305420 SP:0398bef4
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE Params: 01:00000000
02:00000000 03:00000000 04:00000000
2003-01-11 22:52:11 0x888 ERR 19999 BTRACE SymGetLineFromAddr()
failed, rc = 126
2003-01-11 22:52:11 0x888 ERR 20000 INFO No crash dump file
'knlcrash.dmp' written
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*
http://join.msn.com/?page=features/virus
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
