SAP Knowledge Base Article - Preview

2688634 - Error code 40202 Schema could not be resolved for public synonym. Check that the target table exists.

Symptom

  • Found that package is not activated properly using the following command.

select * from "_SYS_REPO"."ACTIVE_OBJECT" where object_suffix = 'hdbti' and object_status > 0 ;

Results:
sap.hana.admin.cockpit.app.uis    permissions hdbti         3 31:57.2 SYSTEM       0 import = [{ hdbtable = \"sap.hana.uis.db::_UIS_PERMISSIONS\"  file = \"sap.hana.admin.cockpit.app.uis:permissions.csv\"  header = true  delimField = \" \"  keys = [\"OBJECT_ID\":\"sap.hana.admin.cockpit.app|monitoring\"] }]

  • Found the Error 40202 in trace files like below.

CheckResults:
(ERROR, error code: 40202, error message: Schema could not be resolved for public synonym.  Check that the target table exists., object: {tenant: , package: sap.hana.hdblcm.cockpit, name: permissions, suffix: hdbti}, location: , time stamp: , unformatted error message: Schema could not be resolved for public synonym.  Check that the target table exists.)


Read more...

Environment

  • HANA 1.0
  • HANA 2.0

Product

SAP HANA 1.0, platform edition

Keywords

"_UIS_PERMISSIONS", "HANA_UI_INTEGRATION_SVC", "hdbti", "2303448", "note 230448", "note ##230448" , KBA , HAN-AS-RPO , SAP HANA Repository , 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.