SCM-APO CTM server issues.

[Former Member]

We had two successful runs with CTM, CIF and all the related planning programs.Last night’s CTM run took about an hour longer than the previous night. The bottleneck step appears to be the writing of the results back into LiveCache. In the logfile, we did not have entry for about 45 minutes and the CTM server appeared, not to be doing anything. After 45 minutes, the entry came in logfile that the CTM run completed successfully.

I have few questions.

1- For 45 minutes, the CTM server seem to hanging and did not write any entries to the logfile in SLG1, /sapapo/c3, /sapapo/ctmaplog, sm21 and lc10. What could be the reason for that?

2- Is there any other log, where CTM is writing to?

3- Are there any SAP recommended certain parameters that need to be considered for CTM runs.

4- What would be the recommended procedure to make the CTM run complete successfully in lesser time?

5- What would be the reason for the CTM run to complete in more time today then yesterday?

6- The expiration for CTM logs in /SAPAPO/COPT00 is set to 7 days. Even after 7 days have passed, the CTM logs are not getting deleted automatically. They have to be manually deleted. What could be the possible reason?

Points to be rewarded for any kind of help.

[kenneth_snyder · Accepted solution]

Logging does impact performance.

You can disable trace files in tcode /sapapo/copt01.

CTM also creates application logs which are set in ctm profile on settings tab.

Be sure there is sufficient disk space for logging. Sometimes the log files get so large, the system has to archive them and which slows down performance.

OM_REORG_DAILY will delete the files which has an expiration date set by COPT00. But this setting is only valid/used for new files created.

Try turning off logging altogether and see what happens.

Ken Snyder

[Former Member · Accepted solution]

Thanks Kenneth for the answers.

I have few more queries, that need to be answered.

1- how do I find LCA routine?

2- Also kindly let me know, what is the significance of a LCA routine in SM50.

3- If LCA routine is running for long time, kindly let me know, what type of action needs to be taken.

4- What is the impact of a long running LCA routine on the system.

5-Where do I get access to RTEDUMP file in livecache 7.6?

[former_member229109 · Accepted solution]

Hello Abdul,

Sorry for the delay. If you have any questions about liveCache/MAXDB database please post the question at MAXDB/liveCache forum

1- how do I find LCA routine?

You could review all registered LCA routines in the lcinit.log file, for example,

or in LC10 -> liveCAche:Monitoring -> Problem Analysis -> Database Procedures

If you run the job on your system you could review the status of the

Job in the job log & you also know in which WP the application step running

=> review the status in /nsm50 & see if 'Action' of the WP is in DB procedure

=> Mark WP and push the Choos Detail botom && will see

WP index 17

Process type BGD

Work process PID <...>

Status Running

Restart Yes

Runtime <...>

Report /SAPAPO/SAPLOM_PLANNINGTABLE

Client 100

User Names <...>

Action DB Procedure

Table DB-PROC "APS_ORDER_GET"

=> in my case the LCA routine APS_ORDER_GET is running.

2- Also kindly let me know, what is the significance of a LCA routine in SM50.

It's difficult to tell you without additional information about data selection,

Application info, system versions & so on. If you have any LCA routine in

Question please create the ticket to the component 'BC-DB-LCA' with application

Scenario information.

3- If LCA routine is running for long time, kindly let me know, what type of action needs to be taken.

Please use the DB Analyzer to find bottleneck in liveCache.

Create the ticket to the components 'BC-DB-LCA' or 'SV-BO-SCM'

4- What is the impact of a long running LCA routine on the system.

Due the long running LCA routine on the system the runtime of your application

Job will be increased + see the SAP note 631629 + see SAP Note No. 695721 to

avoid the liveCache performance falls sharply, because long-running COM

routines block tasks running in parallel.

See Best Practices for mySAP SCM Solution Management documents at

Service.sap.com/solutionmanagerbp

Or

Service.sap.com/scm -> SAP SCM Technology ->

Information on SCM 4.1 and prior releases

Information on SCM 4.1 and prior releases you will find <here>.

-> click on <here> -> Best Practices for mySAP SCM Solution Management

5-Where do I get access to RTEDUMP file in livecache 7.6?

SAP documentation:

http://help.sap.com/saphelp_nw04/helpdata/en/23/d1a03cc24efd1de10000000a114084/frameset.htm

-> Run directory -> log files

< Review information about log files & rtedump (RTEDUMP) >

And please review the SAP note: 354700 FAQ: liveCache analysis of a crash

-> Did you have the liveCache crash?

-> May be you are looking the current status of the liveCache tasks or you would like to know the status of the liveCache tasks during the application job run.

You could use the 'x_cons' tool for that, for example:

x_cons <SID> show active

x_cons <SID> show all

x_cons <SID> sh t_c TXXX

Thank you & best regards, Natalia Khlopina

[Former Member · Accepted solution]

Thanks Natalia for your excellent feedback.

[Former Member]

hi!

Point no 6:

Check the program /SAPAPO/OM_REORG_DAILY is running successfully as a background job in your APO system.

SB

[Former Member]

Thanks for the update. When I run the job "/SAPAPO/OM_REORG_DAILY", it is giving the following message in job log.

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

Number of Work Processes : 89 > See /sapapo/om13

Number of LC Sessions : 257 > See /sapapo/om13

Analysis of LC and LCA objects shows errors

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

How should I analyze the LC and LCA objects, that contain error.

[former_member229109]

Hello Abdul,

1)Please review the SAP notes::

800927 Standard jobs in the SCM/APO area

679118 Which operations are performed by /SAPAPO/OM_REORG_DAILY?

2) "Number of Work Processes : 89 > See /sapapo/om13

Number of LC Sessions : 257 > See /sapapo/om13

Analysis of LC and LCA objects shows errors"

Please run checks in TA /n/sapapo/om13. You will find out that the transaction /sapapo/om13 tab checks shows a red lights. Information on how to avoid the red lights can be found via the blue info buttons.

Please review the SAP note

'719652 Setting initial parameters for liveCache 7.5 or 7.6'

The minimum recommended value of the liveCache parameter MAXUSERTASKS

as of Version 7.6:

(Number of SCM work processes)*3 + 4 =>

In your case 89*3 + 4 & the current value of the liveCache parameter

MAXUSERTASKS on your system is 257, less as recommended value.

3) To get clear on the performance problem on your system I recommend:

A) Please update with additional information:

-> What is the version of the CTM optimizer? < TA /sapapo/opt09 >

-> What is the SP/version of the SCM on your system?

-> What is the version/build of the liveCache/LCA?

B) Please monitor your system first:

-> Check in /nsm50 if LCA routines are running long time;

What is the name LCA routine?

-> If yes, check the active tasks in liveCache;

Use the x_cons tool on the liveCache server, run for example:

x_cons <SID-LC> show active

-> Check errors in knldiag, knldiag.err & LCA trace number 1;

-> Switch on the DB Analyzer in liveCache & check warnings;

C) Check is you have inconsistencies between liveCache & APO database

in /sapapo/om17;

You could use the report "/SAPAPO/CTMMDATCHECK" to check the master

data in the background.

D) Create the OSS ticket to the component 'SV-BO-SCM'

Thank you and best regards, Natalia Khlopina

Message was edited by:

Natalia Khlopina

[Former Member]

Hello Natalia,

Thanks a ton for the feedback. Your's answers have been, of indeed great help to me.

Here are the answers to your questions.

Q- What is the version of the CTM optimizer? < TA /sapapo/opt09 >

ANS - CTM01 5.0_COR SP08, WDFD00123866A, Mar 29 2007 5.0 8

Q- What is the SP/version of the SCM on your system?

ANS - SCM 500 0007

SCM_BASIS 500 0007

Q- What is the version/build of the liveCache/LCA?

KERNEL 7.6.01 BUILD 005-123-135-650

Q- Check knldiag, knldiag.err & LCA trace number 1, /sapapo/om17 and SAPAPO/CTMMDATCHECK.

Ans- I checked and /sapapo/om17 had few inconsistencies and I corrected them.

Q- check the active tasks in liveCache;

A- There are 10 active tasks and 9 CPUs. Is it a problem?

Q- Check in /nsm50 if LCA routines are running long time;

What is the name LCA routine?

A- I can see a long list of jobs executed by users in SM50, but regarding LCA routine, I have few questions.

1- how do I find LCA routine?

2- Also kindly let me know, what is the significance of a LCA routine in SM50.

3- If LCA routine is running for long time, kindly let me know, what type of action needs to be taken.

4- What is the impact of a long running LCA routine on the system.

I have a questions regarding tracing in Livecache.

1- Where do I get access to RTEDUMP file in livecache 7.6?

2- Is there any thing else I can do to trace the activities in Livecache.

3- Also during CTM runs, is it possible to trace, what kind of activity, these runs do in a Livecache?

Thanks a ton for your great help.