Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to deploy the changes to Talend TMC with new azure connections as source.
I encounter this error
Execution a47cf8d4-7f0e-4fcf-aa6b-2820f812c36d failed with code 1 and error Job stopped with errors or unable to run. Exception in component tRunJob_4 (PIMS_to_Getpaid_ODS) java.lang.RuntimeException: Child job running failed. java.sql.SQLException: The syntax of the connection URL 'jdbc:jtds:sqlserver://;appName=GETPAID;' is invalid.
here are the details
additional parameters:
encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;;authentication=ActiveDirectoryPassword
host:
axxpsqlxx.database.windows.net
port:
1433
User:
xyz_DEV@xyz.org.uk
can someone provide info on this pls
Hello,
Does this change perfectly fine when you run it in studio? If it runs fine in studio, are you using context value in it?
Note: The context that gets used is based strictly on the name of the environment in TMC (and goes to the default if the environment doesn't match any of the contexts).
Best regards
Sabrina
Hi
It using the dev environment context
In the SQL I have used Azure linked server and passing that as a context name
Example
Context.linkedservername.dbname.dbo.tablename, when I deactivate this sub job and deploy into TMC it's working fine.
Then I have removed the linked server context variable and pass dbname.dbo.tablename (this database exists in on prem too).
Hello,
In the main job, everything works fine BUT not in the child job when publishing your job into TMC?
The variable name should be the same both in main job and child job, and make sure the 'transmit whole context' box is checked on tRunJob.
Refer to this topic, there should be an environment called Prod in TMC, and select the workspace from Prod in the workspace list when publish the job to Talend Cloud.
Hope it helps.
Best regards
Sabrina
Hi
Transmit whole context is on.
here is the scenario
two separate jobs A and B ;one child job C.
C is called from both A and B . When A calls C its working but B calls C it fails both mains jobs uses same context parameter .so confused what causing the invalid db name as per error .
here using azure linked server in on prem database. Thanks