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.

Running out of procedure cache

5 posts in General Discussion Last posting was on 2010-10-26 17:54:19.0Z
sybuser Posted on 2010-10-25 18:51:46.0Z
Sender: 33cd.4cc5d166.1804289383@sybase.com
From: sybuser
Newsgroups: sybase.public.ase.general
Subject: Running out of procedure cache
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cc5d1c2.33d5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Oct 2010 11:51:46 -0700
X-Trace: forums-1-dub 1288032706 10.22.241.41 (25 Oct 2010 11:51:46 -0700)
X-Original-Trace: 25 Oct 2010 11:51:46 -0700, 10.22.241.41
Lines: 239
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29659
Article PK: 78893

print '<<<<< CREATING Table - "tempdb.dbo.zzz_aaa_rev"
>>>>>'
go
use tempdb
go
create table zzz_aaa_rev (
it_bkng_book_no int
not null ,
it_price_amt money
null ,
bkng_early_arrival datetime
null ,
client_location_id int
not null ,
type varchar(2)
not null
)
lock allpages
on 'default'
go

1> use tempdb
2> go
1> select count(*) from zzz_aaa_rev
2> go

-----------
19045

(1 row affected)

============
QUERY 1
============
use tempdb
go
select
'Client' = client_location_id,
'Rev Jan OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'OM' then it_bkng_book_no
end),
'Rev Jan OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'OA' then it_bkng_book_no
end),
'Rev Jan NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'NM' then it_bkng_book_no
end),
'Rev Jan NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'NA' then it_bkng_book_no
end),
'Rev Feb OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'OM' then it_bkng_book_no
end),
'Rev Feb OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'OA' then it_bkng_book_no
end),
'Rev Feb NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'NM' then it_bkng_book_no
end),
'Rev Feb NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'NA' then it_bkng_book_no
end),
'Rev Mar OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'OM' then it_bkng_book_no
end),
'Rev Mar OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'OA' then it_bkng_book_no
end),
'Rev Mar NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'NM' then it_bkng_book_no
end),
'Rev Mar NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'NA' then it_bkng_book_no
end),
'Rev Apr OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'OM' then it_bkng_book_no
end),
'Rev Apr OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'OA' then it_bkng_book_no
end),
'Rev Apr NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'NM' then it_bkng_book_no
end),
'Rev Apr NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'NA' then it_bkng_book_no
end),
'Rev May OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'OM' then it_bkng_book_no
end),
'Rev May OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'OA' then it_bkng_book_no
end),
'Rev May NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'NM' then it_bkng_book_no
end),
'Rev May NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'NA' then it_bkng_book_no
end),
'Rev Jun OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'OM' then it_bkng_book_no
end),
'Rev Jun OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'OA' then it_bkng_book_no
end),
'Rev Jun NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'NM' then it_bkng_book_no
end),
'Rev Jun NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'NA' then it_bkng_book_no
end)

from tempdb..zzz_aaa_rev
group by client_location_id
order by client_location_id
go
=======
ERRORS:
=======
Msg 7789, Level 16, State 1:
Server 'SYBASE_QA', Line 1:
Unable to allocate work table for processing group by or
distinct clause during query optimization. Maximum limit
(46) of work tables is exceeded. Simplify the query and
retry.



================
QUERY 2
================

use tempdb
go
select
'Client' = client_location_id,
-- 'Rev Jan OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'OM' then it_bkng_book_no
end),
-- 'Rev Jan OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'OA' then it_bkng_book_no
end),
-- 'Rev Jan NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'NM' then it_bkng_book_no
end),
-- 'Rev Jan NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 1 and type = 'NA' then it_bkng_book_no
end),
'Rev Feb OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'OM' then it_bkng_book_no
end),
'Rev Feb OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'OA' then it_bkng_book_no
end),
'Rev Feb NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'NM' then it_bkng_book_no
end),
'Rev Feb NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 2 and type = 'NA' then it_bkng_book_no
end),
'Rev Mar OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'OM' then it_bkng_book_no
end),
'Rev Mar OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'OA' then it_bkng_book_no
end),
'Rev Mar NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'NM' then it_bkng_book_no
end),
'Rev Mar NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 3 and type = 'NA' then it_bkng_book_no
end),
'Rev Apr OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'OM' then it_bkng_book_no
end),
'Rev Apr OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'OA' then it_bkng_book_no
end),
'Rev Apr NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'NM' then it_bkng_book_no
end),
'Rev Apr NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 4 and type = 'NA' then it_bkng_book_no
end),
'Rev May OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'OM' then it_bkng_book_no
end),
'Rev May OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'OA' then it_bkng_book_no
end),
'Rev May NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'NM' then it_bkng_book_no
end),
'Rev May NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 5 and type = 'NA' then it_bkng_book_no
end),
'Rev Jun OM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'OM' then it_bkng_book_no
end),
'Rev Jun OA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'OA' then it_bkng_book_no
end),
'Rev Jun NM' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'NM' then it_bkng_book_no
end),
'Rev Jun NA' = count(distinct case when datepart(mm,
bkng_early_arrival) = 6 and type = 'NA' then it_bkng_book_no
end)

from tempdb..zzz_aaa_rev
group by client_location_id
order by client_location_id
go
=======
ERRORS:
=======

Msg 701, Level 17, State 3:
Server 'SYBASE_QA', Line 1:
There is not enough procedure cache to run this procedure,
trigger, or SQL batch. Retry later, or ask your SA to
reconfigure ASE with more procedure cache.

Parameter Name Default Memory
Used Config Value Run Value Unit
Type
------------------------------ --------------------
----------- -------------------- --------------------
-------------------- ----------
procedure cache size 7000
1307856 600000 600000 memory
pages(2k) dynamic



The first error seems self-explanatory with the number of
worktables being exceeded.
Wondering if the second scenario is a bug (table seems small
enough) and if not, how to estimate the size of the
procedure cache?


J Posted on 2010-10-25 20:47:30.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Running out of procedure cache
Reply-To: J@bogusemailAddress.com
Message-ID: <4cc5eab8.885964734@forums.sybase.com>
References: <4cc5d1c2.33d5.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 25 Oct 2010 13:47:30 -0700
X-Trace: forums-1-dub 1288039650 10.22.241.152 (25 Oct 2010 13:47:30 -0700)
X-Original-Trace: 25 Oct 2010 13:47:30 -0700, vip152.sybase.com
Lines: 256
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29661
Article PK: 78889

On 25 Oct 2010 11:51:46 -0700, sybuser wrote:

What version is your ASE? select @@version.

The state on the error message identifies this as a problem:

701 State 3 unable to find sufficient space to accomodate the query in
the current procedure header.

There are some bugs fixes related to this problem.


Jay

>print '<<<<< CREATING Table - "tempdb.dbo.zzz_aaa_rev"
>>>>>>'
>go
>use tempdb
>go
>create table zzz_aaa_rev (
> it_bkng_book_no int
> not null ,
> it_price_amt money
> null ,
> bkng_early_arrival datetime
> null ,
> client_location_id int
> not null ,
> type varchar(2)
> not null
>)
>lock allpages
> on 'default'
>go
>
>1> use tempdb
>2> go
>1> select count(*) from zzz_aaa_rev
>2> go
>
> -----------
> 19045
>
>(1 row affected)
>
>============
>QUERY 1
>============
>use tempdb
>go
>select
> 'Client' = client_location_id,
> 'Rev Jan OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Jan OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Jan NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Jan NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Feb OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Feb OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Feb NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Feb NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Mar OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Mar OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Mar NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Mar NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Apr OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Apr OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Apr NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Apr NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev May OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev May OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev May NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev May NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Jun OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Jun OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Jun NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Jun NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'NA' then it_bkng_book_no
>end)
>
>from tempdb..zzz_aaa_rev
>group by client_location_id
>order by client_location_id
>go
>=======
>ERRORS:
>=======
>Msg 7789, Level 16, State 1:
>Server 'SYBASE_QA', Line 1:
>Unable to allocate work table for processing group by or
>distinct clause during query optimization. Maximum limit
>(46) of work tables is exceeded. Simplify the query and
>retry.
>
>
>
>================
>QUERY 2
>================
>
>use tempdb
>go
>select
> 'Client' = client_location_id,
>-- 'Rev Jan OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'OM' then it_bkng_book_no
>end),
>-- 'Rev Jan OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'OA' then it_bkng_book_no
>end),
>-- 'Rev Jan NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'NM' then it_bkng_book_no
>end),
>-- 'Rev Jan NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 1 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Feb OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Feb OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Feb NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Feb NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 2 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Mar OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Mar OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Mar NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Mar NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 3 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Apr OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Apr OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Apr NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Apr NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 4 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev May OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev May OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev May NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev May NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 5 and type = 'NA' then it_bkng_book_no
>end),
> 'Rev Jun OM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'OM' then it_bkng_book_no
>end),
> 'Rev Jun OA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'OA' then it_bkng_book_no
>end),
> 'Rev Jun NM' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'NM' then it_bkng_book_no
>end),
> 'Rev Jun NA' = count(distinct case when datepart(mm,
>bkng_early_arrival) = 6 and type = 'NA' then it_bkng_book_no
>end)
>
>from tempdb..zzz_aaa_rev
>group by client_location_id
>order by client_location_id
>go
>=======
>ERRORS:
>=======
>
>Msg 701, Level 17, State 3:
>Server 'SYBASE_QA', Line 1:
>There is not enough procedure cache to run this procedure,
>trigger, or SQL batch. Retry later, or ask your SA to
>reconfigure ASE with more procedure cache.
>
>Parameter Name Default Memory
>Used Config Value Run Value Unit
> Type
> ------------------------------ --------------------
>----------- -------------------- --------------------
>-------------------- ----------
>procedure cache size 7000
>1307856 600000 600000 memory
>pages(2k) dynamic
>
>
>
>The first error seems self-explanatory with the number of
>worktables being exceeded.
>Wondering if the second scenario is a bug (table seems small
>enough) and if not, how to estimate the size of the
>procedure cache?


sybuser Posted on 2010-10-25 21:00:30.0Z
Sender: 33cd.4cc5d166.1804289383@sybase.com
From: sybuser
Newsgroups: sybase.public.ase.general
Subject: Re: Running out of procedure cache
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cc5efee.36b0.1681692777@sybase.com>
References: <4cc5d1c2.33d5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 25 Oct 2010 14:00:30 -0700
X-Trace: forums-1-dub 1288040430 10.22.241.41 (25 Oct 2010 14:00:30 -0700)
X-Original-Trace: 25 Oct 2010 14:00:30 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29662
Article PK: 78890

1> select @@version
2> go
Adaptive Server Enterprise/15.0.3/EBF 17770
ESD#4/P/x86_64/Enterprise Linux/ase1503/2768/64-bit/FBO/Thu
Aug 26 09:54:27 2010

(1 row affected)


J Posted on 2010-10-26 17:43:28.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: Running out of procedure cache
Reply-To: J@bogusemailAddress.com
Message-ID: <4cc712fe.961810703@forums.sybase.com>
References: <4cc5d1c2.33d5.1681692777@sybase.com> <4cc5efee.36b0.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 26 Oct 2010 10:43:28 -0700
X-Trace: forums-1-dub 1288115008 10.22.241.152 (26 Oct 2010 10:43:28 -0700)
X-Original-Trace: 26 Oct 2010 10:43:28 -0700, vip152.sybase.com
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29665
Article PK: 78894

On 25 Oct 2010 14:00:30 -0700, sybuser wrote:


This version is pretty recent. I don't think any of the old bugs I saw
would apply. I would work thru this with Sybase support who will
probably want a reproduction of the problem.

Jay

>1> select @@version
>2> go
> Adaptive Server Enterprise/15.0.3/EBF 17770
>ESD#4/P/x86_64/Enterprise Linux/ase1503/2768/64-bit/FBO/Thu
>Aug 26 09:54:27 2010
>
>(1 row affected)


sybuser Posted on 2010-10-26 17:54:19.0Z
Sender: 33cd.4cc5d166.1804289383@sybase.com
From: sybuser
Newsgroups: sybase.public.ase.general
Subject: Re: Running out of procedure cache
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cc715cb.5024.1681692777@sybase.com>
References: <4cc5d1c2.33d5.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Oct 2010 10:54:19 -0700
X-Trace: forums-1-dub 1288115659 10.22.241.41 (26 Oct 2010 10:54:19 -0700)
X-Original-Trace: 26 Oct 2010 10:54:19 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29666
Article PK: 78895

Thanks for the feedback.

I logged a case with Sybase Tech Support and submitted the
data file to reproduce the problem.