Seven Stars

Data integration

Dear folks
Am using ms SQL server database for input and my output is MySQL database.
My input table has a column named is testdate with DATETIME datatype. My output data will be sorted according to date. While am doing this an error occur with incompatible operand types date and string. How can I resolve this ?
1 ACCEPTED SOLUTION

Accepted Solutions
Thirteen Stars TRF
Thirteen Stars

Re: Data integration

Hi,
When you run your from the Studio, the number of rows coming from each component is displayed on top of the line which represents the flow.
If you have just 100 rows but more than 100 on target database (this is your problem, isn't it?) you probably have remaining rows in target database when the job starts. If you are sure there is no rows in the database and just 100 or less arriving to the tMySQLOutput component, you have to verify you have not a database trigger which generates new rows automagically.
Let us know.

TRF
8 REPLIES
Thirteen Stars TRF
Thirteen Stars

Re: Data integration

Hi,
"...an error..." but which one?
How can we help you if we don't know that?
My instinct says probably a problem due to date format. To be confirmed.

TRF
Seven Stars

Re: Data integration

In tmap Expression Builder ..Select TalendDate from Categories after that select function parseDate("yyyy-MM-dd HH:mm:ss","")
And type current date or which date data u want to move in your output in parseDate("yyyy-MM-dd HH:mm:ss","2018-01-27 00:00:00")


Seven Stars

Re: Data integration

TalendDate.parseDate("yyyy-MM-dd HH :mm:ss ","2018-01-27 00:00:00")

It will written in Expression Builder and if u want to move only male category data than click on activate/unactivate expression filter and type your condition like row1.gender==male
Moderator

Re: Data integration

Hello,

Could you please post your job setting screenshots on forum which will be helpful for us to address your issue?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: Data integration

date_tmap.jpggo_daddy_graphical.JPGdatetime.JPG

 

My job is running successfully But my MS SQL Server particular date data is not correctly show in my output database MYSQL. i mean my database is related to medical. everyday people tests record save in my database ReadMail. suppose 31 january 100 people done their test when am move ReadEmail to output database newread than their will be more than 100 tests. 
Ten Stars

Re: Data integration

You need to change the data format of tmap out put schema to required. like (yyyy-MM-dd HH :mm:ss)

Manohar B
Thirteen Stars TRF
Thirteen Stars

Re: Data integration

Hi,
When you run your from the Studio, the number of rows coming from each component is displayed on top of the line which represents the flow.
If you have just 100 rows but more than 100 on target database (this is your problem, isn't it?) you probably have remaining rows in target database when the job starts. If you are sure there is no rows in the database and just 100 or less arriving to the tMySQLOutput component, you have to verify you have not a database trigger which generates new rows automagically.
Let us know.

TRF
Seven Stars

Re: Data integration

Hello sir 

if you know whats my issue than provide me solution. what i will do ?