File Excel - Preview Fails With Permission Denied.

Five Stars

File Excel - Preview Fails With Permission Denied.

Hi,

 

I recently upgraded (installed side by side in different directories) from Talend Open Studio For Big Data 6.2 to 7. I am running the Linux 64 bit edition. The problem I am getting is that I can't create File Excel metadata objects for one installation (I have 3 separate installations for 3 separate users). For one user I always get a permission denied error. I have checked the file system permissions and they seem fine. I did make a mistake of selecting the wrong jar file (jxl.jar instead of jxl-wizard.jar) for the first time when trying to open the XLSX file for the user that doesn't work. I thought I had fixed this by doing Window > Show View... > Modules > and then reinstalling the correct file.  This didn't work so I even deleted the entire installation and started again by reimporting the version 6.2 workspace into 7. I was asked to reinstall the jars and I made sure I selected the right ones but the error remains. The interesting thing is when I try with the other 2 different users it works fine. I didn't make the mistake of selecting the wrong jar on those users. Comparing installed jar files I believe that the correct jars are installed. I can't seem to work this our and searching the web hasn't really helped.

 

Here are some screen shots to help with context.

 

Permissions:

permissions.png

Error:

error.png

 

 

Modules

modules.png

Trying On A Different User (Not talenduser who owns the file)

other-user-works.png

 

 

Note: the other 2 user's modules look the same as the above screenshot.

 

So my questions are:

  • Is the way I am trying to confirm that the modules are installed correctly the correct way to do this?
  • How can I uninstall modules and reinstall them?
  • Is there anything else that I am missing?

 

Thanks in advance for your time and help. I can provide other information if necessary.

 

Dallas.


Accepted Solutions
Five Stars

Re: File Excel - Preview Fails With Permission Denied.

So the problem appears to be from when I created profile 1's project workspace. I created profile 1's project workspace by copying profile 2's project workspace. There seems to have been a linking of the profiles, so when profile 1 did some work it would create files inside of profile 2's workspace. It was a file system permission issue in the end. There were files inside of profile 2 that had the permissions of rw-rw-r to the owner of profile 1: profile 1, so when profile 2 tried to overwrite them it got permission denied.


All Replies
Ten Stars

Re: File Excel - Preview Fails With Permission Denied.

Very strange!
Run a sh command and see if there are jar-files 'left' ?
Could it be your java environment ? do you point to your sdk (same as workstations)? JAVA_HOME
Is the login of unix ( .profile ) the same?
In talend, preferences are the same as other users?
Are you able to read a csv file from the same dir?
Five Stars

Re: File Excel - Preview Fails With Permission Denied.

Thanks for the reply and your time so far. It is very strange indeed, it is probably just something simple that I am missing. Here are my answers to your questions.

 

  • Where should I be looking for the jar files?
  • The JRE/JDK (Java 1.8) for Profile 1 and 2 is the same, Profile 3 is the same version but on another server.
  • From my understanding the profiles are working like this:
    • Profile 1 is me on the dev/test server. I use this to do dev builds. I can then sudo into: <- My user is working
      • Profile 2 is talenduser on the dev/test server, it is used for test environment. <- This user isn't working
      • Profile 3 is talenduser on prod server. <- This user is working but on a different server
  • As far as I know all the settings are the same internally as I haven't changed anything after installing Talend 7, the only differences between Profile 1/2 and 3 is things like the database connection settings (i.e. other Metadata objects) and the server the data is on.
    • Does the workspace store program settings? If so then the settings might be different.
  • Profile 1 and 2 are reading from the same location (Profile 2 home directory)
    • Profile 1 can read it (the successful screenshot above)
    • Profile 2 can't read it (the error screenshot above)
      • This profile owns all the files and can access them fine in the file system and other programs. This is why I think it is a Talend issue but I can't pin it down yet.
Five Stars

Re: File Excel - Preview Fails With Permission Denied.

So the problem appears to be from when I created profile 1's project workspace. I created profile 1's project workspace by copying profile 2's project workspace. There seems to have been a linking of the profiles, so when profile 1 did some work it would create files inside of profile 2's workspace. It was a file system permission issue in the end. There were files inside of profile 2 that had the permissions of rw-rw-r to the owner of profile 1: profile 1, so when profile 2 tried to overwrite them it got permission denied.