This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Dec 3, 2012 8:14 PM by 727347 RSS

ODI Error while XML file to DB insertion scenario

727347 Newbie
Currently Being Moderated
I am trying to excute a scenario where it reads the XML file and inserts into the database.I am getting the below error, but I do have the complete write permission on the folders where the XML and XSD files reside.

Is this error points to verify the user permission in database side?Please help.

Caused By: java.sql.SQLException: ODI-40844: Could not generate the DTD because the file could not be created. Verify that you have write permission in the directory.
     at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.generateDTD(
     at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.<init>(
     at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.createNewSchema(
     at com.sunopsis.jdbc.driver.xml.SnpsXmlSchemaManager.getSchemaFromProperties(
     at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.internalExecute(
     at com.sunopsis.jdbc.driver.xml.SnpsXmlPreparedStatement.execute(
     at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(
     at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(
     at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(
     at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(
     at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(

Edited by: user8845111 on Nov 30, 2012 8:47 AM
1 2 Previous Next


  • Correct Answers - 10 points
  • Helpful Answers - 5 points