The authentication flow failed for certain user(s). The following errors occur when the problem happened.
org.springframework.dao.IncorrectResultSizeDataAccessException: Query did not return a unique result: 2 results were returned\n\tat org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:305)\n\tat
API Completion Error: method=POST, api=/auth/v1/authenticate, status=500, txnId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, clientTxnId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, flowStateId=xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
The application is configured with "zeroFootPrint": true in IDSP and "trusted device" is enabled in this tenant.
IDSP 3.4.2
This is a known issue documented under DE661315. A permanent fix is scheduled for the IDSP 4.0.2 release.
Steps to Reproduce
The issue occurs during specific shared device registration flows:
Result: The logic error is triggered at Step 4, leading to inconsistent device states.
Workaround
To resolve this manually, you must clear the user's existing trusted devices.
Permanent Solution
To resolve this issue permanently, please upgrade to IDSP 4.0.2 or later.