xTuple.com xTupleU Blog & News Customer Support

Upgraded to 4.11.3 and crash on opening vendors

Current functionality
#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!

#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 :slight_smile:

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 );