Unable to use resource file from referenced project in main project job

[Anonymous]

Hi. I have a referenced project in my main project that contains a bunch of SQL files that I wish to re-use in my main job.

See screenshot below. I basically want to use the resource file from the referenced project as the file in a tFileInputRaw component.

To do this I created context variables in my job as type "Resource".

Then when selecting the resource in the Value column, I choose the resources from the referenced project, as it offered this as an option.

SO all seems fine, but I noticed, as you will notice, that the path put into the context screen are relative paths:

So when I run the job, it is looking for these resources in the main project, and not in the reference project, so it errors.

e.g.

[FATAL]: stevew_test.ao_04_ips_01_functions_0_1.AO_04_IPS_01_Functions - tFileInputRaw_1 File 'stevew_test\New_AO_Flow\AO_04_IPS\AO_04_IPS_01_Functions_0_1\resources\AO_Files\SQL_Files\IPS\IPS_Vendor_0.1.sql' does not exist

So what is the point in offering the opportunity to select a resource in the referenced project, if it's going to look for it in the main project instead? Defeats the object of offering the opportunity to select them.

[Anonymous]

Hello,

From your screenshots, there is no any referenced project from your Job Design folder or as a separate folder(Referenced Project).

Are you able to establish the connection between main and reference projects?

Please refer to this online documentation about: TalendHelpCenter: Working with referenced projects

[Anonymous]

Hi @Xiaodi Shi​ 

I'm afraid this has made no difference. I have merged the reference project with the main project, and the resources from the reference project are now available in the main project. But the error is still the same (see screenshot). I am the owner and admin of both projects

[Anonymous]