MaxDB ST05-trace fallacy – when sometimes the trace is wrong…

One of the most important analytical tools used to investigate slow running SQL statements is the well-known ST05 - SQL trace. The idea of it is that the ABAP database interface notes down what SQL statement it sends to the database, how long it took to get the result, what selection criteria were used and … Continue reading MaxDB ST05-trace fallacy – when sometimes the trace is wrong…

ORA-01007 in ABAP stack and what to do about it.

Recently a colleague asked me about how to analyze the following short dump: Database error text........: "ORA-01007: variable not in select list" Database error code........: 1007 Triggering SQL statement...: "FETCH NEXT " Internal call code.........: "[DBDS/NEW DSQL]" The error was raised within a standard SAP report with the following statement: >>>>>       select tablespace_name, 1435          initial_extent … Continue reading ORA-01007 in ABAP stack and what to do about it.