Turn off Detailed Logging in script logic

[Former Member]

Hi All,

We have some logic scripts which call BADIs internally which work on a very large volume of data. One script in question writes about 1.5 Million records to the database. We have noticed that the log file generated also logs each and every record written to the database, resulting in very large log files.

We suspect that the writing of the logs is causing significant performance delays, and this is corroborated by looking at the QUERY time, BADI Run Time, WRITE time, etc.. values from the log file. It seems that the script does about 2.8 minutes of actual work, while the remaining ~40 minutes are spent writing those millions of records to the log itself.

Is there a way to turn off the detailed logging in EPM 10? Searching online shows a note for a much older version.

Note 1361700 - Add parameter to turn the detailed script logic log off

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1361700

It suggests setting the value of SCRIPT_LOGIC_DETAIL_LOG to "unchecked", but that is the default setting in our system to begin with. Does something else need to be done in EPM 10 for this?

thanks,

Nitin

[Former Member · Accepted solution]

Hi Nitin,

I would be interested in your investigation also. Please share..

Thanks,

Nick

[former_member40152 · Accepted solution]

Hi nitin

Have you add the parameter SCRIPT_LOGIC_DETAIL_LOG = OFF in tcode UJ0_IMG_03, it should work.

Regards

[Former Member]

Hi All,

This is an older post of mine. I wanted to share an update.

As Lucio Martinez correctly pointed out, the detailed logs can be prevented by setting parameter

SCRIPT_LOGIC_DETAIL_LOG = OFF.

However we were wrong in our original premise that the detailed log itself was consuming too much time for writing the logs. Even when writing millions of lines of log details, the time spent on doing that was very small compared to the overall runtime.

We are now on HANA and life is much better!

[former_member182709]

Hi Nithin,

I did two tests, one is make SCRIPT_LOGIC_DETAIL_LOG to OFF and the other one is set to ON, but the logs size of  both tests don't have too much difference.  The log file when set to OFF is still very large.

See the detailed of the log.  As you can see when you set to ON, it outputs the very detailed information.

Attached is the log files. The size when set to off is smaller, but the size is still very big(no big size changed compared with the log with that parameter to ON).  ideally,  what you expected, the log file should be empty, just tell how many records are successfully sent or rejected.

Best Regards,

Charlie

Log when set to ON.txt.zip

log when set to OFF.txt.zip

[Former Member]

Please see note 1723064 - K2: Log performance is poor even if detailed logging is off

Regards,

Ergin

[Former Member]

Hi Nitin

did you solve the issue?

I' m facing the same

Thanks in advance