SAP Knowledge Base Article - Preview

3297668 - Error: "Could not execute 'Drop Agent "***"'SAP DBTech JDBC: [507]: invalid agent name: :cannot find agent name: ***" while trying to drop agent from sql command - SAP HANA Smart Data Integration

Symptom

  • Try to drop an unused agent from HANA system with "DROP AGENT" SQL command failed with error
    • "Could not execute 'Drop Agent "***"'SAP DBTech JDBC: [507]: invalid agent name: :cannot find agent name: ***"
  • We can see the agent though the following query
    • select * from agents;
    • select * from m_agents;
  • There is no mistake in the drop command syntax
  • The agent installation no longer exists in the system


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

Data Provisioning Agent, DP Agent, SDI, delete, redundant, create, alter, monitor , 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.