Live cache start and stop

[Former Member]

Hi Guys,

I have some problem in live cache in APO , i was posting in APO forum could not able to find clear findings

so i am diverting my questions here in this forum

basically the APO and R/3 system are running smoothly with no problem in CIF

but accidently we done the below steps

Entered into transaction LC-10

Click Live cache Monitoring

click the folder - Administration

click Operating under - configuration

There are two Icon bar - start LiveCache and stop LiveCache

First i clicked stop and then after few minutes i click start

After some time i try to open the Product view in APO, the system says Live cache not available

can some one help me in this regard

Thanks

Raj

[former_member229109]

Hello Raj,

-> Please update the ticket with additional information:

1) What is the version of the liveCache on your system? What is the version of your system?

2) "First i clicked stop and then after few minutes i click start "

Was liveCache stopped successfully before you 'clicked' start?

3) Did you see the 'message', that liveCache was started successfully after you

'clicked' start & before you tried "to open the Product view in APO"?

4) Please update with output of the following commands, run them on liveCache server:

xinstinfo <LC-SID>

dbmcli -d <LC-SID> -u control,<control> db_state

x_cons <LC-SID> show active

5) Check the errors in system log < TA /nsm21 >, the corresponding dev log of WP

< TA /nst11 >, the liveCache logs lcinit.log & knldiag & knldiag.err & dbm.prt

< located in the liveCache RUNDIRECTORY on the liveCache server,

/sapdb/data/wrk/<LC-SID> by default. >

-> As SAP customer please review the documentation at

service.sap.com/liveCache

&&

For SAP liveCache documentation in English < See the SAP note 767598 >:

http://help.sap.com/saphelp_nw04/helpdata/en/f2/0271f49770f0498d32844fc0283645/frameset.htm

Thank you and best regards, Natalia Khlopina

[Former Member]

Dear Natalia,

Thanks for your kind information

Here is my problem

Initially i stopped live cache lc10 it was succesfully stopped , but after some time i started again it was succesfully started - i can see both Red and Green indicator

but when i came back after week end i found the whole APO system is down

so i informed Basis team who is working remotly

After Few hours i found APO system is available

then i went to LC10 the live cache is not available , so i started and now it is running successfully for past 1 day

My exact problem the planning version created during the period before live cache was started is not available

so please advice me what i have to do to activate my earlier planning version

AS you mentioned i checked the logs using sm21

Start Workproc18, Pid 5684

Buffer TABL started with 30000000 bytes

Buffer TABLP started with 10240000 bytes

Buffer EIBUF started with 4096k bytes

Buffer ESM started with 4096k bytes

Buffer CUA started with 3000k bytes

Buffer OTR started with 4096k bytes

Buffer CALE started with 500000 bytes

Buffer RSCPCCC Generated with Length 6000000

Update requests were deleted (VBKEY = 32E14ADC23FBF1A4906C001

Initialization complete

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Database error -10709 at CON

> Connection failed (RTE:database not running)

Thanks

Raj

[Former Member]

Hello Raj,

Can you paste lcinit.log file here.

LC10->properties->Files---->lcinit.log ( from file overview )

Regards,

Tushar

[Former Member]

Hi Tusar,

Here is the log u asked me

LCINIT lcinit.log 13,511 10/15/2007 03:00:23 LiveCache Initialisation ASCII

Thanks

Raj

[Former Member]

Raj,

We need the contents of lcinit.log, rather than the directory listing.

I may have missed it but did you say what version of APO and liveCache you are running?

Cheers,

Mark

[Former Member]

Hi,

Here is the log you asked me

veCache LC1 (restart)

Mon 10/15/2007

03:00 AM

-

---

installation path = e:\sapdb\lc1\db

OK

OK

DBMServer 7.6.03 Build 008-123-159-187

starting LC1 into ONLINE

OK

Creating liveCache application procedures

OK

0,OK: everything works fine

0,""e:\sapdb\lc1\db\bin\x_python" "e:\sapdb\lc1\db\env\lapps.py" -R "e:\sapdb\lc1\db" -d LC1 -u SUPERDBA,*"

Installing APPS

Droping Procedures

LC1ADM

SAPTS

SAPLCK

SAPAPO

SAPATP

SAPREP

SAPSIM

SAPRPM

DBPINSTALL

Creating Procedures

LC1ADM

dbpinstall

FORCE_CHECKPOINT

WAIT_FOR_CHECKPOINT

FORCE_AND_WAIT_FOR_CHECKPOINT

SAPAPO

APS_COM_VERSION_GET

APS_PROPAREA_CHANGE

APS_PROPAREA_GET_DATA

APS_PEGAREA_CHANGE

APS_PEGAREA_GET_DATA

APS_PROPAREA_GET_ALL

APS_ORDERTYPE_GET_ALL

APS_ORDER_GET_ALL

APS_PEGID_GET_ALL

APS_IPPE_GET_ALL

APS_RESOURCE_GET_ALL

APS_PLAN_VERS_GET_ALL

BAS_PLAN_VERS_GET_ALL

APS_PLAN_VERS_GET_ALL_DEFECT

APS_PCM_GET_ALL

APS_OBJECT_GET_ALL

APS_OBJECT_EXISTS

APS_CONTAINER_CHANGE

APS_CONTAINER_GET_DATA

APS_GET_ALL_CONTKEYS

APS_PLAN_VERSION_CHANGE

APS_PLAN_VERSION_GET

APS_THROW_DBP_ERROR

APS_SCHEMA_CREATE

APS_SCHEMA_DELETE

APS_SCHEMA_GET_ALL

APS_SCHEMA_GET_ALL_DEFECT

APS_TIME_GET

APS_MIXIN_ATP_DELTAS

APS_MLEVEL_ATP_PROT_DEL

APS_REORG_ATP

APS_REPAIR_ATP

APS_GET_ATP_DATA

APS_ALERTS_GET_DATA

APS_ALERTS_IN_ORDER_NET

APS_ALERTS_DELAY_ORDER_NET

APS_TRACELEVEL_READ

APS_TRACELEVEL_CHANGE

APS_TRACELEVEL_GET_ALL

APS_TRACE_WRITE

APS_CUST_GET_DATA

APS_CUST_CHANGE

APS_CHECK_PERS_DATA

APS_PERS_OBJ_EDIT

APS_IPPE_CHANGE

APS_IPPE_GET_DATA

APS_IPPE_GET_ORDERS

APS_IPPE_GET_BY_IO

APS_ORDER_GET_TIMES

APS_RG_OF_COVER_MATRIX

APS_RANGE_OF_COVER_GET

APS_OPT_GET_ACTIVITY_NET

APS_OPT_GET_ACTIVITY_NET2

APS_OPT_UPDATE_ACTIVITY_NET

APS_BS_SEND64

APS_PERFTEST_1

APS_PERFTEST_2

APS_PERFTEST_3

APS_PERFTEST_4

APS_PERFTEST_5

APS_PERFTEST_6

APS_PERFTEST_7

APS_PERFTEST_8

APS_PERFTEST_9

APS_PERFTEST_COMB

APS_PERFTEST_READ_100

APS_PERFTEST_WRITE_100

APS_PERFTEST_READ_1000

APS_PERFTEST_WRITE_1000

APS_PERFTEST_READ_8000

APS_PERFTEST_WRITE_8000

APS_PERFTEST_TRANSMISSION

APS_IO_RESET_NETCHG_FLAG

APS_ORDER_GET_DATA

APS_ORDER_CREATE

APS_ORDER_CHANGE

APS_ORDER_DELETE

APS_ORDER_MODIFY

APS_FLEX_ORDER_CHANGE

APS_CHARACT_MODIFY

APS_CONSTRAINT_MODIFY

APS_PEGID_SELECT_ORDERS

APS_ORDER_GET_REQMTS

APS_ORDER_GET_SUPPLY

APS_PCM_DELETE

APS_PCM_GET_ORDERS

APS_PEGID_GET_IO

APS_PEG_REFRESH_IO

APS_PEGID_COUNT_IO

APS_PEGID_GET_VIRT_PEG

APS_PEGID_GET_ORDERS

APS_PEG_CAT_GET_ORDERS

APS_SEARCH_DESC_CHAR

APS_FIX_PEGGING_CHANGE

APS_PEGARC_TYPE_CHANGE

APS_PEGPARAM_CHANGE

APS_PEGID_GEN_PM_TRACE

APS_ACT_STATUS_CHANGE

APS_ACT_UNPLAN

APS_ACT_GET

APS_SFW_INITIALIZE

APS_SFW_IONODE_SCHEDULE

APS_SFW_GET_NEXT_SET

APS_SFW_SCHEDULE_SET

APS_SFW_TERMINATE

APS_STOCK_TSERIES_CMP

APS_STOCK_TSERIES_GET

APS_ACT_SCHEDULE

APS_ACT_GET_BY_RES

APS_ACT_GET_BY_ORDER

APS_ACT_GET_BY_PEGAREA

APS_RESOURCE_GET

APS_ORDER_GET

APS_PEGAREA_GET

APS_PROD_GET_BY_PEGAREA

APS_CUS_ORDER_CHANGE

APS_CUS_ORDER_GET

APS_CUS_SCHD_GET_BY_PEG

APS_CUS_SCHD_GET_BY_IO

APS_DELIVERY_CONF

APS_DELIVERY_MESSAGE

APS_FORECAST_GET_BY_PEG

APS_RESOURCE_CHANGE

APS_RESOURCE_GET_DATA

APS_CAPA_PROFILE_GET

APS_PERS_OBJ_ANALYZE

APS_RES_COLL_MERGE

APS_RES_MAX_COLL_BUFFER

APS_STOCK_CHANGE

APS_STOCK_GET

APS_STOCK_GET_BY_UID

APS_SETUPMATRIX_CHANGE

APS_SETUPMATRIX_UPDATE

APS_SETUPMATRIX_GET_DAT

APS_RESOURCE_GET_BRUTTO

APS_TIMING_PATTERN_GET

APS_BUCKETS_GET_NETTO

APS_DATE_VECTOR_CHANGE

APS_DATE_VECTOR_GET

APS_TIMESTREAM_CHANGE

APS_TIMESTREAM_GET_DATA

APS_TIMESTREAM_GET_BY_RES

APS_TLO_GET_RANGE

APS_TRANS_ORDER_CHANGE

APS_TRANS_ORDER_GET

APS_DRP_AMOUNT_GET

APS_DRP_FLOW_GET

APS_DRP_IO_GET

APS_DRP_CONTI_IO_GET

APS_SNP_ORDER_GET

APS_SNP_CAPA_GET

APS_SPP_FORECAST_MODIFY

APS_SPP_PUR_REQ_MODIFY

APS_SPP_FORECAST_EXT_MODIFY

APS_SPP_ORD_AMOUNT_GET

SAPAPO_COMTEST_1

SAPAPO_COMTEST_2

SAPAPO_COMTEST_NEW_PLANVERS

APS_SET_TEST_PARAMS

SAPAPO_CLEANUP

SAPAPO_RESET_GLOBALS

SAPATP

SAPATP_READ_TIMEAXIS

SAPATP_READ_CSV_ARRAY

SAPATP_SETUP_TIMEAXIS

SAPATP_CLEAR_TIMEAXIS

SAPATP_CHECK_AVAILABILITY

SAPATP_LS_LOGFILES

SAPATP_RM_LOGFILES

SAPATP_CREATE_MATRIX_OBJECT

SAPATP_DELETE_MATRIX_OBJECT

SAPATP_GET_MATRIX_OBJECTS

SAPATP_REORG_MATRIX

SAPATP_GET_CHAR_KEY

SAPATP_GET_CHAR_KEY_MULTI

SAPATP_GET_CHAR_LIST

SAPATP_READ_MATRIX

SAPATP_MATRIX_FIND_VERSIONS

SAPATP_READ_VPL_TIMEAXIS

SAPATP_READ_BUCKET_PARAMS_SIM

SAPATP_READ_TIMEAXIS_BOMID

SAPATP_PAC_CHECK

SAPATP_DELTA_EXIST_ANCHOR

SAPATP_DELTA_GET_REMOVE_ATP

SAPATP_DELTA_GET_REMOVE_ALLVPL

SAPATP_DELTA_GET_AGGREGATES

SAPATP_DELTA_GET_POSG_ATP

SAPATP_DELTA_READ_TOTAL

SAPATP_DELTA_READ_TRGUID_APS

SAPATP_DELTA_READ_DELNRAPS

SAPATP_DELTA_ADD_ATP

SAPATP_DELTA_UPD_ALLVPL

SAPATP_DELTA_UPD_ATP

SAPATP_DELTA_COMPRESS_APS

SAPATP_DELTA_REMOVE_TRGUID

SAPATP_DELTA_UPD_POSG_ATP

SAPATP_DELTA_GET_UPD_POSG_ALVP

SAPATP_DELTA_CHANGE_POSGUID

SAPATP_DELTA_REMOVE_DATE

SAPATP_DELTA_GET_PLUIDS_F_TRG

SAPATP_DELTA_GET_PLUIDS_F_DAT

SAPATP_DELTA_CLEAR_ANCHOR

SAPATP_DELTA_GET_ALL_ADMIN_ANC

SAPATP_DELTA_DELETE_ALLOC_ANC

SAPLCK

LCK_ENQUEUE

LCK_DEQUEUE

LCK_RELOAD

LCK_CONSISTENCY

LCK_LIST_ALL

LCK_LIST_SINGLE

LCK_LIST_BY_AREA

LCK_LIST_BY_OWNER

LCK_LIST_BY_USER

LCK_LIST_OWNERS

LCK_DEQUEUE_OWNER

LCK_STATISTICS

LCK_ENQUEUE02

LCK_DEQUEUE02

LCK_LIST_ALL02

LCK_LIST_SINGLE02

LCK_LIST_BY_AREA02

LCK_LIST_BY_OWNER02

LCK_LIST_BY_USER02

SAPSIM

SIM_SIMSESSION_CONTROL

SIM_SIMSESSION_COPY

SIM_SIMSESSION_SAVEAS

SIM_SIMSESSION_UNDO

SIM_SIMSESS_HAS_DELTAS

SIM_SIMSESSION_GET_DATA

SIM_SIMSESSION_GET_DELTAS

SIM_SIMSESSION_GET_ALL

SIM_SIMSESSION_GET_ACTIVE

SAPREP

REP_INIT

REP_CLOSE

REP_CHECK

REP_CHECK_MULTI

REP_ACKNOWLEDGE

REP_REVERT

REP_RETHEAD_READ

REP_RET_READ

REP_CAPA_CHANGE

REP_DEMAND_CHNG

REP_PLNVERS_READ

REP_PLVERS_READ

REP_TX_READ

REP_DELTAS_REORG

REP_CONSI_CHK

REP_DELPOS_DEL

REP_NEWPOS_DEL

REP_DELPOS_GET

REP_NEWPOS_GET

REP_REVERT_MULTI

REP_INST_DELETE

REP_INST_CREATE

REP_DEM_INIT_REC

REP_CHECK_EXIST

REP_TIMELINE_CRE

REP_INST_CHECK

REP_CHK_LOCK_GET

REP_CHK_LOCK_SET

REP_CHK_LOCK_DEL

REP_DELTA_DISP

REP_POSGUID_DISP

REP_CORR_QTY

REP_CHECK_NEW

REP_RESERVE_DEBUG

REP_ACKN_RES_FOR_TX_DEBUG

SAPRPM

RPM_ACTS_FOR_WORKCENTER

RPM_ADD_NODES

RPM_BF_CALC_ORDER_STATUS

RPM_BF_DELETE_ORDER_STATUS

RPM_BF_MODIFY_STATUS

RPM_BF_READ_ORDER_STATUS

RPM_CHG_R_ORD_CF

RPM_COPY_RES_ORD

RPM_CREATE_MATRIX

RPM_CUSTOMIZING_MODIFY

RPM_CUSTOMIZING_READ

RPM_DEL_RES

RPM_DEL_RES_ORD

RPM_DELETE_MATRIX

RPM_DELETE_ONE_CONFIG

RPM_MATRICES_FOR_CUOBJ

RPM_MATRICES_FOR_ORDID

RPM_MATRICES_FOR_ORDID_MUL

RPM_MATRICES_REORG

RPM_MATRIX_PROPERTIES

RPM_MATRIX_PROPS_UPDATE

RPM_MODIFY_CONFIGS

RPM_MODIFY_ONE_CONFIG

RPM_PARKED_ORDERS_READ_ALL

RPM_READ_A_R_ORD

RPM_READ_ALL_ACTIVITIES

RPM_READ_ALL_CONFIGS

RPM_READ_ALL_NODES

RPM_READ_ALL_ORDERS

RPM_READ_ALL_POSVARS

RPM_READ_ALL_RES

RPM_READ_ALL_TOKENS

RPM_READ_CONFIGS_W_TOKENS

RPM_READ_ONE_CONFIG

RPM_READ_ONE_ORDER

RPM_READ_ORDER_BOM

RPM_READ_ORDER_BOM_MUL

RPM_READ_ORDER_SEQUENCE

RPM_READ_ORDERS_FOR_POSVAR

RPM_READ_POS4RS1

RPM_READ_POS4RS2

RPM_READ_RES_ORD

RPM_READ_RES4POS

RPM_READ_ROW_BITS

RPM_REORG_HARD

RPM_REORG_PARKED_ORDERS

RPM_REORG_SOFT

RPM_REQS_FOR_MATERIAL_2

RPM_ROWIDS_FOR_WORKCENTER

RPM_SESSION_SWITCH

RPM_STORE_ACTIVITIES

RPM_STORE_ORDER_SEQUENCE

RPM_STORE_ORDERS

RPM_STORE_POSVARS

RPM_STORE_R_BITS

RPM_STORE_R_ORD

RPM_STORE_RESTR

RPM_STORE_TOKENS

RPM_TIME_LINES_CREATE

RPM_TIME_LINES_DELETE

RPM_TIME_LINES_READ

RPM_TRANSPOSE_PV_MATRIX

RPM_TRANSPOSE_TOKEN_MATRIX

RPM_TRANSPOSED_CONFIGS

RPM_UPDATE_ROW_BITS_TABLE

RPM_WRKCINFO_DELETE

RPM_WRKCINFO_MODIFY

RPM_WRKCINFO_READ

SAPTS

SAPTS_ADAPT_SEASONALITY

SAPTS_AGGMULT_TIMESERIES

SAPTS_AGGSINGLE_TIMESERIES

SAPTS_ASSOCIATE_CH

SAPTS_CALC_DATA

SAPTS_CALC_SNP_INFLOW

SAPTS_CHANGE_CH

SAPTS_CHANGE_FIX_DATA

SAPTS_CHANGE_KF

SAPTS_CHANGE_PT

SAPTS_CHANGE_RELMODE

SAPTS_CHANGE_SH

SAPTS_CHANGE_TG

SAPTS_CHRANGES_IN_AGG

SAPTS_CLEAN_OBJECTS

SAPTS_COMTEST

SAPTS_CONS_OBJECTS

SAPTS_COPY_DATA

SAPTS_CREATE_INCONS_OBJECTS

SAPTS_CREATE_NEW_LAYER

SAPTS_CREATE_REGISTER

SAPTS_CREATE_RELATION

SAPTS_CREATE_SNP_RELATION

SAPTS_CREATE_TIMESERIES

SAPTS_DELETE_KEZ_TS

SAPTS_DELETE_REGISTER

SAPTS_DELETE_RELATION

SAPTS_DELETE_SNP_RELATION

SAPTS_DELETE_TIMESERIES

SAPTS_EXTR_CH_GET

SAPTS_EXTR_CH_SET

SAPTS_EXTR_KF_GET

SAPTS_EXTR_KF_SET

SAPTS_EXTR_PT_GET

SAPTS_EXTR_PT_SET

SAPTS_EXTR_TG_GET

SAPTS_EXTR_TG_SET

SAPTS_EXTR_TSBUF_GET

SAPTS_EXTR_TSBUF_SET

SAPTS_EXTR_TSBUS_GET

SAPTS_EXTR_TSBUS_SET

SAPTS_EXTR_TSH_GET

SAPTS_EXTR_TSH_SET

SAPTS_EXTR_TSKF_GET

SAPTS_EXTR_TSKF_SET

SAPTS_EXTR_TSRLSNP_GET

SAPTS_EXTR_TSRLSNP_SET

SAPTS_EXTR_TSRL_GET

SAPTS_EXTR_TSRL_SET

SAPTS_EXTR_TS_GET

SAPTS_EXTR_TS_SET

SAPTS_GET_AGGREGATED_DATA

SAPTS_GET_AGGREGATED_DATA_RIW

SAPTS_GET_ALL_DATA

SAPTS_GET_ALL_DATA_RIW

SAPTS_GET_DATA

SAPTS_GET_DATA_RIW

SAPTS_GET_INITIAL_DATA

SAPTS_GET_REG_OBJECTS

SAPTS_GET_TS_INFO

SAPTS_GET_TS_INFO2

SAPTS_INITIALIZE_DATA

SAPTS_OBJECTS_BY_CHREF

SAPTS_OBJECTS_BY_KFREF

SAPTS_OBJECTS_BY_TGREF

SAPTS_OBJECTS_GET_ALL

SAPTS_OBJECTS_IN_AGG

SAPTS_OBJECTS_QUERY_STATE

SAPTS_QUERY_OBJECTS

SAPTS_READ_CH

SAPTS_READ_KF

SAPTS_READ_PT

SAPTS_READ_SH

SAPTS_READ_TG

SAPTS_REDISAGG_DATA

SAPTS_REGISTERS_GET

SAPTS_RELATIONS_GET

SAPTS_RELATION_GET_DETAIL

SAPTS_REPLACE_COMPLETE_TSKF

SAPTS_SET_DATA

SAPTS_SET_DATA_RIW

SAPTS_SET_INITIAL_DATA

SAPTS_SET_UNIT

SAPTS_TIMESERIES_GET

SAPTS_TRACE_FILTER

SAPTS_UPDATE_TIMESERIES

==================================

Installation successfully finished

==================================

Enable user LC1ADM

OK

OK

liveCache LC1 successfully started.

-

---

Mon 10/15/2007

03:00 AM

The Problem we face is before this problem happen we created planning version name 000 , when we open the product view system says planning version is not available

please advise me

Thanks

Raj

[former_member229109]

Hello Raj,

To avoid any further problems on the systems, I recommend you to create the OSS ticket for the component 'BC-DB-LCA'.

The following has to be checked first:

-> When the Pl. version was created on your system? < //mvm>

-> Was your system working properly after that?

-> Please be sure that the LCA & LDA connections are pointed to the correct liveCache instance.< review //db59 >

Check that another systems are not connected to this liveCache instance!

-> Check the clients in the table T000 & see if the client you login is liveCache relevant,

run the report /SAPAPO/OM_NON_LC_RELEVANT_CLT.

-> Review the lcinit.his file & search for (init) -> day/time, when the liveCache was initialized in LC10?

Check the 'logging' events in //om11 if the Pl. version was created or dropped science then day/time.

-> Was your system upgraded to SCM 5.0 or it's the new SCM 5.0 installation or your system was a System Copy?

-> Check the dbm.prt file, located in the liveCache Rundirectory, if the 'db_activate' command was listed after the Pl. version was created.

-> Run //om17 -> run check inconsistencies without checking any objects. Post the results.

-> What users do you have in the liveCache? Please post the output of the SQL command:

select * from users

Thank you and best regards, Natalia Khlopina