-2 wrong username password combination

2003-10-29 Thread dinh thanh
When I start Database Manager Second Edition 7.4 there is a warning "-2 wrong username password combination". I dont know what it mean.Could you help me? Thank you.

3102 Invalid subtrans structure error

2003-10-29 Thread Damien Dallimore
Hi, I was wondering if anyone could help with out with some information about this error type. Basically I have some simple triggers that respond to insert, update and delete actions on some of our tables.In the trigger code it does an INSERT into another table for auditing purposes. EXAMPLE :

Announce: SapdbTcl 0.5

2003-10-29 Thread Christian Krone
Hello again, many thanks for all answers, I received for my query last week about server space for an SAB DB releated OpenSource Tcl project. I've got so many different offers, that I'm right now not sure which one to use. And since I already have a SourceForge account, I created a new sapdbtcl pr

UPDATE TRIGGER - Syntax the 2nd

2003-10-29 Thread Hannes Degenhart
Hello list once more, I try to implement a referential constraint "ON UPDATE CASCADE" with a trigger. If somebody says SAPDB has this constraint included, please let me know (I know only "ON DELETE CASCADE"). I have to update more than one table after updating the "Master-Table". Trigger 1 (Up

RE: How to get LONG column's data real size?

2003-10-29 Thread Simenec, Thomas
Hi Valeriy, set the parameter Size of getObject() to 0. After calling getObject(), you have the data length in bytes of the whole long column in the variable LengthIndicator without fetching the long data. Regards, Thomas Simenec SAP Labs Berlin -Original Message- From: Valeriy Kravchuk

UPDATE TRIGGER - Syntax

2003-10-29 Thread Hannes Degenhart
Hello list, I'm using SAPDB 7.3.0 and have created an UPDATE TRIGGER like this: 1. with column list: CREATE TRIGGER triggername FOR table_a AFTER UPDATE (IKINDEX, IKALTERNATIV) EXECUTE ( 2. without column list: CREATE TRIGGER triggername FOR table_a AFTER UPDATE EXECUTE ( Could it be that 2.

Re: SAPDB standy - minimal delay

2003-10-29 Thread Yves Trudeau
I think it is useless, the log are enough, and it will slow down the database. Yves Filip Sergeys wrote: Hello, Thanks for the reply. Is there a reason not to use drdb for network mirroring the datafile? Filip On Wed, 2003-10-29 at 14:38, Yves Trudeau wrote: Hi, I have a similar setup which

Re: SAPDB standy - minimal delay

2003-10-29 Thread Filip Sergeys
Hello, Thanks for the reply. Is there a reason not to use drdb for network mirroring the datafile? Filip On Wed, 2003-10-29 at 14:38, Yves Trudeau wrote: > Hi, > I have a similar setup which uses drbd, a network raid solution on > Linux, to backup the log partition. With the log and the l

Re: How to get LONG column's data real size?

2003-10-29 Thread Sven Ko"hler
Is there any way to get real data size for LONG column in SQLDBC (or, for that matter, from any other SAP DB interface)? I mean, without fetching them by means of getObject... how about the length() function? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To uns

How to get LONG column's data real size?

2003-10-29 Thread Valeriy Kravchuk
Is there any way to get real data size for LONG column in SQLDBC (or, for that matter, from any other SAP DB interface)? I mean, without fetching them by means of getObject... -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.c

Re: SAPDB standy - minimal delay

2003-10-29 Thread Yves Trudeau
Hi, I have a similar setup which uses drbd, a network raid solution on Linux, to backup the log partition. With the log and the last backup, our secondary server can be in production in a few minutes. I once wrote a howto (a bit old now...) http://www.tdtconsultants.ca/Yves/Sapdb-standby-HA-Ho

SAPDB standy - minimal delay

2003-10-29 Thread Filip Sergeys
Hello, I'm comparing a few scenarios for a new server configuration where data availability is important. A solution based on SAN is not possible because to expensive. Thus I need to find a way to keep a less powerfull standby SAPDB server as updated as possible SAPDB documentation notes "You can

RE: loadercli performance loss when upgrading from 7.3 to 7.4

2003-10-29 Thread Alexander Hahn
Hi all, the problem disappeared when we upgraded to the next server version 7.4.3.27. Kudos to the sap team for prompt support! Alexander Hahn -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Bug in JDBC Driver: Calling getBigDecimal results in ConversionExceptionSapDB

2003-10-29 Thread Thomas Rohwer
is the problem reproducable, or occurs it randomly? The test program I posted produces the error during every run. Does the test program yield an error, if you run it? If its reproducable, would you mind creating a VTrace? (see http://sapdb.2scale.net/moin.cgi/VTrace on howto do it) Ok, I will try

Re: no data from log in database after restore

2003-10-29 Thread Thorsten Weers
Hello Uwe, thank you for your quick anwer. With admin mode, you think of the state of the database? If so, it looks like a more severe problem, because the db is set to this state before doing the log in the script sap_logtest_01.sh.. ... dbmcli -d $SID -u $DBUSER,$DBPASS db_cold >>$LOG 2>&1

RE: SAPDB Backup -> PIPE

2003-10-29 Thread Heinrich, Tilo
Hello Michael, is the error reproducible? What is your backup command? What is the command causing the DBM-Api error ( -4'connection broken')? Best regards, Tilo Heinrich -Original Message- From: Michael Mostkowiak [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 2:45 PM To: [E

RE:Installation error / was RE: Bug in JDBC Driver: Calling getBi gDecimal results in ConversionExceptionSapDB

2003-10-29 Thread Schroeder, Alexander
Hello, Would you mind sending problems to the mailing list instead directly to people? Thanks. The installer is possibly not working under Cygwin because one of the programs that come with Cygwin interferes with its scripts. I can suggest only working around by running the installer in Windows o

RE: Bug in JDBC Driver: Calling getBigDecimal results in Conversi onExceptionSapDB

2003-10-29 Thread Schroeder, Alexander
Hello, is the problem reproducable, or occurs it randomly? If its reproducable, would you mind creating a VTrace? (see http://sapdb.2scale.net/moin.cgi/VTrace on howto do it) The question is whether the data is already corrupted (that '1' in the number shown in the error message) on server side,

RE: Resume of sapdb after resume of computer

2003-10-29 Thread Schroeder, Alexander
Hi, first, if your problem is related to an SAP R/3 system , you should usually open an OSS message, as this mailing list is on the open-source flavour of SAP DB/Max DB. Second, if the database does not start the knldiag usually shows more details on what went wrong (see http://sapdb.2scale.net/