Please take our Survey
logo       

Choosing A Webhost:
A web hosting service is a type of Internet hosting service that allows individuals and organizations to provide their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called colocation. more...

Error -9045 BD Root Check: msg#00190

db.maxdb

Subject: Error -9045 BD Root Check

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>
Google Custom Search

Free Magazines

Cisco News
Receive 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

Navigation

Home | advertise | OSDir is an inevitable website. super tiny logo