cancel
Showing results for 
Search instead for 
Did you mean: 

CX_SY_OPEN_SQL_DB Need Help !

laeeqsiddique
Participant
0 Kudos

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 !

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

What is your database/livecache version?

Check note 1001257 - SQL error -1105 Too complicated SQL statement

Markus