I was logged in to my site last night when this error came up.  I just can't seem to recover from it.  I upgraded about a week ago from 6.0.1 to 6.1.2.

The page you are trying to view cannot be shown because it uses an invalid or unsupported form of compression. 

 These two errors are displayed in the log among some others. 

 I've now switched the search engine schedule off.  but the site still won't start.  The /test.aspx works fine. 

Is there a way to recover from this?

<LogProperties><LogProperty><PropertyName>AssemblyVersion</PropertyName><PropertyValue>6.1.2</PropertyValue></LogProperty><LogProperty><PropertyName>PortalID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>PortalName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>UserID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>UserName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>ActiveTabID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>ActiveTabName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>RawURL</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>AbsoluteURL</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>AbsoluteURLReferrer</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>UserAgent</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>DefaultDataProvider</PropertyName><PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>ExceptionGUID</PropertyName><PropertyValue>e18f9cb7-5522-4f30-b690-16aab4796214</PropertyValue></LogProperty><LogProperty><PropertyName>InnerException</PropertyName><PropertyValue>The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ewa_SearchItemWordPosition_ewa_SearchItemWord". The conflict occurred in database "enjoywa", table "dbo.ewa_SearchItemWord", column 'SearchItemWordID'.  The statement has been terminated.</PropertyValue></LogProperty><LogProperty><PropertyName>FileName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>FileLineNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>FileColumnNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>Method</PropertyName><PropertyValue>System.Data.SqlClient.SqlConnection. </PropertyValue></LogProperty><LogProperty><PropertyName>StackTrace</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>Message</PropertyName><PropertyValue>System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ewa_SearchItemWordPosition_ewa_SearchItemWord". The conflict occurred in database "enjoywa", table "dbo.ewa_SearchItemWord", column 'SearchItemWordID'.  The statement has been terminated.     at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)     at DotNetNuke.Data.SqlDataProvider.AddSearchItemWordPosition(Int32 SearchItemWordID, String ContentPositions)     at DotNetNuke.Services.Search.SearchDataStore.AddIndexWords(Int32 indexId, SearchItemInfo searchItem, String language)     at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)</PropertyValue></LogProperty><LogProperty><PropertyName>Source</PropertyName><PropertyValue /></LogProperty></LogProperties>

 

 

   
   <LogProperties><LogProperty><PropertyName>AssemblyVersion</PropertyName><PropertyValue>6.1.2</PropertyValue></LogProperty><LogProperty><PropertyName>PortalID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>PortalName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>UserID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>UserName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>ActiveTabID</PropertyName><PropertyValue>-1</PropertyValue></LogProperty><LogProperty><PropertyName>ActiveTabName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>RawURL</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>AbsoluteURL</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>AbsoluteURLReferrer</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>UserAgent</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>DefaultDataProvider</PropertyName><PropertyValue>DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider</PropertyValue></LogProperty><LogProperty><PropertyName>ExceptionGUID</PropertyName><PropertyValue>63ac861d-203a-4029-8009-1006dcbc9df2</PropertyValue></LogProperty><LogProperty><PropertyName>InnerException</PropertyName><PropertyValue>Transaction (Process ID 220) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.</PropertyValue></LogProperty><LogProperty><PropertyName>FileName</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>FileLineNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>FileColumnNumber</PropertyName><PropertyValue>0</PropertyValue></LogProperty><LogProperty><PropertyName>Method</PropertyName><PropertyValue>System.Data.SqlClient.SqlConnection. </PropertyValue></LogProperty><LogProperty><PropertyName>StackTrace</PropertyName><PropertyValue /></LogProperty><LogProperty><PropertyName>Message</PropertyName><PropertyValue>System.Data.SqlClient.SqlException: Transaction (Process ID 220) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.     at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues)     at DotNetNuke.Data.SqlDataProvider.AddSearchItemWordPosition(Int32 SearchItemWordID, String ContentPositions)     at DotNetNuke.Services.Search.SearchDataStore.AddIndexWords(Int32 indexId, SearchItemInfo searchItem, String language)     at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems)</PropertyValue></LogProperty><LogProperty><PropertyName>Source</PropertyName><PropertyValue /></LogProperty></LogProperties>
   

Thanks for looking,

Bertus

Thanks Bill,

 That fixed the error. I will post the rest of the errors so we can figure out what caused the problem. 

Which tables should be truncated?  And how do I rebuild them?

 Thanks,

Bertus

Thanks again Bill.

 I still  wonder what went wrong.  I was using the GZip compression and were doing so for a long time.  Probably two years at least.

Something else I saw and have mentioned this before, is that some pages seem to disappear from the menu.  If you have a link to the page you can still get to it but the page does not show in the pages list.  The settings of the page seems fine but if you were to loose the link to the page it is gone.

Is there a way to rebuild the pages table?

Regards,

Bertus