we've always had issues with our help desk not being able to review the error messages and we are forced to look back into the database logging tables to troubleshoot the issue. My question is, why isn't the log file on the file system showing error messages when they are clearly shown when running the kitchen through a console window as such:
E:\Pentaho\pdi-ee-client-8.0.0.0-28\data-integration>kitchen.bat /rep:"PENTAHO 8X" /job:"JOB" /user:admin /pass:"Encrypted 2be98afc86aa7f2e4cb79ce71da9fa6d4" /level:detailed > e:\pentaho\log.log


There was some activity on this
http://jira.pentaho.com/browse/PDI-8477
Database / SQL error msg does not show up in the error log nor error dialog (only on the console)



Here's my output when viewing the log file on the files sytem (> e:\pentaho\log.log):
*******************************************************************************
2018/01/31 10:30:49 - Kitchen - Logging is at level : Basic
2018/01/31 10:30:49 - Kitchen - Start of run.
2018/01/31 10:30:49 - RepositoriesMeta - Reading repositories XML file: ..\KettleHome\.kettle\repositories.xml
2018/01/31 10:30:51 - General - Logging plugin type found with ID: CheckpointLogTable
2018/01/31 10:31:05 - JOB - Start of job execution
2018/01/31 10:31:05 - Carte - Installing timer to purge stale objects after 1440 minutes.
2018/01/31 10:31:05 - JOB - Starting entry [Check Db connections]
2018/01/31 10:31:05 - JOB - Starting entry [Transformation]
2018/01/31 10:31:05 - Transformation - Loading transformation from repository [TRANFORMATION] in directory [/]
2018/01/31 10:31:05 - Transformation - Using run configuration [Pentaho local]
2018/01/31 10:31:05 - Transformation - Using legacy execution engine
2018/01/31 10:31:05 - TRANFORMATION - Dispatching started for transformation [TRANFORMATION]
2018/01/31 10:31:05 - Table input.0 - Finished reading query, closing connection.
2018/01/31 10:31:05 - Table input.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2018/01/31 10:31:05 - TRANFORMATION - Transformation detected one or more steps with errors.
2018/01/31 10:31:05 - TRANFORMATION - Transformation is killing the other steps!
2018/01/31 10:31:05 - JOB - Finished job entry [Transformation] (result=[false])
2018/01/31 10:31:05 - JOB - Finished job entry [Check Db connections] (result=[false])
2018/01/31 10:31:05 - JOB - Job execution finished
2018/01/31 10:31:05 - Kitchen - Finished!
2018/01/31 10:31:05 - Kitchen - Start=2018/01/31 10:30:49.716, Stop=2018/01/31 10:31:05.955
2018/01/31 10:31:05 - Kitchen - Processing ended after 16 seconds.



Here's the output from my command line running Kettle:
*******************************************************************************
INFO: Setting the server's publish address to be /lineage
Jan 31, 2018 10:31:00 AM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /i18n
2018/01/31 10:31:05 - Table input.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Unexpected error
2018/01/31 10:31:05 - Table input.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2018/01/31 10:31:05 - Table input.0 - An error occurred executing SQL:
2018/01/31 10:31:05 - Table input.0 - SELECT count(*) FROM dim_appointment_serial
2018/01/31 10:31:05 - Table input.0 - ORA-00942: table or view does not exist

2018/01/31 10:31:05 - Table input.0 -
2018/01/31 10:31:05 - Table input.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1768)
2018/01/31 10:31:05 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:236)
2018/01/31 10:31:05 - Table input.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:140)
2018/01/31 10:31:05 - Table input.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2018/01/31 10:31:05 - Table input.0 - at java.lang.Thread.run(Unknown Source)
2018/01/31 10:31:05 - Table input.0 - Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:762)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1309)
2018/01/31 10:31:05 - Table input.0 - at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:422)
2018/01/31 10:31:05 - Table input.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1757)
2018/01/31 10:31:05 - Table input.0 - ... 4 more
2018/01/31 10:31:05 - TRANFORMATION - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected!
2018/01/31 10:31:05 - TRANFORMATION - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Errors detected!