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

Question

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?

raghuvarann456 · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO