How To Fix DDIC_ADT_SQSC003 - HANA Procedure is not available in DB Catalog (names are case sensitive!)

SAP Error Message - Details

• Message type: E = Error

• Message class: DDIC_ADT_SQSC - Message Class for ABAP Dev Tools of DB Procedure Proxy

• Message number: 003

• Message text: HANA Procedure is not available in DB Catalog (names are case sensitive!)

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message DDIC_ADT_SQSC003 - HANA Procedure is not available in DB Catalog (names are case sensitive!) ?

  The SAP error message DDIC_ADT_SQSC003 indicates that a HANA procedure is not available in the database catalog, and it highlights that names are case-sensitive. This error typically occurs when you are trying to access a stored procedure in SAP HANA that either does not exist or is not accessible due to case sensitivity issues.
  Causes:
  
  Procedure Does Not Exist: The specified procedure may not exist in the database. This could be due to a typo in the procedure name or because it has not been created yet.
  Case Sensitivity: HANA is case-sensitive when it comes to object names. If the procedure was created with a specific case (e.g., MyProcedure), trying to access it with a different case (e.g., myprocedure) will result in this error.
  Schema Issues: The procedure might exist in a different schema than the one you are currently using. If you do not specify the schema, HANA will look for the procedure in the default schema.
  Authorization Issues: The user executing the procedure may not have the necessary permissions to access it.
  
  Solutions:
  
  Check Procedure Existence: Verify that the procedure exists in the database. You can do this by querying the SYS.PROCEDURES system view or using the HANA Studio or HANA Database Explorer.
  SELECT * FROM SYS.PROCEDURES WHERE NAME = 'YourProcedureName';
  
  Verify Case Sensitivity: Ensure that you are using the correct case for the procedure name. If the procedure was created with double quotes, it is case-sensitive.
  Specify Schema: If the procedure exists in a different schema, make sure to specify the schema name when calling the procedure. For example:
  CALL "YourSchema"."YourProcedureName"();
  
  Check User Permissions: Ensure that the user has the necessary permissions to execute the procedure. You may need to grant the appropriate privileges.
  GRANT EXECUTE ON "YourSchema"."YourProcedureName" TO "YourUser";
  
  
  Related Information:
  
  HANA Documentation: Refer to the official SAP HANA documentation for more details on stored procedures and case sensitivity.
  SAP Notes: Check SAP Notes for any known issues or patches related to this error message.
  Database Tools: Use tools like SAP HANA Studio or SAP Web IDE for HANA to manage and troubleshoot database objects more effectively.
  
  By following these steps, you should be able to resolve the error and successfully access the HANA procedure.