Problems with liveCache in APO

[Former Member]

Hi experts,

I have an issue with regards to liveCache in APO and I hope someone can help me.

Whenever I try to create a Planning Version within a Model (via transaction /SAPAPO/MVM) the following

error message is provided: "General error in model / version management planning".

Through some research I found a document that makes the following recommendation: "Sometimes when you work in a multi-client system, you maybe encounter the following error message: "General error in model/planning version management". This error is due to the fact that in LiveCache the planning version already exists but it cannot be found on database. As a remedy, you have to remove this inconsistency by using the transaction /SAPAPO/OM17. For detailed information, please refer to SAP Note 519014."

Then, as recommended, I tried to execute the transaction /SAPAPO/OM17. But when I tried to execute this transaction another error message was released: "Connection to liveCache failed. Message no. /SAPAPO/OM000".

Moreover, the result of the transaction /SAPAPO/OM13 ( Analyze liveCache and LCA Objects ) shows the following errors and warnings:

Item	Check
Connection to LCA	with errors
liveCache Stat. from LCA - ???	with errors
liveCache Initialization - 001	with errors
Old simulation versions	with warnings
/sapapo/om_reorg_daily - 001	with errors
/sapapo/om_delete_old_simsess	with errors
/sapapo/om_lcaalerts	with errors
Number of LC Sessions - 0	with errors

Thanks in advance for help.

Greetings,

Francisco Fonseca.

[Former Member · Accepted solution]

This shows there is an issue with LC installation. Please escalate this issue to the BASIS team. They will take of the issue

[Former Member · Accepted solution]

Hi sai balakavi,

initially, thanks for the fast help.

As suggested, the issue was escalated to the BASIS team and the procedure chosen was as follows:

1. Shutdown SAP APO and liveCache (ECC + SE6) services

2. Shutdown DB Oracle (ORCL + ECC + APO + SE6) services

3. Logs verification

4. Restart server

5. Restart SAP APO and liveCache (ECC) services

6. Restart DB Oracle (ORCL + ECC + APO + SE6) services

However, the previous problems still persist. So, in order to get more information about the problem, I exported a full report (at the end of this message) on the result of the transaction /SAPAPO/OM13 ( Analyze liveCache and LCA Objects ).

Is there any other action to be taken in addition to shutdown and restart of liveCache services?

Thanks in advance for help.

Greetings,

Francisco Fonseca.

EXPORTED REPORT

Versions

Current ABAP SP          : LCAPPS 2005_700: patch 0003
Import Date of SP        : 28.09.2006
Import Time of SP        : 17:14:18
Runtime Environment Vers.:
liveCache Connection     : titanidas-LCA

Module     ReleaBuildPatch OpSys      Change  DLL Date    Size      D

Number of LCA Routines   :                                            0

dbsdbslib                : (Cannot determine) Patch
SQLDBC Release           :

Times
Application Server       : 16.10.2008 06:00:16
liveCache Server         :
LCA Object               :

_______________________________________________________________________


Checks

liveCache Connection LCA : X                                OK
liveCache Connection LDA : X                                OK
liveCache Connection LEA : X                                OK
Connection to LCA        :                                  ERROR
liveCache Status from LCA: ???                              ERROR
liveCache Initialization : 001                              ERROR

Number of Active Traces  :                             0    OK
Number of Active Checks  :                             0    OK

No. of Old Trans. Sim.   :                             0    Warning

Initialize Follow-Up     :                                  ERROR

/sapapo/om_reorg_daily Scheduled Daily: 001                 ERROR
/sapapo/om_delete_old_simsess scheduled regularly:          ERROR
/sapapo/om_lcaalerts Scheduled Daily:                       ERROR

Number of Work Processes :                            13    ERROR
Number of LC Sessions    :                             0    ERROR

RFC Connections          :                                  OK
Clients with Errors      :                                  OK

MAXLOCKS                 :                             0    Warning
OMS_HEAP_LIMIT           :                             0    Warning
OMS_HEAP_THRESHOLD       :                             0    Warning
OMS_VERS_THRESHOLD       :                             0    Warning
REQUEST_TIMEOUT          :                             0    Warning

Critical Logging Event   :                                  OK

_______________________________________________________________________


Network

Server titanidas
Client titanidas

Thu Oct 16 06:00:52 2008
***LOG Q0I=> NiPConnect2: connect (10061: WSAECONNREFUSED: Connection re
*** ERROR => NiPConnect2: SiPeekPendConn failed for hdl 0 / sock 1916
    (SI_ECONN_REFUSE/10061; I4; ST; 172.16.28.148:3298) [nixxi.cpp    27
*** ERROR => NiTClientLoop: NiHandle (rc=-10) [nixxtst.cpp  2839]

************************************************************************
*
*  ERROR       partner '172.16.28.148:3298' not reached
*
*  TIME        Thu Oct 16 06:00:52 2008
*  RELEASE     700
*  COMPONENT   NI (network interface)
*  VERSION     38
*  RC          -10
*  MODULE      nixxi.cpp
*  LINE        2770
*  DETAIL      NiPConnect2
*  SYSTEM CALL connect
*  ERRNO       10061
*  ERRNO TEXT  WSAECONNREFUSED: Connection refused
*  COUNTER     1
*
************************************************************************

Process died with exitcode -1

_______________________________________________________________________


Current Messages

knldiag - Start

Error when reading the KNLDIAG file

knldiag - End


_______________________________________________________________________


Error Messages

knldiag.err - Last Message


knldiag.err - Last Initialization


knldiag.err - Last Start


_______________________________________________________________________


Log Initialization

lcinit.log - Start

Error when reading the LCINIT.LOG file

lcinit.log - End


_______________________________________________________________________


Logging for Log - /SAPAPO/OM11

Date       Time     Event      Cl. Message

_______________________________________________________________________


Data Cache

                    Pages              Megabyte
Cache Sizes                 0                  0
OMS Data                    0                  0
OMS History/Undo            0                  0
SQL Data                    0                  0      Used (%)
Overall                     0                  0            0,00

Accesses       Hit Rate (%)            Overall         Failed
OMS Data                 0,00                       0            0
OMS History/Undo         0,00                       0            0
SQL Data                 0,00                       0            0

[Former Member]

please check if you have same issue with other client systems as well. I f not ask the BASIS team to have a trace between these two systems

[Former Member]

The BASIS team discovered the problem and solved it.

The liveCache component was installed in a 32-bit plataform. But it seems that the installation of this component in 32-bit platforms is no more supported. So, the component was reinstalled in a 64-bit platform and the error messages mentioned by me in previous posts no longer occur.

[Former Member]

Have u checked the Live Cache is Active in transaction LC10.

Or in LC10 Check live cache monitoring?

if nothing is working then reinstall the DB

Rajesh Patil

[Former Member]

Hi,

Inspite of your Basis Team doing the Starting Steps the Log shows that the "LiveCache Connection" has failed as well as the "Initialization of LiveCache" has not happened.

With these issues you cannot work in APO.

Has your SAP Basis Team been Trained on SCM-APO "LiveCache" Courses (training on MaxDB type of DB) ?

There are Additional Courses to be done for APO LiveCache apart from the Standard SAP Basis (AS) Training.

Also there is a Training on "LiveCache" Performance which is a MUST to attend to be able to support APO.

In case you have ... Please report the Issue to SAP on OSS and let the LiveCache Experts (MaxDB) from Waldorf guide you.

Thanks,

Ambrish