BusinessLayerException
 The CurrentRow could not be evaluated because the CurrentRowIndex is out of range.  Business object record count: 0.  CurrentRowIndex: -1.

Source     : MicroFour StrataFrame Business

Stack Trace:
   at MicroFour.StrataFrame.Business.BusinessLayer.get_CurrentRow()
   at MicroFour.StrataFrame.Business.DBEFileGroupsBO.get_fg_pk()
   at MicroFour.StrataFrame.Data.TableProperties..ctor(Int32 ProfilePK, String DatabaseName, Int32 DatabasePK, Int32 TablePK)
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.ShowTableProperties(Int32 TablePK)
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.cmi_Profile_AddTable_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Is that error reproducable, and what sequence of clicks did you go through to create that error?

Ben:

Can't remember what I did to produce that error. I have sent an e-mail to Bob with private things enclosed that may help in figuring out my ongoing problems.

As an experiment, tried to create a new database and got the following:

BusinessLayerException
 An error occurred while saving an the data to the server.
BusinessLayerException
 An error occurred while saving the data to the server.
SqlException
 Invalid object name 'dbefilegroups'.

Source     : MicroFour StrataFrame Business

Stack Trace:
   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.ExecuteScalar()
   at MicroFour.StrataFrame.Data.DbDataSourceItem.ExecuteScalar(DbCommand Command)
   at MicroFour.StrataFrame.Business.BusinessLayer.ExecuteScalar(DbCommand CommandToExecute)
   at MicroFour.StrataFrame.Business.DBEFileGroupsBO.GetFileGroupsCount(String FileGroupName, Int32 DatabasePK)
   at MicroFour.StrataFrame.Business.DBEFileGroupsBO.DBEFileGroupsBO_CheckRulesOnCurrentRow(CheckRulesEventArgs e)
   at MicroFour.StrataFrame.Business.BusinessLayer.raise_CheckRulesOnCurrentRow(CheckRulesEventArgs e)
   at MicroFour.StrataFrame.Business.BusinessLayer.OnCheckRulesOnCurrentRow(CheckRulesEventArgs e)
   at MicroFour.StrataFrame.Business.BusinessLayer.CheckRules(Boolean RaiseCheckedEvent)
   at MicroFour.StrataFrame.Business.BusinessLayer.Save(Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.Data.DataLayer.SaveByForm(DataTable TableToSave, Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.Business.BusinessLayer.SaveByForm(Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save(Boolean Transactional, String TransactionKey)
   at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.Save()
   at MicroFour.StrataFrame.Data.DatabaseProperties.cmdSave_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Flavelle

Generally, when you get an "Invalid object name" error within the DDT or the BOMapper, it's because the database connection to the StrataFrame database has changed.  However, if this was the case, you probably would have received the error when the DDT first started up and the open profile dialog attempted to retrieve the available profiles.  I'm not sure...

Ben:

I'm beginning to suspect that there is a problem with the SQLExpress installation - I don't get any error when I start DDT. It's probably time that I did a cleanup on my machine, so let's leave this for now until that's done (about a week or so). Once that's done, then I'll let you know if the problem still persists.

Until then, let's not lose any more sleep.

thanks,

Flavelle