Hi Community,
today I have a strange issue, hope so much that you can help me.

Environment:
------------------
Operating System: CentOS 7.x (simple user)
PDI Version: pdi-ce-7.1.0.0-12
Console Client: MobaXterm

Issue description
-----------------------
Outcome ok: using pan.sh via bash console: ./pans.sh rep: trans: etc. with a simple text file output step all works fine, files where created.

Outcome not ok: using pan.sh ./pan.sh etc. with e.g. excel writer step to create *.xlsx files, the error below (below Stacktrace occurs.

But, and this where I nee your help, when I use a user and connect with X option on, for example: sudox -iu my_user. The transformation does not generate the error.

In my knowledge I thougt pan.sh is only to use command line, so no X server is needed. Must I switch of, maby a parameter in the console when I use Excel writer step?
Or do you have another idea? becaus the user does not have X switched on.

Thank you in advance to try this out on your side. And we could find a solution ot it.

Best regards

Thorsten


Stacktrace:
---------------

INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-javascript (225) [org.apache.cxf.javascript.JavascriptServerListener]
Nov 22, 2018 12:59:16 PM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
INFO: New Caching Service registered
2018/11/22 12:59:19 - Pan - Start of run.
2018/11/22 12:59:19 - RepositoriesMeta - Reading repositories XML file: /usr/local/home/etl/.kettle/repositories.xml
Nov 22, 2018 12:59:21 PM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /marketplace
Nov 22, 2018 12:59:21 PM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /lineage
Nov 22, 2018 12:59:21 PM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be /i18n
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/home/etl/kettle/pdi-ce-7.1.0.0-12/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/home/etl/kettle/pdi-ce-7.1.0.0-12/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
2018/11/22 12:59:22 - t_test_xxxxx - Dispatching started for transformation [t_test_xxxxx]
2018/11/22 12:59:22 - Generate Rows.0 - Finished processing (I=0, O=0, R=0, W=1, U=0, E=0)
2018/11/22 12:59:22 - Check if file is locked.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2018/11/22 12:59:22 - Filter rows.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
org.apache.commons.vfs2.FileSystemException: File closed.
at org.apache.commons.vfs2.util.MonitorOutputStream.assertOpen(MonitorOutputStream.java:162)
at org.apache.commons.vfs2.util.MonitorOutputStream.flush(MonitorOutputStream.java:133)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:141)
at java.io.FilterOutputStream.close(FilterOutputStream.java:158)
at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.copyFile(ExcelWriterStep.java:643)
at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:717)
at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:123)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:745)
2018/11/22 12:59:22 - t_test.0 - Finished reading query, closing connection.
2018/11/22 12:59:22 - t_test.0 - Finished processing (I=77, O=0, R=0, W=77, U=0, E=0)
2018/11/22 12:59:23 - t_test_xx.0 - Finished reading query, closing connection.
2018/11/22 12:59:23 - t_test_xx.0 - Finished processing (I=1729, O=0, R=0, W=1729, U=0, E=0)
MobaXterm X11 proxy: Unsupported authorisation protocol
java.awt.AWTError: Can't connect to X11 window server using 'localhost:10.0' as the value of the DISPLAY variable.
at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
at sun.awt.X11GraphicsEnvironment.access$200(X11GraphicsEnvironment.java:65)
at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:115)
at java.security.AccessController.doPrivileged(Native Method)
at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:74)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:103)
at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82)
at sun.awt.X11FontManager.isHeadless(X11FontManager.java:509)
at sun.awt.X11FontManager.getFontPath(X11FontManager.java:786)
at sun.font.SunFontManager.getPlatformFontPath(SunFontManager.java:3282)
at sun.font.SunFontManager$10.run(SunFontManager.java:3308)
at java.security.AccessController.doPrivileged(Native Method)
at sun.font.SunFontManager.loadFonts(SunFontManager.java:3304)
at sun.awt.X11FontManager.loadFonts(X11FontManager.java:460)
at sun.font.SunFontManager.findFont2D(SunFontManager.java:2348)
at java.awt.Font.getFont2D(Font.java:500)
at java.awt.Font.canDisplayUpTo(Font.java:2060)
at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
at java.awt.font.TextLayout.<init>(TextLayout.java:531)
at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:275)
at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:250)
at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:235)
at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:2164)
at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:2146)
at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:250)
at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:210)
at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
at java.lang.Thread.run(Thread.java:745)
2018/11/22 12:59:23 - create source file.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unexpected error
2018/11/22 12:59:23 - create source file.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : java.awt.AWTError: Can't connect to X11 window server using 'localhost:10.0' as the value of the DISPLAY variable.
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11GraphicsEnvironment.access$200(X11GraphicsEnvironment.java:65)
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:115)
2018/11/22 12:59:23 - create source file.0 - at java.security.AccessController.doPrivileged(Native Method)
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:74)
2018/11/22 12:59:23 - create source file.0 - at java.lang.Class.forName0(Native Method)
2018/11/22 12:59:23 - create source file.0 - at java.lang.Class.forName(Class.java:264)
2018/11/22 12:59:23 - create source file.0 - at java.awt.GraphicsEnvironment.createGE(GraphicsEnvironment.java:103)
2018/11/22 12:59:23 - create source file.0 - at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:82)
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11FontManager.isHeadless(X11FontManager.java:509)
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11FontManager.getFontPath(X11FontManager.java:786)
2018/11/22 12:59:23 - create source file.0 - at sun.font.SunFontManager.getPlatformFontPath(SunFontManager.java:3282)
2018/11/22 12:59:23 - create source file.0 - at sun.font.SunFontManager$10.run(SunFontManager.java:3308)
2018/11/22 12:59:23 - create source file.0 - at java.security.AccessController.doPrivileged(Native Method)
2018/11/22 12:59:23 - create source file.0 - at sun.font.SunFontManager.loadFonts(SunFontManager.java:3304)
2018/11/22 12:59:23 - create source file.0 - at sun.awt.X11FontManager.loadFonts(X11FontManager.java:460)
2018/11/22 12:59:23 - create source file.0 - at sun.font.SunFontManager.findFont2D(SunFontManager.java:2348)
2018/11/22 12:59:23 - create source file.0 - at java.awt.Font.getFont2D(Font.java:500)
2018/11/22 12:59:23 - create source file.0 - at java.awt.Font.canDisplayUpTo(Font.java:2060)
2018/11/22 12:59:23 - create source file.0 - at java.awt.font.TextLayout.singleFont(TextLayout.java:470)
2018/11/22 12:59:23 - create source file.0 - at java.awt.font.TextLayout.<init>(TextLayout.java:531)
2018/11/22 12:59:23 - create source file.0 - at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:275)
2018/11/22 12:59:23 - create source file.0 - at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:250)
2018/11/22 12:59:23 - create source file.0 - at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:235)
2018/11/22 12:59:23 - create source file.0 - at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:2164)
2018/11/22 12:59:23 - create source file.0 - at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:2146)
2018/11/22 12:59:23 - create source file.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.closeOutputFile(ExcelWriterStep.java:250)
2018/11/22 12:59:23 - create source file.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:210)
2018/11/22 12:59:23 - create source file.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2018/11/22 12:59:23 - create source file.0 - at java.lang.Thread.run(Thread.java:745)
child index = 16, logging object : org.pentaho.di.core.logging.LoggingObject@7285978 parent=5084b45a-65b7-4c14-883e-11f4d6a1fa9a