usbrandon opened a new issue, #2171:
URL: https://github.com/apache/hop/issues/2171

   ### Apache Hop version?
   
   2.3
   
   ### Java version?
   
   11
   
   ### Operating system
   
   Linux
   
   ### What happened?
   
   I have a pipeline that writes to a table and excel file.  When running it 
from the terminal, I get the following error.  There are two different 
usernames involved.  bjackson (my KDE GUI), etluser (which the pipeline was 
running as using hop-run.sh)
   
   I would not expect the Excel output set to try to use the Xwindows display.  
Does it really need to?
   
   2023/01/19 15:15:11 - Set values like infinity to 0.0 - Finished processing 
(I=0, O=0, R=304195, W=304195, U=0, E=0)
   Invalid MIT-MAGIC-COOKIE-1 keyjava.awt.AWTError: Can't connect to X11 window 
server using ':10.0' as the value of the DISPLAY variable.
        at java.desktop/sun.awt.X11GraphicsEnvironment.initDisplay(Native 
Method)
        at 
java.desktop/sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:102)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at 
java.desktop/sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:61)
        at java.base/java.lang.Class.forName0(Native Method)
        at java.base/java.lang.Class.forName(Class.java:315)
        at 
java.desktop/java.awt.GraphicsEnvironment$LocalGE.createGE(GraphicsEnvironment.java:101)
        at 
java.desktop/java.awt.GraphicsEnvironment$LocalGE.<clinit>(GraphicsEnvironment.java:83)
        at 
java.desktop/java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:129)
        at 
java.desktop/sun.awt.X11FontManager.isHeadless(X11FontManager.java:464)
        at 
java.desktop/sun.awt.X11FontManager.getFontPath(X11FontManager.java:732)
        at 
java.desktop/sun.font.SunFontManager.getPlatformFontPath(SunFontManager.java:3196)
        at java.desktop/sun.font.SunFontManager$10.run(SunFontManager.java:3218)
        at java.base/java.security.AccessController.doPrivileged(Native Method)
        at 
java.desktop/sun.font.SunFontManager.loadFonts(SunFontManager.java:3214)
        at 
java.desktop/sun.awt.X11FontManager.loadFonts(X11FontManager.java:438)
        at 
java.desktop/sun.font.SunFontManager.findFont2D(SunFontManager.java:2231)
        at java.desktop/java.awt.Font.getFont2D(Font.java:506)
        at java.desktop/java.awt.Font.canDisplayUpTo(Font.java:2250)
        at java.desktop/java.awt.font.TextLayout.singleFont(TextLayout.java:469)
        at java.desktop/java.awt.font.TextLayout.<init>(TextLayout.java:530)
        at 
org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:301)
        at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:273)
        at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:257)
        at 
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:497)
        at 
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:479)
        at 
org.apache.hop.pipeline.transforms.excelwriter.ExcelWriterTransform.closeOutputFile(ExcelWriterTransform.java:320)
        at 
org.apache.hop.pipeline.transforms.excelwriter.ExcelWriterTransform.closeFiles(ExcelWriterTransform.java:244)
        at 
org.apache.hop.pipeline.transforms.excelwriter.ExcelWriterTransform.processRow(ExcelWriterTransform.java:234)
        at org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55)
        at java.base/java.lang.Thread.run(Thread.java:829)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 - ERROR: Unexpected error
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 - ERROR: java.awt.AWTError: Can't 
connect to X11 window server using ':10.0' as the value of the DISPLAY variable.
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.awt.X11GraphicsEnvironment.initDisplay(Native Method)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.awt.X11GraphicsEnvironment$1.run(X11GraphicsEnvironment.java:102)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.base/java.security.AccessController.doPrivileged(Native Method)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.awt.X11GraphicsEnvironment.<clinit>(X11GraphicsEnvironment.java:61)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.base/java.lang.Class.forName0(Native Method)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.base/java.lang.Class.forName(Class.java:315)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.GraphicsEnvironment$LocalGE.createGE(GraphicsEnvironment.java:101)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.GraphicsEnvironment$LocalGE.<clinit>(GraphicsEnvironment.java:83)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:129)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.awt.X11FontManager.isHeadless(X11FontManager.java:464)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.awt.X11FontManager.getFontPath(X11FontManager.java:732)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.font.SunFontManager.getPlatformFontPath(SunFontManager.java:3196)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.font.SunFontManager$10.run(SunFontManager.java:3218)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.base/java.security.AccessController.doPrivileged(Native Method)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.font.SunFontManager.loadFonts(SunFontManager.java:3214)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.awt.X11FontManager.loadFonts(X11FontManager.java:438)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/sun.font.SunFontManager.findFont2D(SunFontManager.java:2231)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.Font.getFont2D(Font.java:506)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.Font.canDisplayUpTo(Font.java:2250)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.font.TextLayout.singleFont(TextLayout.java:469)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.desktop/java.awt.font.TextLayout.<init>(TextLayout.java:530)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:301)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:273)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:257)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:497)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:479)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.hop.pipeline.transforms.excelwriter.ExcelWriterTransform.closeOutputFile(ExcelWriterTransform.java:320)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.hop.pipeline.transforms.excelwriter.ExcelWriterTransform.closeFiles(ExcelWriterTransform.java:244)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.hop.pipeline.transforms.excelwriter.ExcelWriterTransform.processRow(ExcelWriterTransform.java:234)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
org.apache.hop.pipeline.transform.RunThread.run(RunThread.java:55)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 -         at 
java.base/java.lang.Thread.run(Thread.java:829)
   2023/01/19 15:15:13 - Microsoft Excel 
pka_formula_and_chemical_lots_and_use.xlsx.0 - Finished processing (I=0, 
O=304196, R=304195, W=304195, U=0, E=1)
   2023/01/19 15:15:13 - pka_chemical_inventory - Pipeline duration : 42.376 
seconds [ 42.375" ]
   
   
   ### Issue Priority
   
   Priority: 3
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to