on 01-25-2008 4:29 PM
Hi I'm Getting this Dump
Runtime Errors DBIF_RSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
Date and Time 01/25/2008 05:30:05
-
-
Short text |
SQL error in the database when accessing a table. |
-
-
What can you do? |
Note which actions and input led to the error. |
For further help in handling the problem, contact your SAP administrator |
. |
You can use the ABAP dump analysis transaction ST22 to view and manage |
termination messages, in particular for long term reference. |
-
-
How to correct the error |
Database error text........: "POS(4477) Too complicated SQL statement (too much |
data)" |
Internal call code.........: "[RSQL/OPEN/ZBBP_CONF_VIEW ]" |
Please check the entries in the system log (Transaction SM21). |
If the error occures in a non-modified SAP program, you may be able to |
find an interim solution in an SAP Note. |
If you have access to SAP Notes, carry out a search with the following |
keywords: |
"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB" |
"SAPLZ3P_CLC_FG01" or "LZ3P_CLC_FG01U01" |
"Z3P_CLC_CONFIRMATION_DETAILS" |
If you cannot solve the problem yourself and want to send an error |
notification to SAP, include the following information: |
1. The description of the current problem (short dump) |
To save the description, choose "System->List->Save->Local File |
(Unconverted)". |
2. Corresponding system log |
Display the system log by calling transaction SM21. |
Restrict the time interval to 10 minutes before and five minutes |
after the short dump. Then choose "System->List->Save->Local File |
(Unconverted)". |
3. If the problem occurs in a problem of your own or a modified SAP |
program: The source code of the program |
In the editor, choose "Utilities->More |
Utilities->Upload/Download->Download". |
4. Details about the conditions under which the error occurred or which |
actions and input led to the error. |
The exception must either be prevented, caught within proedure |
"Z3P_CLC_CONFIRMATION_DETAILS" "(FUNCTION)", or its possible occurrence must be |
declared in the |
RAISING clause of the procedure. |
To prevent the exception, note the following: |
-
-
System environment |
SAP-Release 700 |
Application server... "pwdf1918" |
Network address...... "10.17.99.25" |
Operating system..... "Windows NT" |
Release.............. "5.2" |
Hardware type........ "4x AMD64 Level" |
Character length.... 16 Bits |
Pointer length....... 64 Bits |
Work process number.. 1 |
Shortdump setting.... "full" |
Database server... "pwdf4324" |
Database type..... "ADABAS D" |
Database name..... "IBP" |
Database user ID.. "SAPR3" |
Char.set.... "C" |
SAP kernel....... 700 |
created (date)... "Oct 1 2007 00:34:30" |
create on........ "NT 5.2 3790 Service Pack 1 x86 MS VC++ 14.00" |
Database version. "SQLDBC 7.6.1.015 CL 147649 " |
Patch level. 130 |
Patch text.. " " |
Database............. "MaxDB 7.6, MaxDB 7.7" |
SAP database version. 700 |
Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows |
NT 6.0" |
Memory consumption |
Roll.... 16192 |
EM...... 4189840 |
Heap.... 0 |
Page.... 0 |
MM Used. 1496416 |
MM Free. 2690800 |
-
-
User and Transaction |
Client.............. 001 |
User................ "EBP_ISP" |
Language Key........ "E" |
Transaction......... " " |
Transactions ID..... "FCF9CADCE4F4F16DB8ED0017A44BD489" |
Program............. "SAPLZ3P_CLC_FG01" |
Screen.............. "SAPMSSY1 3004" |
Screen Line......... 2 |
Information on caller of Remote Function Call (RFC): |
System.............. "ISP" |
Database Release.... 700 |
Kernel Release...... 700 |
Connection Type..... 3 (2=R/2, 3=ABAP System, E=Ext., R=Reg. Ext.) |
Call Type........... "synchron and non-transactional (emode 0, imode 0)" |
Inbound TID.........." " |
Inbound Queue Name..." " |
Outbound TID........." " |
Outbound Queue Name.." " |
Client.............. 001 |
User................ "I802084" |
Transaction......... "SE38" |
Call Program........."Z3P_CLC_MAIN01" |
Function Module..... "Z3P_CLC_CONFIRMATION_DETAILS" |
Call Destination.... "EBP_IBPCLNT001" |
Source Server....... "pwdf4106_ISP_33" |
Source IP Address... "10.21.24.140" |
Additional information on RFC logon: |
Trusted Relationship " " |
Logon Return Code... 0 |
Trusted Return Code. 0 |
Note: For releases < 4.0, information on the RFC caller are often |
only partially available. |
-
-
Information on where terminated |
Termination occurred in the ABAP program "SAPLZ3P_CLC_FG01" - in |
"Z3P_CLC_CONFIRMATION_DETAILS". |
The main program was "SAPMSSY1 ". |
In the source code you have the termination point in line 410 |
of the (Include) program "LZ3P_CLC_FG01U01". |
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in |
procedure "Z3P_CLC_CONFIRMATION_DETAILS" "(FUNCTION)", but it was neither |
handled locally nor declared |
in the RAISING clause of its signature. |
The procedure is in program "SAPLZ3P_CLC_FG01 "; its source code begins in line |
307 of the (Include program "LZ3P_CLC_FG01U01 ". |
-
-
Source Code Extract |
-
Line | SourceCde |
-
380 | END OF TAB1 . |
381 | DATA DAT1 TYPE STANDARD TABLE OF ZBBP_WF_STRUC WITH HEADER LINE . |
382 | DATA OUT_DATES2 TYPE STANDARD TABLE OF Z3P_STR03 WITH HEADER LINE . |
383 | |
384 | DATA : TAB2 LIKE TAB1 OCCURS 10 WITH HEADER LINE. |
385 | DATA : TAB3 LIKE TAB1 OCCURS 10 WITH HEADER LINE. |
386 | |
387 | RANGES : REF_DOC FOR BBPD_PD_INDEX_H-REF_DOC_NO. |
388 | |
389 | CHECK NOT IN_TAB IS INITIAL. |
390 | *Appending the range |
391 | LOOP AT IN_TAB INTO WA_IN. |
392 | *out_dates-dedat = '19791003'. |
393 | *Append out_dates. |
394 | * |
395 | CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' |
396 | EXPORTING |
397 | INPUT = WA_IN-CONFIRMATION |
398 | IMPORTING |
399 | OUTPUT = WA_IN-CONFIRMATION |
400 | . |
401 | |
402 | REF_DOC-SIGN = 'I'. |
403 | REF_DOC-LOW(10) = WA_IN-CONFIRMATION. |
404 | REF_DOC-OPTION = 'EQ'. |
405 | APPEND REF_DOC. |
406 | ENDLOOP. |
407 | |
408 | *Select Query |
409 | |
>>>>> | SELECT REF_DOC_NO itm_vper_start Z_VPER_START Z_VPER_END itm_product_type zexpensetype zinvo |
411 | OBJECT_TYPE |
412 | OBJECT_ID |
413 | V~GUID |
414 | FROM zbbp_conf_view AS v " |
415 | LEFT OUTER JOIN bbp_pdisc AS b |
416 | ON vclient = bclient |
417 | AND vitm_guid = bguid |
418 | INTO CORRESPONDING FIELDS OF TABLE TAB1 |
419 | WHERE |
420 | object_type = 'BUS2203' |
421 | AND |
422 | itm_itm_type ne 'HIER' |
423 | and |
424 | ref_doc_no IN REF_DOC. |
425 | |
426 | *LOOP AT REF_DOC. |
427 | *SELECT REF_DOC_NO itm_vper_start Z_VPER_START Z_VPER_END itm_product_type zexpensetype zinv |
428 | *OBJECT_TYPE |
429 | *OBJECT_ID |
-
-
Contents of system fields |
-
Name | Val. |
-
SY-SUBRC | 0 |
SY-INDEX | 1 |
SY-TABIX | 0 |
SY-DBCNT | 0 |
SY-FDPOS | 0 |
SY-LSIND | 0 |
SY-PAGNO | 0 |
SY-LINNO | 1 |
SY-COLNO | 1 |
SY-PFKEY | |
SY-UCOMM | |
SY-TITLE | CPIC and RFC Control |
SY-MSGTY | |
SY-MSGID | |
SY-MSGNO | 000 |
SY-MSGV1 | |
SY-MSGV2 | |
SY-MSGV3 | |
SY-MSGV4 | |
SY-MODNO | 0 |
SY-DATUM | 20080125 |
SY-UZEIT | 053005 |
SY-XPROG | SAPLZ3P_CLC_FG01 |
SY-XFORM | Z3P_CLC_CONFIRMATION_DETAILS |
-
-
Active Calls/Events |
-
No. Ty. Program Include Line |
Name |
-
4 FUNCTION SAPLZ3P_CLC_FG01 LZ3P_CLC_FG01U01 410 |
Z3P_CLC_CONFIRMATION_DETAILS |
3 FORM SAPLZ3P_CLC_FG01 LZ3P_CLC_FG01U01 307 |
Z3P_CLC_CONFIRMATION_DETAILS |
2 FORM SAPMSSY1 SAPMSSY1 85 |
REMOTE_FUNCTION_CALL |
1 MODULE (PBO) SAPMSSY1 SAPMSSY1 30 |
%_RFC_START |
-
-
Chosen variables |
-
Name |
Val. |
-
No. 4 Ty. FUNCTION |
Name Z3P_CLC_CONFIRMATION_DETAILS |
-
IN_TAB[] |
Table IT_0[1019x146] |
\FUNCTION-POOL=Z3P_CLC_FG01\FORM=Z3P_CLC_CONFIRMATION_DETAILS\DATA=%_%_IN_TAB |
Table reference: 0 |
TABH+ 0(20) = 70292557FE07000070252557FE07000000000000 |
TABH+ 20(20) = 0000000000000000FB03000092000000FFFFFFFF |
TABH+ 40(16) = 04010000E003000010000000C1248101 |
store = 0x70292557FE070000 |
ext1 = 0x70252557FE070000 |
shmId = 0 (0x00000000) |
id = 0 (0x00000000) |
label = 0 (0x00000000) |
fill = 1019 (0xFB030000) |
leng = 146 (0x92000000) |
loop = -1 (0xFFFFFFFF) |
xtyp = TYPE#000006 |
occu = 16 (0x10000000) |
access = 1 (ItAccessStandard) |
idxKind = 0 (ItIndexNone) |
uniKind = 2 (ItUniqueNon) |
keyKind = 1 (default) |
cmpMode = 2 (cmpSingleMcmpR) |
occu0 = 1 |
groupCntl = 0 |
rfc = 1 |
unShareable = 0 |
mightBeShared = 0 |
sharedWithShmTab = 0 |
isShmLockId = 0 |
gcKind = 0 |
isUsed = 1 |
isCtfyAble = 1 |
>>>>> Shareable Table Header Data <<<<< |
tabi = 0xC0493757FE070000 |
pgHook = 0xB08C3957FE070000 |
idxPtr = 0x0000000000000000 |
shmTabhSet = 0x0000000000000000 |
id = 4 (0x04000000) |
refCount = 0 (0x00000000) |
tstRefCount = 0 (0x00000000) |
lineAdmin = 2032 (0xF0070000) |
lineAlloc = 1072 (0x30040000) |
shmVersId = 0 (0x00000000) |
shmRefCount = 1 (0x01000000) |
>>>>> 1st level extension part <<<<< |
regHook = 0x0000000000000000 |
collHook = 0x0000000000000000 |
ext2 = 0x00252557FE070000 |
>>>>> 2nd level extension part <<<<< |
tabhBack = 0xA0242557FE070000 |
delta_head = 0100000001000000CE0000000100000004010000100400009200000001000000000000000500000 |
pb_func = 0x0000000000000000 |
pb_handle = 0x0000000000000000 |
OUT_DATES[] |
Table IT_1[0x54] |
\FUNCTION-POOL=Z3P_CLC_FG01\FORM=Z3P_CLC_CONFIRMATION_DETAILS\DATA=%_%_OUT_DATES |
Table reference: 1 |
TABH+ 0(20) = 000000000000000000533757FE07000000000000 |
TABH+ 20(20) = 01000000010000000000000036000000FFFFFFFF |
TABH+ 40(16) = 04010000A004000010000000C1248101 |
store = 0x0000000000000000 |
ext1 = 0x00533757FE070000 |
shmId = 0 (0x00000000) |
id = 1 (0x01000000) |
label = 1 (0x01000000) |
fill = 0 (0x00000000) |
leng = 54 (0x36000000) |
loop = -1 (0xFFFFFFFF) |
xtyp = TYPE#000010 |
occu = 16 (0x10000000) |
access = 1 (ItAccessStandard) |
idxKind = 0 (ItIndexNone) |
uniKind = 2 (ItUniqueNon) |
keyKind = 1 (default) |
cmpMode = 2 (cmpSingleMcmpR) |
occu0 = 1 |
groupCntl = 0 |
rfc = 1 |
unShareable = 0 |
mightBeShared = 0 |
sharedWithShmTab = 0 |
isShmLockId = 0 |
gcKind = 0 |
isUsed = 1 |
isCtfyAble = 1 |
>>>>> Shareable Table Header Data <<<<< |
tabi = Not allocated |
pghook = Not allocated |
idxPtr = Not allocated |
shmTabhSet = Not allocated |
id = Not allocated |
refCount = Not allocated |
tstRefCount = Not allocated |
lineAdmin = Not allocated |
lineAlloc = Not allocated |
shmVersId = Not allocated |
shmRefCount = Not allocated |
shmIsReadOnly = Not allocated |
>>>>> 1st level extension part <<<<< |
regHook = 0x0000000000000000 |
collHook = 0x0000000000000000 |
ext2 = 0x00673857FE070000 |
>>>>> 2nd level extension part <<<<< |
tabhBack = 0x10D43757FE070000 |
delta_head = 0100000002000000CD0000000200000004010000D00400003600000001000000000000000500000 |
pb_func = 0x0000000000000000 |
pb_handle = 0x0000000000000000 |
OUT_DETAILS[] |
Table IT_2[0x244] |
\FUNCTION-POOL=Z3P_CLC_FG01\FORM=Z3P_CLC_CONFIRMATION_DETAILS\DATA=%_%_OUT_DETAILS |
Table reference: 2 |
TABH+ 0(20) = 000000000000000070673857FE07000000000000 |
TABH+ 20(20) = 020000000200000000000000F4000000FFFFFFFF |
TABH+ 40(16) = 040100004004000010000000C1248101 |
store = 0x0000000000000000 |
ext1 = 0x70673857FE070000 |
shmId = 0 (0x00000000) |
id = 2 (0x02000000) |
label = 2 (0x02000000) |
fill = 0 (0x00000000) |
leng = 244 (0xF4000000) |
loop = -1 (0xFFFFFFFF) |
xtyp = TYPE#000008 |
occu = 16 (0x10000000) |
access = 1 (ItAccessStandard) |
idxKind = 0 (ItIndexNone) |
uniKind = 2 (ItUniqueNon) |
keyKind = 1 (default) |
cmpMode = 2 (cmpSingleMcmpR) |
occu0 = 1 |
groupCntl = 0 |
rfc = 1 |
unShareable = 0 |
mightBeShared = 0 |
sharedWithShmTab = 0 |
isShmLockId = 0 |
gcKind = 0 |
isUsed = 1 |
isCtfyAble = 1 |
>>>>> Shareable Table Header Data <<<<< |
tabi = Not allocated |
pghook = Not allocated |
idxPtr = Not allocated |
shmTabhSet = Not allocated |
id = Not allocated |
refCount = Not allocated |
tstRefCount = Not allocated |
lineAdmin = Not allocated |
lineAlloc = Not allocated |
shmVersId = Not allocated |
shmRefCount = Not allocated |
shmIsReadOnly = Not allocated |
>>>>> 1st level extension part <<<<< |
regHook = 0x0000000000000000 |
collHook = 0x0000000000000000 |
ext2 = 0xE0B23957FE070000 |
>>>>> 2nd level extension part <<<<< |
tabhBack = 0x80B23957FE070000 |
delta_head = 0100000003000000CC000000030000000401000070040000F400000001000000000000000500000 |
pb_func = 0x0000000000000000 |
pb_handle = 0x0000000000000000 |
%_DUMMY$$ |
2222 |
0000 |
0000 |
0000 |
SYST-REPID |
SAPLZ3P_CLC_FG01 |
5454535544454433222222222222222222222222 |
310CA30F3C3F6701000000000000000000000000 |
0000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000 |
SY-XPROG |
SAPLZ3P_CLC_FG01 |
5454535544454433222222222222222222222222 |
310CA30F3C3F6701000000000000000000000000 |
0000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000 |
SY-TABIX |
0 |
0000 |
0000 |
SCREEN |
2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
SY |
##############################################################################T######### #### |
000000F000000000000000000000000000000090000000000000000000000000000000000000105000000010220000 |
100000B000000000000000001000100000000020000000000000000000000000000000000000604000000000000500 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
00000030000000000000000000000000000000000000000000000000000000000000000000000000000000E000000C |
<%_TABLE_BBP_PDHGP> |
??? |
?????? |
?????? |
%_SPACE |
2 |
0 |
0 |
0 |
SY-MANDT |
001 |
333 |
001 |
000 |
000 |
<%_TABLE_BBP_PDISC> |
??? |
?????? |
?????? |
REF_DOC[] |
Table IT_3[1019x70] |
\FUNCTION=Z3P_CLC_CONFIRMATION_DETAILS\DATA=REF_DOC[] |
Table reference: 3 |
TABH+ 0(20) = 50FE3957FE070000000000000000000000000000 |
TABH+ 20(20) = 0300000003000000FB03000046000000FFFFFFFF |
TABH+ 40(16) = 04010000100D00000A000000C1048001 |
store = 0x50FE3957FE070000 |
ext1 = 0x0000000000000000 |
shmId = 0 (0x00000000) |
id = 3 (0x03000000) |
label = 3 (0x03000000) |
fill = 1019 (0xFB030000) |
leng = 70 (0x46000000) |
loop = -1 (0xFFFFFFFF) |
xtyp = TYPE#000055 |
occu = 10 (0x0A000000) |
access = 1 (ItAccessStandard) |
idxKind = 0 (ItIndexNone) |
uniKind = 2 (ItUniqueNon) |
keyKind = 1 (default) |
cmpMode = 2 (cmpSingleMcmpR) |
occu0 = 0 |
groupCntl = 0 |
rfc = 0 |
unShareable = 0 |
mightBeShared = 0 |
sharedWithShmTab = 0 |
isShmLockId = 0 |
gcKind = 0 |
isUsed = 1 |
isCtfyAble = 1 |
>>>>> Shareable Table Header Data <<<<< |
tabi = 0x70FB3957FE070000 |
pgHook = 0x30FB3A57FE070000 |
idxPtr = 0x0000000000000000 |
shmTabhSet = 0x0000000000000000 |
id = 5 (0x05000000) |
refCount = 0 (0x00000000) |
tstRefCount = 0 (0x00000000) |
lineAdmin = 1950 (0x9E070000) |
lineAlloc = 1054 (0x1E040000) |
shmVersId = 0 (0x00000000) |
shmRefCount = 1 (0x01000000) |
>>>>> 1st level extension part <<<<< |
regHook = Not allocated |
collHook = Not allocated |
ext2 = Not allocated |
>>>>> 2nd level extension part <<<<< |
tabhBack = Not allocated |
delta_head = Not allocated |
pb_func = Not allocated |
pb_handle = Not allocated |
TAB1[] |
Table IT_4[0x256] |
\FUNCTION=Z3P_CLC_CONFIRMATION_DETAILS\DATA=TAB1[] |
Table reference: 4 |
TABH+ 0(20) = 0000000000000000000000000000000000000000 |
TABH+ 20(20) = 04000000040000000000000000010000FFFFFFFF |
TABH+ 40(16) = 04010000700A000010000000C1248001 |
store = 0x0000000000000000 |
ext1 = 0x0000000000000000 |
shmId = 0 (0x00000000) |
id = 4 (0x04000000) |
label = 4 (0x04000000) |
fill = 0 (0x00000000) |
leng = 256 (0x00010000) |
loop = -1 (0xFFFFFFFF) |
xtyp = TYPE#000041 |
occu = 16 (0x10000000) |
access = 1 (ItAccessStandard) |
idxKind = 0 (ItIndexNone) |
uniKind = 2 (ItUniqueNon) |
keyKind = 1 (default) |
cmpMode = 2 (cmpSingleMcmpR) |
occu0 = 1 |
groupCntl = 0 |
rfc = 0 |
unShareable = 0 |
mightBeShared = 0 |
sharedWithShmTab = 0 |
isShmLockId = 0 |
gcKind = 0 |
isUsed = 1 |
isCtfyAble = 1 |
>>>>> Shareable Table Header Data <<<<< |
tabi = Not allocated |
pghook = Not allocated |
idxPtr = Not allocated |
shmTabhSet = Not allocated |
id = Not allocated |
refCount = Not allocated |
tstRefCount = Not allocated |
lineAdmin = Not allocated |
lineAlloc = Not allocated |
shmVersId = Not allocated |
shmRefCount = Not allocated |
shmIsReadOnly = Not allocated |
>>>>> 1st level extension part <<<<< |
regHook = Not allocated |
collHook = Not allocated |
ext2 = Not allocated |
>>>>> 2nd level extension part <<<<< |
tabhBack = Not allocated |
delta_head = Not allocated |
pb_func = Not allocated |
pb_handle = Not allocated |
TAB1 |
000000000000000000000000 00 |
2222222222222222222222222233333333333333333333333322222222222222222222222222222222222222222233 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
DAT1-GUID |
2222222222222222222222222222222222222222222222222222222222222222222222 |
0000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000 |
TAB1-GUID |
0000000000000000 |
0000000000000000 |
-
No. 3 Ty. FORM |
Name Z3P_CLC_CONFIRMATION_DETAILS |
-
%_ARCHIVE |
2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
%_%_IN_TAB |
Table IT_0[1019x146] |
%_%_OUT_DATES |
Table IT_1[0x54] |
%_VIASELSCR |
# |
0 |
4 |
%_%_OUT_DETAILS |
Table IT_2[0x244] |
-
No. 2 Ty. FORM |
Name REMOTE_FUNCTION_CALL |
-
HEADER |
000000000000 |
000000000000 |
TYPE |
3 |
0000 |
3000 |
SY-XPROG |
SAPLZ3P_CLC_FG01 |
5454535544454433222222222222222222222222 |
310CA30F3C3F6701000000000000000000000000 |
0000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000 |
RC |
0 |
0000 |
0000 |
SY-XFORM |
Z3P_CLC_CONFIRMATION_DETAILS |
535544454444454454445445444522 |
A30F3C3F3FE692D149FEF45419C300 |
000000000000000000000000000000 |
000000000000000000000000000000 |
%_SPACE |
2 |
0 |
0 |
0 |
-
No. 1 Ty. MODULE (PBO) |
Name %_RFC_START |
-
%_PRINT |
000 0### |
2222333222222222222222222222222222222222222222222222222222222222222222222222222222222222223000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 |
RFCTYPE_INTERNAL |
3 |
0000 |
3000 |
-
-
Internal notes |
The termination was triggered in function "HandleRsqlErrors" |
of the SAP kernel, in line 764 of the module |
"//bas/700_REL/src/krn/runt/absapsql.c#8". |
The internal operation just processed is "SQLS". |
Internal mode was started at 20080125053005. |
Internal call code.........: "[RSQL/OPEN/ZBBP_CONF_VIEW ]" |
-
-
Active Calls in SAP Kernel |
-
Lines of C Stack in Kernel (Structure Differs on Each Platform) |
-
SAP (R) - R/3(TM) Callstack, Version 1.0 |
Copyright (C) SAP AG. All rights reserved. |
Callstack without Exception: |
App : disp+work.EXE (pid=1568) |
When : 1/25/2008 5:30:5.129 |
Threads : 2 |
Computer Name : PWDF1918 |
User Name : ibpadm |
Number of Processors: 4 |
Processor Type: AMD64 Family 15 Model 33 Stepping 2 |
Windows Version : 5.2 Current Build: 3790 |
State Dump for Thread Id 2238 |
FramePtr ReturnAd Param#1 Function Name |
0000000007ccb730 0000000077d7047f 0000000056355570 ntdll!NtWaitForSingleObject |
0000000007ccb7d0 0000000001722861 00000000000002a0 kernel32!WaitForSingleObjectEx |
0000000007ccba20 0000000000610ec5 0000000000000001 disp+work!NTDebugProcess [ntstcdbg.c (501)] |
0000000007ccba50 0000000000afbbec 0000000000000001 disp+work!CTrcStack [dptstack.c (182)] |
0000000007ccbaa0 0000000000b00e10 0000000000000001 disp+work!rabax_CStackSave [abrabax.c (7091)] |
0000000007ccc480 0000000000a1153c 0000000001c934c0 disp+work!ab_rabax [abrabax.c (1231)] |
0000000007ccc520 00000000009e2656 0000000000000000 disp+work!ab_rsqlerr [abdberr.c (787)] |
0000000007ccc630 00000000009e4761 0000000000000003 disp+work!HandleRsqlErrors [absapsql.c (765)] |
0000000007ccc820 00000000009f5543 000000000000003b disp+work!SqlsExecuteCall [absapsql.c (7466)] |
0000000007ccc8d0 00000000008339b2 0000000000000001 disp+work!ab_jsqls [absapsql.c (1414)] |
0000000007ccca50 0000000000a0e8b7 0000000000000008 disp+work!ab_extri [abextri.c (554)] |
0000000007cccaa0 0000000000acb06c 0000000000000008 disp+work!ab_xevent [abrunt1.c (281)] |
0000000007cccb30 000000000066f0a8 0000000000000008 disp+work!ab_dstep [abdynpro.c (492)] |
0000000007ccccb0 0000000000672c7d 000007fe5730c890 disp+work!dynpmcal [dymainstp.c (2403)] |
0000000007cccd40 000000000067267a 000007fe572514a0 disp+work!dynppbo0 [dymainstp.c (543)] |
0000000007cccdf0 0000000000631ed5 0000000000000000 disp+work!dynprctl [dymainstp.c (360)] |
0000000007ccfc30 00000000004d71d3 0000000000000003 disp+work!dynpen00 [dymain.c (1629)] |
0000000007ccfeb0 000000000042d5a6 0000000007d58600 disp+work!TskhLoop [thxxhead.c (4467)] |
0000000007ccfee0 000000000040108d ffffffff00000003 disp+work!DpMain [dpxxdisp.c (1121)] |
0000000007ccff10 00000000019c7781 0000000000000000 disp+work!nlsui_main [thxxanf.c (84)] |
0000000007ccff70 0000000077d5966c 0000000000000000 disp+work!wmainCRTStartup [crtexe.c (498)] |
0000000007ccffa0 0000000000000000 00000000019c7610 kernel32!BaseProcessStart |
State Dump for Thread Id 374c |
FramePtr ReturnAd Param#1 Function Name |
000000000de0fe40 0000000077d5f651 0000000000000000 ntdll!NtFsControlFile |
000000000de0feb0 00000000018ad9af fffffffffffffffe kernel32!ConnectNamedPipe |
000000000de0ff40 000007ff7fc411c4 0000000000000000 disp+work!SigIMsgFunc [signt.c (679)] |
000000000de0ff70 0000000077d6b69a 0000000077d6b660 msvcrt!endthreadex |
000000000de0ffa0 0000000000000000 0000000000000000 kernel32!BaseThreadStart |
-
-
List of ABAP programs affected |
-
Index | Typ | Program | Group | Date | Time | Size | Lang. |
-
0 | Prg | SAPMSSY1 | 0 | 05/27/2005 | 16:45:10 | 22528 | E |
1 | Prg | SAPLZ3P_CLC_FG01 | 1 | 01/25/2008 | 02:47:42 | 33792 | E |
2 | Typ | Z3P_STR01 | 0 | 11/03/2007 | 07:50:03 | 3072 | |
3 | Typ | Z3P_STR03 | 0 | 11/03/2007 | 07:50:03 | 2048 | |
4 | Typ | Z3P_STR02 | 0 | 01/25/2008 | 02:47:42 | 4096 | |
5 | Prg | SAPLALFA | 5 | 02/08/2005 | 13:13:24 | 8192 | E |
6 | Typ | ZBBP_CONF_VIEW | 0 | 09/07/2007 | 05:21:21 | 10240 | |
7 | Typ | BBP_PDISC | 0 | 12/06/2007 | 04:04:51 | 12288 | |
8 | Prg | CX_SY_OPEN_SQL_DB=============CP | 8 | 07/01/2005 | 18:22:20 | 12288 | E |
9 | Typ | SCX_SRCPOS | 0 | 02/08/2005 | 13:13:15 | 2048 | |
10 | Prg | CX_SY_OPEN_SQL_ERROR==========CP | 10 | 07/01/2005 | 18:22:20 | 10240 | E |
11 | Prg | CX_SY_SQL_ERROR===============CP | 11 | 07/01/2005 | 18:22:20 | 10240 | E |
12 | Prg | CX_DYNAMIC_CHECK==============CP | 12 | 07/01/2005 | 18:22:20 | 10240 | E |
13 | Prg | CX_ROOT=======================CP | 13 | 11/03/2007 | 02:55:47 | 11264 | E |
14 | Prg | CX_NO_CHECK===================CP | 14 | 07/01/2005 | 18:22:20 | 10240 | E |
15 | Prg | CX_SY_NO_HANDLER==============CP | 15 | 07/01/2005 | 18:22:20 | 10240 | E |
16 | Typ | SYST | 0 | 01/23/2005 | 00:05:42 | 31744 | |
17 | Typ | ZBBP_WF_STRUC | 0 | 09/07/2007 | 05:21:20 | 2048 |
-
-
Directory of Application Tables |
-
Name Date Time Lngth |
Val. |
-
Program SAPMSSY1 |
-
SYST / / : : 00004612 |
\0\0\0\0\0\0#\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\x0001\0\0 |
-
-
ABAP Control Blocks (CONT) |
-
Index | Name | Fl | PAR0 | PAR1 | PAR2 | PAR3 | PAR4 | PAR5 | PAR6 | Source Code | Line |
-
160 | WHER | 28 | 0004 | 0000 | 0000 | LZ3P_CLC_FG01U01 | 410 | ||||
162 | WHER | 00 | 0000 | 0000 | 0016 | LZ3P_CLC_FG01U01 | 410 | ||||
164 | WHER | 2A | 0003 | 0000 | 0000 | LZ3P_CLC_FG01U01 | 410 | ||||
166 | WHER | 20 | 0000 | 0018 | 0024 | LZ3P_CLC_FG01U01 | 410 | ||||
168 | PAR1 | 80 | 001E | LZ3P_CLC_FG01U01 | 410 | ||||||
169 | WHER | 25 | 0000 | 0012 | 0027 | LZ3P_CLC_FG01U01 | 410 | ||||
171 | PAR1 | 80 | 001F | LZ3P_CLC_FG01U01 | 410 | ||||||
172 | WHER | 13 | 0000 | 0022 | 001D | LZ3P_CLC_FG01U01 | 410 | ||||
174 | PAR1 | 84 | C02A | LZ3P_CLC_FG01U01 | 410 | ||||||
175 | SQLS | 39 | 001F | LZ3P_CLC_FG01U01 | 410 | ||||||
176 | SQLS | 39 | 0000 | LZ3P_CLC_FG01U01 | 410 | ||||||
177 | SQLS | 3B | 0000 | LZ3P_CLC_FG01U01 | 410 | ||||||
>>>>> | SQLS | 20 | C020 | LZ3P_CLC_FG01U01 | 410 | ||||||
179 | LOOP | 03 | 0243 | C020 | C021 | 0000 | 0000 | 0000 | 0000 | LZ3P_CLC_FG01U01 | 462 |
183 | LOOP | 05 | 0000 | C020 | C021 | 0000 | 0000 | 0000 | 0000 | LZ3P_CLC_FG01U01 | 462 |
187 | BRAN | 05 | 002B | LZ3P_CLC_FG01U01 | 462 | ||||||
188 | MVCO | 00 | 0000 | LZ3P_CLC_FG01U01 | 463 | ||||||
189 | mvqk | 28 | 8080 | 1D70 | 1D30 | LZ3P_CLC_FG01U01 | 463 | ||||
191 | MOVE | FF | 0006 | C02E | C02F | LZ3P_CLC_FG01U01 | 463 | ||||
193 | MVCO | 01 | 0000 | LZ3P_CLC_FG01U01 | 463 |
-
Can anybody help please ? Its really urgent !
What is your database/livecache version?
Check note 1001257 - SQL error -1105 Too complicated SQL statement
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.