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?
Discussion posts and replies are publicly visible
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.