Here is the knldiag.err reflecting the mentioned error (9111) Benedikt
---------------------------------------------------------------------------- ---- Date Time TID(hex) Typ MsgID Label Message-Text ---------------------------------------------------------------------------- ---- 2003-01-07 10:35:42 --- Starting --- 2003-01-10 10:13:38 0x75C ERR 54111 MOVE VGG04.10: 29[32768]->1[1024] len:-8 2003-01-10 10:13:38 0x75C ERR 51080 SYSERROR -9111 Move error 2003-01-10 10:14:12 0x75C ERR 54111 MOVE VGG04.10: 29[32768]->1[1024] len:-8 2003-01-10 10:14:12 0x75C ERR 51080 SYSERROR -9111 Move error 2003-01-10 10:16:48 0x75C ERR 54111 MOVE VGG04.10: 29[32768]->1[1024] len:-8 2003-01-10 10:16:48 0x75C ERR 51080 SYSERROR -9111 Move error 2003-01-10 10:17:02 0x75C ERR 54111 MOVE VGG04.10: 29[32768]->1[1024] len:-8 2003-01-10 10:17:02 0x75C ERR 51080 SYSERROR -9111 Move error 2003-01-10 10:21:38 0x75C ERR 54111 MOVE VGG04.10: 11[32768]->1[1024] len:-8 2003-01-10 10:21:38 0x75C ERR 51080 SYSERROR -9111 Move error 2003-01-10 10:41:25 0x75C ERR 54111 MOVE VGG04.10: 11[32768]->1[1024] len:-8 2003-01-10 10:41:25 0x75C ERR 51080 SYSERROR -9111 Move error 2003-01-10 10:41:31 0x75C ERR 54111 MOVE VGG04.10: 11[32768]->1[1024] len:-8 2003-01-10 10:41:31 0x75C ERR 51080 SYSERROR -9111 Move error "Benedikt Wismans" <[EMAIL PROTECTED]> schrieb im Newsbeitrag avm4c3$gru$[EMAIL PROTECTED]">news:avm4c3$gru$[EMAIL PROTECTED]... > Dear NG, > > [SAPDB 7.3.0.29/029-000-087-746 on W2K, DateFormat ISO, rest default] > > I get "9111 system error" when executing this statement. Without the > WHERE-clause it runs fine! > > Any hint is welcome. Thank you > > Benedikt Wismans > > > SAP DB:-9111[SAP AG][SQLOD32 DLL][SAP DB]General error;-9111 POS(1) System > error: Move error. > > when executing > > SELECT COUNT( * ) > INTO :nAnzahl > FROM auftrag > WHERE auftrag.auftragsdatum >= :df_DatumVon AND auftrag.auftragsdatum <= > :df_DatumBis > AND auftragid > 0 > AND auftrag.auftragid in > ( > SELECT auftragid > FROM debit > WHERE rechnungid = 0 > ) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
