How To Fix S06104 - &1 records in &2 ms selected from &3

SAP Error Message - Details

• Message type: E = Error

• Message class: S06 - SAP Netweaver Workload Collector

• Message number: 104

• Message text: &1 records in &2 ms selected from &3

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 S06104 - &1 records in &2 ms selected from &3 ?

  The SAP error message S06104 typically indicates that a large number of records have been selected from a database table or view, and it provides information about the number of records and the time taken for the selection. The message format is usually as follows:
  S06104 &1 records in &2 ms selected from &3
  Where:
  
  &1 is the number of records selected.
  &2 is the time taken for the selection in milliseconds.
  &3 is the name of the database table or view from which the records were selected.
  
  Cause
  This message is not necessarily an error but rather an informational message indicating that a significant number of records were retrieved in a specific time frame. It can be triggered in various scenarios, such as:
  
  Executing a report or transaction that retrieves a large dataset.
  Running a query that does not have sufficient filters or selection criteria, leading to a high volume of data being processed.
  
  Solution
  
  
  Optimize Selection Criteria: If the selection of records is too large, consider refining the selection criteria to limit the number of records retrieved. This can be done by adding filters or conditions to the query or report.
  
  
  Performance Tuning: If the performance is a concern (i.e., the time taken is too long), you may need to look into performance tuning options:
  
  Ensure that the database tables are properly indexed.
  Analyze the execution plan of the query to identify bottlenecks.
  Consider using aggregate functions or summary tables if applicable.
  
  
  
  Pagination: If the application allows, implement pagination to retrieve records in smaller chunks rather than all at once.
  
  
  Review Background Jobs: If this message appears in the context of background jobs, ensure that the job is configured correctly and that it is not attempting to process more data than necessary.
  
  
  Monitor System Performance: Keep an eye on system performance metrics to ensure that the database and application server can handle the load efficiently.
  
  
  Related Information
  
  Transaction Codes: You may encounter this message while using various transaction codes that involve data retrieval, such as SE16 (Data Browser), SE11 (Data Dictionary), or custom reports.
  SAP Notes: Check SAP Notes for any known issues or recommendations related to performance and data retrieval.
  Database Optimization: Consult with your database administrator (DBA) for further optimization strategies specific to your SAP environment.
  
  If you continue to experience issues or if the message is accompanied by performance problems, it may be beneficial to engage with your SAP Basis team or a technical consultant for a deeper analysis.