23.3.11

SAP Note 25412 - Nametab interface provides incorrect field catalog

Symptom:

When mass activation programs run in parallel, errors occur because the SQL statement for different tables is incorrectly set up, e.g. a SELECT for DD03L may use the field list of DD41V. Every table used in these SQL statements is described in the SAP data dictionary.

On an INFORMIX system, this causes SQL errors such as INF254, INF217 or INF608. SYSMASTER tables can never be involved.

On an ORACLE system ORA904 can be expected.

Cause and prerequisites

There is an error in the Nametab interface.
In certain situations, the pointer which should refer to the required Nametab information is set incorrectly.
The error occurs if
( i) this particular Nametab information has already been requested once for the table (for example, the field catalog) within the transaction,
( ii) then, the same Nametab information is accessed for a second table,
(iii) the Nametabs for the second table are invalidated,
( iv) the Nametab information for the first table is requested again.
In this case, an incorrect pointer can be returned due to an error in managing the Nametabs last addressed in the process.

Solution
Corrected starting with releases 30A and 22G

Additional key words

dbntab, dbtran, dbtrtab, dbrsql, dbrtab, field catalog, NT_RDFBASE

No comments:

Post a Comment