Home > Archive > SQL Anywhere database > October 2005 > Re: General error: Run time SQL error -- Index "sys_attribute_uniqueness" has an inaccura









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: General error: Run time SQL error -- Index "sys_attribute_uniqueness" has an inaccura
Glenn Paulley

2005-10-27, 7:41 am

I cannot think of a workaround for this issue, since the index is over a
catalog table and even as a DBA you cannot alter catalog objects.

Because you are having difficulty reproducing the problem on other
databases (and thanks for doing so), I would like to see this particular
database so we can determine what the problem is, as long as that is
acceptable to you. If so, please email me directly so that we can make
arrangements.

Glenn

Ronald <ronald.van.der.linden@quadrant.nl> wrote in
news:qgasl115v7js5on
ae9gq1ihbr65hnm8um5@
4ax.com:

> Hi,
>
> We use Asa 8.03.5022 and with a specific database we get the following
> error : General error: Run time SQL error -- Index
> " sys_attribute_unique
ness" has an inaccurate leaf page count
> statistics.
> If we run a validate everything is oke, but after some "actions" from
> our program we get the error above. These actions are not much more
> than openening and closing the database. I tried with a lot of other
> databases, but I can't reproduce these error with this databases. I
> have already done a complete rebuild of the specific database, but I
> get these error again. Is there a workaround? Or is there somebody who
> has a guess?
>
>
> Thanks,
> Ronald
>




--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com