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.

DBCC ERROR

2 posts in General Discussion Last posting was on 2012-01-14 19:48:54.0Z
Raj Posted on 2012-01-13 12:15:20.0Z
Sender: 41c5.4f101fb1.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: DBCC ERROR
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f102058.41e4.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 13 Jan 2012 04:15:20 -0800
X-Trace: forums-1-dub 1326456920 172.20.134.41 (13 Jan 2012 04:15:20 -0800)
X-Original-Trace: 13 Jan 2012 04:15:20 -0800, 172.20.134.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30825
Article PK: 73714

Hi, Can any one help me to get rid of from this DBCC error
message.

1> dbcc checktable (rates_xml)
2> go
Checking table 'rates_xml' (object ID 1116527980): Logical
page size is 2048 bytes.

Checking partition 'rates_xml_1116527980' (partition ID
1116527980) of table 'rates_xml'. The logical page size of
this table is 2048 bytes.
An invalid 'data row id' value (1769, 5) was found in first
text page of a text/image/unitext column. This information
is on page 122536, partition ID 1116527980, and belongs to
the object with ID 1116527980. Text/image/unitext
replication on this column may not work.
An invalid 'data row id' value (1770, 9) was found in first
text page of a text/image/unitext column. This information
is on page 7178482, partition ID 1116527980, and belongs to
the object with ID 1116527980. Text/image/unitext
replication on this column may not work.
An invalid 'data row id' value (6890177, 14) was found in
first text page of a text/image/unitext column. This
information is on page 88145, partition ID 1116527980, and
belongs to the object with ID 1116527980. Text/image/unitext
replication on this column may not work.


Rob V Posted on 2012-01-14 19:48:54.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: DBCC ERROR
References: <4f102058.41e4.1681692777@sybase.com>
In-Reply-To: <4f102058.41e4.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f11dc26$1@forums-1-dub>
Date: 14 Jan 2012 11:48:54 -0800
X-Trace: forums-1-dub 1326570534 10.22.241.152 (14 Jan 2012 11:48:54 -0800)
X-Original-Trace: 14 Jan 2012 11:48:54 -0800, vip152.sybase.com
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30827
Article PK: 73715


On 13-Jan-2012 13:15, Raj wrote:
> Hi, Can any one help me to get rid of from this DBCC error
> message.
>
> 1> dbcc checktable (rates_xml)
> 2> go
> Checking table 'rates_xml' (object ID 1116527980): Logical
> page size is 2048 bytes.
>
> Checking partition 'rates_xml_1116527980' (partition ID
> 1116527980) of table 'rates_xml'. The logical page size of
> this table is 2048 bytes.
> An invalid 'data row id' value (1769, 5) was found in first
> text page of a text/image/unitext column. This information
> is on page 122536, partition ID 1116527980, and belongs to
> the object with ID 1116527980. Text/image/unitext
> replication on this column may not work.
> An invalid 'data row id' value (1770, 9) was found in first
> text page of a text/image/unitext column. This information
> is on page 7178482, partition ID 1116527980, and belongs to
> the object with ID 1116527980. Text/image/unitext
> replication on this column may not work.
> An invalid 'data row id' value (6890177, 14) was found in
> first text page of a text/image/unitext column. This
> information is on page 88145, partition ID 1116527980, and
> belongs to the object with ID 1116527980. Text/image/unitext
> replication on this column may not work.

Try running dbcc tablealloc + dbcc indexalloc on that table, using the
'fix' option.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------