How do i acivate the sofa logging for R3

[thilo_weigel]

Hello,

I'm working with R3 and the SAP integration kit. Now I want to activate the sofa logging in order to find some problems with variables and to extract the mdx statement. I found here in the forum a thread for R2. But I don't get it to work. Do I have to do different registry entries?

Thanks

[roland_hoeller2 · Accepted solution]

Hi

Yes, there are different registry keys for XI R2 and XI 3.0.

Here is the list (don't forget to back up the rgistry)

Markup/Result

  

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Asserts]
"Model"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log]
"OverWrite"="No"
"AppendPID"="Yes"
"LogFile"="C:\\sofa.log"
"LogFormat"="%T ThreadID<%i> %X : %m"

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules]

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\APIMODULE]
"Verbosity"=dword:00000000
"Timer Threshold"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\APIMODULE\Components\INFO]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\JNIMODULE]
"Verbosity"=dword:00000000
"Timer Threshold"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\RORMODULE]
"Verbosity"=dword:0000000a
"Timer Threshold"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\JNIMODULE\Components\INFO]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\ASSERTION]
"Verbosity"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\COMMONMODULE]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\ESSBASEMODULE]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\INTERFACE]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\MEMORY]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\OCAMODULE]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\ODBOMODULE]
"Verbosity"=dword:00000004
"MDX Query Log"="C:\\mdx_odbo_query.log"
"MDX Query Clock"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\ODBOPROVIDERMODULE]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\ODBOSHAREDUTILITIES]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\ORACLEMODULE]
"Verbosity"=dword:00000000

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\SAPMODULE]
"Verbosity"=dword:0000000a
"MDX Query Log"="C:\\mdx_sap_query.log"

[HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\MDA\Log\Modules\UTILITIES]
"Verbosity"=dword:00000000

Roland

Edited by: Roland Hoeller on Oct 8, 2008 1:23 PM

[thilo_weigel]

Hello,

with these regitry keys, it should produce a mdx.log when refreshing a document. Here it is working.

Regards

[Former Member]

Thanks for the tip, but in my logfile are only the not running statements.

Maybe you have also other registry keys I don't have.

Regard,

Joachim

[Former Member]

Hi,

What is the way to activate sofa logging when the BOE servers are on Unix (AIX)?

Thanks,

Aveek

[thilo_weigel]

Thanks Roland,

it´s running!

[Former Member]

Hey,

is it also possible to log the running MDX statements?

In my logfile are only the statements which throw an exception ...

Thanks!

Joachim