InstantASP Community Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        

Home » Old Forums » InstantKB.NET 1.x » New Search issue
New Search issue Expand / Collapse
Author
Message
Posted 19/04/2006 13:02:51
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 03/10/2006 13:09:42
Posts: 14, Visits: 21
So we found a way to use SQL DTS to import a large quantity of .csv content into InstantKB, which is nice.  However, now we are running into a situation where, even though it was searching ok earlier, we are back to being unable to search.

Unlike yesterday, when we were figuring out that it was a question of Indexing running over night, today we cannot even search what has been indexed so far.  Its like the index went away.

Has anyone experienced this?  Recommendations?

Here is the Exception Log text.  It started having problems at 10:30am, but it seems that at 12:27 is when the real problems began, but I am not sure what to make of them.

<AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 10:17:34 AM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 6: Incorrect syntax near 'Ro'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.GetPopularArticles()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/default.aspx</URI>
    <DateTime>4/19/2006 12:27:07 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 6: Incorrect syntax near 'Ro'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.GetPopularArticles()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/default.aspx</URI>
    <DateTime>4/19/2006 12:27:17 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 6: Incorrect syntax near '.'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.GetPopularArticles()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/default.aspx</URI>
    <DateTime>4/19/2006 12:28:04 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 6: Incorrect syntax near '.'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.GetPopularArticles()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/default.aspx</URI>
    <DateTime>4/19/2006 12:47:33 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 6: Incorrect syntax near '.'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.GetPopularArticles()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/default.aspx</URI>
    <DateTime>4/19/2006 12:47:41 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 6: Incorrect syntax near '.'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.GetPopularArticles()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/default.aspx</URI>
    <DateTime>4/19/2006 12:47:43 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Invalid CurrentPageIndex value. It must be &gt;= 0 and &lt; the PageCount.</Message>
    <Source>System.Web</Source>
    <StackTrace>   at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
   at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
   at System.Web.UI.WebControls.BaseDataList.DataBind()
   at InstantKB.InstantKB_AdminUpdate.BindQuestionData()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:37:49 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 4: Incorrect syntax near ')'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.AdminSearch(String strQuery, String strNodeID, String strUsing, String strArticleStatus, String strMaximumAge, String strReviewDate)</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:49:56 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 4: Incorrect syntax near ')'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.AdminSearch(String strQuery, String strNodeID, String strUsing, String strArticleStatus, String strMaximumAge, String strReviewDate)</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:50:11 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 4: Incorrect syntax near ')'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.AdminSearch(String strQuery, String strNodeID, String strUsing, String strArticleStatus, String strMaximumAge, String strReviewDate)</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:50:30 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Invalid CurrentPageIndex value. It must be &gt;= 0 and &lt; the PageCount.</Message>
    <Source>System.Web</Source>
    <StackTrace>   at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
   at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
   at System.Web.UI.WebControls.BaseDataList.DataBind()
   at InstantKB.InstantKB_AdminUpdate.BindQuestionData()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:55:47 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Invalid CurrentPageIndex value. It must be &gt;= 0 and &lt; the PageCount.</Message>
    <Source>System.Web</Source>
    <StackTrace>   at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource)
   at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e)
   at System.Web.UI.WebControls.BaseDataList.DataBind()
   at InstantKB.InstantKB_AdminUpdate.BindQuestionData()</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:55:54 PM</DateTime>
  </Exception>
  <Exception>
    <Message>Line 4: Incorrect syntax near ')'.</Message>
    <Source>.Net SqlClient Data Provider</Source>
    <StackTrace>   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   at InstantASP.InstantKB.Database.DataAccess.AdminSearch(String strQuery, String strNodeID, String strUsing, String strArticleStatus, String strMaximumAge, String strReviewDate)</StackTrace>
    <AppPath>http://kbdev-msw-01v/kb/</AppPath>
    <URI>/kb/admin/update.aspx</URI>
    <DateTime>4/19/2006 1:59:55 PM</DateTime>
  </Exception>
</ExceptionLog>

Post #10670
Posted 20/04/2006 15:12:18
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 03/10/2006 13:09:42
Posts: 14, Visits: 21
Just to add some detail,

a CSV is a comma separated file.  We have the content in a csv so we can import it more easily because Excel can work with the CSV file and we can turn it into rows and columns, which we can then import into a table in SQL and then use a SQL job to push into the table InstantKB is using for articles.

We were able to force a re-index of the data and that seemed to take care of the problem, but we are wondering if doing bulk uploads of content are going to force us to do a manual re-index of the data each time.

Chris

Post #10682
Posted 21/04/2006 01:37:15


Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Customers
Last Login: 27/09/2008 09:59:43
Posts: 47, Visits: 248
Just not enough info on these errors to tell much.

One or two of them are IKB's annoying failure to reset to page 1 of a result set.

The real data errors could well be due to non-canonical data. You are fixing up your single quotes, right?  What about unicode character support?   Is your import process doing something funny like changing the quoted-identifier setting?

If you are doing serious bulk imports and using SQL fulltext, I would certainly count on including at least an incremental update of the catalog as part of the bulk import. If not you can't say when the catalog might get back up to date. And a weekly full rebuild is not a bad idea either.

Charles

Post #10688
« Prev Topic | Next Topic »

Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ryan Healey, Mark Christianson, James Trott

Permissions Expand / Collapse

All times are GMT, Time now is 7:52pm

Powered by InstantForum.NET v4.1.4 © 2009
Execution: 0.063. 9 queries. Compression Disabled.
Home | Products | Purchase | Support | Company | Contact Us
Privacy Statement | © 1999-2007 InstantASP Limited. All Rights Reserved.