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.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download