ERROR: "General error; 1033 error while parsing protocol" while connecting to SAP Hana DB

[vijayakarthikeyan]

Issue

 

In the Alteryx Designer, when a user connects to SAP HANA DB using the Input Data Tool, the following error is displayed:

ERROR[HY000][SAP AG][LIBODBCHDB DLL][HDBODBC] General error; 1033 error while parsing protocol

This error occurs, right after selecting the DSN name pointing to the SAP HANA Connection. There is a suitable driver for SAP HANA that is downloaded and installed. The connection to the DB is successful from the ODBC Admin window. The issue is only when it is connected from the Alteryx Designer.

Environment

• Product - Alteryx
  • Observed in - 2018.2
• Product - SAP HANA

 

Cause

This issue is caused when the user do not give the username and password details in the "Data Source Connection" dialog. Since there is no username and password given here, Alteryx takes this as an SSO Authentication and it errors out. Another cause is special characters in the connection password.

Resolution

 

Solution A

1. Click on the 'Input Data Tool" to configure the DSN for SAP HANA. Select the dropdown near to the "Connect a file or database" field, to choose the SAP Hana as the data source name.
2. The SAP Hana Connection window appears as below:
3. Now, enter the username and password in the above dialog box and click 'OK'.
4. The SAP Hana connection would be successful now.

Solution B

1. If there are special characters in the password, try changing the password to not include special characters.
2. The links in "Additional Details" describe database settings that can be changed to account for special characters.

Additional Resources

• Informatica- Authentication Failed
• SAP Documentation- password_layout

[JoshuaEdwardNunez]

Good info!

 I do want to note that the SAP Documentation link doesn't seem to work.