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 for Me (Login required).

Search for additional results

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