Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: EXCEL Input htrows error jxl.common.AssertionFailed

  1. #1
    Join Date
    Feb 2011
    Posts
    2

    Default EXCEL Input htrows error jxl.common.AssertionFailed

    Hi,

    I am trying to take an excel sheet as input which has image in it.
    When i try it with Kettle 4.1.4r version and jdk1.6.0._04 version on one machine then it is working fine and i am able to dp preview rows for the input Excell file.

    But when i migrated the transformation to another machine with same pentaho and jdk version then it throws the below error:
    jxl.common.AssertionFailed
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.common.Assert.verify(Assert.java:37)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.DrawingData.initialize(DrawingData.java:74)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.DrawingData.getSpContainer(DrawingData.java:207)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.Drawing.initialize(Drawing.java:326)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.Drawing.getObjectId(Drawing.java:449)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.DrawingGroup.addDrawing(DrawingGroup.java:212)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.Drawing.<init>(Drawing.java:240)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.SheetReader.handleObjectRecord(SheetReader.java:1620)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.SheetReader.read(SheetReader.java:1059)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:290)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.steps.excelinput.jxl.XLSWorkbook.getSheet(XLSWorkbook.java:40)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:614)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:455)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at java.lang.Thread.run(Thread.java:619)


    Is it dependent on some other machine configurations also??

    Can anyone suggest?

    Thanks,
    Neha

  2. #2
    Join Date
    May 2012
    Posts
    19

    Default Issue is with Excel Input step that have and image.

    Hello ,

    I am also getting the same error while trying to process the file in linux server.
    The process runs fine in Windows server.
    Please let me know if We have to make some changes for linux server.

    INFO 03-09 19:08:40,552 - update_visit_trend_mobile - Dispatching started for transformation [update_visit_trend_mobile]
    Warning: Object record is not associated with a drawing record - ignoring
    Warning: Cannot find drawing record - using continue record
    ERROR 03-09 19:08:44,137 - Microsoft Excel Input - Error processing row from Excel file [/tmp/hourly-visitor-mobiles_tablets.xls] : java.lang.NullPointerException
    ERROR 03-09 19:08:44,137 - Microsoft Excel Input - java.lang.NullPointerException
    at jxl.biff.drawing.Drawing.<init>(Drawing.java:240)
    at jxl.read.biff.SheetReader.handleObjectRecord(SheetReader.java:1619)
    at jxl.read.biff.SheetReader.read(SheetReader.java:1052)
    at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
    at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:252)
    at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:285)
    at org.pentaho.di.trans.steps.excelinput.jxl.XLSWorkbook.getSheet(XLSWorkbook.java:41)
    at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:617)
    at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:458)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    at java.lang.Thread.run(Thread.java:679)




    Quote Originally Posted by Neha View Post
    Hi,

    I am trying to take an excel sheet as input which has image in it.
    When i try it with Kettle 4.1.4r version and jdk1.6.0._04 version on one machine then it is working fine and i am able to dp preview rows for the input Excell file.

    But when i migrated the transformation to another machine with same pentaho and jdk version then it throws the below error:
    jxl.common.AssertionFailed
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.common.Assert.verify(Assert.java:37)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.DrawingData.initialize(DrawingData.java:74)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.DrawingData.getSpContainer(DrawingData.java:207)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.Drawing.initialize(Drawing.java:326)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.Drawing.getObjectId(Drawing.java:449)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.DrawingGroup.addDrawing(DrawingGroup.java:212)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.biff.drawing.Drawing.<init>(Drawing.java:240)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.SheetReader.handleObjectRecord(SheetReader.java:1620)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.SheetReader.read(SheetReader.java:1059)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.SheetImpl.readSheet(SheetImpl.java:716)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:257)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at jxl.read.biff.WorkbookParser.getSheet(WorkbookParser.java:290)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.steps.excelinput.jxl.XLSWorkbook.getSheet(XLSWorkbook.java:40)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:614)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:455)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/08/03 05:53:27 - Excel Input.0 - ERROR (version 4.1.4, build 15487 from 2011-07-06 09.14.19 by tomcat) : at java.lang.Thread.run(Thread.java:619)


    Is it dependent on some other machine configurations also??

    Can anyone suggest?

    Thanks,
    Neha

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2017 Pentaho Corporation. All Rights Reserved.