Skip to Content
2
Jan 29, 2019 at 01:23 PM

How to setup Smart Data Integration for SAP HANA service on SCP Cloud Foundry?

800 Views Last edit Jan 29, 2019 at 01:43 PM 2 rev

We are trying to set up Smart Data Integration for the SAP HANA Service on SCP Cloud Foundry by installing the Data Provisioning Agent on a Windows PC in order to register the FileAdapter to upload CSV files. The steps are as per mentioned in the SAP docs. Steps 1 to 3 can be performed successfully.

The connection to SAP HANA Service instance is successful as seen below.

************************************************************
                 DPAgent Configuration Tool
************************************************************
1. Agent Status
2. Start or Stop Agent
3. Agent Preferences
4. Remote Source Credentials
5. SSL Keystores
6. SAP HANA Connection
7. Agent Registration
8. Adapter Registration
9. Custom Adapters
10. Agent & Adapter Versions
q. Quit
b. Back
************************************************************
Enter Option:1
************************************************************
Agent                    Status: Running
                         Listener port: 5050
                         Admin port: 5051
                         Agent Name:
HANA Connection          Server: wsproxy.hana.prod.ap-southeast-2.xxxxx.dbaas.ondemand.com
                         Port: 80
                         Protocol: JDBC
                         Agent Admin HANA user: SYSTEM
************************************************************

However, the step 4 of Registering the Agent with SAP HANA doesn't go through successfully. An error is seen:

************************************************************
                       Register Agent
************************************************************
Press "Enter" button to skip optional or default setting.
If one setting cannot be skipped, it is required.
************************************************************
Enter Agent Name[dpagent_1]:
dpagent_29_jan_cli
Enter Agent Host Name[10.211.xx.x]:


Registering agent 'dpagent_29_jan_cli' with SAP HANA.
2019-01-29 18:42:55,566 [ERROR] SocketConnector.read  - Executing SQL statement "GRANT AGENT MESSAGING ON AGENT "dpagent
_29_jan_cli" TO USER-HANA-AGENT-MSG" failed with SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "-": l
ine 1 col 61 (at pos 61)
Failed to register agent.
Context: Executing SQL statement "GRANT AGENT MESSAGING ON AGENT "dpagent_29_jan_cli" TO USER-HANA-AGENT-MSG" failed wi
th 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 "dpagent_29_jan_cli" TO USER-HANA-AGENT-MSG" failed with SAP D
BTech JDBC: [257]: sql syntax error: incorrect syntax near "-": line 1 col 61 (at pos 61)


Now, if we check 'Data Provisioning Agents' in the Database Explorer for SAP WebIDE, we can see the agent as registered but it appears disconnected.

Another thing to note is that we are not able to apply any Application Privileges to the HANA user because they simply are not available in the HANA Service instance Cockpit.

Zoom image.png

Zoom image.png

Any help in this regard is very much appreciated.

Thanks!

Attachments