Talend 4.2.3 taddCRCrow same CRC value for 2 different data set

[Anonymous]

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

[Anonymous]

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

[Anonymous]

How so ?

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

[Anonymous]

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

[Anonymous]

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,

[Anonymous]

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

[Anonymous]

if you want my example: (don't forget the space for the postal code after: "3498 "), all others have a trim
CRC is made on the 6 fields
.-----------+--------------------+---------------+-----------+-----------+------+----------.
| tLogRow_2 |
|=----------+--------------------+---------------+-----------+-----------+------+---------=|
|NUMERO_VOIE|ADRESSE_LIGNE_1 |ADRESSE_LIGNE_2|CODE_POSTAL|COMMUNE |PAYS |CRC |
|=----------+--------------------+---------------+-----------+-----------+------+---------=|
|924 |CHEMIN DE PEYROT |null |31620 |BOULOC |FRANCE|278186796 |
|null |3498 rue de la pomme|null |3498 |Commune3498|null |1853816814|
'-----------+--------------------+---------------+-----------+-----------+------+----------'

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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