Page (1:14440325), slot 6 for text, ntext,or image node does not e

Hello,
This is the second time in less than 2 weeks this has happened to my db
server.
Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
FULLSCAN after obtaining the table info. from the following
dbcc traceon(3604)
dbcc page(dbname,1, 14440325)
dbcc traceoFF(3604)
Do not know why it is happening��
TIA,
Manoj Kumar
DBCC is of limited use when dealing with BLOB data types. Generally when
you have repeated allocation mismatches, there is an underlying hardware
problem. I would check the system and application event logs for a disk
subsystem fault.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
> Hello,
> This is the second time in less than 2 weeks this has happened to my db
> server.
>
> Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
> I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
> FULLSCAN after obtaining the table info. from the following
> dbcc traceon(3604)
> dbcc page(dbname,1, 14440325)
> dbcc traceoFF(3604)
> Do not know why it is happening��
>
> TIA,
> --
> Manoj Kumar
|||Thanks Geoff.
I do not see any issues in the evt log which are related with physical disk
subsystem or RAM although the dbcc page(DBName,1, 19440325,2) does indicate a
data corruption!!
Manoj Kumar
"Geoff N. Hiten" wrote:

> DBCC is of limited use when dealing with BLOB data types. Generally when
> you have repeated allocation mismatches, there is an underlying hardware
> problem. I would check the system and application event logs for a disk
> subsystem fault.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
> news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
>

Padding Issue

We are creating hierarchical report showing line of sight for given Organization. The report data is tree structure. Each node is a row in the report. Each row in the report is nested by using padding expression. Padding expression is based on Node Level. When we print report or create PDF padding is removed and all the rows appear aligned. It looks like reporting Services treat padding as white space. We tried several options like using gif images and rectangle but failed.

The report appears fine when we export to Web Archive, the working sample and sample with issue are as attached.

This issue occurs both in report viewer control and report services url.

Does "Padding expression" mean that you insert whitespace based on the node level?

There is another way of doing this: Every textbox has a Padding.Left property. Assuming that the node level is available as a numeric field value, you could set the Padding.Left property dynamically: =CStr(4 * Fields!NodeLevel.Value) & " pt"

-- Robert

|||

Thanks for the reply

I have tried both padding.left and padding.right. When report is rendered padding appears fine but on print or export to pdf, padding is removed.

|||

Which version of Reporting Services are you using? Did you install the latest service packs for that version?

-- Robert