1864103 - Deleting KM resource fails with error ORA-01427: single-row subquery returns more than one row openSQLExceptionCategories: [] | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1864103 - Deleting KM resource fails with error ORA-01427: single-row subquery returns more than one row openSQLExceptionCategories: []

Symptom

  • After upgrade from 7.0x to 7.3x, if a user tries to delete a KM resource, deletion fails with the following error:

'ORA-01427: single-row subquery returns more than one row openSQLExceptionCategories: []'

  • In the default trace the following error can be found:

SQL error occurred on connection <Database name>: code=1,427, state="21000", message="ORA-01427: single-row subquery returns more than one row"; SQL statement is "SELECT "CHILDNODEID" FROM "KMC_DBRM_RELATIONS" WHERE "TUCCID" IS NULL AND "PARENTNODEID" = (SELECT "CHILDNODEID" FROM "KMC_DBRM_RELATIONS" WHERE "TUCCID" IS NULL AND "PARENTNODEID" = ? AND "HASHCODE" = ? AND "NAME" = ?) AND "HASHCODE" = ? AND "NAME" = ?".

 


Read more...

Environment

  • SAP NetWeaver Enterprise Portal 7.30
  • SAP NetWeaver Enterprise Portal 7.31
  • SAP NetWeaver Enterprise Portal 7.40
  • SAP NetWeaver Enterprise Portal 7.50
  • KMC Content Management

Product

SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

remove,file,folder,document,EP,Enterprise Portal,content admin, km content, context menu , KBA , EP-KM-CM , KM 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 ONE Support launchpad (Login required).

Search for additional results

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