SAP Knowledge Base Article - Preview

2729739 - Error indexing search connectors: "Authorization indexing unsuccessful for object type USER_AUTHORITY"

Symptom

In the ESH_COCKPIT, you have created a connector and you have started the indexing process.

The indexing fails with error like the following example:

Search for authorization not successful for index ESH:<SID><client>~<SID><client>~PROJECT_NETWORK_H%%21FBF250
Execution of SELECT DISTINCT query on ESH:<SID><client>~<SID><client>~PROJECT_NETWORK_H~%21FBF250~ (schema <HANA schema>) failed
SQL Statement failed;SELECT DISTINCT "WERKS", "DISPO" FROM "<HANA schema>"."ESH:<SID><client>~<SID><client>~PROJECT_NETWORK_H~%21FBF250~" L
column store error: search table error: [2617] executor: plan operation execution failed with an exception;caught unexpec
Authorization indexing unsuccessful for object type USER_AUTHORITY
Search for authorization not successful for index ESH:<SID><client>~<SID><client>~PROJECT_NETWORK_H%%21FBF250
Execution of SELECT DISTINCT query on ESH:<SID><client>~<SID><client>~PROJECT_NETWORK_H~%21FBF250~ (schema <HANA schema>) failed
SQL Statement failed;SELECT DISTINCT "WERKS", "DISPO" FROM "<HANA schema>"."ESH:<SID><client>~<SID><client>~PROJECT_NETWORK_H~%21FBF250~" L
column store error: search table error: [2617] executor: plan operation execution failed with an exception;caught unexpec
Indexing ended with error
Job canceled after system exception ERROR_MESSAGE


Read more...

Environment

  • SAP BASIS 740 and later releases.
  • SAP HANA

Product

SAP NetWeaver Enterprise Search all versions ; SAP S/4HANA 1809

Keywords

HANA indexing 2617 USER_AUTHORITY PROJECT_NETWORK_H , KBA , BC-EIM-ESH , NetWeaver Enterprise Search , 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.