• Index
  •  » Talend Enterprise Data Integration » General questions
  •  » Problem while using tLogCatcher with DB MS SQL Server ---TOS

#1 2011-10-19 10:49:18

asa436
Member
Registered: 2011-09-19
Posts: 21

Problem while using tLogCatcher with DB MS SQL Server ---TOS

tLogCatcher (TOS) can not store information in MS SQL Server even die on error option is checked,but it work fine with Teradata DB ,why is so?
also tlogcatcher cannot store information regarding component error message as shown in run console prompt (like tTeradatainput component error message display in red colour in run console window)which can be used to send error message via tSendMail using  ((String)globalMap.get("tContextLoad_1_ERROR_MESSAGE")) or use row1.message  in the message body of email component ????

secondly if we use tCreateTable component and select if not exist then create or drop if exist and create in action dropdown box its not work only work if table is create first not during job,also table with same name and structure but in different DB like DB_A and DB_B not created as gives table already exist ,why is so?

Offline

#2 2011-10-20 14:41:38

shong
Talend team
Registered: 2007-08-29
Posts: 10299
Website

Re: Problem while using tLogCatcher with DB MS SQL Server ---TOS

Hi

I am sure the tLogCatcher can capture the error and log them into MS SQL server. In your case, what's the error message? Can you upload a screenshot of job?

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2011-10-20 15:40:01

asa436
Member
Registered: 2011-09-19
Posts: 21

Re: Problem while using tLogCatcher with DB MS SQL Server ---TOS

the image is uploaded its neither show an error nor it record in tlogcatcher DB which is MS SQL Server even checked die on error .... also is tLogcatcher catch the error display in red colour in the run console windows


Uploaded Images

Offline

#4 2011-10-21 14:15:44

shong
Talend team
Registered: 2007-08-29
Posts: 10299
Website

Re: Problem while using tLogCatcher with DB MS SQL Server ---TOS

Hi
What's the error message thrown on the console? There should be an exception message on console if the job works failure.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

  • Index
  •  » Talend Enterprise Data Integration » General questions
  •  » Problem while using tLogCatcher with DB MS SQL Server ---TOS

Board footer

Powered by FluxBB