How To Fix S10058 - Parameter of &1 contains TSQL comment string which is not allowed

SAP Error Message - Details

• Message type: E = Error

• Message class: S10 - MS SQL Server Database monitor tools messages

• Message number: 058

• Message text: Parameter of &1 contains TSQL comment string which is not allowed

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 S10058 - Parameter of &1 contains TSQL comment string which is not allowed ?

  The SAP error message S10058 indicates that a parameter in your SQL statement contains a T-SQL comment string, which is not allowed in the context where it is being used. This typically occurs when you are working with SQL statements in SAP that are being executed against a database that does not support T-SQL comment syntax.
  Cause:
  The error is caused by the presence of a comment in the SQL statement that is formatted in a way that is not compatible with the SQL dialect being used. For example, T-SQL comments can be written using -- for single-line comments or /* ... */ for multi-line comments. If these comment styles are included in a parameter that is being processed by SAP, it can lead to this error.
  Solution:
  To resolve this error, you should:
  
  
  Remove Comments: Check the SQL statement or the parameters being passed to it and remove any T-SQL comment strings. Ensure that the SQL code is clean and does not contain any comments.
  
  
  Use Compatible Syntax: If you need to include comments for documentation purposes, consider using a different method to document your SQL code outside of the SQL statement itself, such as in a separate documentation file or comments in your application code.
  
  
  Review SQL Code: Ensure that the SQL code adheres to the syntax rules of the database you are working with. If you are using a database that does not support T-SQL, make sure to use the appropriate SQL syntax for that database.
  
  
  Test the SQL Statement: After making changes, test the SQL statement again to ensure that it executes without errors.
  
  
  Related Information:
  
  Database Compatibility: Different databases have different SQL dialects. Make sure you are aware of the specific SQL syntax and features supported by the database you are using with SAP.
  SAP Documentation: Refer to SAP's official documentation for guidelines on writing SQL statements and handling errors.
  Debugging: If you continue to encounter issues, consider enabling debugging or logging to capture the exact SQL statement being executed, which can help identify the source of the problem.
  
  By following these steps, you should be able to resolve the S10058 error and ensure that your SQL statements are compatible with the database you are using.