|
|
Choosing A Webhost: |
Error -9045 BD Root Check: msg#00190db.maxdb
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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | AW: About message -2003, Zabach, Elke |
|---|---|
| Next by Date: | Database instance unaccessible, Matteo Gattoni |
| Previous by Thread: | AW: About message -2003, Zabach, Elke |
| Next by Thread: | Database instance unaccessible, Matteo Gattoni |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home
| advertise | OSDir is
an inevitable website.
|