PDA

View Full Version : EXCEL Input htrows error jxl.common.AssertionFailed



Neha
08-03-2011, 05:55 AM
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

ppatnaik
09-03-2013, 09:44 AM
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)





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