How To Fix GU797 - No records found in the database

SAP Error Message - Details

• Message type: E = Error

• Message class: GU - FI-SL utilities

• Message number: 797

• Message text: No records found in the database

What causes this issue?

The FI-SL tables have been read using the selection criteria you
specified, but no suitable records were found.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message GU797 - No records found in the database ?

  The SAP error message GU797 ("No records found in the database") typically indicates that a query or transaction is attempting to retrieve data from the database, but no records match the specified criteria. This can occur in various contexts, such as when running reports, executing transactions, or accessing specific data records.
  Causes:
  
  Incorrect Selection Criteria: The parameters or filters used in the query may be too restrictive or incorrect, leading to no matching records.
  Data Not Yet Created: The data you are trying to access may not have been created or posted yet in the system.
  Data Deletion: Records may have been deleted or archived, making them unavailable for retrieval.
  Authorization Issues: The user may not have the necessary authorizations to view certain records, leading to the appearance of no data.
  Database Issues: There may be issues with the database connection or integrity, causing it to not return expected results.
  
  Solutions:
  
  Check Selection Criteria: Review the parameters you are using in your query or transaction. Ensure they are correct and not overly restrictive.
  Verify Data Existence: Confirm that the data you are trying to access has been created and is available in the system. You may need to check with other users or look in different transactions.
  Review Authorizations: Ensure that you have the necessary permissions to access the data. If not, contact your system administrator to adjust your authorizations.
  Check for Deletions or Archiving: Investigate whether the records have been deleted or archived. You may need to consult with your data management team.
  Database Health Check: If you suspect a database issue, work with your IT or database administration team to check the health of the database and resolve any connectivity or integrity issues.
  
  Related Information:
  
  Transaction Codes: Depending on the context, you may be using specific transaction codes (e.g., SE16 for table display, ME23N for purchase order display) that could be relevant to the error.
  SAP Notes: Check SAP Notes for any known issues or patches related to the error message GU797.
  System Logs: Review system logs (transaction SLG1) for any additional error messages or warnings that could provide more context.
  User Forums: Consider searching or posting in SAP community forums for insights from other users who may have encountered the same issue.
  
  If the problem persists after trying the above solutions, it may be beneficial to escalate the issue to your SAP support team for further investigation.