Hi Scott,
We have a custom field that is a multicheckbox, which we have as a searchable field. We have recently started having issues with it during searches. Our production site is on 1.07.12. I checked our test site (mirror of our live save for some visuals - moving fields, etc) and it was having the same problem. So, I updated to 1.07.16 in our test environment to see if that would help, but it did not.
I'm assuming it's a data problem on our end, but I can't see the problem. I turned on another multicheckbox field for search and it causes the same problem.
I'm going to email you our site links and some login information in the hopes that you have the time and inclination to take a look and see if you can see the issue.
The error I get is :
Error: Find Childcare is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Ventrian.PropertyAgent.SqlDataProvider.ListProperty(Int32 moduleID, Int32 propertyTypeID, Int32 status, Int32 authorID, Int32 brokerID, Boolean isActive, Boolean isPending, Boolean isExpired, Boolean showFeaturedOnly, Int32 sortBy, Int32 sortByID, Int32 sortByIDType, Int32 sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Double latitude, Double longitude) at Ventrian.PropertyAgent.PropertyController.List(Int32 moduleID, Int32 propertyTypeID, SearchStatusType status, Int32 authorID, Int32 brokerID, Boolean showFeaturedOnly, SortByType sortBy, Int32 sortByID, SortDirectionType sortOrder, String customFieldIDs, String searchValues, Int32 pageNumber, Int32 pageSize, Int32& totalRecords, Boolean bubbleFeatured, Boolean searchSubTypes, Int32 propertyIDForNextPrev, Int32& typePosition, Double latitude, Double longitude) at Ventrian.PropertyAgent.ViewType.BindProperty() at Ventrian.PropertyAgent.ViewType.Page_Initialization(Object sender, EventArgs e) --- End of inner exception stack trace ---
Thanks in advance for any light you might be able to shed.
paula |