Upgraded to 4.11.3 and crash on opening vendors

AndyNorrie 2018-10-25 16:31:55 UTC #1

Hello,

The upgrade from 4.9.5 to 4.11.3 went fine, but we see a n issue now:

1) Opening (almost any) vendor in the Vendors list gives an error:

ERROR: invalid byte sequence for encoding "UTF8": 0xc6 0x1c
CONTEXT: PL/pgSQL function formatbytea(bytea) line 5 at RETURN
(22021) QPSQL: Unable to create query

Any idea how we fix this? The vendor screen will still open but everything is blank, This happens on most, but not all vendors. I cannot see an obvious difference between the ones that do and don't work!

AndyNorrie 2018-10-25 16:41:17 UTC #2

From the error trace, it looks like it is related to decryption of the bank routing numbers. It may be relevant that we do not store account numbers or routing codes in xTuple so we don't really care if we 'lose' this data, just that the screen works

The 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 FROM vendinfo JOIN crmacct ON (vend_id=crmacct_vend_id) WHERE (vend_id=:3 );