Actually transforming this column to a string got the problem worse. It is appearing not only 0e characters but others like square or like "kanji" style.
Original Message:
Sent: Mon July 03, 2023 09:51 AM
From: Tammy Ziegler
Subject: National ID Depersonalisation failing.
In your LUA script, try changing:
optim.target.setcolumnvalue(newvalue)
to
optim.target.setcolumnvalue(tostring(newvalue))
------------------------------
----------------------------------------------
Tammy Ziegler
tziegler@abmartin.com
Original Message:
Sent: Mon July 03, 2023 07:52 AM
From: Matheus Rocha
Subject: National ID Depersonalisation failing.
Hello, Tammy!
Thank you for your answer!
Here we go:
My source database (DB2) does not have records with those weird characters when I search for them (I use DbVisualizer). I can see those odd numbers after the convert service (Optim convert file) and on the database after the Insert service.
The Column type is a VARCHAR of 20 characters (Only using 11).
I can see them during the Convert step, in the file, and in the database after the insert.
If I insert them without masking, it inserts normally.
It is not about the display type on the application, because when I run the Convert (Optim Manager), I coded to print the value and the result is the same as I can see in the database.
------------------------------
Matheus Rocha
Original Message:
Sent: Fri June 30, 2023 05:12 PM
From: Tammy Ziegler
Subject: National ID Depersonalisation failing.
Matheus,
There are a lot of things that could be causing this problem. The most obvious would be the application client being used to display the data. You are going to have to get your hands dirty on this one and start eliminating possibilities. Go through the data masking process one step at a time and try to find out where the data is being changed.
Here are some questions and ideas to get you started.
What application or client are you using that is showing you those results?
Do you get the same results when using that client to look at the source (pre-masked) data?
What is the data type of the column?
Are you getting these results after you load the masked data into the data source or is Optim browse giving you these results?
What happens if you load the unmasked data into the source, will it also change the values?
It is possible that there is no problem with the data in the database, but rather that the client displaying the numeric data is putting it into scientific notation?
If you can rule out that the program displaying the data is not changing anything, then look at the data types. Verify if the columns giving you that result are in fact a numeric type column. Perhaps the data source is defining the scientific format for numeric display.
If the columns are a character type column, then it may help to look at the specific area where the data is being modified. The column map for example.
I hope this helps/
--
Tammy Ziegler
Data Security and Privacy Specialist
www.abmartin.com
Cell: (908) 209-8819
Original Message:
Sent: 6/29/2023 3:01:00 AM
From: Matheus Rocha
Subject: RE: National ID Depersonalisation failing.
Hello, Thammy!
Yep, No problem!
if (oldvalue ~= nil) then
if (oldvalue > '0') then
P9 = 10
while (P9==10)
do
P1 = math.random(0,9)
P2 = math.random(0,9)
P3 = math.random(0,9)
P4 = math.random(0,9)
P5 = math.random(0,9)
P6 = math.random(0,9)
P7 = math.random(0,9)
P8 = math.random(0,9)
SOM = 9*P1+8*P2+7*P3+6*P4+5*P5+4*P6+3*P7+2*P8
P9 = (SOM%11)
end
BSN = (P1..P2..P3..P4..P5..P6..P7..P8..P9)
-- print("BSN : ",BSN)
newvalue = BSN
else
newvalue = oldvalue
end
else
newvalue = oldvalue
end
-- print ("newvalue : ", newvalue)
optim.target.setcolumnvalue(newvalue)
end
------------------------------
Matheus Rocha
Original Message:
Sent: Wed June 28, 2023 09:05 AM
From: Tammy Ziegler
Subject: National ID Depersonalisation failing.
Matheus,
Can you share the LUA script or column map function that is generating the result.
Tammy
Original Message:
Sent: 6/27/2023 4:01:00 AM
From: Matheus Rocha
Subject: National ID Depersonalisation failing.
Dear Community,
I am experiencing a weird bug on Optim that is for creating National Id's via Optim Policy or LUa Script, I am getting a result of numbers like:
| NATIONALREGISTRATIONNUMBER |
| 0.0e+00014252776 |
| 0.0e+00019166783 |
| 0.0e+00021575150.0e+ |
| 0.0e+00023969477 |
| 0.0e+00025298768 |
| 0.0e+00026926544 |
This started to happen after our company migrated from Optim 11.5 to 11.7. there is anyone that experienced this bug? if yes how you solve it?
Kind Regards,
Matheus Rocha
------------------------------
Matheus Rocha
------------------------------