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!

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

Rajesh HiriyannaOct 21 2013 — edited Oct 22 2013

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

Comments

Sudipto Desmukh
Answer
Marked as Answer by greenly · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 19 2013
Added on Oct 21 2013
3 comments
963 views