using xTuple 5.0.0 Windows
After adding several hundred vendors, I was eager to view my results.
Clicking on an individual vendor I receive the error.
ERROR: decrypt error: Data not a multiple of block size
(39000) QPSQL: Unable to create query
SELECT vendinfo.*, crmacct_id, crmacct_owner_username, CASE WHEN LENGTH(vend_ach_routingnumber) > 0 THEN formatbytea(decrypt(setbytea(vend_ach_routingnumber), setbytea(:1 ), 'bf')) ELSE '' END AS routingnum, CASE WHEN LENGTH(vend_ach_accntnumber) > 0 THEN formatbytea(decrypt(setbytea(vend_ach_accntnumber), setbytea(:2 ), 'bf')) ELSE '' END AS accntnum, COALESCE(vend_tax_exemption, fetchMetricText('AvalaraPurchaseExemptionCode')) AS tax_exemption FROM vendinfo JOIN crmacct ON (vend_crmacct_id=crmacct_id) WHERE (vend_id=:3 );
:1: To improve is to change. To be perfect is to change often.
:2: To improve is to change. To be perfect is to change often.
I do like the personal touch of wisdom, that is our corporate philosophy.
Anyway, it seems that the two columns vend_ach_routingnumber and vend_ach_accntnumber are not actually set to null (the length == 1) even though I did not enter any data for these two columns.
So for now, can I null out these two columns, for now?