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.

Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error

6 posts in NT Last posting was on 2009-04-27 16:29:53.0Z
Kim Groves Posted on 2009-04-17 02:18:16.0Z
From: "Kim Groves" <kimg@steelforce.com.au>
Newsgroups: Advantage.NT
Subject: Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error
Date: Fri, 17 Apr 2009 12:18:16 +1000
Lines: 41045
Organization: digicate
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="----=_NextPart_000_002E_01C9BF56.9E2CAB30"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: 220.157.70.194
Message-ID: <49e7e77e@solutions.advantagedatabase.com>
X-Trace: 16 Apr 2009 20:20:46 -0700, 220.157.70.194
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!220.157.70.194
Xref: solutions.advantagedatabase.com Advantage.NT:1772
Article PK: 1131003

Hi Advantage Support,

Attached are the error logs from our production database server.

Unfortunately I could not find the adsdump* file(s) as specified at
http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/troubleshooting_and_technical_support/troubleshooting/adsdump_files.htm

The registry key MINIDUMPINTERVAL does not exist.

I am not sure that i could reproduce this error for you but this is what I
was doing at the time:

I was designing a report in Crystal Reports 2008 in Remote Desktop on the
same server as ADS. I was editing the report query, adding another field to
be returned by the query.

While Crystal was processing this change request (it executes the query and
then checks the returned data to determine data types of each field, whether
fields have been added/removed etc) I switched to a separate remote desktop
session on a different terminal server. This terminal server hosts our main
application. It is 16-bit so uses the older 16-bit ACE dlls to access the
database server. I was adding some data to the database using this
application so that I could test the report that I was working on. So both
applications were accessing the same database tables at the same time
(presumably). There was a delay and then both applications reported a
communication error with the database server. Did I mention that this is
production server? I started to sweat... Sure enough, the service had
stopped. I restarted it without error and emailed the ~100 users about the
problem and to reopen their applications and re-key their last transactions.

I realise we are a little behind on the Advantage 8.0/8.1 series
releases/patches. Can you confirm that upgrading Advantage Database Server
would address this issue? I believe it has happened in the past but I may
not have reported it.

Upgrading ADS is not a simple procedure for our company as our core
application is using 16-bit technology.

In the past (albeit on different hardware) I upgraded ADS 7.0 to ADS 7.1 and
afterwards was unable to execute any 16-bit applications on our server. (Not
just database applications, any application e.g. setup.exe's). The NTVDM
subsystem was inexplicably affected. So we would need to absolutely rule out
this possibility (through internal testing) before changing the production
server.

Thanks for your time,

Kim Groves
Steelforce
www.steelforce.com.au
kimg@steelforce.com.au


Mark Wilkins Posted on 2009-04-17 22:56:45.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.NT
References: <49e7e77e@solutions.advantagedatabase.com>
Subject: Re: Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error
Date: Fri, 17 Apr 2009 16:56:45 -0600
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 10.24.38.228
Message-ID: <49e90905@solutions.advantagedatabase.com>
X-Trace: 17 Apr 2009 16:56:05 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.NT:1773
Article PK: 1130823

Hi Kim,

The dump file capability was added in v8.0.0.9, so the version you have will
not produce the dump file. And unfortunately, without the dump file, it is
not simple to tell exactly what caused the exception. There is, though, a
query shown in the provided log file that looks as if it could be the
culprit. I would need the tables (probably with the data) to be sure. But
it seems probable that the problem was fixed in v8.10.0.38. I will send the
information to another developer to get his opinion on it too.

I noticed in the log file that you have 1 million locks configured. That
seems a bit high to me. I guess it's not a problem, but in the 18 days that
the server was running, the maximum used was about 250. I'm quite sure,
though, it has nothing to do with the problem you encountered. It was just
a random thing I noticed.

Mark Wilkins
Advantage R&D

"Kim Groves" <kimg@steelforce.com.au> wrote in message
news:49e7e77e@solutions.advantagedatabase.com...
> Hi Advantage Support,
>
> Attached are the error logs from our production database server.
>
> Unfortunately I could not find the adsdump* file(s) as specified at
>

...


Kim Groves Posted on 2009-04-24 01:40:52.0Z
From: "Kim Groves" <kimg@steelforce.com.au>
Newsgroups: Advantage.NT
References: <49e7e77e@solutions.advantagedatabase.com> <49e90905@solutions.advantagedatabase.com>
In-Reply-To: <49e90905@solutions.advantagedatabase.com>
Subject: Re: Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error
Date: Fri, 24 Apr 2009 11:40:52 +1000
Lines: 57
Organization: digicate
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: 220.157.70.194
Message-ID: <49f11883@solutions.advantagedatabase.com>
X-Trace: 23 Apr 2009 19:40:19 -0700, 220.157.70.194
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!220.157.70.194
Xref: solutions.advantagedatabase.com Advantage.NT:1774
Article PK: 1130825

Hi Mark,

I have upgraded the server to 8.1. Thank you very much.

Could a corrupted index file (due to a 9077/9095 error) lead to further
unexpected shutdowns of ADS? With 9029 errors?

We have performed a database maintenance (rebuild index files etc) which we
are hoping will resolve our issue (as well as upgrading the server to 8.1).

ADS shutdown unexpectedly at 3pm 23/04/2009 and has shutdown about 12 times
since then. There have been no shutdowns since the 8.1 upgrade/maintenance.

I should have done a database maintance yesterday but I guess I got confused
by the 9xxx errors. I would have thought invalid indexes would generate 7xxx
errors.

Anyway I can send the logs if you want but I will probably wait to see if it
crashes again and then we will have a dump file.

Thanks,

Kim Groves

"Mark Wilkins" <mark@no.email> wrote in message
news:49e90905@solutions.advantagedatabase.com...
> Hi Kim,
>
> The dump file capability was added in v8.0.0.9, so the version you have
> will not produce the dump file. And unfortunately, without the dump file,
> it is not simple to tell exactly what caused the exception. There is,
> though, a query shown in the provided log file that looks as if it could
> be the culprit. I would need the tables (probably with the data) to be
> sure. But it seems probable that the problem was fixed in v8.10.0.38. I
> will send the information to another developer to get his opinion on it
> too.
>
> I noticed in the log file that you have 1 million locks configured. That
> seems a bit high to me. I guess it's not a problem, but in the 18 days
> that the server was running, the maximum used was about 250. I'm quite
> sure, though, it has nothing to do with the problem you encountered. It
> was just a random thing I noticed.
>
> Mark Wilkins
> Advantage R&D
>
> "Kim Groves" <kimg@steelforce.com.au> wrote in message
> news:49e7e77e@solutions.advantagedatabase.com...
>> Hi Advantage Support,
>>
>> Attached are the error logs from our production database server.
>>
>> Unfortunately I could not find the adsdump* file(s) as specified at
>>
> ...
>


Mark Wilkins Posted on 2009-04-24 14:32:38.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.NT
References: <49e7e77e@solutions.advantagedatabase.com> <49e90905@solutions.advantagedatabase.com> <49f11883@solutions.advantagedatabase.com>
Subject: Re: Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error
Date: Fri, 24 Apr 2009 08:32:38 -0600
Lines: 51
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <49f1cd5c@solutions.advantagedatabase.com>
X-Trace: 24 Apr 2009 08:31:56 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.NT:1775
Article PK: 1130862

Hi Kim,

In theory, a corrupt index file "should" not result in any 9000 errors. If
we found a situation that did lead to a 9000 error, we would change it to
log a 7000 class error typically. The 9000 errors are generally logged in
the code if it is in a logical situation that "should not happen". I know
there are a number of those that we have fixed in the past. And in
particular, the logging of the 9029 error on the failure to create a
semaphore file is one of those. That was changed in v9.x to not produce the
dump file (although I do think the error is still 9029).

Are you intentionally using semaphore files? Unless there is a specific
reason, it is probably best to turn those off. You can turn them off in the
configuration utility (ads_cfg.exe) under the configuration\communications
tab.

I think waiting to see what happens with the upgraded server is the best
bet - that way (as you noted) we should have a dump file to work with.

Mark Wilkins
Advantage R&D

"Kim Groves" <kimg@steelforce.com.au> wrote in message
news:49f11883@solutions.advantagedatabase.com...
> Hi Mark,
>
> I have upgraded the server to 8.1. Thank you very much.
>
> Could a corrupted index file (due to a 9077/9095 error) lead to further
> unexpected shutdowns of ADS? With 9029 errors?
>
> We have performed a database maintenance (rebuild index files etc) which
> we are hoping will resolve our issue (as well as upgrading the server to
> 8.1).
>
> ADS shutdown unexpectedly at 3pm 23/04/2009 and has shutdown about 12
> times since then. There have been no shutdowns since the 8.1
> upgrade/maintenance.
>
> I should have done a database maintance yesterday but I guess I got
> confused by the 9xxx errors. I would have thought invalid indexes would
> generate 7xxx errors.
>
> Anyway I can send the logs if you want but I will probably wait to see if
> it crashes again and then we will have a dump file.
>
> Thanks,
>
> Kim Groves
>


Kim Groves Posted on 2009-04-25 10:50:20.0Z
From: "Kim Groves" <kimg@steelforce.com.au>
Newsgroups: Advantage.NT
References: <49e7e77e@solutions.advantagedatabase.com> <49e90905@solutions.advantagedatabase.com> <49f11883@solutions.advantagedatabase.com> <49f1cd5c@solutions.advantagedatabase.com>
In-Reply-To: <49f1cd5c@solutions.advantagedatabase.com>
Subject: Re: Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error
Date: Sat, 25 Apr 2009 20:50:20 +1000
Lines: 76
Organization: digicate
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: 58.173.154.217
Message-ID: <49f2eacb@solutions.advantagedatabase.com>
X-Trace: 25 Apr 2009 04:49:47 -0700, 58.173.154.217
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!58.173.154.217
Xref: solutions.advantagedatabase.com Advantage.NT:1776
Article PK: 1130858

Hi Mark,

Server has been running for about 36 hours now there shouldn't be any more
crashes.

Our core application is supplied by a vendor. I think that is where the
semaphore files come from. I wouldn't want to disable them :) The
application is written in Visual Objects I think (16-bit) but a new
32/64-bit application version is promised.

In the meantime, I am writing/re-writing various screens in C# .Net to
resolve performance issues, bolt on new features etc. These screens are
accessed via a shell command tied into scriptable events/hooks exposed by
the VO application. I am pretty sure the 9077/9095 errors first originated
from the .Net code. My impression is that this is a common scenario, using
ADS to serve legacy DBF data while porting to newer technologies, using
multiple API's to access the data.

Regards,

Kim Groves

"Mark Wilkins" <mark@no.email> wrote in message
news:49f1cd5c@solutions.advantagedatabase.com...
> Hi Kim,
>
> In theory, a corrupt index file "should" not result in any 9000 errors.
> If we found a situation that did lead to a 9000 error, we would change it
> to log a 7000 class error typically. The 9000 errors are generally logged
> in the code if it is in a logical situation that "should not happen". I
> know there are a number of those that we have fixed in the past. And in
> particular, the logging of the 9029 error on the failure to create a
> semaphore file is one of those. That was changed in v9.x to not produce
> the dump file (although I do think the error is still 9029).
>
> Are you intentionally using semaphore files? Unless there is a specific
> reason, it is probably best to turn those off. You can turn them off in
> the configuration utility (ads_cfg.exe) under the
> configuration\communications tab.
>
> I think waiting to see what happens with the upgraded server is the best
> bet - that way (as you noted) we should have a dump file to work with.
>
> Mark Wilkins
> Advantage R&D
>
> "Kim Groves" <kimg@steelforce.com.au> wrote in message
> news:49f11883@solutions.advantagedatabase.com...
>> Hi Mark,
>>
>> I have upgraded the server to 8.1. Thank you very much.
>>
>> Could a corrupted index file (due to a 9077/9095 error) lead to further
>> unexpected shutdowns of ADS? With 9029 errors?
>>
>> We have performed a database maintenance (rebuild index files etc) which
>> we are hoping will resolve our issue (as well as upgrading the server to
>> 8.1).
>>
>> ADS shutdown unexpectedly at 3pm 23/04/2009 and has shutdown about 12
>> times since then. There have been no shutdowns since the 8.1
>> upgrade/maintenance.
>>
>> I should have done a database maintance yesterday but I guess I got
>> confused by the 9xxx errors. I would have thought invalid indexes would
>> generate 7xxx errors.
>>
>> Anyway I can send the logs if you want but I will probably wait to see if
>> it crashes again and then we will have a dump file.
>>
>> Thanks,
>>
>> Kim Groves
>>
>


Mark Wilkins Posted on 2009-04-27 16:29:53.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: Advantage.NT
References: <49e7e77e@solutions.advantagedatabase.com> <49e90905@solutions.advantagedatabase.com> <49f11883@solutions.advantagedatabase.com> <49f1cd5c@solutions.advantagedatabase.com> <49f2eacb@solutions.advantagedatabase.com>
Subject: Re: Advantage Database Server 8.00.0.4 on MS Windows Server 2003 R2 -- Service stops with 9095 error
Date: Mon, 27 Apr 2009 10:29:53 -0600
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 10.24.38.228
Message-ID: <49f5dd57@solutions.advantagedatabase.com>
X-Trace: 27 Apr 2009 10:29:11 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.NT:1777
Article PK: 1130860

Hi Kim,

That makes sense. Using a legacy application is a good "specific reason"
for leaving semaphore files turned on.

Mark Wilkins
Advantage R&D

"Kim Groves" <kimg@steelforce.com.au> wrote in message
news:49f2eacb@solutions.advantagedatabase.com...
> Hi Mark,
>
> Server has been running for about 36 hours now there shouldn't be any more
> crashes.
>
> Our core application is supplied by a vendor. I think that is where the
> semaphore files come from. I wouldn't want to disable them :) The
> application is written in Visual Objects I think (16-bit) but a new
> 32/64-bit application version is promised.
>
> In the meantime, I am writing/re-writing various screens in C# .Net to
> resolve performance issues, bolt on new features etc. These screens are
> accessed via a shell command tied into scriptable events/hooks exposed by
> the VO application. I am pretty sure the 9077/9095 errors first originated
> from the .Net code. My impression is that this is a common scenario, using
> ADS to serve legacy DBF data while porting to newer technologies, using
> multiple API's to access the data.
>
> Regards,
>
> Kim Groves
>