How to set event logging to all to see parameter values

[Dominique]

I'm working with Telerik OpenAccess, giving support to a C# application.

In the logs of that application, I have seen a query, where the parameters are not filled in with values, just question marks.

Next to that, there is following line:

set event logging to all to see parameter values

What can I do as a support engineer in order to make the values visible (replace the question marks by real values)?

In another question on this site, I've seen following advise:

Set the property Enable data caching to False. The property can be found under Data section of Administration -> Settings -> Advanced menu.

How can I achieve this? (Where is the configuration "application" I can use for this?)

 

Thanks in advance

[Viktor Zhivkov]

Hello,

If you want to see the values of SQL parameters you should set LogEvents configuration setting to "All". Please note that this will add some overhead to all calls to Telerik DataAccess and you need to secure the log files properly as they may contain sensitive security or private data. It is strongly advised to use this configuration value for local debug sessions and not in production.

To update the LogEvents via code or configuration file please see https://docs.telerik.com/data-access/feature-reference/api/context-api/backend-configuration/feature-ref-api-context-api-backend-config-logging-config

If you are still using Visual Studio Telerik DataAccess tooling with .RLINQ models see https://docs.telerik.com/data-access/deprecated/feature-reference/tools/model-settings-dialog/backend-settings/feature-ref-tools-visual-designer-model-settings-backend-trace-logging

 

I am unaware of the "Enable data caching" setting that you are referring in the second part of your question.

 

Please note that Telerik DataAccess has been retired a few years ago and is out of support.

 

Regards,
Viktor Zhivkov
Progress Telerik

[Dominique]

I've added the "configSections" and "openAccessConfiguration" tags in my configuration XML file, but the following line of source code does not work on my computer ("backend" seems to be unknown):

using Telerik.OpenAccess;

...

    BackendConfiguration.MergeBackendConfigurationFromConfigFile(
    backend,
    ConfigurationMergeMode.ConfigFileDefinitionWins,
    "LoggingConfiguration");

For your information: "BackendConfiguration" is recognised as Telerik.OpenAccess.BackendConfiguration and "ConfigurationMergeMode" is recognised as Telerik.OpenAccess.ConfigurationMergeMode, but nothing is proposed in order to recognise "backend".