12-02-2021 09:08 AM
I'm attempting to view the full SQL query being executed by a particular OnBase activity, and the query is being truncated by the Diagnostics Console, even when viewed via detail view. This happens when viewed in the console or logging to external file. I don't recall this happening in v18, but I also may not have been viewing a query that long. The character limit appears to be 2048.
Is there a workaround for this?
12-02-2021 09:18 AM
Hi
While it might not be documented in the MRG, this is functioning to specification with 20.3.15.1000 and higher. The default character limit is 2048 as you referenced. To get around this limit, you can update the Hyland.Logging configuration key adding the TruncateLogValues attribute.
Here is an example for XML based applications (e.g. Web Server, Application Server, etc) which use the web.config
<Hyland.Logging TruncateLogValues="4096">
Here is an example for JSON based application (e.g. Hyland Diagnostics, Hyland IDP, etc)
"Hyland.Logging": { "TruncateLogValues": "4096", "Routes": { "DiagnosticsConsole-Errors": { "Http": "http://localhost:8989", "minimum-level": "Verbose" } }}
You can set it to any value you would like, or set it to 0 which will disable the truncation.
Best wishes.
05-13-2022 07:36 AM
Hi
From the looks of it you have an extraneous < character ...
<<Hyland.Logging TruncateLogValues="4096">
Best wishes.
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.