Problems with encrypted fields.

[Stanimir Todorov <st...@iguanait.com>]

Hi all, 
I have a task to import a lot of data into a new database. Some of the
fields are encrypted. And these fields does a problem.
I have all data in properly xml files. For example <Number
partyId="10000" PersonalNumber="7777777" />.
I am using webtools->XML Data Import Dir with a argument "Create "Dummy"
FKs". In this way I imported the all xmls from the directory at once.
And all that works very well.
The problems come when I restart the server. Then the personalNumber
that shown in user interface is not "7777777", but looks encrypted
something like "74a871acbf060dda5fc7260d05a5924a". And could not be
decrypt, I got the following error:
Problem decrypting field [Number / personalNumber]
     [java] ---- exception report
----------------------------------------------------------
     [java] Problem decrypting field [Number / personalNumber]
     [java] Exception: org.ofbiz.entity.EntityCryptoException
     [java] Message: Given final block not properly padded
     [java] ---- stack trace
---------------------------------------------------------------

I am using for now Derby DB. But the same problem appears on the
Postgres DB also. What is the different after the restart?

Other problem is that I can not search by encrypted fields for example
PersonalNumber or Credit Card Number. I need this feature. Is it
possible to search by encrypted fields? I try thru the Webtools but
unsuccessful.

I will appreciate all advices, Thanks!
Stanimir