Skip to main content
S
sitirabiatula
July 15, 2021
Question

Unable to see SQL statements generated after customizing the logs in appian_log4j.properties

  • July 15, 2021
  • 1 reply
  • 0 views

Hi everyone, I am trying to see the generated SQL statements whenever i run my query entities/when my process receives a request and run thru my save to data entities node. I have configured below, located in /deployment/web.war/WEB-INF/resources/appian_log4j.properties as per instructed from Appian documentation https://docs.appian.com/suite/help/20.3/Customizing_Application_Logging.html#database-integration-details

I then ran my query entity by clicking Test Rule as show below and open the log 'tomcat-stdOut.log' located in APPIAN_HOME/latest/logs. But i cant find any SQL statements output. am i missing smth?

1 reply

raghuvarann456
raghuvarann456
August 3, 2021

Hi Rabish,

As per Appian's documentation, the loggers mentioned in the above documentation is for Write to datastore smart services and query rules onky. And not for query entities. I believe that's the reason why your query entity execution is not logged.

Terms & ConditionsAccessibility statement