SAP Knowledge Base Article - Preview

2509567 - Unable to Drop Remote Source based on SDI - can't drop without CASCADE specification

Symptom

Can't drop remote source and dependent objects.

  • ' DROP REMOTE SOURCE <remote_source_name>' CASCADE gives you the error:
  • 'unique constraint violated: Table(P_OBJECTDEPENDENCY_), Index(_SYS_TREE_RS_#132258_#0_#P0)'

 If trying without the CASCADE you get error - cannot drop with out cascade

 If trying deleting via WebID Catalog app you get - can't drop without CASCADE specification

 

 


Read more...

Environment

  • SAP HANA Smart Data Integration
  • SAP HANA 122.06

Product

SAP HANA 1.0 smart data integration ; SAP HANA 1.0, platform edition

Keywords

DP Agent, can't, not possible, to , KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.