Talend components not doing anything after execution

Four Stars

Talend components not doing anything after execution

Hi All,

I am new to Talend and try to understand how Talend works. I have created a job in Talend, but it's not doing anything. For ex: I have put Delete, Truncate Insert logic on Sql Server database. But when I check data after job execution, nothing is happening. Below is the screen shot of my job. Please help. Below is the flow of my job.

 

1.I have used some gloabal variables in TSetGlobalVar

2. Then open a SQL server connection(tMSSqlConnection_1) on sub job ok

3. Then delete last three month data using above connection on sub job ok

4. then truncate a table using same connection on sub job ok

5. then use tFileList to loop through files in a directory

6. Fetch first row of file to get some header info.

7. Then use tMSSqlRow to fecth department from db

     "select DeptCode from AccountDeptMapping where DeptCode = '"+((String)globalMap.get("Department"))+"'"

8. Then set a gloabal variable "CheckDepartment" in tJavaRow

    if(row2.DeptCode == null || row2.DeptCode.isEmpty())
         globalMap.put("CheckDepartment","true");
   else
          globalMap.put("CheckDepartment","false");

9. And then put a Run IF trigger and add a condition - (String)globalMap.get("CheckDepartment") == "true"

10. Last, insert one record in log table if run condition is satisfied.

 

But nothing happen in backend, although I m getting variable values if I print. But nothing happen on backend. Many thanks for reply

 

 Talend Error.PNG


Accepted Solutions
Twelve Stars

Re: Talend components not doing anything after execution

it seems to be fine did you manage commit method?
can you run it on Traces Debug? (Run -> Debug Run -> Trace Debug)

 

Francois Denis

Tag as "solved" for others! Kudos to thanks!


All Replies
Twelve Stars

Re: Talend components not doing anything after execution

did you have any exécution log?

find it under run button.

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Talend components not doing anything after execution

Hi,

This is the execution log. I printed the file directory path and another variable which is null.

 

Starting job FinalOCR at 12:35 07/06/2018.

[statistics] connecting to socket on port 3830
[statistics] connected
D:\Software\OCR process\OCR Reports for New Accounts in SAFE Part 1
null
[statistics] disconnected
Job FinalOCR ended at 12:35 07/06/2018. [exit code=0]

Twelve Stars

Re: Talend components not doing anything after execution

it seems to be fine did you manage commit method?
can you run it on Traces Debug? (Run -> Debug Run -> Trace Debug)

 

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Talend components not doing anything after execution

thanks, after managing commit it's working fine.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download