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.

Cannot insert rows into sysstatistics,

2 posts in Windows NT Last posting was on 2000-07-12 14:43:17.0Z
Øivind Wernersen Posted on 2000-07-11 18:40:16.0Z
From: "Øivind Wernersen" <wernersen@kghspedition.com>
Subject: Cannot insert rows into sysstatistics,
Date: Tue, 11 Jul 2000 20:40:16 +0200
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <XCVT8j26$GA.304@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ppp-109.halden.net 195.70.189.109
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1911
Article PK: 1089349

Hey

I try to update a tabel bet get the folloving message
-------------
QUERY PLAN FOR STATEMENT 1 (at line 1).
STEP 1
The type of query is UPDATE STATISTICS.

Parse and Compile Time 0.
SQL Server cpu time: 0 ms.
Total writes for this command: 48

Execution Time 50.
SQL Server cpu time: 5000 ms. SQL Server elapsed time: 11586 ms.
Server Message: Number 1763, Severity 18
Cannot insert rows into sysstatistics, due to multiple equal frequency
values, please contact Sybase Technical Support
--------------
anyone know what is the problem ??

Tanks


Peter Veilleux Posted on 2000-07-12 14:43:17.0Z
Message-ID: <396C8405.75797342@nvestservices.com>
Date: Wed, 12 Jul 2000 10:43:17 -0400
From: Peter Veilleux <pveilleux@nvestservices.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Cannot insert rows into sysstatistics,
References: <XCVT8j26$GA.304@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 22
NNTP-Posting-Host: 206.136.227.152
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1907
Article PK: 1089338

I'm assuming this is 11.9.....it's a bug, CR#173666.....get up to the
latest EBF level of 11.9....if it's 12.0, check with Sybase. Probably a
new bug or some kind of regression on the port to 12.0....

Pete

"Øivind Wernersen" wrote:

> Hey
>
> I try to update a tabel bet get the folloving message
> -------------
> QUERY PLAN FOR STATEMENT 1 (at line 1).
> STEP 1
> The type of query is UPDATE STATISTICS.
>
> Parse and Compile Time 0.
> SQL Server cpu time: 0 ms.
> Total writes for this command: 48
>
> Execution Time 50.
> SQL Server cpu time: 5000 ms. SQL Server elapsed time: 11586 ms.
> Server Message: Number 1763, Severity 18
> Cannot insert rows into sysstatistics, due to multiple equal frequency
> values, please contact Sybase Technical Support
> --------------
> anyone know what is the problem ??
>
> Tanks