How To Fix 0S037 - End record missing for last SQL trace record in list

SAP Error Message - Details

• Message type: E = Error

• Message class: 0S - Messages for the SQL trace

• Message number: 037

• Message text: End record missing for last SQL trace record in list

What causes this issue?

For each statement, two logical records are written to the trace file.
Whilst assessing the trace file, the system determines that the "end
record" is missing for the last trace record.

System Response

The system tries to format and output as much of the last trace record
as possible.

How to fix this error?

This type of situation can arise if the last trace block is not written
to the trace file. Switch the trace off and then repeat the trace
assessment.
If the trace has already been switched off, repeat the assessment.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message 0S037 - End record missing for last SQL trace record in list ?

  The SAP error message 0S037: End record missing for last SQL trace record in list typically indicates an issue with the SQL trace data that has been collected in the system. This error can occur when the SQL trace is not properly closed or when there is a corruption in the trace data.
  Cause:
  
  Incomplete Trace Data: The SQL trace may not have been properly finalized, leading to missing end records.
  Corruption: The trace files may be corrupted due to system issues or improper shutdowns.
  System Errors: There may be underlying system errors that affect the logging and tracing mechanisms.
  
  Solution:
  
  Re-run the Trace: If possible, stop the current trace and start a new one. Ensure that the trace is properly stopped after the required operations.
  Check Trace Files: Look for any inconsistencies in the trace files. You can use transaction ST05 to analyze the SQL trace.
  Delete Corrupted Traces: If you identify corrupted trace files, consider deleting them and re-running the trace.
  System Check: Perform a system check to ensure that there are no underlying issues affecting the database or the SAP system.
  SAP Notes: Check the SAP Support Portal for any relevant SAP Notes that may address this specific error. There may be patches or updates available that resolve known issues.
  Consult Documentation: Review the SAP documentation for SQL tracing to ensure that you are following the correct procedures for starting and stopping traces.
  
  Related Information:
  
  Transaction ST05: This transaction is used for SQL tracing in SAP. You can start and stop traces here and analyze the collected data.
  SAP Support: If the issue persists, consider reaching out to SAP support for further assistance. They may provide specific guidance based on your system configuration and version.
  System Logs: Check the system logs (transaction SM21) for any related errors or warnings that might give more context to the issue.
  
  By following these steps, you should be able to address the error message and ensure that SQL tracing functions correctly in your SAP environment.