2019R10 - reduce API message logging to DB

Jochen Davis

• March 03, 2023 10:51

At the moment stuck with using 2019R10, (2022 upgrade in flight)  We seem unable to reduce the logging verbosity the integration service makes to the DataStore DB table InegrationMessages.  The table alone is 92GB.  We can truncate to reduce size, however, we wish to lower logging to capture error/critical only messages. 

ca 12 messages per second pound the table impacts general performance anyway.  We have 200 printers in use all via API, generating a lot of informational/event messages in the DB.

Options seem not available in the integration builder, or integration service.

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • March 03, 2023 11:44

  I would try adjusting the logging options on the System Database tab in Administration Console and especially the Integration Message Logging section and see if that helps

  0
• 

  Jochen Davis

  ★ BarTender Hero ★

  • March 03, 2023 13:51

  Hi Peter,

   

  I think I found the solution.  In 2021 there is indeed a GUI driven option.  2019 and below an XML needs to be doctored, as per Fernando's KB I found after my original post.  Testing this now..

  https://support.seagullscientific.com/hc/en-us/articles/360000551767-How-to-prevent-integration-messages-from-being-logged-to-the-BarTender-System-Database?version=2016-2019

   

  0

Please sign in to leave a comment.