Error -9045 BD Root Check

[Matthias . Endler]

Hi,

can anyone tell me what error "-9045 BD Root Check" means. We are using 
SapDB Version 7.4.30 on SuSE 8.2 Linux. The error occures in the insert 
statement when I try to execute the following procedure with user ADMIN 
(DBA). The table ADMIN.LE only needs LE.LE_NR to be not null.

Thanks for any hints in advance.

Regards,
Matthias

CREATE DBPROC ADMIN.SP_DOWNLOADPROVIDER2 (
  IN    P_SPACE_ID                VARCHAR(10),
  INOUT P_LOCAL_ID                VARCHAR(20),
  IN    P_SOCIETY_NAME            VARCHAR(80),
  IN    P_NAME                    VARCHAR(80),
  IN    P_ADDRESS                 VARCHAR(100),
  IN    P_TOWN                    VARCHAR(40),
  IN    P_ZIP_CODE                VARCHAR(10),
  IN    P_LOCAL_COUNTRY           VARCHAR(40),
  IN    P_AREA_NAME               VARCHAR(40),
  IN    P_CONTACTS                VARCHAR(4000),
  IN    P_OPENING_TIME            VARCHAR(180),
  IN    P_ALWAYS_OPENED           VARCHAR(1),
  IN    P_PRICES_GRID             VARCHAR(2000),
  IN    P_EQUIPMENT               VARCHAR(2000),
  IN    P_REMARKS                 VARCHAR(1000),
  IN    P_CURRENCY_ID             VARCHAR(1000),
  IN    P_LANGUAGE_ID             VARCHAR(1000),
  IN    P_PAYMENT_TYPE            VARCHAR(50),
  IN    P_BBAN                    VARCHAR(50),
  IN    P_IBAN                    VARCHAR(40),
  IN    P_SWIFT                   VARCHAR(50),
  IN    P_BANK_NAME               VARCHAR(100),
  IN    P_BANK_ADDRESS            VARCHAR(100),
  IN    P_BANK_TOWN               VARCHAR(100),
  IN    P_BANK_ZIPCODE            VARCHAR(10),
  IN    P_BANK_COUNTRY            VARCHAR(2),
  IN    P_LOCAL_PAYMENT_POLICIES  VARCHAR(100),
  IN    P_PAYMENT_REMARK          VARCHAR(1000),
  IN    P_PAYEE_NAME              VARCHAR(80),
  IN    P_PAYEE_ADDRESS           VARCHAR(100),
  IN    P_PAYEE_TOWN              VARCHAR(40),
  IN    P_PAYEE_ZIPCODE           VARCHAR(10),
  IN    P_PAYEE_COUNTRY           VARCHAR(2),
  IN    P_PROFESSIONAL_INSURANCE  VARCHAR(100),
  IN    P_TAX_NR                  VARCHAR(20),
  IN    LAST_UPDATE_DATE          DATE,
  OUT   SUCCESS                   CHAR(1),
  OUT   MESSAGE                   VARCHAR(4000)
) AS
VAR
  -- aux
  TS_NOW          TIMESTAMP;
  LE_NR           FIXED(10);
  LE_ART          SMALLINT;
BEGIN


SET TS_NOW = TIMESTAMP;
SET LE_NR = 2333333333;
SET LE_ART = 88;

-- insert statement.
    INSERT INTO ADMIN.LE (
      LE_NR, LE_FIRSTUSER, LE_FIRSTTIME, LE_LASTUSER, LE_LASTTIME,
      LE_TIMEUPDATE, LE_ANZUPDATE, LE_ART, LE_PRIORITY, LE_SPEZIFIKATION,
      LE_SPEZIFIKATION@, LE_HDLNR, LE_FIRMA, LE_FIRMA@, LE_ASP,
      LE_ASP@, LE_STRASSE, LE_PLZ, LE_ORT, LE_ORT@,
      LE_LAND, LE_TEL1, LE_TEL2, LE_FAX, LE_HANDY,
      LE_EMAIL, LE_INTERNET, LE_24H, LE_SPRACHE1, LE_SPRACHE2,
      LE_SPRACHE3, LE_SPRACHE4, LE_TEL3, LE_OPENTIME, LE_FESTPREIS,
      LE_VERTRAG, LE_KONTO, LE_BLZ, LE_RECHNUNG, LE_INSTITUT,
      LE_BANKSTRASSE, LE_BANKORT, LE_BANKLAND, LE_EXIST, LE_BANKPLZ,
      LE_ISDNKENNUNG, LE_ISDNREPLACE, LE_XKOOR, LE_YKOOR, LE_AKTIV,
      LE_FIBUKONTO, LE_FIBUART, LE_USTID
    ) VALUES (
      :LE_NR, 'automatischer Import SPACe', :TS_NOW, 'automatischer Import 
SPACe', :TS_NOW,
      NULL, NULL, :LE_ART, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL, NULL, NULL,
      NULL, NULL, NULL 
    );

 
END;
//



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]