3 Replies Latest reply: Oct 22, 2013 7:26 AM by Rajesh Hiriyanna RSS

    Getting ODI-228 : SQL Anywhere error: Operation failed on the file due to file permissions issue

    Rajesh Hiriyanna

      Hi ,

      We are trying to load data from DB2 source to Sybase IQ target using ODI. We have made the staging area on Target itself.

      The LKM we are using for this is LKM SQL to SYBASE IQ (LOAD TABLE).

      We are developed the interface on windows and pointed to the agent is running on HP-UX target machine. When we execute the interface, a dump file is getting created on the temporary directory specified but it is failing at the load command with the following error.

      ODI-1228: Task SrcSet0 (Loading) fails on the target SYBASE_AS_IQ connection TRGT_XXX_DW.
      Caused By: com.sybase.jdbc4.jdbc.SybSQLException: SQL Anywhere Error -1006148: Operation failed on file due to file permissions. File: /tmp/C$_0_XXX_TARG_ODI.dmp.


      If login to the  /tmp  directory and give chmod 755 /tmp/C$_0_XXX_TARG_ODI.dmp then try to restart from the session , session is completing.


      Could you please let me know how can in automate this command because XX.dmp file being generated is dynamic and how can i integrate this.


      Thanks,

      Rajesh