We have recently migrated (into a test environment) our RS2000 DB per the
microsoft migration instructions into RS2005.
When a history snapshot record is requested (Via ReportManager), we get an
internal RS Exception...
w3wp!library!1!11/13/2006-11:35:39:: i INFO: Call to
GetPermissions:<Roger!REPORTPATH>
w3wp!library!1!11/13/2006-11:35:39:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., Error compressing;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
w3wp!library!1!11/13/2006-11:35:40:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.5\Reporting Services\LogFiles flags=
ReferencedMemory, AllThreads, SendToWatson
w3wp!chunks!1!11/13/2006-11:35:40:: e ERROR: ###
SnapshotConverter(cb8c0d49-39e1-4775-ae6f-f73ac0fc68c4, True),
Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
at Microsoft.ReportingServices.Diagnostics.CompressUt il.checkErr(Int32 err)
at Microsoft.ReportingServices.Diagnostics.CompressUt il.UnCompress(Byte[]
input, Int32 outputBufferLength, Byte[]& output)
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.UncompressNative(Byte[]
compressedBuffer, Int32 uncompressedBufferLength, Byte[]& uncompressedBuffer)
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.Uncompress(Byte[]
compressedBuffer, Int32 uncompressedBufferLength, Byte[]& uncompressedBuffer)
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.ReadAndUncompressBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.FillBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream..ctor(Stream
store, Int16 version)
at
Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.CreateReadStream(Guid
snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
chunkType, Boolean rawStreamRequested, ConnectionManager connectionManager,
String& mimeType)
at
Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.GetCompressedReadStream(Guid
snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
chunkType, ConnectionManager connectionManager, String& mimeType)
at
Microsoft.ReportingServices.Library.SnapshotConver ter.ConvertFromV1(ReportSnapshot snapshot, Boolean isSnapshotProcessing)
Has anyone sucessfully migrated history from RS2000 to RS2005?
- Roger
Could you post this in the reporting services newsgroup? I think it belongs
there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tx Whytboy" <TxWhytboy@.discussions.microsoft.com> wrote in message
news:18002B03-FAED-4825-A6E7-ED56B8668B77@.microsoft.com...
> We have recently migrated (into a test environment) our RS2000 DB per the
> microsoft migration instructions into RS2005.
> When a history snapshot record is requested (Via ReportManager), we get an
> internal RS Exception...
> w3wp!library!1!11/13/2006-11:35:39:: i INFO: Call to
> GetPermissions:<Roger!REPORTPATH>
> w3wp!library!1!11/13/2006-11:35:39:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., Error compressing;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> w3wp!library!1!11/13/2006-11:35:40:: i INFO: Exception dumped to:
> C:\Program
> Files\Microsoft SQL Server\MSSQL.5\Reporting Services\LogFiles flags=
> ReferencedMemory, AllThreads, SendToWatson
> w3wp!chunks!1!11/13/2006-11:35:40:: e ERROR: ###
> SnapshotConverter(cb8c0d49-39e1-4775-ae6f-f73ac0fc68c4, True),
> Microsoft.ReportingServices.Diagnostics.Utilities. InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> at Microsoft.ReportingServices.Diagnostics.CompressUt il.checkErr(Int32
> err)
> at
> Microsoft.ReportingServices.Diagnostics.CompressUt il.UnCompress(Byte[]
> input, Int32 outputBufferLength, Byte[]& output)
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.UncompressNative(Byte[]
> compressedBuffer, Int32 uncompressedBufferLength, Byte[]&
> uncompressedBuffer)
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.Uncompress(Byte[]
> compressedBuffer, Int32 uncompressedBufferLength, Byte[]&
> uncompressedBuffer)
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.ReadAndUncompressBuffer()
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream.FillBuffer()
> at
> Microsoft.ReportingServices.Library.BufferedCompre ssedReadStream..ctor(Stream
> store, Int16 version)
> at
> Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.CreateReadStream(Guid
> snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
> chunkType, Boolean rawStreamRequested, ConnectionManager
> connectionManager,
> String& mimeType)
> at
> Microsoft.ReportingServices.Library.SnapshotChunkS treamFactory.GetCompressedReadStream(Guid
> snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
> chunkType, ConnectionManager connectionManager, String& mimeType)
> at
> Microsoft.ReportingServices.Library.SnapshotConver ter.ConvertFromV1(ReportSnapshot
> snapshot, Boolean isSnapshotProcessing)
>
> Has anyone sucessfully migrated history from RS2000 to RS2005?
> - Roger
|||Yeah.. Missed it by one.. and I didnt realize that...
Sorry!
"Hilary Cotter" wrote:
> Could you post this in the reporting services newsgroup? I think it belongs
> there.
> --
> Hilary Cotter
sql
Showing posts with label record. Show all posts
Showing posts with label record. Show all posts
Monday, March 26, 2012
Monday, March 12, 2012
Mid Data Point
I have a database table with 464473 records in it. The file is an opt-in
list. Each record has a unique id number which are not sequential. I need
to split the file in half or find the id number of the mid-point in the
file. At some point I might need to split the file 3 or 5 ways.
HELP. How do i find the mid-point...
I thought that "select top 232237 order by id desc" would show me the id
number. It does not. Any other techniques.William,
If the ID is not sequential and there are possibly gaps in the sequencing,
finding the mid-way point is virtually useless if you are truly trying to
access 50% of the 464,473 row table.
Consider using SET ROWCOUNT:
set rowcount 232236
insert into new_table select * from current_table
delete from current_table
set rowcount 0
"William" wrote:
> I have a database table with 464473 records in it. The file is an opt-in
> list. Each record has a unique id number which are not sequential. I nee
d
> to split the file in half or find the id number of the mid-point in the
> file. At some point I might need to split the file 3 or 5 ways.
> HELP. How do i find the mid-point...
> I thought that "select top 232237 order by id desc" would show me the id
> number. It does not. Any other techniques.
>
>|||I think some clarfications would be useful.
First of all a table isn't a file.
Secondly, what do you mean by "split the file [table?] in half"? That seems
like something quite different from "find the id number of the mid-point".
It would help if you would state your actual goal rather than hinting at
different ideas. If we know what you are trying to achieve we may be able to
suggest better alternatives.
To find the mid-point ID:
SELECT MIN(id) AS mid_point
FROM
(SELECT TOP 232237 id
FROM YourTable
ORDER BY id) AS T
However, I suspect you may be looking for something slightly different, such
as paging or sampling, to which there are likely to be different and maybe
better solutions.
David Portas
SQL Server MVP
--
list. Each record has a unique id number which are not sequential. I need
to split the file in half or find the id number of the mid-point in the
file. At some point I might need to split the file 3 or 5 ways.
HELP. How do i find the mid-point...
I thought that "select top 232237 order by id desc" would show me the id
number. It does not. Any other techniques.William,
If the ID is not sequential and there are possibly gaps in the sequencing,
finding the mid-way point is virtually useless if you are truly trying to
access 50% of the 464,473 row table.
Consider using SET ROWCOUNT:
set rowcount 232236
insert into new_table select * from current_table
delete from current_table
set rowcount 0
"William" wrote:
> I have a database table with 464473 records in it. The file is an opt-in
> list. Each record has a unique id number which are not sequential. I nee
d
> to split the file in half or find the id number of the mid-point in the
> file. At some point I might need to split the file 3 or 5 ways.
> HELP. How do i find the mid-point...
> I thought that "select top 232237 order by id desc" would show me the id
> number. It does not. Any other techniques.
>
>|||I think some clarfications would be useful.
First of all a table isn't a file.
Secondly, what do you mean by "split the file [table?] in half"? That seems
like something quite different from "find the id number of the mid-point".
It would help if you would state your actual goal rather than hinting at
different ideas. If we know what you are trying to achieve we may be able to
suggest better alternatives.
To find the mid-point ID:
SELECT MIN(id) AS mid_point
FROM
(SELECT TOP 232237 id
FROM YourTable
ORDER BY id) AS T
However, I suspect you may be looking for something slightly different, such
as paging or sampling, to which there are likely to be different and maybe
better solutions.
David Portas
SQL Server MVP
--
Subscribe to:
Posts (Atom)