Blocked Resources Never Release

In what appears to be a deadlock scenario, why doesn’t the deadlock manager engage and determine a victim?
Here is an example of what I am talking about:
Query 1
Select statement on table "A" with a suitable where clause to define only the records desired.
Query 2
Multiple insert statements within a single transaction to several different tables including table "A."
The resulting scenario is that query 2 has crossed the magic threshold of 1250 locks and therefore escalates its lock to a table lock. Query 1, which is now blocked, also escalates to a table lock. The two queries then sit around waiting for each other to
finish, but they never do.
Here are my questions:
The lock manager will begin escalation if a single resource is using more than 1250 locks on table resources, or 765 locks on index resources. If the machine in question has 2GB of physical memory, how big is the memory pool for locks?
Even though this isn't the classic deadlock scenario, why doesn't the deadlock manager recognize this as a deadlock and choose a victim to help free up the resources?
Thanks.
Hi,
From your descriptions, I understood that you would like to know how much
memory will be allocated to locks and what happened in the scenario you
described. Have I understood you? If there is anything I misunderstood,
please feel free to let me know
For the first question, based on my knowledge, there are no standard for
allocating memory pool for locks, so I cannot tell how much it will be
For the second question, could you reporduce ti? It is appreciated if you
could provide me some sample scenario, which, I believe, will make us
closer to the resolution.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know.
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Lock Pool:
According to a resource that I have now, the number of slots in the lock hash table directly relates to physical memory size. Since we have more than 1GB of physical memory, the number of slots in the hash table is 2 to the 19th, or 512K. If this has
h table gets fulls because of the number of locks in the system does it engage the escalation process and start upgrading locks to table locks?
Block Scenario:
Yes, we can reproduce this problem very easily. The best way to do it is to setup one query to read a set of rows (< 10) from table "A." This should be the first query executed. Then while that query is running, start another query that insert at leas
t 200 rows into table "A" within a transaction. What we are seeing here is that both resources get blocked, and never return.
Let me know if you need further details. Thanks.
Ken L
|||Hello Ken,
The lock escalation attempts are never blocked in SQL Server. If the lock
threshold is crossed and we decide we want to escalate but someone holds an
incompatible lock on the table, we simply cancel the escalation attempt and
continue acquiring locks at the page, row or key level.
Also, if there was truly a simple lock-based deadlock then the deadlock
monitor should detect it and roll back one of the participants.
As far as the particulars of lock escalation thresholds, they are
undocumented and have changed between 7.0 and SQL 2000, and again with
service packs for SQL 2000.
Investigation of your scenario would need trace, blocker script and
errorlog analysis which would be done quickly and effectively with direct
assistance from a Microsoft Support Professional through Microsoft Product
Support Services. You can contact Microsoft Product Support directly to
discuss additional support options you may have available, by contacting us
at 1-(800)936-5800 or by choosing one of the options listed at
http://support.microsoft.com/default...=sz;en-us;top.
If this is not an urgent issue and your would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address): mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*Subject Line
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computers security.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Blocked Resources Never Release
>thread-index: AcQ4/1L2Dymf0MfBRy6pVZIiiOpc7A==
>X-WN-Post: microsoft.public.sqlserver.server
>From: "=?Utf-8?B?S2VuIEw=?=" <visDev@.online.nospam>
>References: <AC3EA969-391B-4849-8473-99BBA5EC96B5@.microsoft.com>
<cEHqVuNOEHA.424@.cpmsftngxa10.phx.gbl>
>Subject: RE: Blocked Resources Never Release
>Date: Thu, 13 May 2004 08:31:13 -0700
>Lines: 9
>Message-ID: <24381669-EE80-4206-9EDF-8D36C1C5CA3E@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:341150
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Lock Pool:
According to a resource that I have now, the number of slots in the
lock hash table directly relates to physical memory size. Since we have
more than 1GB of physical memory, the number of slots in the hash table is
2 to the 19th, or 512K. If this hash table gets fulls because of the number
of locks in the system does it engage the escalation process and start
upgrading locks to table locks?
Block Scenario:
Yes, we can reproduce this problem very easily. The best way to do it
is to setup one query to read a set of rows (< 10) from table "A." This
should be the first query executed. Then while that query is running, start
another query that insert at least 200 rows into table "A" within a
transaction. What we are seeing here is that both resources get blocked,
and never return.
Let me know if you need further details. Thanks.
Ken L
>

Blocked Resources Never Release

In what appears to be a deadlock scenario, why doesn’t the deadlock manage
r engage and determine a victim?
Here is an example of what I am talking about:
Query 1
Select statement on table "A" with a suitable where clause to define only th
e records desired.
Query 2
Multiple insert statements within a single transaction to several different
tables including table "A."
The resulting scenario is that query 2 has crossed the magic threshold of 12
50 locks and therefore escalates its lock to a table lock. Query 1, which is
now blocked, also escalates to a table lock. The two queries then sit aroun
d waiting for each other to
finish, but they never do.
Here are my questions:
The lock manager will begin escalation if a single resource is using more th
an 1250 locks on table resources, or 765 locks on index resources. If the ma
chine in question has 2GB of physical memory, how big is the memory pool for
locks?
Even though this isn't the classic deadlock scenario, why doesn't the deadlo
ck manager recognize this as a deadlock and choose a victim to help free up
the resources?
Thanks.Hi,
From your descriptions, I understood that you would like to know how much
memory will be allocated to locks and what happened in the scenario you
described. Have I understood you? If there is anything I misunderstood,
please feel free to let me know
For the first question, based on my knowledge, there are no standard for
allocating memory pool for locks, so I cannot tell how much it will be
For the second question, could you reporduce ti? It is appreciated if you
could provide me some sample scenario, which, I believe, will make us
closer to the resolution.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know.
Sincerely yours,
Michael Cheng
Microsoft Online Support
****************************************
*******************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.|||Lock Pool:
According to a resource that I have now, the number of slots in the lock has
h table directly relates to physical memory size. Since we have more than 1G
B of physical memory, the number of slots in the hash table is 2 to the 19th
, or 512K. If this has
h table gets fulls because of the number of locks in the system does it enga
ge the escalation process and start upgrading locks to table locks?
Block Scenario:
Yes, we can reproduce this problem very easily. The best way to do it is to
setup one query to read a set of rows (< 10) from table "A." This should be
the first query executed. Then while that query is running, start another qu
ery that insert at leas
t 200 rows into table "A" within a transaction. What we are seeing here is t
hat both resources get blocked, and never return.
Let me know if you need further details. Thanks.
Ken L|||Hello Ken,
The lock escalation attempts are never blocked in SQL Server. If the lock
threshold is crossed and we decide we want to escalate but someone holds an
incompatible lock on the table, we simply cancel the escalation attempt and
continue acquiring locks at the page, row or key level.
Also, if there was truly a simple lock-based deadlock then the deadlock
monitor should detect it and roll back one of the participants.
As far as the particulars of lock escalation thresholds, they are
undocumented and have changed between 7.0 and SQL 2000, and again with
service packs for SQL 2000.
Investigation of your scenario would need trace, blocker script and
errorlog analysis which would be done quickly and effectively with direct
assistance from a Microsoft Support Professional through Microsoft Product
Support Services. You can contact Microsoft Product Support directly to
discuss additional support options you may have available, by contacting us
at 1-(800)936-5800 or by choosing one of the options listed at
http://support.microsoft.com/defaul...d=sz;en-us;top.
If this is not an urgent issue and your would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address): mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*Subject Line
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computers security.
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>Thread-Topic: Blocked Resources Never Release
>thread-index: AcQ4/1L2Dymf0MfBRy6pVZIiiOpc7A==
>X-WN-Post: microsoft.public.sqlserver.server
>From: "examnotes" <visDev@.online.nospam>
>References: <AC3EA969-391B-4849-8473-99BBA5EC96B5@.microsoft.com>
<cEHqVuNOEHA.424@.cpmsftngxa10.phx.gbl>
>Subject: RE: Blocked Resources Never Release
>Date: Thu, 13 May 2004 08:31:13 -0700
>Lines: 9
>Message-ID: <24381669-EE80-4206-9EDF-8D36C1C5CA3E@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:341150
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Lock Pool:
According to a resource that I have now, the number of slots in the
lock hash table directly relates to physical memory size. Since we have
more than 1GB of physical memory, the number of slots in the hash table is
2 to the 19th, or 512K. If this hash table gets fulls because of the number
of locks in the system does it engage the escalation process and start
upgrading locks to table locks?
Block Scenario:
Yes, we can reproduce this problem very easily. The best way to do it
is to setup one query to read a set of rows (< 10) from table "A." This
should be the first query executed. Then while that query is running, start
another query that insert at least 200 rows into table "A" within a
transaction. What we are seeing here is that both resources get blocked,
and never return.
Let me know if you need further details. Thanks.
Ken L
>

Blocked Resources Never Release

In what appears to be a deadlock scenario, why doesnâ't the deadlock manager engage and determine a victim?
Here is an example of what I am talking about
Query
Select statement on table "A" with a suitable where clause to define only the records desired
Query
Multiple insert statements within a single transaction to several different tables including table "A.
The resulting scenario is that query 2 has crossed the magic threshold of 1250 locks and therefore escalates its lock to a table lock. Query 1, which is now blocked, also escalates to a table lock. The two queries then sit around waiting for each other to finish, but they never do
Here are my questions
The lock manager will begin escalation if a single resource is using more than 1250 locks on table resources, or 765 locks on index resources. If the machine in question has 2GB of physical memory, how big is the memory pool for locks
Even though this isn't the classic deadlock scenario, why doesn't the deadlock manager recognize this as a deadlock and choose a victim to help free up the resources
ThanksHi,
From your descriptions, I understood that you would like to know how much
memory will be allocated to locks and what happened in the scenario you
described. Have I understood you? If there is anything I misunderstood,
please feel free to let me know :)
For the first question, based on my knowledge, there are no standard for
allocating memory pool for locks, so I cannot tell how much it will be
For the second question, could you reporduce ti? It is appreciated if you
could provide me some sample scenario, which, I believe, will make us
closer to the resolution.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know.
Sincerely yours,
Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.|||Hello Ken,
The lock escalation attempts are never blocked in SQL Server. If the lock
threshold is crossed and we decide we want to escalate but someone holds an
incompatible lock on the table, we simply cancel the escalation attempt and
continue acquiring locks at the page, row or key level.
Also, if there was truly a simple lock-based deadlock then the deadlock
monitor should detect it and roll back one of the participants.
As far as the particulars of lock escalation thresholds, they are
undocumented and have changed between 7.0 and SQL 2000, and again with
service packs for SQL 2000.
Investigation of your scenario would need trace, blocker script and
errorlog analysis which would be done quickly and effectively with direct
assistance from a Microsoft Support Professional through Microsoft Product
Support Services. You can contact Microsoft Product Support directly to
discuss additional support options you may have available, by contacting us
at 1-(800)936-5800 or by choosing one of the options listed at
http://support.microsoft.com/default.aspx?scid=sz;en-us;top.
If this is not an urgent issue and your would like us to create an incident
for you and have Microsoft Customer Service Representative contact you
directly, please send email to (remove "online." from this no Spam email
address): mailto:dscommhf@.online.microsoft.com with the following
information,
*Include "Followup: <Tomcat IssueID>" in the email Subject.
*Location of the post
*Subject Line
*First Name, Last Name
*MSDN Subscriber ID
*Company name (if any)
*Phone number
*e-mail address
Thanks for using MSDN Managed Newsgroup.
Vikrant Dalwale
Microsoft SQL Server Support Professional
Microsoft highly recommends to all of our customers that they visit the
http://www.microsoft.com/protect site and perform the three straightforward
steps listed to improve your computer?s security.
This posting is provided "AS IS" with no warranties, and confers no rights.
>Thread-Topic: Blocked Resources Never Release
>thread-index: AcQ4/1L2Dymf0MfBRy6pVZIiiOpc7A==>X-WN-Post: microsoft.public.sqlserver.server
>From: "=?Utf-8?B?S2VuIEw=?=" <visDev@.online.nospam>
>References: <AC3EA969-391B-4849-8473-99BBA5EC96B5@.microsoft.com>
<cEHqVuNOEHA.424@.cpmsftngxa10.phx.gbl>
>Subject: RE: Blocked Resources Never Release
>Date: Thu, 13 May 2004 08:31:13 -0700
>Lines: 9
>Message-ID: <24381669-EE80-4206-9EDF-8D36C1C5CA3E@.microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.server:341150
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.sqlserver.server
>Lock Pool:
According to a resource that I have now, the number of slots in the
lock hash table directly relates to physical memory size. Since we have
more than 1GB of physical memory, the number of slots in the hash table is
2 to the 19th, or 512K. If this hash table gets fulls because of the number
of locks in the system does it engage the escalation process and start
upgrading locks to table locks?
Block Scenario:
Yes, we can reproduce this problem very easily. The best way to do it
is to setup one query to read a set of rows (< 10) from table "A." This
should be the first query executed. Then while that query is running, start
another query that insert at least 200 rows into table "A" within a
transaction. What we are seeing here is that both resources get blocked,
and never return.
Let me know if you need further details. Thanks.
Ken L
>

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank pages in report preview

Hello, Everyone,

I'm new to Reporting Services. I wrote a report today containing one grouping. Everything appears all right in the report preview, except that every other page is "blank", i.e., shows only the page header and page footer; all grouping and detail information is missing. The data on the page following the blank page seems to pick up where the previous non-blank page left off, so all information seems to be present within the report.

The report width and height properties are typical portrait-style -- 8.5 x 11 inches. The columns do not "run off the edge" of the report page boundary. I haven't selected any page break for the grouping, as the grouping detail is typically only a few rows long, and would otherwise result in a very large number of pages. Can anyone offer some advice to correct this problem, please?

Many thanks!

CraigI found the problem cause. In Reporting Services,

report body width must be <= (report width - report margins width).

I reduced the margins to zero width, and the pagination problem disappeared!|||

Hi,

I am struggeling with the same problem, only your solution does not work for me...

My page width = 30cm, Report Width = 26cm, Margins = 1 cm allround, and no fields are set to CanGrow=false, any other ideas?

I'm using RS 2000

|||I have just upgraded the report to RS 2005 without any modifications, and the problem disappeared, seems to be a RS 2000 bug...|||

Hi,

I'm having the same problem but with a twist.

If the body width <= report width+margins then i only get 1 page of the report with no blank pages. (supposed to be 2)

If however the body width > report width+margins then i get all the pages but with an extra 2 blank pages.

Any ideas anyone? (I'm using RS2005)

|||

Craig,

Thanks! That one had me. All I had to do was right-click on the "Body" section and set the width to 10in and it worked fine.

Jim

|||Had another similar problem, this time involving a matrix Table (cross-tab) in the Body section of the report. I had to actually make the Table itself smaller (narrower) until the blank page disappeared in Preview. Also, I noticed that in Preview the blank pages didn't show up until I clicked the Print Layout button on the toolbar in Preview. Similar problems happen in Reporting Services report viewer. Weird.|||

I am using a matrix control in a report containing 2 subreports. The matrix control is present in one of the subreports. When I export the full report into the PDF,if the matrix are rendered in a single page, the report is fine and there are no blank pages. But when the number of columns exceeds the first page and moves into the second page then there are 3 blank pages in the report for every page with content.

This problem occurs only when I try to generate the whole report. No blank pages appear when I render subreports into PDFs individually.

Please help!!

Cheers!!

Ravi

Blank page in report manager

When i load report manager everything appears to be running fine. The header, footer and nav bar at the top load correctly. Even the directory and file tree load fine.

The problem is when you click on a report everything from below the nav bar ( where the report would be rendered) blanks out and load bar at the bottom just tacks at full.

One way to fix this problem is to open the web config file for report manager save it then close the file.

This is not a viable solution to the problem. I was wondering if any one else had the same problem . If so how to fix it ?

Has anyone had a similar problem with reporting services. Also is there a place to formally site this as a bug

|||

We are having a very similar problem that is driving me nuts. My end users will get this situation - Report Manager banner and links at top, and blank below the color line. They all have the appropriate permissions. At first, we thought it was caused by an Internet Explorer patch, an uninstalling that patch seemed to work... for a little while. Now, they are complaining again. I get the same patches, and I still have full access (of course, I do have sys admin and sql admin rights). I have a suspicion that it is not an IE patch, but an IE security setting or security policy that may be causing it. When I looked at the Report Manager homepage in FrontPage (just to see what I could see), I noticed that banner is rendered in HTML, and it sets the language for the rest of the page to Javascript. If the Internet Explorer security doesn't allow Javascript, or even prompts for permissions, that may be preventing the display of the rest of the page, and would explain why the banner displays and doesn't just throw an error message to the end user. I am investigating this more. Let me know if you have any thoughts.

Tee Dubs

Blank page in report manager

When i load report manager everything appears to be running fine. The header, footer and nav bar at the top load correctly. Even the directory and file tree load fine.

The problem is when you click on a report everything from below the nav bar ( where the report would be rendered) blanks out and load bar at the bottom just tacks at full.

One way to fix this problem is to open the web config file for report manager save it then close the file.

This is not a viable solution to the problem. I was wondering if any one else had the same problem . If so how to fix it ?

Has anyone had a similar problem with reporting services. Also is there a place to formally site this as a bug

|||

We are having a very similar problem that is driving me nuts. My end users will get this situation - Report Manager banner and links at top, and blank below the color line. They all have the appropriate permissions. At first, we thought it was caused by an Internet Explorer patch, an uninstalling that patch seemed to work... for a little while. Now, they are complaining again. I get the same patches, and I still have full access (of course, I do have sys admin and sql admin rights). I have a suspicion that it is not an IE patch, but an IE security setting or security policy that may be causing it. When I looked at the Report Manager homepage in FrontPage (just to see what I could see), I noticed that banner is rendered in HTML, and it sets the language for the rest of the page to Javascript. If the Internet Explorer security doesn't allow Javascript, or even prompts for permissions, that may be preventing the display of the rest of the page, and would explain why the banner displays and doesn't just throw an error message to the end user. I am investigating this more. Let me know if you have any thoughts.

Tee Dubs

Bizarre Index on Table causing problems

Hello,
One of my sql tables has a bizarre index on it that looks like its name is
?8 (that's some weird small k, 8, and what appears to be a newline
character). The first character appears to be some sort of ascii code for
what I have no idea. The index appeared out of nowhere, and is a clustered,
hypothetical, auto create located on PRIMARY. It does not show in
Enterprise Manager's list of indexes. I believe it is the source of some
major problems on the table, and it cannot be dropped via DROP INDEX --
Cannot drop the index 'tblTable.?8', because it does not exist in the system
catalog.
Does anyone know of a way to remove this index, and where it came from? I
tried creating some sql to try and get around it
declare @.indexname nvarchar(2000)
select @.indexname = 'tblTable.' + name from sysindexes where id = 1110347070
and indid = 13
select @.indexname
declare @.sql nvarchar(3000)
set @.sql = 'DROP INDEX ' + @.indexname
exec (@.sql)
thinking that perhaps that might do the trick. No dice. If anyone can help
me out here I would really appreciate it. Thanks so much.I had something somewhat similar to this and I had to script a temp table out how I wanted, insert the data from the original to the temp, drop the original, rename the temp.
>--Original Message--
>Hello,
>One of my sql tables has a bizarre index on it that looks like its name is
>?8=04 (that's some weird small k, 8, and what appears to be a newline
>character). The first character appears to be some sort of ascii code for
>what I have no idea. The index appeared out of nowhere, and is a clustered,
>hypothetical, auto create located on PRIMARY. It does not show in
>Enterprise Manager's list of indexes. I believe it is the source of some
>major problems on the table, and it cannot be dropped via DROP INDEX --
>Cannot drop the index 'tblTable.?8', because it does not exist in the system
>catalog.
>Does anyone know of a way to remove this index, and where it came from? I
>tried creating some sql to try and get around it
>declare @.indexname nvarchar(2000)
>select @.indexname =3D 'tblTable.' + name from sysindexes where id =3D 1110347070
>and indid =3D 13
>select @.indexname
>declare @.sql nvarchar(3000)
>set @.sql =3D 'DROP INDEX ' + @.indexname
>exec (@.sql)
>thinking that perhaps that might do the trick. No dice. If anyone can help
>me out here I would really appreciate it. Thanks so much.
>
>
>.
>|||To reference names that don't conform to the rules for identifiers, try
enclosing the names in brackets (or double quotes):
DECLARE @.indexname nvarchar(261)
SELECT @.indexname = QUOTENAME(OBJECT_NAME(id)) +
'.' +
QUOTENAME(name)
FROM sysindexes
WHERE id = 1110347070 AND
indid = 13
--
Hope this helps.
Dan Guzman
SQL Server MVP
"tglenist" <tglenist@.hotmail.com> wrote in message
news:OT5jysNwDHA.2540@.TK2MSFTNGP10.phx.gbl...
> Hello,
> One of my sql tables has a bizarre index on it that looks like its name is
> ?8 (that's some weird small k, 8, and what appears to be a newline
> character). The first character appears to be some sort of ascii code for
> what I have no idea. The index appeared out of nowhere, and is a
clustered,
> hypothetical, auto create located on PRIMARY. It does not show in
> Enterprise Manager's list of indexes. I believe it is the source of some
> major problems on the table, and it cannot be dropped via DROP INDEX --
> Cannot drop the index 'tblTable.?8', because it does not exist in the
system
> catalog.
> Does anyone know of a way to remove this index, and where it came from? I
> tried creating some sql to try and get around it
> declare @.indexname nvarchar(2000)
> select @.indexname = 'tblTable.' + name from sysindexes where id =1110347070
> and indid = 13
> select @.indexname
> declare @.sql nvarchar(3000)
> set @.sql = 'DROP INDEX ' + @.indexname
> exec (@.sql)
> thinking that perhaps that might do the trick. No dice. If anyone can
help
> me out here I would really appreciate it. Thanks so much.
>
>|||"tglenist" <tglenist@.hotmail.com> wrote:
>One of my sql tables has a bizarre index on it that looks like its name is
>?8 (that's some weird small k, 8, and what appears to be a newline
>character). The first character appears to be some sort of ascii code for
>what I have no idea. The index appeared out of nowhere, and is a clustered,
>hypothetical, auto create located on PRIMARY. It does not show in
>Enterprise Manager's list of indexes. I believe it is the source of some
>major problems on the table, and it cannot be dropped via DROP INDEX --
>Cannot drop the index 'tblTable.?8', because it does not exist in the system
>catalog.
>Does anyone know of a way to remove this index, and where it came from? I
>tried creating some sql to try and get around it
>declare @.indexname nvarchar(2000)
>select @.indexname = 'tblTable.' + name from sysindexes where id = 1110347070
>and indid = 13
>select @.indexname
>declare @.sql nvarchar(3000)
>set @.sql = 'DROP INDEX ' + @.indexname
>exec (@.sql)
>thinking that perhaps that might do the trick. No dice. If anyone can help
>me out here I would really appreciate it. Thanks so much.
This sounds related to a recent thread entitled "Hypothetical indexes",
F8EE1587-3A79-4E3A-85B8-BE0B5B2E3A59@.microsoft.com
It refers to a KB article,
http://support.microsoft.com/support/kb/articles/Q293/1/77.ASP
HTH,
Ross.
--
Ross McKay, WebAware Pty Ltd
"Words can only hurt if you try to read them. Don't play their game" - Zoolander