john doed wrote:
>
> 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
Sorry, it lasted a little bit longer, but here we are:
1. this bug will be fixed starting with 7.4.3.14 (no timeschedule so far)
2. for explaining reasons the select list of your select in another form:
SELECT
AO.op_id,
AO.first_name,
AO.last_name,
D.name AS dept_name,
D.dept_id,
// starting the first scalar and correlated subquery
( SELECT
count(OPFPOW.op_id)
FROM
OPS_FPO_WORKLOAD OPFPOW
WHERE
OPFPOW.op_id=AO.op_id) AS fpo_count,
// end of the first and start of the seconf scalar and correlated subquery
( 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
The problem occurs when more than 1 correlated subquery
is in the select and if at least one of it is a so-called <scalar_subquery>.
Elke
SAP Labs Berlin
> 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\SAPD
> B\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_6595b6
> 4144ccf1df_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
> [EMAIL PROTECTED] + 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
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
