topic Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set in Talend Studio

Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Mon, 18 Mar 2013 14:55:47 GMT

Hi,
We are currently encountering some issues with the taddCRCrow component.
The component is configured to calculate the CRC value based on 2 fields : ID_SHOP and ID_PRODUCT (screenshot 1).
But with several values like in the example (screenshot 2) it generates the same CRC value for 2 different combination of id_shop and id_product.
Do you have any explanation for this problem ?
Regards

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Mon, 18 Mar 2013 15:01:29 GMT

Hi,
Could it be the field length that causes this error?

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Mon, 18 Mar 2013 15:10:38 GMT

How so ?

Hi,
Could it be the field length that causes this error?

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Tue, 19 Mar 2013 04:01:58 GMT

Hi vpacquet,
Here is component reference tAddCRCRow with scenario.
In addition, perhaps the" field length" said by @saukema is the schema of tAddCRCRow(see my pic). Could you give us more information about your workflow and job design(by the way, screenshot1 is so small that it is hard to see its inner structure clearly), thanks a lot.
Best regards
Sabrina

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Tue, 19 Mar 2013 09:42:31 GMT

Hi,
I have added a better quality screenshot.
The job is fairly simple, i am just adding a CRC row to a data flow using the fields ID_SHOP and ID_PRODUCT.
I have a length of 12 for the ID_PRODUCT but the ID_SHOP doesn't have any field length. Could this be the problem ?
Regards,

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Mon, 18 Jan 2016 14:47:56 GMT

Hello,
i meet the same problem and i try several cases:
* with length
* without length
i just find one thing: when i set CRC type in "CRC16", the result is better, crc are different.
but it's not a good solution for me, a lower CRC can take more same results. . .
i work on Talend 5.6.1

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Mon, 18 Jan 2016 15:09:16 GMT

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Tue, 19 Jan 2016 04:11:18 GMT

Hi rlegrand,
Did you also repro this issue on Talend v 6.1?
Best regards
Sabrina

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Wed, 20 Jan 2016 14:11:10 GMT

i don't have this version.
i ask my colleagues if they have Talend 6.1 and if they can try it
after opening an issue on talend support, they tell me to don't use tConvertType with option " Set empty values to Null before converting", what is impossible.
So they open a jira:
https://jira.talendforge.org/browse/TDQ-11547

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Wed, 20 Jan 2016 14:37:56 GMT

ok, a colleague has the version 6.1.
He tries it and has exactly the same result

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Thu, 21 Jan 2016 09:07:38 GMT

Hi,
We have seen this jira issue: https://jira.talendforge.org/browse/TDI-35136 and will keep you posted.
Best regards
Sabrina

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Fri, 22 Jan 2016 13:26:32 GMT

I know, it's mine. . . but i'm a little bit disappointed. . . no solution because it's normal. . .
i only works on 24 millions adresses so 24 millions different CRC.
I calculate 1.6 millions CRC and compare it to the existing values to know if it is a insert or an update.
4374 CRC are found but they are not the same!
i can take some other examples. Do you think 4300 is little?

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Fri, 22 Jan 2016 13:33:01 GMT

Re: Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

Anonymous — Mon, 25 Jan 2016 06:27:07 GMT

Hi,
Our component developer has updated this jira issue: https://jira.talendforge.org/browse/TDI-35136, could you please take a look at it?
Feel free to add your comment in this jira issue.
Best regards
Sabrina