Integrity Violation during DBLOAD

Hi, I'm trying to migrate the data of one MAXDB instance (7.6.0.34 on Linux 64bit) to another (7.6.0.34 on Linux 32bit) using the loader. On the one side I used DBEXTRACT to extract the catalog and data: DBEXTRACT CATALOG OUTSTREAM FILE 'catalog' DATA OUTSTREAM FILE 'data' One the target machi

Re: -24994,ERR_RTE: runtime environment error

Am Donnerstag, 23. Februar 2006 02:48 schrieb Döhr, Markus ICC-H: > > I get this error message: > > > > -24994,ERR_RTE: runtime environment error 1,Database FORTUDB > > already started > > Did you set LD_ASSUME_KERNEL=2.4.21 before starting the x_server? In my init script I set LD_ASSUME_KERNEL=2.

-24994,ERR_RTE: runtime environment error

Hi, I had a system crash and after rebooting the machine my database (MaxDB 7.5.0.19 on a SuSE Linux 10.0) cannot be started. When I execute this command: dbmcli -u , -d FORTUDB db_warm I get this error message: -24994,ERR_RTE: runtime environment error 1,Database FORTUDB already started A d

Re: Again: Problem with "ON DELETE SET NULL"

Am Mittwoch, 11. Januar 2006 07:59 schrieb Anhaus, Thomas: > In the documentation > (http://dev.mysql.com/doc/maxdb/en/6d/117c5fd14811d2a97400a0c9449261/frames >et.htm) the following rule gives the answer : > > A reference cycle in which one referential CONSTRAINT definition does not > specify CASC

Again: Problem with "ON DELETE SET NULL"

Hi, I did not get a real answer to my question two weeks ago, so I try it again: I try to create a table with two foreign key definitions like the following statement on a MaxDB 7.5.0.19: create table USERS ( ID integer not null, USERNAME varchar(100) not null, CREAT

MaxDB with Hibernate 3.1

Hi, I make some first experiments with Hibernate 3.1 and MaxDB 7.5.0.19. Everything works fine, but after some period of time I get an exception saying: ERROR [03.01.2006 00:13:20] (JDBCExceptionReporter.java:72) - [-708] Timeout org.hibernate.exception.JDBCConnectionException: could not exec

Re: Problem with "ON DELETE SET NULL"

Am Montag, 2. Januar 2006 17:05 schrieb Martin Cordova: > Yes, although not a very common case, in yours looks 100% justified. > Maybe you did hit a MaxDB limitiation or a bug. Let's wait to see what > SAP people have to say about it. Did you try with another type of > on-delete-action instead of s

Problem with "ON DELETE SET NULL"

Hi, I try to create a table with two foreign key definitions like the following statement on a MaxDB 7.5.0.19: create table USERS ( ID integer not null, USERNAME varchar(100) not null, CREATED_BY integer, MODIFIED_BY integer, primary key (ID),

Re: AW: Cannot create View as STANDARD user

Am Freitag 14 Oktober 2005 11:07 schrieb Anhaus, Thomas: > >I try to create a view as a user of type STANDARD, but I get the error > >message: > > > >Syntax error or access violation;-5001 POS(35) Missing > >privilege:ROLE DEFINED > >PRIVILEGE > > This has nothing to do with the standard user. > Th

Cannot create View as STANDARD user

Hi, I try to create a view as a user of type STANDARD, but I get the error message: Syntax error or access violation;-5001 POS(35) Missing privilege:ROLE DEFINED PRIVILEGE The reference manual says that a STANDARD user can create views, synonyms and temporary tables. What is the problem? I u

Re: AW: How to track DB usage of user

Am Dienstag, 20. September 2005 14:58 schrieb Robert Klemme: > Then probably a limit different from bytes makes more sense? Maybe > something that can be directly translated into record counts (max > contacts or similar). That's right from a developers perspective, but not from a sales perspectiv

Re: AW: How to track DB usage of user

Am Dienstag, 20. September 2005 13:44 schrieb Zabach, Elke: > 5. The szenario that different people have to share one table, but are > limited to some amount of space, seems to me uncommon. May I ask for > some background-info? > I think that info stored in a table used by different people is reall

Re: How to track DB usage of user

Am Montag, 19. September 2005 17:28 schrieb Robert Klemme: > You could do reports like > > select user, count(*) > from your_table > > to see which user takes up how much space of the table. If you > combine this with information about the whole table's size you can > even calculate MB a certain u

How to track DB usage of user

Hi, I've a Java application on top of MaxDB. This application provides accounts for different users. All my tables have the userID as column to distinguish the data of the users. I want to track how much DB space is used by each user for checking the current usage against a defined limit. How

Re: x_server kills my database

Am Montag, 14. Juni 2004 19:56 schrieb "Döhr, Markus ICC-H": > > But when I call "x_server stop" and then "x_server start" I > > cannot restart my database instance. When I execute db_online > > I get the following error > > Starting the x_server as root will also try to start the database as root

x_server kills my database

Hi, after creating a new database instance with SAP DB 7.4.3.32 on SuSE Linux 9.1 I can execute the dbmcli commands db_offline and db_online as user root as often as I want. Everything works fine. But when I call "x_server stop" and then "x_server start" I cannot restart my database instance.

Re: Starting SAP DB on Linux after Reboot

Am Samstag, 12. Juni 2004 17:13 schrieb John Singleton: > Ralf, > > Try adding this line before starting x_server: > > export LD_ASSUME_KERNEL=2.2.5 This is included in the script. Otherwise, the database would not start. Ralf. -- MaxDB Discussion Mailing List For list archives: http://lists.my

Re: Starting SAP DB on Linux after Reboot

Am Samstag, 12. Juni 2004 10:57 schrieb Ralf Schneider: > Am Samstag, 12. Juni 2004 08:54 schrieb Jean-Michel OLTRA: > > > #$X_SERVER stop > /dev/null 2>&1 > > > > The server is not stopped when shuting down instance. > > > > Hav

Re: Starting SAP DB on Linux after Reboot

Am Samstag, 12. Juni 2004 08:54 schrieb Jean-Michel OLTRA: > > #$X_SERVER stop > /dev/null 2>&1 > > The server is not stopped when shuting down instance. > > Have you some script cleanly stopping x_server on shutdown (runlevels 0 > and 6) ? No, I commented this line out, because w

Starting SAP DB on Linux after Reboot

Hi, after I managed to get a SAP DB 7.4.3.32 instance up and running on my SuSE 9.1 machine, I encountered some problems with the init script that starts the database during system startup. The sequence that is executed during startup and shutdown looks this way (the script comes from the SuSE

Re: Again: SAPDB 7.4 on SuSE 9.1

Am Dienstag, 8. Juni 2004 10:36 schrieb Eckhard Jost: > The Version which comes with SuSE9.1 is buggy. You can not load the > systemtables. An easy solution is to get 7.4.3.32 as tgz and use the > install-scripts, like writen in the manual. Do not use the rpm's! They are > buggy! Do you mean the R

Re: Again: SAPDB 7.4 on SuSE 9.1

Am Mittwoch, 2. Juni 2004 19:42 schrieb Alexei Novakov: > I have no clue, but know that newer version 7.4.3.32 > is available as RPM download from SAPDB site. You > might want to try it. Sorry, the version is 7.4.3.31. And when I buy a Linux distribution, I expect that the software that is shippe

Again: SAPDB 7.4 on SuSE 9.1

Hi, did anybody get SAPDB 7.4 running on SuSE 9.1 with a Linux kernel 2.6.x? I tried to use the SAPDB 7.4.0.31 that comes with SuSE 9.1, but I did not get it running. I followed the suggestions from the list to increase the shared memory size and to set LD_ASSUME_KERNEL to 2.2.5, but then I get

Load system tables failed

Hi, after I managed the problem of starting a new database instance on a SuSE 9.1 system (Kernel 2.6.4) I get an error during loading the system tables. According to the shown error code (2816) I guess it's a different error as already described on the mailinglist, but I'm not sure. The error

Re: SAPDB 7.4 and SuSE 9.1

Am Mittwoch, 28. April 2004 15:28 schrieb Kittel, Martin: > Hi Ralf, > > have you tried 'export LD_ASSUME_KERNEL=2.2.5' before starting the > database? SAPDB/MaxDB currently does not work with the new thread > implementation that comes with the Linux 2.6 kernel series. In the meantime I got a hint

SAPDB 7.4 and SuSE 9.1

Hi, I've installed the brand new SuSE 9.1 (Kernel 2.6.4) and the SAPDB 7.4.0.31 that comes with it. When I try to create a new database instance with a script that worked fine for SAPDB 7.4.0.29 on SuSE 8.1 I get an error when starting the instance. Here is the beginning of the script which was

Re: JDBC and Struts

Am Dienstag, 20. April 2004 08:23 schrieb Schroeder, Alexander: > That exception does not come from the MaxDB JDBC Driver. Perhaps a 'Struts' > Mailing List would be a better starting point. My hope was that someone who did manage to get the Struts connection pooling working with SAP DB 7.4 could

JDBC and Struts

Hi, I'm trying to setup Struts 1.1 with a database connection using DBCP 1.1 to connect to a SAP DB 7.4 database. Unfortunately, I get the following error during startup of Tomcat (5.0.19): StandardContext[/demo_03]Servlet /demo_03 threw load() exception javax.servlet.UnavailableException: Initi

Re: Adding a File into a database

Am Montag, 8. März 2004 10:11 schrieb Marc Morgan: > Hi There, > > Is it possible to add a file into a database ? For example we have Of course, you can store them in columns of type LONG BYTE. I do that the fax documents, too. > electronic faxes that come through, we would like to take those ti

WebSQL with SSL

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I want to access a SAP DB instance (7.4 running on Linux) running on a webserver. For that, I want to use WebSQL with the SSL option I found in /var/spool/sql/ini/WebAgent74.ini. So I tried to set the option withSSL to 1 and sslURL to https://

Problem with GRANT

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I've encoutered a strange problem when creating a new table and granting access rights to this table to an existing role. After I create the table I execute the following command: GRANT INSERT, SELECT, UPDATE, DELETE ON faxvoice_calls, faxvoice_f