3 Replies Latest reply on Oct 22, 2013 12:26 PM by Rajesh Hiriyanna

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

Rajesh Hiriyanna Oct 21, 2013 5:23 AM

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

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

Rajesh Hiriyanna Oct 22, 2013 10:03 AM (in response to Rajesh Hiriyanna)

Hi,

I gave full permissions to the directory where the file was getting created and set umask 022 in .profile file, logged out and logged in back,still files were getting created like one below,
-rw-r----- 21 xxx xxx Oct 21 2013 C$_0_XXX_TARG_ODI.dmp
Got doubt somewhere the umask value was getting overridden.

This i found it in oraparams.sh, , where the a umask is set to 026 that would mean if you start an agent then any file being created by the agent would have these permissions

Finally changed the umask value to 022 and we were able to load the data into target.
umask value is in DO NOT EDIT section of odiparams.sh.

Thanks,
Rajesh H
Like Show 0 Likes(0)

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

RAM_STUDENT Oct 22, 2013 12:08 PM (in response to Rajesh Hiriyanna)

Request you Admin to grant Privileges to your folder as rwxrwxrwx, folder where you place your file.
this may help.
else check for unix command.
Like Show 0 Likes(0)

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

Rajesh Hiriyanna Oct 22, 2013 12:26 PM (in response to RAM_STUDENT)

Thanks for the reply,

Yes,

That was done.
The user used for agent is same as the use i used to login i.e. is ora11g.
i login into machine as ora11g and create files then its is having all the permissions. If i start the agent and run the interface that creates the dump file then permissions are stripped off.
Everywhere only ora11g is used including installation.

Thanks,
Rajesh H
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.