Visokio website     Downloads     Video tutorials     KnowledgeBase  
Scheduler Error: extra sheet exists when it opens the Excel file? - Visokio Forums
Scheduler Error: extra sheet exists when it opens the Excel file?
  • JamesPC December 4, 2015 9:17AM
    A batch file was meant to import a Excel file using the Omniscope reader then some logic gets applied and it ouputs, however the following error occurred. I think it's looking for another worksheet from Excel:

    Chain action "omniscope" failure:
    Error publishing block "Data file output 2"
    com.visokio.util.jy: Error publishing block "Data file output 2"
    at com.visokio.ent.actions.files.PublishDataManagerOutputBlocks.a(PublishDataManagerOutputBlocks.java:47)
    at com.visokio.ent.actions.FileAction.a(FileAction.java:34)
    at com.visokio.ent.actions.ChainAction.a(ChainAction.java:20)
    at com.visokio.ent.actions.ChainAction.a(ChainAction.java:40)
    at com.visokio.ent.actions.f.v(f.java:5)
    at com.visokio.ent.actions.f.i(f.java:4)
    at com.visokio.util.ut.run(ut.java:3)
    at com.visokio.mxc.a(mxc.java:1)
    at com.visokio.util.sy.a(sy.java:65)
    at com.visokio.util.sy.a(sy.java:241)
    at com.visokio.util.go.r(go.java:56)
    at com.visokio.util.ph.s(ph.java:5)
    at com.visokio.util.mh.o(mh.java:56)
    at com.visokio.util.lh.l(lh.java:4)
    at com.visokio.util.lh.a(lh.java:93)
    at com.visokio.util.y3.run(y3.java:3)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Caused by: org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException: A part with the name '/xl/worksheets/sheet2.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12]
    at org.apache.poi.openxml4j.opc.OPCPackage.createPart(OPCPackage.java:777)
    at org.apache.poi.openxml4j.opc.OPCPackage.createPart(OPCPackage.java:741)
    at org.apache.poi.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:373)
    at org.apache.poi.POIXMLDocumentPart.createRelationship(POIXMLDocumentPart.java:357)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:661)
    at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:81)
    at com.visokio.ms.th.d(th.java:42)
    at com.visokio.ms.rh.a(rh.java:131)
    at com.visokio.ms.rh.a(rh.java:65)
    at com.visokio.ms.li.a(li.java:13)
    at com.visokio.tvb.b(tvb.java:1)
    at com.visokio.svb.a(svb.java:42)
    at com.visokio.util.res.l.g(l.java:115)
    at com.visokio.util.res.l.(l.java:145)
    at com.visokio.svb.c(svb.java:29)
    at com.visokio.svb.a(svb.java:57)
    at com.visokio.svb.b(svb.java:34)
    at com.visokio.svb.a(svb.java:31)
    at com.visokio.mff.a(mff.java:28)
    at com.visokio.mff.a(mff.java:14)
    at com.visokio.mff.a(mff.java:7)
    at com.visokio.lpd.a(lpd.java:147)
    at com.visokio.lpd.a(lpd.java:144)
    at com.visokio.amd.b(amd.java:22)
    at com.visokio.zld.a(zld.java:23)
    at com.visokio.datamanager.c6.run(c6.java:9)
    at com.visokio.mxc.a(mxc.java:1)
    at com.visokio.util.sy.a(sy.java:28)
    at com.visokio.util.sy.a(sy.java:123)
    at com.visokio.datamanager.hmb.a(hmb.java:79)
    at com.visokio.ent.actions.files.PublishDataManagerOutputBlocks.a(PublishDataManagerOutputBlocks.java:29)
    ... 18 more

    any ideas?
  • 2 Comments
  • JamesPC December 4, 2015 9:26AM
    Just like to point out this was on the server, when run manually it was fine.
  •     paola December 8, 2015 5:54AM
    James, I sent you an email. Please check the errors identified and notify our support if the problem is still there.
    Thanks

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership