SAP Knowledge Base Article - Preview

2748220 - Registering dpagent fails with a user name containing special characters - SAP HANA Smart Data Integration

Symptom

  • Registering agent '<agent name>' with SAP HANA.
  • 2019-01-29 18:42:55,566 [ERROR] SocketConnector.read - Executing SQL statement "GRANT AGENT MESSAGING ON AGENT "<agent name>" TO <HANA-USER-WITH-DASHES>" failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "-": line 1 col 61 (at pos 61) Failed to register agent.
  • Context: Executing SQL statement "GRANT AGENT MESSAGING ON AGENT "<agent name>" TO <HANA-USER-WITH-DASHES>" failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "-": line 1 col 61 (at pos 61)
  • 2019-01-29 18:42:55,566 [ERROR] AgentConnection.submitRequest - Request Failed for ADMIN_SET_CONFIG_PROPERTIES Context:Executing SQL statement "GRANT AGENT MESSAGING ON AGENT "<agent name>" TO <HANA-USER-WITH-DASHES>" failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "-": line 1 col 61 (at pos 61)


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

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.