Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
CGUERIF1652348112
Contributor
Contributor

Problem executing a powershell script on the talend administration center

Hi,

I need help on a issue with the talend administration center.

I created a powershell script that updates excel files on a network drive. Updates are mainly conditional formatting and header formatting.

In my Job Talend, I just have a TSystem with the command : "powershell ////server//script/script.ps1".

I deployed the Job on the Talend administration center and i execute it.

The script starts, opens the excel files but does nothing and the excel files are not modified. In the Task Manager, i see the excel files open and close very quickly.

If i start the job from IDE Talend or even just by double clicking on the powershell script, the excel files are modified and saved.

The user who launch the powershell script on the talend administration center has all rights on the network drive.

Thank you beforehand for your answers.

Labels (2)
1 Reply
Anonymous
Not applicable

Hello

The job execution successfully finished? Open the execution log and check the status, if fails, check any useful information on there. The user who launches the Job Server should the rights to access network drive and the excel files.

 

Regards

Shong