2 Replies Latest reply: Jul 31, 2013 3:20 AM by user9210815 RSS

    issue with ODI LKM datapump when using NFS location

    user9210815
      Hi,

      I have developed an ODI interface which transfers data from one database to another. For the dump to be created I am using a NFS location. But the LKM errors out while trying to create the dump file. The stack trace is as below. I have also run the nfsstat command and below are the properties with which the NFS was monuted.

      Flags: vers=3,proto=tcp,sec=sys,hard,intr,link,symlink,acl,devs,rsize=32768,wsize=32768,retrans=5,timeo=600
      Attr cache: acregmin=3,acregmax=60,acdirmin=30,acdirmax=60

      Note: The log is getting created successfully in the path.

      Could you please guide me on this issue. Thank you.

      ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection ORACLE_INTG_ORMSSTG_DEV_ER9.
      Caused By: java.sql.SQLException: ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
      ORA-31641: unable to create dump file *" NFS PATH/X370574051.exp"*
      ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
      Additional information: 3

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
           at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1079)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
           at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3937)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1535)
           at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
           at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
           at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
           at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2906)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537)
           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453)
           at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:338)
           at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:272)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:263)
           at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:822)
           at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123)
           at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
           at java.lang.Thread.run(Thread.java:662)