Error Creating B2B customer from backoffice in hybris version 1905

[Former Member]

In Hybris 1905 null pointer exception is being thrown while saving new B2B customer from backoffice .

Failed to persist audit records (sql: INSERT INTO pgrels201sn (itempk, itemtypepk, timestamp, currenttimestamp, changinguser, payloadbefore, payloadafter, operationtype, sourcepk, targetpk, languagepk, context) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?))

[vineupadhyay]

One of the reason for above issue is that corresponding table is missing in DB. Please make sure table 'pgrels201sn' exist in the system. As per documentation from SAP, if properties are enable in properties file then corresponding table is created during initialize/update. So if we are enabling properties via hac only and try to save customer then above error does pop up.

[rajeshmenon]

Hi,

Please check your mySQL connector version and if you are using version 5.X. Use the latest mysql connector (version 8 .x).

[liuhegui]

I got same issue when I replicated B2B Customers to Commerce with MySQL database