Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database Trigger Corruption?

3 posts in General Discussion Last posting was on 2004-08-24 19:34:55.0Z
M. Pezzi Posted on 2004-08-24 13:51:14.0Z
Sender: 2c82.412b40e6.1804289383@sybase.com
From: M. Pezzi
Newsgroups: ianywhere.public.general
Subject: Database Trigger Corruption?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <412b4930.2d13.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 24 Aug 2004 06:57:04 -0700, 10.22.241.42
Lines: 9
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2004 06:41:03 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2004 06:51:14 -0700
X-Trace: forums-1-dub 1093355474 10.22.108.75 (24 Aug 2004 06:51:14 -0700)
X-Original-Trace: 24 Aug 2004 06:51:14 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3417
Article PK: 7325

ASA 9.0/Windows 2000/XP

Database Triggers appear to stop firing. Obtain "Invalid
Statement" on
attempts to insert/update via ISQL. While not a palpable
solution,
Dropping and re-inserting all of the triggers clears up the
problem.
Any ideas on what could be causing this problem?


Stephen Rice Posted on 2004-08-24 18:16:52.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Database Trigger Corruption?
From: Stephen Rice <srice_nospam@ianywhere.com>
References: <412b4930.2d13.1681692777@sybase.com>
Organization: iAnywhere Solutions
Message-ID: <Xns954F8F90BBD4Asricenospamianywhere@10.22.241.106>
User-Agent: Xnews/5.04.25
X-Original-NNTP-Posting-Host: srice-pc1.sybase.com
X-Original-Trace: 24 Aug 2004 11:22:55 -0700, srice-pc1.sybase.com
Lines: 38
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2004 11:06:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2004 11:16:52 -0700
X-Trace: forums-1-dub 1093371412 10.22.108.75 (24 Aug 2004 11:16:52 -0700)
X-Original-Trace: 24 Aug 2004 11:16:52 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3419
Article PK: 7324


M. Pezzi wrote in news:412b4930.2d13.1681692777@sybase.com:

> ASA 9.0/Windows 2000/XP
>
> Database Triggers appear to stop firing. Obtain "Invalid
> Statement" on
> attempts to insert/update via ISQL. While not a palpable
> solution,
> Dropping and re-inserting all of the triggers clears up the
> problem.
> Any ideas on what could be causing this problem?
>

I did a couple of quick checks on the fix logs and found nothing
resembling this :(

After the triggers start giving the error does the database pass
validation?

When you debug the execution, after the "corruption", is it obvious what
has changed (if anything)? What statement generates the error?

Can you post one of the triggers?

Also please post the build number of v9

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions

- Please Post-
Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
Developer Community at www.ianywhere.com/developer


Rick Blythe Posted on 2004-08-24 19:34:55.0Z
Reply-To: "Rick Blythe" <nospam__rickb@sybase.com>
From: "Rick Blythe" <nospam__rickb@sybase.com>
Newsgroups: ianywhere.public.general
References: <412b4930.2d13.1681692777@sybase.com>
Subject: Re: Database Trigger Corruption?
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: rickb-pc.sybase.com
Message-ID: <412b99cd$1@forums-2-dub>
X-Original-Trace: 24 Aug 2004 12:41:01 -0700, rickb-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 24 Aug 2004 12:24:57 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 24 Aug 2004 12:34:55 -0700
X-Trace: forums-1-dub 1093376095 10.22.108.75 (24 Aug 2004 12:34:55 -0700)
X-Original-Trace: 24 Aug 2004 12:34:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3421
Article PK: 7326

All triggers? or all triggers over a certain length?



<M. Pezzi> wrote in message news:412b4930.2d13.1681692777@sybase.com...
ASA 9.0/Windows 2000/XP

Database Triggers appear to stop firing. Obtain "Invalid
Statement" on
attempts to insert/update via ISQL. While not a palpable
solution,
Dropping and re-inserting all of the triggers clears up the
problem.
Any ideas on what could be causing this problem?