2524837 - Error "Subquery returned more than 1 value" or "ORA-01422" when adding or modifying an entry | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2524837 - Error "Subquery returned more than 1 value" or "ORA-01422" when adding or modifying an entry

Symptom

Following error happens when adding or modifying an entry with job:

  • Microsoft SQL Server: DATABASE EXCEPTION:com.microsoft.sqlserver.jdbc.SQLServerException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
  • Oracle: ORA-01422: exact fetch returns more than requested number of rows.

Read more...

Environment

SAP Netweaver Identity Management 7.2

Product

SAP NetWeaver Identity Management 7.2

Keywords

IDM IDStore ToPassException , KBA , BC-IAM-IDM , Identity Management , Problem

About this page

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

Search for additional results

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