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.

Events Failing

4 posts in General Discussion Last posting was on 2004-03-26 20:07:19.0Z
Billy Willoughby Posted on 2004-03-24 13:17:59.0Z
From: "Billy Willoughby" <Billy@FultonPaper.com>
Newsgroups: ianywhere.public.general
Subject: Events Failing
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 64.240.244.75
X-Original-NNTP-Posting-Host: 64.240.244.75
Message-ID: <40618a87$1@forums-1-dub>
Date: 24 Mar 2004 05:17:59 -0800
X-Trace: forums-1-dub 1080134279 64.240.244.75 (24 Mar 2004 05:17:59 -0800)
X-Original-Trace: 24 Mar 2004 05:17:59 -0800, 64.240.244.75
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2834
Article PK: 6306

Good Morning;

I have events that are running in an ASA 8 database. The events
do nothing but call a stored procedure that runs daily. These events will
work fine for months, and then one of them will simply stop firing. Once it
stops, it will never start again till I drop the event and recreate it.
I've tried changing various parts of the event to try to get it to work
again without success.(i.e. time, content) If I can't find a way to keep
the event reliable, I'm going to have to take them outside the database
again which I don't want.

Any ideas?

Thanks,

Billy Willoughby

Details:
ASA 8.0.2.4285
Server: Windows 2000 SP 4
Dual Processors 1.7g
Memory 1.5g


"Bruce Hay" Posted on 2004-03-24 14:26:01.0Z
From: "Bruce Hay" <hay at sybase dot com>
Newsgroups: ianywhere.public.general
References: <40618a87$1@forums-1-dub>
Subject: Re: Events Failing
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: hay-xp.sybase.com
X-Original-NNTP-Posting-Host: hay-xp.sybase.com
Message-ID: <40619a79$1@forums-1-dub>
Date: 24 Mar 2004 06:26:01 -0800
X-Trace: forums-1-dub 1080138361 10.25.99.106 (24 Mar 2004 06:26:01 -0800)
X-Original-Trace: 24 Mar 2004 06:26:01 -0800, hay-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2835
Article PK: 6305

A problem similar to this was fixed in 8.0.2.4372. The latest 8.0.2 EBF will
have the fix.

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

"Billy Willoughby" <Billy@FultonPaper.com> wrote in message
news:40618a87$1@forums-1-dub...
> Good Morning;
>
> I have events that are running in an ASA 8 database. The
events
> do nothing but call a stored procedure that runs daily. These events will
> work fine for months, and then one of them will simply stop firing. Once
it
> stops, it will never start again till I drop the event and recreate it.
> I've tried changing various parts of the event to try to get it to work
> again without success.(i.e. time, content) If I can't find a way to keep
> the event reliable, I'm going to have to take them outside the database
> again which I don't want.
>
> Any ideas?
>
> Thanks,
>
> Billy Willoughby
>
> Details:
> ASA 8.0.2.4285
> Server: Windows 2000 SP 4
> Dual Processors 1.7g
> Memory 1.5g
>
>


Billy Willoughby Posted on 2004-03-25 13:51:41.0Z
From: "Billy Willoughby" <Billy@FultonPaper.com>
Newsgroups: ianywhere.public.general
References: <40618a87$1@forums-1-dub> <40619a79$1@forums-1-dub>
Subject: Re: Events Failing
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 64.240.244.75
X-Original-NNTP-Posting-Host: 64.240.244.75
Message-ID: <4062e3ed$1@forums-1-dub>
Date: 25 Mar 2004 05:51:41 -0800
X-Trace: forums-1-dub 1080222701 64.240.244.75 (25 Mar 2004 05:51:41 -0800)
X-Original-Trace: 25 Mar 2004 05:51:41 -0800, 64.240.244.75
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2846
Article PK: 6317

Thanks, I'll download that and install it today. Where would I find this
kind of information?, I couldn't find it in the solved cases search...

"Bruce Hay" <hay at sybase dot com> wrote in message
news:40619a79$1@forums-1-dub...
> A problem similar to this was fixed in 8.0.2.4372. The latest 8.0.2 EBF
will
> have the fix.
>
> Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> Developer Community at http://www.ianywhere.com/developer
>
> "Billy Willoughby" <Billy@FultonPaper.com> wrote in message
> news:40618a87$1@forums-1-dub...
> > Good Morning;
> >
> > I have events that are running in an ASA 8 database. The
> events
> > do nothing but call a stored procedure that runs daily. These events
will
> > work fine for months, and then one of them will simply stop firing.
Once
> it
> > stops, it will never start again till I drop the event and recreate it.
> > I've tried changing various parts of the event to try to get it to work
> > again without success.(i.e. time, content) If I can't find a way to
keep
> > the event reliable, I'm going to have to take them outside the database
> > again which I don't want.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Billy Willoughby
> >
> > Details:
> > ASA 8.0.2.4285
> > Server: Windows 2000 SP 4
> > Dual Processors 1.7g
> > Memory 1.5g
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-03-26 20:07:19.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <40618a87$1@forums-1-dub> <40619a79$1@forums-1-dub> <4062e3ed$1@forums-1-dub>
Subject: Re: Events Failing
Lines: 83
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 10.25.100.133
X-Original-NNTP-Posting-Host: 10.25.100.133
Message-ID: <40648d77@forums-1-dub>
Date: 26 Mar 2004 12:07:19 -0800
X-Trace: forums-1-dub 1080331639 10.25.100.133 (26 Mar 2004 12:07:19 -0800)
X-Original-Trace: 26 Mar 2004 12:07:19 -0800, 10.25.100.133
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2857
Article PK: 6328

You should also look at CHANGE REQUESTS option..

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Billy Willoughby" <Billy@FultonPaper.com> wrote in message
news:4062e3ed$1@forums-1-dub...
> Thanks, I'll download that and install it today. Where would I find this
> kind of information?, I couldn't find it in the solved cases search...
>
> "Bruce Hay" <hay at sybase dot com> wrote in message
> news:40619a79$1@forums-1-dub...
> > A problem similar to this was fixed in 8.0.2.4372. The latest 8.0.2 EBF
> will
> > have the fix.
> >
> > Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
> > Developer Community at http://www.ianywhere.com/developer
> >
> > "Billy Willoughby" <Billy@FultonPaper.com> wrote in message
> > news:40618a87$1@forums-1-dub...
> > > Good Morning;
> > >
> > > I have events that are running in an ASA 8 database. The
> > events
> > > do nothing but call a stored procedure that runs daily. These events
> will
> > > work fine for months, and then one of them will simply stop firing.
> Once
> > it
> > > stops, it will never start again till I drop the event and recreate
it.
> > > I've tried changing various parts of the event to try to get it to
work
> > > again without success.(i.e. time, content) If I can't find a way to
> keep
> > > the event reliable, I'm going to have to take them outside the
database
> > > again which I don't want.
> > >
> > > Any ideas?
> > >
> > > Thanks,
> > >
> > > Billy Willoughby
> > >
> > > Details:
> > > ASA 8.0.2.4285
> > > Server: Windows 2000 SP 4
> > > Dual Processors 1.7g
> > > Memory 1.5g
> > >
> > >
> >
> >
>
>