Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI-1226 and ODI-1241 errors during exectution of OdiUnZip_file

user2367815Feb 5 2019 — edited Feb 11 2019

Hello, I encounter curious error in OdiUnZip_file execution. Nobody use this ODI function in my company. My ODI administrtor has no answer to give me. It seems to be an unhandled exception of Java, but perhaps somebody in the world also encoutered  this problem and solved it ? File and Folder parameter are not the problem.

Hypothesis of missing of unzip soft : in our server odi, there is no particular installed soft to unzip file like WINZIP and so on. It is a Windows Server with its proper zip and unzip tool.

ODI-1226: Echec de l'étape OdiUnZip_file après 1 tentative(s).

ODI-1241: Echec de lexécution de loutil Oracle Data Integrator.

Caused By: Error while expanding my_folder\my_fichier.csv.gz (changed for example, it is not an error concerning file or folder )

java.io.IOException: Negative seek offset

at org.apache.tools.ant.taskdefs.Expand.expandFile(Expand.java:148)

at org.apache.tools.ant.taskdefs.Expand.execute(Expand.java:107)

at com.sunopsis.dwg.tools.UnZip.actionExecute(UnZip.java:86)

at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

at java.lang.Thread.run(Thread.java:662)

Caused by: java.io.IOException: Negative seek offset

at java.io.RandomAccessFile.seek(Native Method)

at org.apache.tools.zip.ZipFile.positionAtCentralDirectory(ZipFile.java:403)

at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:271)

at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:152)

at org.apache.tools.ant.taskdefs.Expand.expandFile(Expand.java:137)

... 21 more

--- Nested Exception ---

java.io.IOException: Negative seek offset

at java.io.RandomAccessFile.seek(Native Method)

at org.apache.tools.zip.ZipFile.positionAtCentralDirectory(ZipFile.java:403)

at org.apache.tools.zip.ZipFile.populateFromCentralDirectory(ZipFile.java:271)

at org.apache.tools.zip.ZipFile.<init>(ZipFile.java:152)

at org.apache.tools.ant.taskdefs.Expand.expandFile(Expand.java:137)

at org.apache.tools.ant.taskdefs.Expand.execute(Expand.java:107)

at com.sunopsis.dwg.tools.UnZip.actionExecute(UnZip.java:86)

at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)

at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)

at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)

at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)

at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)

at java.lang.Thread.run(Thread.java:662)

Comments

Post Details