Invalid column name 'ChunkFlags'

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.orgI 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?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Stonehouse" <scott@.ifilter.org> wrote in message
news:OOOXPA$SFHA.3140@.TK2MSFTNGP14.phx.gbl...
>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
>|||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
> 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?
>|||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.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Stonehouse" <scott@.ifilter.org> wrote in message
news:eI1OCdLTFHA.1896@.TK2MSFTNGP14.phx.gbl...
> 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
>> 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?