We encountered an intermittent issue where a SAP HANA stored procedure attempted to retrieve record count information from M_TABLES, which contains metadata and runtime information about database tables. As a result, the job failed with a "no data found" error because the stored procedure was unable to retrieve the expected record count information from M_TABLES. Job Run Time: 27 August 2026, 10:35 PM UTC CALL "_SYS_BIC"."project.namespace.PROCEDURES::SP_REPORT_SNAPSHOT" ('NA','''*''','*','20260828021600','20260827'); com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1299]: no data found: "_SYS_BIC"."project.namespace.PROCEDURES::SP_REPORT_SNAPSHOT": col 1 (at pos 2444) "_SYS_BIC"."project.namespace.PROCEDURES::SP_EXECUTION_ERROR_LOG": line 82 col 2 (at pos 2747) "_SYS_BIC"."project.namespace.PROCEDURES::SP_EXECUTION_ERROR_LOG": line 83 col 2 Questions Has anyone encountered a similar intermittent "no data found" error when querying M_TABLES? Are there any known SAP Notes related to this behavior? Could table unload/reload activities, metadata refreshes, locking, or resource constraints lead to such an issue? What diagnostics or traces should be collected if the issue occurs again? Any guidance would be greatly appreciated. Thank you.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.