SAP Knowledge Base Article - Preview

3662927 - Unable to login to backoffice after DB restoration

Symptom

Users are unable to login to backoffice through SSO/normal login after DB restoration has been done. The following exceptions can be seen in logs:

Exception:
de.hybris.platform.servicelayer.exceptions.ModelSavingException
Message:
Failed to persist audit records (sql: INSERT INTO users4sn (itempk, itemtypepk, timestamp, currenttimestamp, changinguser, payloadbefore, payloadafter, operationtype, context) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?))

Exception:
java.sql.BatchUpdateException
Message:
Invalid object name 'users4sn'.


Read more...

Environment

All SAP Commerce Cloud versions

Product

SAP Commerce Cloud all versions

Keywords

backoffice login error, invalid object name 'users4sn', auditing.enabled=false, database restore issue, missing audit table, sso login error, system update, auditing table missing, sap commerce cloud login error , KBA , CEC-SCC-CDM-BO , Backoffice & Product Content Management , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.