Skip to Content
avatar image
Former Member

In SCM 5.0 Runtime Errors: DBIF_DSQL2_SQL_ERROR Exception: CX_SY_NATIVE_SQ

Hi,

I am getting following shortdump in my SCM 5.0 system with LiveCache 7.6.03 on AIX 5.3.

Please help me.

-


Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Date and Time 01.07.2008 09:20:09

-


-


Short text

An SQL error occurred when executing Native SQL.

-


-


What happened?

The error "-4016" occurred in the current database connection "LCA".

-


-


What can you do?

Note down which actions and inputs caused the error.

To process the problem further, contact you SAP system

administrator.

Using Transaction ST22 for ABAP Dump Analysis, you can look

at and manage termination messages, and you can also

keep them for a long time.

-


-


How to correct the error

Database error text........: "POS(1) Unknown procedure

name:SIM_SIMSESSION_GET_ACTIVE"

Database error code........: "-4016"

Triggering SQL statement...: "EXECUTE PROCEDURE "SIM_SIMSESSION_GET_ACTIVE""

Internal call code.........: "[DBDS/NEW DSQL]"

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_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"

"/SAPAPO/SAPLOM_CORE" or "/SAPAPO/LOM_COREU23"

"/SAPAPO/OM_SIMSESSION_GET_ALL"

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

"/SAPAPO/OM_SIMSESSION_GET_ALL" "(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... "dewall43"

Network address...... "10.40.16.43"

Operating system..... "AIX"

Release.............. "5.3"

Hardware type........ "00C912FC4C00"

Character length.... 16 Bits

Pointer length....... 64 Bits

Work process number.. 14

Shortdump setting.... "full"

Database server... "dewall43"

Database type..... "ORACLE"

Database name..... "APO"

Database user ID.. "SAPSR3"

Char.set.... "C"

SAP kernel....... 700

created (date)... "Jan 23 2008 21:25:00"

create on........ "AIX 2 5 005DD9CD4C00"

Database version. "OCI_102 (10.2.0.2.0) "

Patch level. 144

Patch text.. " "

Database............. "ORACLE 9.2.0.., ORACLE 10.1.0.., ORACLE 10.2.0.."

SAP database version. 700

Operating system..... "AIX 1 5, AIX 2 5, AIX 3 5, AIX 1 6"

Memory consumption

Roll.... 1117168

EM...... 0

Heap.... 0

Page.... 24576

MM Used. 720672

MM Free. 376056

-


-


User and Transaction

Client.............. 100

User................ "DDIC"

Language key........ "E"

Transaction......... " "

Transactions ID..... "48692ABF23D6012AE10080000A28102B"

Program............. "/SAPAPO/SAPLOM_CORE"

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

-


-


Information on where terminated

Termination occurred in the ABAP program "/SAPAPO/SAPLOM_CORE" - in

"/SAPAPO/OM_SIMSESSION_GET_ALL".

The main program was "/SAPAPO/OM_DELETE_OLD_SIMS ".

In the source code you have the termination point in line 39

of the (Include) program "/SAPAPO/LOM_COREU23".

The program "/SAPAPO/SAPLOM_CORE" was started as a background job.

Job Name....... "/SAPAPO/OM_DELETE_OLD_SIMSESS"

Job Initiator.. "DDIC"

Job Number..... 08200801

The termination is caused because exception "CX_SY_NATIVE_SQL_ERROR" occurred

in

procedure "/SAPAPO/OM_SIMSESSION_GET_ALL" "(FUNCTION)", but it was neither

handled locally nor declared

in the RAISING clause of its signature.

The procedure is in program "/SAPAPO/SAPLOM_CORE "; its source code begins in

line

1 of the (Include program "/SAPAPO/LOM_COREU23 ".

-


-


Source Code Extract

-


Line

SourceCde

-


9

*" REFERENCE(ET_ACTIVE_SIMSESSION) TYPE /SAPAPO/OM_SIMSESSION_TAB

10

*" REFERENCE(ET_RC) TYPE /SAPAPO/OM_LC_RC_TAB

11

*" EXCEPTIONS

12

*" LC_CONNECT_FAILED

13

*" LC_COM_ERROR

14

*" LC_APPL_ERROR

15

*"----


16

17

data_def.

18

create_gen_com_params_default.

19

CLEAR ls_gen_com_params-client.

20

21

  • Verbindung zum liveCache aufbauen

22

start_function 'OM_SIMSESSION_GET_ALL'. "#EC *

23

check_server.

24

connect_to_livecache.

25

IF et_simsession IS REQUESTED.

26

  • COM-Routine zum Auslesen aller trans. Sim.

27

EXEC SQL.

28

EXECUTE PROCEDURE "SIM_SIMSESSION_GET_ALL" (

29

IN :LS_GEN_COM_PARAMS,

30

OUT :LV_RC,

31

OUT :ET_SIMSESSION)

32

ENDEXEC.

33

  • Returncodes pruefen und evtl. Exception raisen

34

lv_subrc_sav = sy-subrc.

35

ENDIF.

36

IF et_active_simsession IS REQUESTED.

37

  • COM-Routine zum Auslesen aller aktiven trans. Sim.

38

EXEC SQL.

>>>>>

EXECUTE PROCEDURE "SIM_SIMSESSION_GET_ACTIVE" (

40

IN :LS_GEN_COM_PARAMS,

41

OUT :LV_RC,

42

OUT :ET_ACTIVE_SIMSESSION)

43

ENDEXEC.

44

  • Returncodes pruefen und evtl. Exception raisen

45

lv_subrc_sav = sy-subrc.

46

ENDIF.

47

48

end_performance_measure.

49

  • end_function_no_main om_simsession_get_all.

50

check_returncodes.

51

if iv_get_testguids = gc_false.

52

delete ET_ACTIVE_SIMSESSION where table_line cs '~'.

53

delete ET_SIMSESSION where table_line cs '~'.

54

endif.

55

ENDFUNCTION.

-


-


Contents of system fields

-


Name

Val.

-


SY-SUBRC

0

SY-INDEX

0

SY-TABIX

1

SY-DBCNT

0

SY-FDPOS

0

SY-LSIND

0

SY-PAGNO

0

SY-LINNO

1

SY-COLNO

1

SY-PFKEY

SY-UCOMM

SY-TITLE

Periodic Deletion of Hanging Simulation Versions

SY-MSGTY

SY-MSGID

SY-MSGNO

000

SY-MSGV1

SY-MSGV2

SY-MSGV3

SY-MSGV4

SY-MODNO

0

SY-DATUM

20080701

SY-UZEIT

092008

SY-XPROG

RSDBRUNT

SY-XFORM

%_INIT_PBO_FIRST

-


-


Active Calls/Events

-


No. Ty. Program Include Line

Name

-


3 FUNCTION /SAPAPO/SAPLOM_CORE /SAPAPO/LOM_COREU23 39

/SAPAPO/OM_SIMSESSION_GET_ALL

2 FUNCTION /SAPAPO/SAPLOM_CORE /SAPAPO/LOM_COREU12 52

/SAPAPO/OM_SIMSESSION_SELECT

1 EVENT /SAPAPO/OM_DELETE_OLD_SIMS /SAPAPO/OM_DELETE_OLD_SIMS 67

START-OF-SELECTION

-


-


Chosen variables

-


Name

Val.

-


No. 3 Ty. FUNCTION

Name /SAPAPO/OM_SIMSESSION_GET_ALL

-


IV_GET_TESTGUIDS

X

0

0

5

8

ET_ACTIVE_SIMSESSION

Table IT_9[0x44]

\FUNCTION=/SAPAPO/OM_SIMSESSION_SELECT\DATA=LT_SIMSESSION

Table reference: 2

TABH+ 0(20) = 0000000000000000000000000000000000000000

TABH+ 20(20) = 0000000200000009000000000000002CFFFFFFFF

TABH+ 40(16) = 04000021000026C00010249401800000

store = 0x0000000000000000

ext1 = 0x0000000000000000

shmId = 0 (0x00000000)

id = 2 (0x00000002)

label = 9 (0x00000009)

fill = 0 (0x00000000)

leng = 44 (0x0000002C)

loop = -1 (0xFFFFFFFF)

xtyp = TYPE#000192

occu = 16 (0x00000010)

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

ET_RC

Table[initial]

ET_SIMSESSION

Table[initial]

OM_LC_NAME

LCA

000000000000000000000000000000

000000000000000000000000000000

444222222222222222222222222222

C31000000000000000000000000000

GC_OM_SYSUBRC

-16842752

F

E

SY-SUBRC

0

0000

0000

%_SPACE

0

0

2

0

%_VIASELSCR

#

0

4

OM_LC_APPL_NAME

000000000000000000000000000000

000000000000000000000000000000

222222222222222222222222222222

000000000000000000000000000000

SPACE

0

0

2

0

LS_GEN_COM_PARAMS

DDIC # /SAPAPO/OM_DELETE_OLD_SIMS

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

2222222222222222222222444422222222222222222222222222222222202254545424454444545444554452222222

0000000000000000000000449300000000000000000000000000000000000F31010FFFDF45C545FFC4F39D30000000

LV_RC

00

00

00

00

GC_OM_SPP_FORECAST_EXT

K

4

B

GC_IMMEDIATE_TRANSFER

65537

0

0

GC_RESOURCE_MULTI

16909060

0

1

GV_SIMSESSION_TYPE

0

0

2

0

OM_MEASURE_PERFORMANCE

0

0

2

0

GC_OM_OBJECT_OUTPUT_NODE

454827294

1

B

OM_AS_KEY

000000000000000000000000000000

000000000000000000000000000000

222222222222222222222222222222

000000000000000000000000000000

%_DUMMY$$

0000

0000

2222

0000

-


No. 2 Ty. FUNCTION

Name /SAPAPO/OM_SIMSESSION_SELECT

-


IV_MIN_AGE_IN_HOURS

1

0000

0001

IV_SAVED_INCLUSIVE

0

0

2

0

ET_OMS_VERSION

Table[initial]

ET_SIMSESSION_DELTA

Table[initial]

SCREEN

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

GC_OM_RPM_PORD_DEL

2004

000D

0074

GC_OM_OBJECT_UNKNOWN

66051

0

0

GC_OM_OBJECT_ORDER

16909060

0

1

GS_OMS_VERSION

00000000 ########

000000000000000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000000000000C

222222222222222222222233333333222222222222222222222200000000

000000000000000000000000000000000000000000000000000000000000

GC_MINTIME

09011000

1700002C

GT_OMS_VERSION

Table[initial]

GC_APPLICATION_BLRG

235868177

0

E

GC_OM_OBJECT_MODE

50595078

0

3

GC_TRUE

X

0

0

5

8

RSJOBINFO

00000000000000 ##

0000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000

2222222222222222222222222222222233333333333333222222222222222222222222222222222200

0000000000000000000000000000000000000000000000000000000000000000000000000000000000

GC_OM_OBJECT_RESOURCE

67438087

0

4

LT_SIMSESSION

Table IT_9[0x44]

GC_APPLICATION_CTPE

168496141

0

A

SY-REPID

/SAPAPO/SAPLOM_CORE

0000000000000000000000000000000000000000

0000000000000000000000000000000000000000

2545454254544454454222222222222222222222

F31010FF310CFDF3F25000000000000000000000

GC_APPLICATION_MATP

185339150

0

B

SYST-REPID

/SAPAPO/SAPLOM_CORE

0000000000000000000000000000000000000000

0000000000000000000000000000000000000000

2545454254544454454222222222222222222222

F31010FF310CFDF3F25000000000000000000000

GC_ATP_UPD_RPM

R

0

0

5

2

-


No. 1 Ty. EVENT

Name START-OF-SELECTION

-


VARI

###00000000000000 ############

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

2222222222222222222222222222222222222222222222222222222222200033333333333333222222000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

SYST-REPID

/SAPAPO/OM_DELETE_OLD_SIMS

0000000000000000000000000000000000000000

0000000000000000000000000000000000000000

2545454244544445454445544522222222222222

F31010FFFDF45C545FFC4F39D300000000000000

GC_OM_OBJECT_RPM_GENERIC

791687475

2

F

SY-SUBRC

0

0000

0000

%_VIASELSCR

#

0

4

SY-REPID

/SAPAPO/OM_DELETE_OLD_SIMS

0000000000000000000000000000000000000000

0000000000000000000000000000000000000000

2545454244544445454445544522222222222222

F31010FFFDF45C545FFC4F39D300000000000000

SY-MSGID

00000000000000000000

00000000000000000000

22222222222222222222

00000000000000000000

GC_TRANSPORT

y

0

0

7

9

SPACE

0

0

2

0

SY-MSGNO

000

000

000

333

000

SY-MSGV1

00000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000

22222222222222222222222222222222222222222222222222

00000000000000000000000000000000000000000000000000

SY-MSGV2

00000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000

22222222222222222222222222222222222222222222222222

00000000000000000000000000000000000000000000000000

SY-MSGV3

00000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000

22222222222222222222222222222222222222222222222222

00000000000000000000000000000000000000000000000000

SY-MSGV4

00000000000000000000000000000000000000000000000000

00000000000000000000000000000000000000000000000000

22222222222222222222222222222222222222222222222222

00000000000000000000000000000000000000000000000000

GC_ITRUE

16777623

0

1

GC_FALSE

0

0

2

0

SYST

###############################################################################T########X ####

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

000000000000000000000000000000000000000100000000000000000000000000000000000000000000000E000200

0000000000000000000000000000000000000006000000000000000000000000000000000000010500000001520000

000001010000010000000000010001000000000A00000000000000000000000000000000000006040000000080000C

GC_IFALSE

104192

0

0

GT_OMS_VERSION

Table[initial]

GC_MINTIME

09011000

1700002C

GT_SIMS_DELTA

Table[initial]

SY-XFORM

%_INIT_PBO_FIRST

000000000000000000000000000000

000000000000000000000000000000

254445554454455522222222222222

5F9E94F02FF6923400000000000000

%_DUMMY$$

0000

0000

2222

0000

SCREEN

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

-


-


Internal notes

The termination was triggered in function "DsqlErrorHandler"

of the SAP kernel, in line 2062 of the module

"//bas/700_REL/src/krn/runt/abexsql.c#2".

The internal operation just processed is "DSQL".

Internal mode was started at 20080701092008.

Internal call code.........: "[DBDS/NEW DSQL]"

-


-


Active Calls in SAP Kernel

-


Lines of C Stack in Kernel (Structure Differs on Each Platform)

-


=> 64 bit R/3 Kernel

=> 64 bit AIX Kernel

=> Heap limit = unlimited

=> Stack limit = unlimited

=> Core limit = 4294965248

=> File size limit = unlimited

=> Heap address = 0x0x1152ede20

=> Stack address = 0xfffffffffff84a0

=> Stack low = 0xfffffffffff84a0

=> Stack high = 0xffffffffffff7a0

=> Stack Trace:

AixStack() at 0x1000c7d94

CTrcStack2() at 0x1000c7e8c

rabax_CStackSave__Fv() at 0x1000b2d70

ab_rabax() at 0x1000af728

ab_dbdserr__FiPCUsT1T2P9DS_HEADERT2T1Pv() at 0x10057efbc

DsqlErrorHandler__Fi() at 0x10135b8e8

ExecuteCall__Fv() at 0x10135b454

ab_jdsql__Fv() at 0x101356b40

ab_extri__Fv() at 0x10040d93c

ab_xevent__FPCUs() at 0x100a9d170

ab_trigg__Fv() at 0x100a9ce5c

ab_run() at 0x1014bee48

N_ab_run() at 0x100d5bca8

dynpmcal() at 0x100d5aa74

dynppai0() at 0x100d58a08

dynprctl() at 0x100d6047c

dynpen00() at 0x100d52364

Thdynpen00() at 0x1000e2410

TskhLoop() at 0x1000e4254

ThStart() at 0x1000fe324

DpMain() at 0x10156c770

nlsui_main() at 0x101a99998

-


-


List of ABAP programs affected

-


Index

Typ

Program

Group

Date

Time

Size

Lang.

-


0

Prg

/SAPAPO/OM_DELETE_OLD_SIMS

0

28.09.2006

17:13:54

115712

E

1

Prg

SAPMSSY0

1

07.01.2008

17:16:23

92160

E

2

Prg

SAPMSSYD

1

27.09.2006

18:38:20

21504

E

3

Prg

SAPFSYSCALLS

1

03.12.2004

17:45:45

8192

E

4

Prg

RSDBRUNT

0

07.01.2008

17:27:13

254976

E

5

Typ

RSSCR

0

12.10.1999

15:50:05

5120

6

Prg

RSDBSPBL

0

22.02.2005

08:58:45

72704

E

7

Prg

SAPDB__S

0

03.12.2004

17:45:45

19456

E

8

Prg

RSDBSPMC

0

27.09.2006

18:23:16

79872

E

9

Typ

DDSHDESCR

0

28.11.1997

16:26:30

4096

10

Typ

SPPARAMS

0

07.03.1997

14:48:48

2048

11

Prg

SAPLSABE

11

03.12.2004

17:45:46

13312

E

12

Prg

SAPLSECU

12

07.01.2008

17:09:46

87040

E

13

Typ

RSSUBINFO

0

25.02.2000

15:47:23

3072

14

Prg

SAPLSTUP

14

07.01.2008

17:08:20

74752

E

15

Prg

SAPLCNDP

15

13.12.2007

16:41:21

195584

E

16

Prg

SAPLSCNT

16

22.02.2005

08:58:56

30720

E

17

Prg

SAPSHDTV

16

31.01.2005

15:41:11

33792

E

18

Prg

SAPFGUICNTL

1

22.02.2005

08:58:14

24576

E

19

Prg

SAPLOLEA

19

12.12.2007

14:16:36

96256

E

20

Prg

SAPLSGUI

20

07.01.2008

17:16:23

84992

E

21

Prg

SAPLSTTM

21

28.07.2005

11:12:25

69632

E

22

Prg

SAPLSBDC

22

07.01.2008

17:09:02

44032

E

23

Prg

SAPLSFES

23

07.01.2008

17:27:14

260096

E

24

Prg

SAPLTHFB

24

07.01.2008

17:16:23

394240

E

25

Typ

WPINFO

0

08.02.1999

14:18:32

6144

26

Prg

SAPLURFC

26

07.01.2008

17:13:39

22528

E

27

Prg

SAPLSPLUGIN

27

03.12.2004

17:45:46

8192

E

28

Typ

SWCBCONT

0

07.10.1997

12:13:50

3072

29

Typ

OLE_VERBS

0

09.02.1995

13:23:37

2048

30

Typ

OLE_PA

0

13.01.1995

11:06:59

2048

31

Prg

/1BCDWBEN/SAPL/SAPAPO/EN0001

31

08.06.2001

20:33:24

233472

E

32

Prg

SAPLSENA

32

12.12.2007

14:18:37

33792

E

33

Prg

/SAPAPO/SAPLOM_CORE

33

28.07.2005

16:02:32

502784

E

34

Prg

SAPLSAL2

34

07.01.2008

17:15:35

81920

E

35

Typ

/SAPAPO/OM_OMS_VERSIONS_STR

0

16.02.2006

18:01:55

3072

36

Prg

CL_ABAP_CHAR_UTILITIES========CP

36

28.07.2005

11:12:24

13312

E

37

Prg

CX_SY_NATIVE_SQL_ERROR========CP

37

12.12.2007

12:39:14

13312

E

38

Typ

SCX_SRCPOS

0

08.07.2004

09:59:00

2048

39

Prg

CX_SY_SQL_ERROR===============CP

39

28.07.2005

11:12:24

10240

E

40

Prg

CX_DYNAMIC_CHECK==============CP

40

28.07.2005

11:12:24

10240

E

41

Prg

CX_ROOT=======================CP

41

12.12.2007

17:18:15

11264

E

42

Prg

CX_NO_CHECK===================CP

42

28.07.2005

11:12:24

10240

E

43

Prg

CX_SY_NO_HANDLER==============CP

43

28.07.2005

11:12:24

10240

E

44

Prg

%_CSYDES

0

22.02.2005

08:58:46

8192

E

45

Prg

%_CSYDB0

0

22.02.2005

08:58:45

36864

E

46

Typ

RSVAMEMKEY

0

16.12.1996

19:31:50

2048

47

Prg

%_CRSDS

0

22.02.2005

08:58:21

10240

E

48

Prg

%_CSLIS

12

17.02.2006

08:58:39

89088

E

49

Typ

DTC_S_LAYO

0

08.06.2001

15:59:56

6144

50

Typ

CAT_SVARS

0

19.05.2004

16:00:08

3072

51

Typ

SYST

0

03.12.2004

17:45:35

31744

52

Typ

RSJOBINFO

0

09.02.1995

13:25:17

3072

53

Typ

VARI

0

16.12.1996

19:38:11

6144

-


-


Directory of Application Tables

-


Name Date Time Lngth

Val.

-


Program /SAPAPO/OM_DELETE_OLD_SIMS

-


SYST 03.12.2004 17:45:35 00004612

\0\0\0\0\0\x0001\0\x0001\0\0\0\0\0\x0001\0\0\0\0\0\0\0\0\0

VARI . . : : 00003052

-


Program /SAPAPO/SAPLOM_CORE

-


RSJOBINFO . . : : 00000164

00000000000000

-


-


ABAP Control Blocks (CONT)

-


Index

Name

Fl

PAR0

PAR1

PAR2

PAR3

PAR4

PAR5

PAR6

Source Code

Line

-


15307

DSQL

00

0000

/SAPAPO/LOM_COREU23

28

15308

DSQL

02

C002

/SAPAPO/LOM_COREU23

28

15309

DSQL

03

C000

/SAPAPO/LOM_COREU23

28

15310

DSQL

03

8001

/SAPAPO/LOM_COREU23

28

15311

DSQL

1B

0129

/SAPAPO/LOM_COREU23

28

15312

mvqw

04

8005

0004

005C

/SAPAPO/LOM_COREU23

34

15314

CMPS

40

0244

8002

8002

/SAPAPO/LOM_COREU23

36

15316

BRAF

02

0008

/SAPAPO/LOM_COREU23

36

15317

DSQL

00

0000

/SAPAPO/LOM_COREU23

39

15318

DSQL

02

C002

/SAPAPO/LOM_COREU23

39

15319

DSQL

03

C000

/SAPAPO/LOM_COREU23

39

15320

DSQL

03

8002

/SAPAPO/LOM_COREU23

39

>>>>>

DSQL

1B

012A

/SAPAPO/LOM_COREU23

39

15322

mvqw

04

8005

0004

005C

/SAPAPO/LOM_COREU23

45

15324

CMPS

20

0242

0245

0245

/SAPAPO/LOM_COREU23

48

15326

BRAF

05

0007

/SAPAPO/LOM_COREU23

48

15327

FUNC

00

6899

/SAPAPO/LOM_COREU23

48

15328

FUNC

00

08E5

/SAPAPO/LOM_COREU23

48

15329

PAR2

02

0000

00B7

0246

/SAPAPO/LOM_COREU23

48

15331

FUNC

10

0001

/SAPAPO/LOM_COREU23

48

-


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 10, 2014 at 08:37 PM

    As per note 1619720, drop following two tables and then validate by running t-code lca03.

    drop table APPSYSNAME

    drop table APPSYSPARAM

    dbmcli -d LCSID -n hostname -u superdba,sdbapassword -uSQL SAPSID,password

    dbmcli on hostname : SID>sql_execute drop table APPSYSPARAM

    OK

    ---

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 01, 2008 at 03:41 PM

    Check the connectivity to Livecache using LC10.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If connection is ok, try running consistency check again OM17. If even that doesnt solve the problem

      check with Basis guys. Following note may be useful

      941012-During the consistency check of resources (Transaction /SAPAPO/OM17), the system terminates after a certain amount of time with a dump:

      DBIF_DSQL2_SQL_ERROR, CX_SY_NATIVE_SQL_ERROR, program /SAPAPO/OM_RESOURCE_GET_DATA.

  • avatar image
    Former Member
    Jul 25, 2008 at 06:35 AM

    go to LC10 (as "Sajeev Anand" mentioned) ,

    choose LCA

    click "LiveCache: Monitoring"

    on the left pane open "Administration"

    click "operating"

    "Stop Live Cache"

    "Start Live Cache"

    problem should be solved..

    Add comment
    10|10000 characters needed characters exceeded