 |
|
|
 |
Joined: 1/6/2005
Posts: 608
|
|
|
Hi,
Suddenly I get the error mentioned below.
Somebody know what to do about that?
Regards, Ton Hermes
----------------------
AssemblyVersion: 6.1.5
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: d9438ccf-4e5c-4b66-b9ab-009e34b4a40b
InnerException: Warning: Fatal error 9100 occurred at May 19 2013 12:06AM. Note the error and time, and contact your system administrator.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: System.Data.SqlClient.SqlConnection.
StackTrace:
Message: System.Data.SqlClient.SqlException (0x80131904): Warning: Fatal error 9100 occurred at May 19 2013 12:06AM. Note the error and time, and contact your system administrator. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) 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.DeleteSearchItemWords(Int32 SearchItemId) at DotNetNuke.Services.Search.SearchDataStoreController.DeleteSearchItemWords(Int32 SearchItemId) at DotNetNuke.Services.Search.SearchDataStore.StoreSearchItems(SearchItemInfoCollection SearchItems) ClientConnectionId:62e6c37e-53a5-492f-8237-35badc292dd1
Source:
Server Naam: sknet148
Art is hard work, inspiration is the cream on top of it.
See my watercolors at
www.watermansite.com and my enamel art at www.watermanshop.com
|
| |
|
|
 | |
|
|
|
According to the MSDN Documentation ( http://msdn.microsoft.com/en-us/libra...(v=sql.105).aspx) it looks to be an index corruption issue. You will need to most likely re-build the indexes on the database.
|
| |
|
|
| |
|
|
|
Joined: 1/6/2005
Posts: 608
|
|
|
Thank you Mitchell,
I do not know how to re-build the indexes on the database.
Can you write how to do so?
I use the following lines to clean the database.
Are these lines ok?
TRUNCATE TABLE {databaseOwner}{objectQualifier}Eventlog
TRUNCATE TABLE {databaseOwner}{objectQualifier}Sitelog
TRUNCATE TABLE {databaseOwner}{objectQualifier}Schedulehistory
and
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DELETE {databaseOwner}{objectQualifier}SearchItemWord
DELETE {databaseOwner}{objectQualifier}SearchWord
DELETE {databaseOwner}{objectQualifier}SearchItem
Regards, Ton Hermes
Art is hard work, inspiration is the cream on top of it.
See my watercolors at
www.watermansite.com and my enamel art at www.watermanshop.com
|
| |
|
|
| |
|
|
|
Joined: 1/6/2005
Posts: 608
|
|
|
I discovered the following:
When I run these lines:
--------------------------------------
truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition
DELETE {databaseOwner}{objectQualifier}SearchItemWord
DELETE {databaseOwner}{objectQualifier}SearchWord
DELETE {databaseOwner}{objectQualifier}SearchItem
Then I get the following error:
------------------------------------
System.Data.SqlClient.SqlException (0x80131904): Warning: Fatal error 9100 occurred at May 20 2013 2:00AM. Note the error and time, and contact your system administrator. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection. (SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Bool
How can I resolve this?
With regards, Ton Hermes
Art is hard work, inspiration is the cream on top of it.
See my watercolors at
www.watermansite.com and my enamel art at www.watermanshop.com
|
| |
|
|
| |
|
|
|
Joined: 1/6/2005
Posts: 608
|
|
|
Hi,
I have done a restore of the website.
Everything is working fine now.
Regards, Ton Hermes
Art is hard work, inspiration is the cream on top of it.
See my watercolors at
www.watermansite.com and my enamel art at www.watermanshop.com
|
| |
|
|
| |