Troubleshooting Connection Issue with SAP HANA Database

ingestion
1

Original Slack Thread

source:
type: hana
config:
env: STG
host_port: ‘34.87.167.111:30044’
database: SAPABAP1
username: VH_DATAWAREHOUSE
password: Warehouse@2025
include_tables: true
include_views: true
schema_pattern:
allow:
- BKPF
- BSEG

<class ‘sqlalchemy.exc.DBAPIError’>: (hdbcli.dbapi.Error) (2, “general error: database ‘SAPABAP1’ not connected”) (Background on this error at: https://sqlalche.me/e/14/dbapi)

2

Hey there! :wave:

<@U06TM7M40RK> Can you help with the questions in this thread?

:information_source: Please continue to tag RunLLM (e.g <@U06TM7M40RK>) to have it continue generating responses!

3

It seems likely that the error you’re encountering, general error: database 'SAPABAP1' not connected, is related to a connection issue with the SAP HANA database. Here are a few steps you might consider to troubleshoot and resolve this issue:

  1. Verify Connection Details: Double-check the host_port, database, username, and password fields in your configuration to ensure they are correct. According to the <SAP HANA | DataHub source configuration details>, these fields are crucial for establishing a connection.

  2. Network Connectivity: Ensure that there are no network issues preventing the connection to the SAP HANA database. You can test the connectivity using a simple script or tool that attempts to connect to the database using the same credentials and host details.

  3. Database Availability: Confirm that the SAP HANA database is up and running and that it is accessible from the network where your DataHub ingestion is being executed.

  4. Firewall and Security Settings: Check if there are any firewall settings or security groups that might be blocking the connection to the SAP HANA database. Ensure that the port (30044 in this case) is open and accessible.

  5. SAP HANA Client: Ensure that the SAP HANA client (hdbcli) is correctly installed and configured on the machine where the ingestion is being run. The https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/tests/unit/test_hana_source.py|test_hana_source.py file indicates that the hdbcli dependency is necessary for connecting to HANA databases.

Would you like more detailed steps or further assistance on any of these points?

Sources:

4

Hi, how did my answer work out for you? Need any more assistance? You can also tag <@U07FV3UHE4D> to let your fellow community members know you’re still looking for guidance.

5

Hi :slight_smile: ! Did this interaction resolve your issue or do you still require assistance ?

Please tag @ RunLLM if you still need further assistance !

Or tag @Datahub Community Support if you require a person to take a look :slight_smile:

Hope this helps ! ><