Hello, I heve installed SapDB 7.4.03.31, but my problem is not solved. With the new version this trigger works like before.
Regards, Dusan
On Wed, 10 Mar 2004 15:38:14 +0100, Anhaus, Thomas <[EMAIL PROTECTED]> wrote:
Hi Dusan,
thanks for mailing the additional information.
I noticed that you run 7.4.03.17. Even though I can't guarantee that it will help
I would like to recommend to upgrade to the current 7.4.03.31 version.
I do that because I know that we fixed many bugs concerning
triggers and db-procedures.
Sorry that I can't prove this, because I don't have the time to go back
to 7.4.03.17.
Best Regards Thomas
-----Original Message----- From: Dusan Kolesar [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 10. März 2004 14:03 To: Zabach, Elke Cc: SAP DB mailing list Subject: Re: Trigger problem - database crash
On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke <[EMAIL PROTECTED]> wrote:
Dusan Kolesar wrote:
Hello,
I have one problematic trigger. When I insert into LEVEL table, all database instance crash down. When there is the same trigger but without 2 lines: line 16 and 31 is EXECUTE insertstmt; everything is running and in the debug table TEST I can see all correct insert statemants. Trigger is also running when there is only one prat of it (parts are separated by empty line). Can you help me, please. What am I doing wrong?
Regards, Dusan
You told us that after inserting into LEVEL, the database crashes. But you send us an update trigger, not fired after insert. Where is the mistake? Are we looking onto the needed info?
Which version do you use? How does the traceback look like? Are we talking about ASCII or Unicode-database? Can you provide a vtrace according to http://sapdb.2scale.net/moin.cgi/VTrace
Elke SAP Labs Berlin
Sorry, this was my mistake. Database crashes after updateing TEST table (column DESCR), of course. I'm using SapDB 7.4.3 BUILD 017-123-039-277 on WinXp(SP1). DEFAUL_CODE='ASCII'. I don't what traceback is. Can you explain me how can I get it. I tryed to make vtrace, but it's not possible. My sequence is: dbmcli -d fleetdb -u name,passwd util_execute diagnose vtrace default on return: OK My update execution dbmcli -d fleet -u name,passwd util_execute diagnose vtrace flush return: Error! Connection failed to node (local) for database fleet: cserver not found
Regards, Dusan
-- Dusan Kolesar Helsinska 19 040 13 Kosice Slovakia e-mail : [EMAIL PROTECTED] ICQ# : 160507424
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
