3588866 - Error: "Database Connector Error: Invalid name of function or procedure..." when adding a HANA Stored Procedure to a report in Crystal Reports

• Error when creating report based on some HANA Stored Procedure.
• When creating a report based on a HANA Stored Procedure containing uppercase, and lowercase characters in Crystal Reports, it fails with the error:
  
  "Database Connector Error: ‘S1000:[SAP AGJ[LIBODBCHDB DLL][HDBODBC] 
   General error,328 invalid name of function or procedure: no procedure with name <STORED PROCEDURE NAME> 
   found: line X col Y (at pos Z) [Database Vendor Code: 328 ]‘" 

• SAP Crystal Reports 2020
• SAP Crystal Reports 2025

1. In Crystal Reports 2020, create a new report.
2. Connect to HANA using an ODBC connection.
3. Select a HANA Stored Procedure that contains uppercase and lowercase characters.
4. Enter a parameter value if any.
5. It then fails with the error:
     
   "Database Connector Error... invalid name of function or procedure: no procedure with name..."

• The HANA database is case sensitive, but the Database Option in Crystal Reports is set to be case insensitive.

• In Crystal Reports, uncheck the Database Option: Database Server is Case-Insensitive:
  
  
  1. In Crystal Reports, under the menu "File", select: "Options..."
  2. In "Options", under the tab "Database", uncheck the option "Database Server is Case-Insensitive"
  3. Click "OK"

CR, HANA , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem