Live cache giving the error while starting the liv...

HI All,

i installed and configured everything related live cache in my SCM system and also i can checked LCA,LEA,LDA connection working properly in DB59 tcode but when am starting the Live cache in LC10 tcode am getting the dump error as below please provide me the solution as soon as possible

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Date and Time 16.04.2013 15:10:25

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.

Thanks

R@J>>>

SAP Managed Tags:
SCM APO SAP LiveCache

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (2)

Hi,

the -4016 means 'Unknown procedure name'.

Please check the ST22 trace for the concrete name of the stored procedure.

During start via LC10 the dbmcli will be called with exec_lcinit and with load_lcapps command

We can check in wich phase the error occured.

Burkhard

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Burkhard,

thanks for your reply but i unable to trace the error i am attaching the st22 dump please check can u help me to find out the error.

Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Date and Time 20.04.2013 10:04:57

----------------------------------------------------------------------------------------------------

|Short text |

| An SQL error occurred when executing Native SQL. |

----------------------------------------------------------------------------------------------------

|What happened? |

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

----------------------------------------------------------------------------------------------------

|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:LCK_LIST_OWNERS" |

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

| Triggering SQL statement...: "EXECUTE PROCEDURE LCK_LIST_OWNERS" |

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

| "SAPLSLCAPPS_LCK" or "LSLCAPPS_LCKU06" |

| "LCA_LCK_LIST_OWNERS" |

| |

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

| "LCA_LCK_LIST_OWNERS" "(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 701 |

| |

| Application server... "pwscm" |

| Network address...... "90.0.0.1" |

| Operating system..... "Windows NT" |

| Release.............. "5.2" |

| Hardware type........ "2x AMD64 Level" |

| Character length.... 16 Bits |

| Pointer length....... 64 Bits |

| Work process number.. 12 |

| Shortdump setting.... "full" |

| |

| Database server... "PWSCM" |

| Database type..... "ORACLE" |

| Database name..... "SCM" |

| Database user ID.. "SAPSR3" |

| |

| Terminal.......... " " |

| |

| Char.set.... "C" |

| |

| SAP kernel....... 701 |

| created (date)... "Jul 29 2012 23:45:07" |

| create on........ "NT 5.2 3790 Service Pack 2 x86 MS VC++ 14.00" |

| Database version. "OCI_10201_SHARE (10.2.0.4.0) " |

| |

| Patch level. 194 |

| Patch text.. " " |

| |

| Database............. "ORACLE 10.1.0.*.*, ORACLE 10.2.0.*.*, ORACLE 11.2.*.*.*" |

| SAP database version. 701 |

| Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2, Windows |

| NT 6.0, Windows NT 6.1, Windows NT 6.2" |

| |

| Memory consumption |

| Roll.... 16192 |

| EM...... 12569520 |

| Heap.... 0 |

| Page.... 24576 |

| MM Used. 1132416 |

| MM Free. 3054800 |

----------------------------------------------------------------------------------------------------

|User and Transaction |

| |

| Client.............. 800 |

| User................ "SAPUSER" |

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

| Transaction......... " " |

| Transactions ID..... "A773A9E27549F1EB8DCF000C29892F93" |

| |

| Program............. "SAPLSLCAPPS_LCK" |

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

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

----------------------------------------------------------------------------------------------------

|Information on where terminated |

| Termination occurred in the ABAP program "SAPLSLCAPPS_LCK" - in |

| "LCA_LCK_LIST_OWNERS". |

| The main program was "SLCA_LCK_SYNCHOWNERS ". |

| |

| In the source code you have the termination point in line 25 |

| of the (Include) program "LSLCAPPS_LCKU06". |

| The program "SAPLSLCAPPS_LCK" was started as a background job. |

| Job Name....... "SLCA_LCK_SYNCOWNERS" |

| Job Initiator.. "SAPUSER" |

| Job Number..... 09045700 |

| The termination is caused because exception "CX_SY_NATIVE_SQL_ERROR" occurred |

| in |

| procedure "LCA_LCK_LIST_OWNERS" "(FUNCTION)", but it was neither handled |

| locally nor declared |

| in the RAISING clause of its signature. |

| |

| The procedure is in program "SAPLSLCAPPS_LCK "; its source code begins in line |

| 1 of the (Include program "LSLCAPPS_LCKU06 ". |

----------------------------------------------------------------------------------------------------

|Source Code Extract |

----------------------------------------------------------------------------------------------------

|Line |SourceCde |

----------------------------------------------------------------------------------------------------

| 1|FUNCTION lca_lck_list_owners. |

| 2|*"---------------------------------------------------------------------- |

| 3|*"*"Lokale Schnittstelle: |

| 4|*" EXPORTING |

| 5|*" REFERENCE(ET_RC) TYPE LCA_RC_TAB |

| 6|*" REFERENCE(ET_OWNERS) TYPE LCA_GUID_22_TAB |

| 7|*" EXCEPTIONS |

| 8|*" LC_CONNECT_FAILED |

| 9|*" LC_COM_ERROR |

| 10|*" LC_APPL_ERROR |

| 11|*"---------------------------------------------------------------------- |

| 12| |

| 13| DATA: ls_rc TYPE lca_rc, |

| 14| lv_subrc_sav LIKE sy-subrc, |

| 15| ls_gen_com_params TYPE lca_gen_com_params. |

| 16| |

| 17| PERFORM fill_gen_com_params |

| 18| CHANGING ls_gen_com_params. |

| 19| |

| 20| check_server_lck. |

| 21| connect_to_livecache. |

| 22| |

| 23| EXEC "#EC CI_EXECSQL |

| 24| SQL. |

|>>>>>| EXECUTE PROCEDURE LCK_LIST_OWNERS ( |

| 26| IN :LS_GEN_COM_PARAMS, |

| 27| OUT :LS_RC, |

| 28| OUT :ET_RC, |

| 29| OUT :ET_OWNERS, |

| 30| IN :GV_MODE |

| 31| ) |

| 32| ENDEXEC. |

| 33| |

| 34| lv_subrc_sav = sy-subrc. |

| 35| exec_commit. |

| 36| check_returncodes. |

| 37|ENDFUNCTION. |

----------------------------------------------------------------------------------------------------

|Contents of system fields |

----------------------------------------------------------------------------------------------------

|Name |Val. |

----------------------------------------------------------------------------------------------------

|SY-SUBRC|0 |

|SY-INDEX|0 |

|SY-TABIX|1 |

|SY-DBCNT|1 |

|SY-FDPOS|0 |

|SY-LSIND|0 |

|SY-PAGNO|0 |

|SY-LINNO|1 |

|SY-COLNO|1 |

|SY-PFKEY| |

|SY-UCOMM| |

|SY-TITLE|Synchronization of the Lock Owner of the liveCache Lock Server |

|SY-MSGTY| |

|SY-MSGID| |

|SY-MSGNO|000 |

|SY-MSGV1| |

|SY-MSGV2| |

|SY-MSGV3| |

|SY-MSGV4| |

|SY-MODNO|0 |

|SY-DATUM|20130420 |

|SY-UZEIT|100457 |

|SY-XPROG|RSDBRUNT |

|SY-XFORM|%_INIT_PBO_FIRST |

----------------------------------------------------------------------------------------------------

|Active Calls/Events |

----------------------------------------------------------------------------------------------------

|No. Ty. Program Include Line |

| Name |

----------------------------------------------------------------------------------------------------

| 2 FUNCTION SAPLSLCAPPS_LCK LSLCAPPS_LCKU06 25 |

| LCA_LCK_LIST_OWNERS |

| 1 EVENT SLCA_LCK_SYNCHOWNERS SLCA_LCK_SYNCHOWNERS 66 |

| START-OF-SELECTION |

----------------------------------------------------------------------------------------------------

|Chosen variables |

----------------------------------------------------------------------------------------------------

|Name |

| Val. |

----------------------------------------------------------------------------------------------------

|No. 2 Ty. FUNCTION |

|Name LCA_LCK_LIST_OWNERS |

----------------------------------------------------------------------------------------------------

|ET_OWNERS |

| Table IT_18[0x44] |

| \PROGRAM=SLCA_LCK_SYNCHOWNERS\DATA=GT_OWNERS |

| Table reference: 9 |

| TABH+ 0(20) = 0000000000000000000000000000000000000000 |

| TABH+ 20(20) = 0900000012000000000000002C000000FFFFFFFF |

| TABH+ 40(16) = 043C00004004000010000000C1248001 |

| store = 0x0000000000000000 |

| ext1 = 0x0000000000000000 |

| shmId = 0 (0x00000000) |

| id = 9 (0x09000000) |

| label = 18 (0x12000000) |

| fill = 0 (0x00000000) |

| leng = 44 (0x2C000000) |

| 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 = 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 IT_17[0x140] |

| \FUNCTION=LCA_LCK_LIST_OWNERS\DATA=ET_RC |

| Table reference: 6 |

| TABH+ 0(20) = 0000000000000000000000000000000000000000 |

| TABH+ 20(20) = 0600000011000000000000008C000000FFFFFFFF |

| TABH+ 40(16) = 043C00009005000010000000C1308001 |

| store = 0x0000000000000000 |

| ext1 = 0x0000000000000000 |

| shmId = 0 (0x00000000) |

| id = 6 (0x06000000) |

| label = 17 (0x11000000) |

| fill = 0 (0x00000000) |

| leng = 140 (0x8C000000) |

| loop = -1 (0xFFFFFFFF) |

| xtyp = TYPE#000015 |

| occu = 16 (0x10000000) |

| access = 1 (ItAccessStandard) |

| idxKind = 0 (ItIndexNone) |

| uniKind = 2 (ItUniqueNon) |

| keyKind = 1 (default) |

| cmpMode = 8 (cmpManyEq) |

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

|SY-MSGV1 |

| |

| 22222222222222222222222222222222222222222222222222 |

| 00000000000000000000000000000000000000000000000000 |

|SY-MSGV2 |

| |

| 22222222222222222222222222222222222222222222222222 |

| 00000000000000000000000000000000000000000000000000 |

|SY-MSGV3 |

| |

| 22222222222222222222222222222222222222222222222222 |

| 00000000000000000000000000000000000000000000000000 |

|SY-MSGV4 |

| |

| 22222222222222222222222222222222222222222222222222 |

| 00000000000000000000000000000000000000000000000000 |

|CL_ABAP_CHAR_UTILITIES=>ENDIAN |

| L |

| 4 |

| C |

| 0 |

|GV_LC_NAME |

| LEA |

| 444222222222222222222222222222 |

| C51000000000000000000000000000 |

| 000000000000000000000000000000 |

|SY-SUBRC |

| 0 |

| 0000 |

|SY-REPID |

| SAPLSLCAPPS_LCK |

| 5454544455554442222222222222222222222222 |

| 310C3C31003FC3B0000000000000000000000000 |

| 0000000000000000000000000000000000000000 |

|%_SPACE |

| |

| 2 |

| 0 |

|GV_COM |

| 0 |

| 0000 |

|LS_GEN_COM_PARAMS |

| SAPUSER 800 # SLCA_LCK_SYNCHOWNERS |

| 2222222222222222222222545554522222333222222222222222222222202544454445554444544552222222222222|

| 00000000000000000000003105352000008000000000000000000000000003C31FC3BF39E38F7E5230000000000000|

| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|

|LS_RC |

| ## |

| 00 |

|GV_MODE |

| 0 |

| 0000 |

|LV_SUBRC_SAV |

| 0 |

| 0000 |

|SYST-REPID |

| SAPLSLCAPPS_LCK |

| 5454544455554442222222222222222222222222 |

| 310C3C31003FC3B0000000000000000000000000 |

| 0000000000000000000000000000000000000000 |

|LS_RC-RC |

| 0 |

| 0000 |

|%_PRINT |

| LP01001SLCA_LCK_SYN XXX8#A#|

| 4533333544454445554222222222222222222222222222222222222222222222222222222222222222222225553040|

| C0010013C31FC3BF39E000000000000000000000000000000000000000000000000000000000000000000008888010|

| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|

----------------------------------------------------------------------------------------------------

|No. 1 Ty. EVENT |

|Name START-OF-SELECTION |

----------------------------------------------------------------------------------------------------

|GC_START |

| LCK~DELETE~OLD~ENQUEUE |

| 4447444454744474455454 |

| C3BE45C545EFC4E5E15555 |

| 0000000000000000000000 |

|%_DUMMY$$ |

| |

| 2222 |

| 0000 |

|SY-LDBPG |

| SAPDB__S |

| 5454455522222222222222222222222222222222 |

| 31042FF300000000000000000000000000000000 |

| 0000000000000000000000000000000000000000 |

|SY-REPID |

| SLCA_LCK_SYNCHOWNERS |

| 5444544455544445445522222222222222222222 |

| 3C31FC3BF39E38F7E52300000000000000000000 |

| 0000000000000000000000000000000000000000 |

|SYST-REPID |

| SLCA_LCK_SYNCHOWNERS |

| 5444544455544445445522222222222222222222 |

| 3C31FC3BF39E38F7E52300000000000000000000 |

| 0000000000000000000000000000000000000000 |

|SY-SUBRC |

| 0 |

| 0000 |

|RSJOBINFO |

| 00000000000000 ## |

| 2222222222222222222222222222222233333333333333222222222222222222222222222222222200 |

| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000 |

|GV_OWNERS |

| |

| 2222222222222222222222 |

| 0000000000000000000000 |

|GT_OWNERS |

| Table IT_18[0x44] |

|GV_GARG |

| |

| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|

| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|

|GT_ENQ |

| Table[initial] |

|GS_ENQ |

| |

| 2222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222222|

| 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000|

|%_SPACE |

| |

| 2 |

| 0 |

----------------------------------------------------------------------------------------------------

|Internal notes |

| The termination was triggered in function "DsqlErrorHandler" |

| of the SAP kernel, in line 2062 of the module |

| "//bas/701_REL/src/krn/runt/abexsql.c#1". |

| The internal operation just processed is "DSQL". |

| Internal mode was started at 20130420100457. |

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

----------------------------------------------------------------------------------------------------

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

|Callstack without Exception: |

|App : disp+work.EXE (pid=2932) |

|When : 4/20/2013 10:4:57.888 |

|Threads : 2 |

|Computer Name : PWSCM |

|User Name : SAPServiceSCM |

|Number of Processors: 2 |

|Processor Type: EM64T Family 6 Model 44 Stepping 2 |

|Windows Version : 5.2 Current Build: 3790 |

|State Dump for Thread Id 920 |

|FramePtr ReturnAd Param#1 Function Name |

|0000000002024750 0000000077d704bf 00000001400002da ntdll!ZwWaitForSingleObject |

|00000000020247f0 00000001413930d1 00000000000004c8 kernel32!WaitForSingleObjectEx |

|0000000002024a30 00000001402250b1 0000000000000001 disp+work!NTDebugProcess [ntstcdbg.c (509)] |

|0000000002024a60 000000014072317e 00000000781ea000 disp+work!CTrcStack [dptstack.c (182)] |

|0000000002024ab0 0000000140728681 000007df000b1df8 disp+work!rabax_CStackSave [abrabax.c (7337)] |

|0000000002025470 000000014063c578 000000014199f138 disp+work!ab_rabax [abrabax.c (1287)] |

|00000000020254d0 0000000140622f3e 0000000000000001 disp+work!ab_dbdserr [abdberr.c (986)] |

|0000000002025520 0000000140624798 000000014364a880 disp+work!DsqlErrorHandler [abexsql.c (2064)] |

|0000000002025810 0000000140624dbc 0000000000000006 disp+work!ExecuteCall [abexsql.c (1556)] |

|00000000020258a0 000000014045c688 0000000000000000 disp+work!ab_jdsql [abexsql.c (271)] |

|0000000002025a00 0000000140639458 0000000000000001 disp+work!ab_extri [abextri.c (512)] |

|0000000002025a50 0000000140639d56 0000000000000001 disp+work!ab_xevent [abrunt1.c (281)] |

|0000000002025ae0 00000001407a79d7 00000001000002a0 disp+work!ab_trigg [abrunt1.c (61)] |

|0000000002025b70 000000014028be93 0000000100000016 disp+work!ab_run [absubmit.c (408)] |

|0000000002025d00 0000000140290d6e 000007df000c4190 disp+work!dynpmcal [dymainstp.c (2381)] |

|0000000002025da0 000000014029006a 0000000000000013 disp+work!dynppai0 [dymainstp.c (1113)] |

|0000000002025e50 00000001402482c8 0000000000000000 disp+work!dynprctl [dymainstp.c (360)] |

|000000000202fc10 00000001400f7f0e 0000000000000013 disp+work!dynpen00 [dymain.c (1928)] |

|000000000202fe90 0000000140031fd2 fffffffffffffffe disp+work!TskhLoop [thxxhead.c (4661)] |

|000000000202ff10 00000001400010a9 ffffffff00000003 disp+work!DpMain [dpxxdisp.c (1240)] |

|000000000202ff40 000000014166ac20 0000000002030000 disp+work!nlsui_main [thxxanf.c (64)] |

|000000000202ff70 0000000077d5964c 0000000000000000 disp+work!__tmainCRTStartup [crtexe.c (594)] |

|000000000202ffa0 0000000000000000 00000001400010e0 kernel32!BaseProcessStart |

|State Dump for Thread Id a6c |

|FramePtr ReturnAd Param#1 Function Name |

|00000000092dfe10 0000000077d5f691 0000000000000510 ntdll!NtFsControlFile |

|00000000092dfe80 000000014154e66f fffffffffffffffe kernel32!ConnectNamedPipe |

|00000000092dff10 00000000781337d7 00000000023b35e0 disp+work!SigIMsgFunc [signt.c (679)] |

|00000000092dff40 0000000078133894 00000000781e95c0 MSVCR80!endthreadex |

|00000000092dff70 0000000077d6b6da 0000000077d6b6a0 MSVCR80!endthreadex |

|00000000092dffa0 0000000000000000 0000000000000000 kernel32!BaseThreadStart |

----------------------------------------------------------------------------------------------------

|List of ABAP programs affected |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

| 0|Prg|SLCA_LCK_SYNCHOWNERS | 0|15.02.2005|14:00:59| 22528|E |

| 1|Prg|SAPMSSY0 | 1|08.05.2008|16:36:32| 93184|E |

| 2|Prg|SAPMSSYD | 1|16.10.2006|12:15:29| 21504|E |

| 3|Prg|SAPFSYSCALLS | 1|03.12.2004|17:45:45| 7168|E |

| 4|Prg|RSDBRUNT | 0|09.03.2009|13:30:19| 254976|E |

| 5|Prg|SAPLSPRI | 5|09.03.2009|13:27:07| 343040|E |

| 6|Typ|PRI_PARAMS | 0|27.10.1998|15:01:35| 5120| |

| 7|Typ|ARC_PARAMS | 0|08.08.1997|14:45:20| 5120| |

| 8|Typ|PRI_LAYOUT | 0|29.01.2003|15:39:12| 3072| |

| 9|Typ|PRIPAR_EXT | 0|08.07.2004|09:58:19| 3072| |

| 10|Typ|PRIPAR_EX2 | 0|08.06.2001|16:06:22| 2048| |

| 11|Typ|PRIPAR_EX3 | 0|08.07.2004|09:58:19| 3072| |

| 12|Typ|TPRI_DEF | 0|08.06.2001|16:42:16| 5120| |

| 13|Typ|USR01 | 0|06.03.2008|10:41:58| 4096| |

| 14|Typ|TSP1D | 0|02.02.1998|15:00:56| 5120| |

| 15|Prg|SAPLSPOO | 15|26.11.2008|12:44:14| 160768|E |

| 16|Prg|SAPLRSPOLSTDRV | 16|26.11.2008|12:44:08| 58368|E |

| 17|Typ|TSPOPTIONS | 0|06.12.1996|16:09:18| 2048| |

| 18|Typ|TSP03 | 0|13.08.1998|16:56:08| 5120| |

| 19|Typ|TSP0A | 0|26.11.2008|11:05:28| 6144| |

| 20|Typ|TSP03C | 0|18.11.2003|13:33:18| 7168| |

| 21|Typ|TSP03T | 0|20.02.1998|13:16:00| 6144| |

| 22|Typ|TSP06A | 0|26.11.2008|11:05:28| 7168| |

| 23|Prg|SAPCNVE | 23|03.12.2004|17:45:45| 8192|E |

| 24|Prg|SAPLSPOC | 24|09.03.2009|13:21:58| 137216|E |

| 25|Typ|TSP03L | 0|10.06.1997|01:43:12| 2048| |

| 26|Typ|RSPOCHECK | 0|14.07.1997|13:01:20| 4096| |

| 27|Typ|TSP03A | 0|10.06.1997|01:43:11| 3072| |

| 28|Prg|SAPLSPOR | 28|26.03.2007|10:31:33| 39936|E |

| 29|Prg|SAPLSPOB | 29|04.03.2008|18:03:12| 67584|E |

| 30|Prg|SAPLSDEX | 30|03.12.2004|17:48:42| 22528|E |

| 31|Typ|DD07T | 0|08.08.1997|14:46:27| 3072| |

| 32|Typ|DEVPAR | 0|08.06.2001|15:59:20| 3072| |

| 33|Typ|RSPOATTR | 0|25.02.2000|15:47:07| 2048| |

| 34|Typ|RSSCR | 0|12.10.1999|15:50:05| 5120| |

| 35|Prg|RSDBSPBL | 0|22.02.2005|08:58:45| 72704|E |

| 36|Prg|SAPDB__S | 0|03.12.2004|17:45:45| 19456|E |

| 37|Prg|RSDBSPMC | 0|16.10.2006|11:39:55| 79872|E |

| 38|Typ|DDSHDESCR | 0|28.11.1997|16:26:30| 4096| |

| 39|Typ|SPPARAMS | 0|07.03.1997|14:48:48| 2048| |

| 40|Prg|SAPLSABE | 40|03.12.2004|17:45:46| 12288|E |

| 41|Prg|SAPLSECU | 41|06.03.2008|10:41:58| 87040|E |

| 42|Typ|RSSUBINFO | 0|25.02.2000|15:47:23| 3072| |

| 43|Prg|SAPLSTUP | 43|09.03.2009|13:22:00| 74752|E |

| 44|Prg|SAPLCNDP | 44|09.03.2009|13:25:11| 195584|E |

| 45|Prg|SAPLSCNT | 45|22.02.2005|08:58:56| 30720|E |

| 46|Prg|SAPSHDTV | 45|31.01.2005|15:41:11| 33792|E |

| 47|Prg|SAPFGUICNTL | 1|22.02.2005|08:58:14| 24576|E |

| 48|Prg|SAPLOLEA | 48|09.03.2009|13:26:31| 96256|E |

| 49|Prg|SAPLSGUI | 49|08.05.2008|16:36:32| 84992|E |

| 50|Prg|SAPLSTTM | 50|28.07.2005|11:12:25| 69632|E |

| 51|Prg|SAPLSBDC | 51|06.03.2008|10:41:10| 44032|E |

| 52|Prg|SAPLSFES | 52|09.03.2009|13:29:35| 259072|E |

| 53|Prg|SAPLTHFB | 53|09.03.2009|13:27:44| 394240|E |

| 54|Typ|WPINFO | 0|08.02.1999|14:18:32| 6144| |

| 55|Prg|SAPLURFC | 55|06.03.2008|10:45:35| 22528|E |

| 56|Prg|SAPLSPLUGIN | 56|03.12.2004|17:45:46| 8192|E |

| 57|Typ|SWCBCONT | 0|07.10.1997|12:13:50| 3072| |

| 58|Typ|OLE_VERBS | 0|09.02.1995|13:23:37| 2048| |

| 59|Typ|OLE_PA | 0|13.01.1995|11:06:59| 2048| |

| 60|Prg|SAPLSLCAPPS_LCK | 60|15.02.2005|14:00:54| 40960|E |

| 61|Prg|SAPLSLCAPPS | 61|09.03.2009|13:27:05| 30720|E |

| 62|Typ|DBCON | 0|22.07.2003|14:19:14| 4096| |

| 63|Prg|IF_LCA_CONFIG=================IP | 61|31.01.2005|15:44:24| 7168|E |

| 64|Typ|T000 | 0|22.08.1997|13:07:16| 4096| |

| 65|Typ|LCA_CONFI | 0|03.12.2004|17:46:54| 2048| |

| 66|Prg|/1BCDWBEN/SAPLSEN0014 | 66|09.03.2009|13:45:14| 224256|E |

| 67|Prg|SAPLSENA | 67|26.03.2007|10:33:09| 33792|E |

| 68|Prg|CL_ABAP_CHAR_UTILITIES========CP | 68|28.07.2005|11:12:24| 13312|E |

| 69|Typ|LCA_RC_STR | 0|03.12.2004|17:44:35| 3072| |

| 70|Prg|CX_SY_NATIVE_SQL_ERROR========CP | 70|21.11.2006|15:04:55| 13312|E |

| 71|Typ|SCX_SRCPOS | 0|08.07.2004|09:59:00| 2048| |

| 72|Prg|CX_SY_SQL_ERROR===============CP | 72|28.07.2005|11:12:24| 10240|E |

| 73|Prg|CX_DYNAMIC_CHECK==============CP | 73|28.07.2005|11:12:24| 10240|E |

| 74|Prg|CX_ROOT=======================CP | 74|04.03.2008|18:00:01| 11264|E |

| 75|Prg|CX_NO_CHECK===================CP | 75|28.07.2005|11:12:24| 10240|E |

| 76|Prg|CX_SY_NO_HANDLER==============CP | 76|28.07.2005|11:12:24| 10240|E |

| 77|Prg|%_CSYDB0 | 0|22.02.2005|08:58:45| 35840|E |

| 78|Typ|RSVAMEMKEY | 0|16.12.1996|19:31:50| 2048| |

| 79|Prg|%_CRSDS | 0|22.02.2005|08:58:21| 10240|E |

| 80|Prg|%_CSLIS | 41|18.05.2006|15:07:25| 89088|E |

| 81|Typ|DTC_S_LAYO | 0|08.06.2001|15:59:56| 6144| |

| 82|Typ|CAT_SVARS | 0|19.05.2004|16:00:08| 3072| |

| 83|Typ|SYST | 0|03.12.2004|17:45:35| 31744| |

| 84|Typ|LCA_RC | 0|05.01.2005|11:50:12| 2048| |

| 85|Typ|RSJOBINFO | 0|09.02.1995|13:25:17| 3072| |

----------------------------------------------------------------------------------------------------

|Directory of Application Tables |

----------------------------------------------------------------------------------------------------

|Name Date Time Lngth |

| Val. |

----------------------------------------------------------------------------------------------------

|Program SLCA_LCK_SYNCHOWNERS |

----------------------------------------------------------------------------------------------------

|SYST 03.12.2004 17:45:35 00004612 |

| \0\0\0\0\x0001\0\x0001\0\0\0\0\0\x0001\0\0\0\0\0\0\0\x0001 |

|RSJOBINFO . . : : 00000164 |

| 00000000000000 |

----------------------------------------------------------------------------------------------------

|Program SAPLSPRI |

----------------------------------------------------------------------------------------------------

|TSP03 . . : : 00000460 |

| LP01 ASCIIPRI U\0\0 |

|USR01 . . : : 00000222 |

| 800SAPUSER LP01 GD1 |

|PRI_PARAMS . . : : 00000380 |

| LP01001SLCA_LCK_SYN |

|ARC_PARAMS . . : : 00000660 |

| |

|TPRI_DEF . . : : 00002932 |

| 800GV21 \0\0\0\0\x0600##\x0080##\0\0\x08D3\0### |

|TSP1D . . : : 00000320 |

| 0000000000 |

----------------------------------------------------------------------------------------------------

|Program SAPLSPOO |

----------------------------------------------------------------------------------------------------

|TSP03 . . : : 00000460 |

| LP01 ASCIIPRI U\0\0 |

|TSP03C . . : : 00000352 |

| LP01 \0 \0\0\0\0 \0\0 lp |

|TSP1D . . : : 00000320 |

| X_65_80 ANY PL0008000065SAP 1998040711 |

----------------------------------------------------------------------------------------------------

|Program SAPLRSPOLSTDRV |

----------------------------------------------------------------------------------------------------

|TSP0A . . : : 00000388 |

| ASCIIPRI STN200122Some generic ASCII printer 1105110511 |

|TSP03 . . : : 00000460 |

| LP01 ASCIIPRI U\0\0 |

|TSP03C . . : : 00000352 |

| LP01 \0 \0\0\0\0 \0\0 lp |

|TSP03T . . : : 00000422 |

| LP01 |

|TSPOPTIONS . . : : 00000432 |

| |

----------------------------------------------------------------------------------------------------

|Program SAPLSPOC |

----------------------------------------------------------------------------------------------------

|TSP03L . . : : 00000068 |

| LP01 LP01| |

----------------------------------------------------------------------------------------------------

|Program SAPLSPOR |

----------------------------------------------------------------------------------------------------

|TSP03 . . : : 00000460 |

| LP01 ASCIIPRI U\0\0 |

|TSP03L . . : : 00000068 |

| LP01 LP01| |

----------------------------------------------------------------------------------------------------

|Program SAPLSDEX |

----------------------------------------------------------------------------------------------------

|DD07T . . : : 00000260 |

| RSPOARCHTY EA00010000Print |

----------------------------------------------------------------------------------------------------

|ABAP Control Blocks (CONT) |

----------------------------------------------------------------------------------------------------

|Index|Name|Fl|PAR0|PAR1|PAR2|PAR3|PAR4|PAR5|PAR6|Source Code |Line |

----------------------------------------------------------------------------------------------------

| 1216|DSQL|1D|001F| | | | | | |LSLCAPPS_LCKU06 | 21|

| 1217|cmpr|00|00CA|0028|0000| | | | |LSLCAPPS_LCKU06 | 21|

| 1219|BRAF|05|0004| | | | | | |LSLCAPPS_LCKU06 | 21|

| 1220|DSQL|21|0034| | | | | | |LSLCAPPS_LCKU06 | 21|

| 1221|FUNE|03|001A| | | | | | |LSLCAPPS_LCKU06 | 21|

| 1222|ENDF|00|0000| | | | | | |LSLCAPPS_LCKU06 | 21|

| 1223|DSQL|00|0000| | | | | | |LSLCAPPS_LCKU06 | 25|

| 1224|DSQL|02|C002| | | | | | |LSLCAPPS_LCKU06 | 25|

| 1225|DSQL|03|C000| | | | | | |LSLCAPPS_LCKU06 | 25|

| 1226|DSQL|03|8000| | | | | | |LSLCAPPS_LCKU06 | 25|

| 1227|DSQL|03|8001| | | | | | |LSLCAPPS_LCKU06 | 25|

| 1228|DSQL|02|001B| | | | | | |LSLCAPPS_LCKU06 | 25|

|>>>>>|DSQL|1B|004F| | | | | | |LSLCAPPS_LCKU06 | 25|

| 1230|mvqw|04|0580|0004|005C| | | | |LSLCAPPS_LCKU06 | 34|

| 1232|DSQL|00|0000| | | | | | |LSLCAPPS_LCKU06 | 35|

| 1233|DSQL|01|0027| | | | | | |LSLCAPPS_LCKU06 | 35|

| 1234|DSQL|0B|0000| | | | | | |LSLCAPPS_LCKU06 | 35|

| 1235|DSQL|21|0034| | | | | | |LSLCAPPS_LCKU06 | 36|

| 1236|cmpr|00|00CA|C001|0000| | | | |LSLCAPPS_LCKU06 | 36|

| 1238|BRAT|05|0003| | | | | | |LSLCAPPS_LCKU06 | 36|

----------------------------------------------------------------------------------------------------

Thanks

R@J

This message was moderated.

Hi Raju,

If connection is ok, try running consistency check using Transaction /SAPAPO/OM17.

Additionally you may a have a look into following

SAP note 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

Hope this helps.

Regards,

Deepak Kori

Hello,

-> Please check that LCA/LDA/LEA connected to the same liveCache instance name/sever

in LC10 -> Integration. And the same liveCache user set.

-> Stop the liveCache, then start the liveCache in LC10 & check that LCK_LIST_OWNERS routine was listed in lcinit.log as created.

-> The dump occurred at Date and Time 20.04.2013 10:04:57, please check the dbm.prt & lcinit.his if at the time when you run the liveCache applications the routines were droped but not

created/registered yet.

-> Create the SAP message & get SAP support.

Regards, Natalia Khlopina

Are you able to start it manually via dbmcli ?

Kr. Mark

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

hi Mark,

can u please tell me briefly what i have to start from dbmcli?

Hi Jaju,

Sure! On the host where your livecache is running, logon with user <SID>adm

Enter the following command: dbmcli -d <SID> -u username,password

When you are logged on successfully with dbmcli you can check the status of the database with the command show state. If the instance is down, you can enter db_warm

Kind regards,

Mark

Hi Mark,

thanks for ur reply the database connection is ok there is no issues and for you i am sharing the result of show status command

dbmcli on MAXDB>show state

SERVERDB: MAXDB

The SERVERDB state is ONLINE

Console command finished (2013-04-18 18:40:10).

---

dbmcli on MAXDB>

Hi Raju,

Have you patched the maxdb instance with the latest available patch level? I know of some issues between ABAP and LiveCache when the LiveCache instance is not running on the correct patch level.

Kr. Mark

Hi mark,

actually i am new for Maxdb can you please tell me how to check the current version i installed and from where we can download patches and how to apply patches.

Thanks

R@J..

Ask a Question

Top Q&A Solution Author

User

Count