How to set event logging to all to see parameter values

1 Answer 348 Views
Miscellaneous
Dominique
Top achievements
Rank 1
Dominique asked on 13 Oct 2021, 01:34 PM

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

1 Answer, 1 is accepted

Sort by
0
Viktor Zhivkov
Telerik team
answered on 18 Oct 2021, 05:53 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Dominique
Top achievements
Rank 1
commented on 26 Jun 2023, 09:08 AM

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".

Tags
Miscellaneous
Asked by
Dominique
Top achievements
Rank 1
Answers by
Viktor Zhivkov
Telerik team
Share this question
or