Ansicht
Dokumentation

ORACLE DB error -1438 for transport with R3trans
Tip-No.: 3043 ( INFO3043 )

Short text

ORACLE DB error -1438 for transport with R3trans
Tip-No.: 3043

Symptom

When copying clients or transporting with the R3trans utility, Release
1.1H encounters a data base error (-1438).

Cause

Error in the SAP data base interface when handling new fields that were
added to existing data base tables withthe ADD-field facility and were
implemented as NULL value fields in Oracle for this purpose. The problem
is restricted to transparent tables, and only those in which packed
fields were added to with ADD-field. This is the case for:
- KNA1, Field UMSAT and
- BSIK, Field QSFBT

This kind of error is not possible for pool tables.

Solution

The error can be prevented in two ways:

1) Client copying only for control tables instead of all tables
(inclusive application tables with master and movement data).
In most cases, client copying should also be restricted to purely
control tables - use the procedure described in the installations
guidelines that is based on the utility report RSCLIC01 or RSCLIC02.

2) Eliminate the NULL-Values in the Oracle data base using the following
SQLPLUS or EXEC SQL command:
UPDATE KNA1 SET UMSAT = 0 WHERE UMSAT IS NULL;
and
UPDATE BSIK SET QSFBT = 0 WHERE QSFBT IS NULL;