Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-09-21 : 09:51:12
|
| Hi, Im getting a strange error, in some cases when using a table in reporting services, if I delete some columns however, the error disapears, bellow is the error string,How can I increase the lenght of the LOB data?thank you-----------------------------------------------------w3wp!library!7!09/21/2007-08:51:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Length of LOB data (97840) to be replicated exceeds configured maximum 65536.The statement has been terminated. |
|
|
jhermiz
3564 Posts |
Posted - 2007-09-21 : 22:45:55
|
| sp_configure 'max text repl size'Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-22 : 00:14:01
|
quote:
Originally posted by jhermiz
sp_configure 'max text repl size'Weblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url]
I thought that option was valid only for replicated tables?
Future guru in the making. |
|
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2007-09-24 : 09:09:23
|
| Thanks, Z, regarding your question,(I thought that option was valid only for replicated tables?)I am replicating the "catalog" table in reporting services to another db, since a reporting services application is querying it and I didnt want it to query the original one, as a result I received the "internal server error", now everything makes sense.the only problem now wold be to measure the impact on the server if I increase the 65536 value |
|
|
|
|
|
|
|
|
Rep Services Internal Error