In SCM 5.0 Runtime Errors: DBIF_DSQL2_SQL_ERROR Ex...

Former Member · ‎07-01-2008

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

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

444222222222222222222222222222

C31000000000000000000000000000

GC_OM_SYSUBRC

-16842752

F

E

SY-SUBRC

0

0000

%_SPACE

0

2

0

%_VIASELSCR

#

0

4

OM_LC_APPL_NAME

000000000000000000000000000000

222222222222222222222222222222

000000000000000000000000000000

SPACE

0

2

0

LS_GEN_COM_PARAMS

DDIC # /SAPAPO/OM_DELETE_OLD_SIMS

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

2222222222222222222222444422222222222222222222222222222222202254545424454444545444554452222222

0000000000000000000000449300000000000000000000000000000000000F31010FFFDF45C545FFC4F39D30000000

LV_RC

00

GC_OM_SPP_FORECAST_EXT

K

4

B

GC_IMMEDIATE_TRANSFER

65537

0

GC_RESOURCE_MULTI

16909060

0

1

GV_SIMSESSION_TYPE

0

2

0

OM_MEASURE_PERFORMANCE

0

2

0

GC_OM_OBJECT_OUTPUT_NODE

454827294

1

B

OM_AS_KEY

000000000000000000000000000000

222222222222222222222222222222

000000000000000000000000000000

%_DUMMY$$

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

-

Former Member · ‎09-10-2014

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

---

oguzhanarslan35 · ‎07-25-2008

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..

Former Member · ‎07-01-2008

Check the connectivity to Livecache using LC10.

In SCM 5.0 Runtime Errors: DBIF_DSQL2_SQL_ERROR Exception: CX_SY_NATIVE_SQ

Accepted Solutions (0)

Answers (3)

Answers (3)

Re: Freight Order Management

Freight Order Management

How to make product type group mandatory in creati...

Hello Expert ,We need to activate PC Miler Map in ...

Re: Sending ASN from Freight Order (embedded TM)