Invalid column name 'ChunkFlags'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Stonehouse - 28 Apr 2005 13:44 GMT

I get the following error whenever I try to run a report.

---
An unexpected error occurred in Report Processing. (rsInternalError)
Invalid column name 'ChunkFlags'
---

A search turned up nothing. This is after installing SP2. Any ideas?
I don't have any columns named 'ChunkFlags' in my databases, so I guess
it must be in the reporting services database?

---
Scott Stonehouse
http://www.ifilter.org

Reply to this Message

Daniel Reib \(MSFT\) - 29 Apr 2005 06:32 GMT

I have never seen this issue before. I don't believe ChunkFlags was a
column added during SP2 but I will have to check. If it is then it seems
that something went wrong during the upgrade.

Is there any other information that might be relevant? Was this part of a
web farm? Did you use RSConfig to point to different database? Any DB
restores that might have happened?

Signature

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

>I get the following error whenever I try to run a report.
>
[quoted text clipped - 10 lines]
> Scott Stonehouse
> http://www.ifilter.org

Reply to this Message

Scott Stonehouse - 29 Apr 2005 13:30 GMT

Daniel,

Absolutely, I shouldn't have attributed the error to SP2, although I did
see it first immediately after installing SP2.

This is also after moving to a new (hardware) server. I installed RS,
then restored the Reporting Services database. I think I may have just
opened the report manager website without actually testing a report -
not sure. Then, I discovered SP2 was available, so I installed it.
Then I tried running a report and got the error.

It isn't in a web farm, it's standalone. I didn't use RSConfig. But I
did do the restore.

---
Scott Stonehouse
http://www.ifilter.org

Daniel Reib (MSFT) wrote:

> I have never seen this issue before. I don't believe ChunkFlags was a
> column added during SP2 but I will have to check. If it is then it seems
[quoted text clipped - 3 lines]
> web farm? Did you use RSConfig to point to different database? Any DB
> restores that might have happened?

Reply to this Message

Daniel Reib \(MSFT\) - 30 Apr 2005 01:13 GMT

Ok, so the ChunkFlags column was added during SP1 so it seems you have a RTM
database that you restored. Your best option would be to uninstall RS.
Install a new RS (pointing to a new DB). After the install point RS to your
old DB.

Make sure everything is working.

Then run the SP2 setup.

Hopefully this will work for you.

Signature

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

> Daniel,
>
[quoted text clipped - 22 lines]
>> a web farm? Did you use RSConfig to point to different database? Any DB
>> restores that might have happened?

Reply to this Message