topic Re: tFileInputProperties - Unable to load file in Talend Studio

tFileInputProperties - Unable to load file

pbz1983 — Tue, 06 Nov 2018 16:02:29 GMT

Hi,

Since upgrading to TOS 7.1.1 I am unable to initiate the property file and load the information into my project.

My property files are located in folder C:\settings
Workspace (6.5) is located at C:\talend\TOS_DI-Win32-20180116_1512-V6.5.1\workspace
Workspace (7.1.1) is located at C:\talend\TOS_DI-Win32-20181026_1147-V7.1.1\workspace

In tFileInputProperties the filename path = "../../SETTINGS/branch.Properties"

I have never had any issues previously but when trying to run the same project (exported from 6.5 > 7.1) the file will not load.

Exception in component tFileInputProperties_1 (BRANCH)
java.io.FileNotFoundException: ..\..\SETTINGS\BRANCH.Properties (The system cannot find the path specified)

If I enter the full path "C:/SETTINGS/branch.Properties" then it works.

Any ideas?

Thanks in advance.

Re: tFileInputProperties - Unable to load file

Anonymous — Thu, 08 Nov 2018 04:43:28 GMT

Hello,

Is there any a permissions issue for 7.1.1? Are you able to load file when create a new job in v 7.1.1( In tFileInputProperties the filename path = "../../SETTINGS/branch.Properties")

Best regards

Sabrina

Best regards

Sabrina

Re: tFileInputProperties - Unable to load file

pbz1983 — Thu, 08 Nov 2018 09:29:13 GMT

Hi Sabrina,

There are no permission issues, same install procedure, no elevated privileges.

Only difference is the version of TOS that I am running.

I have now created a new project directly in 7.1.1 and added the components.

I receive exactly the same issue.

Can you replicate the error?

Old workspace = C:\talend\TOS_DI-Win32-20181026_1147-V7.1.1\workspace\PBZ

New workspace = C:\talend\TOS_DI-Win32-20180116_1512-V6.5.1\workspace\PBZ

Re: tFileInputProperties - Unable to load file

Anonymous — Thu, 08 Nov 2018 09:57:25 GMT

Hello,

Is there any difference for administrator( domain admin or local admin)?

Best regards

Sabrina

Re: tFileInputProperties - Unable to load file

pbz1983 — Thu, 08 Nov 2018 11:18:21 GMT

Hi,

I don't have access as administrator within my organisation.

Although I have 3x types of accounts that I can use on the domain......

Regular user
SVC account
ADM account

The absolute path works for all accounts and there are no restrictions on the folder (C:\Settings).

It's only when using the relative path it can't locate the file.

Works with 6.5 but just not with 7.1

Re: tFileInputProperties - Unable to load file

pbz1983 — Sun, 08 Mar 2020 15:22:11 GMT

Just in case this helps anyone, I figured out the isssue and created a workaround

In my earlier thread I used the below......which always worked

6.5 propery file path = "../../SETTINGS/x.Properties"

When upgrading to Talend 7.1 this stopped working.

The solution was to add an extra / at the beginning of the string

7.1 property file path = "/../../SETTINGS/x.Properties"

However, I also figured that although that solves my issue on my local machine (laptop running talend 7*) the new path failed on the server once the project was published (Windows Server 2012 R2). The server only recognises the previous naming convention used in 6.5.

So in all my projects, I have applied the below logic where it will try one format and then the other.

Local = "/../../SETTINGS/x.Properties"

Server = "../../SETTINGS/x.Properties"

example2.png