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.
Edited by: user8845111 on Nov 30, 2012 8:47 AM
It is in Unix environment.
I already gone tried the options mentioned in the links you have provided.
I am trying to understand whether the error message says permission issue.Is it in the DB( I understood it tried to create a schema from the xsd file passed) or in the unix server where I pass the XML and xSD file?
Thanks for your help.
I execute the scenario as "SUPERVISOR", should I need to check whether this user have the permission to access the XSD file? or the weblogic user which runs the ODI agent should have the access to XSD file?
Thanks for you help ...
I gave the complete read ,write,execute permission to all the directories...drwxrwxrwx - from /tmp level...
Looks like the DTD which was created by the process don't have the permission to write.Do you know how to provide write permission for the DTD file it creates?
Thanks in advance
Edited by: user8845111 on Nov 30, 2012 9:50 AM
If your studio is on windows, your agent is configure on linux/unix and you give the location for xsd/xml files as your linux/unix system you will get the error.
You should either use the local agent or configure the agent in windows.
Ideally, you should be able to access the location of the xsd/xml from the machine/server where you have configured your agent.
If you used local/windows agent and specify your unix location (provided you have mapped the unix directory to windows), you will not have any issue