StrataFrame Forum

Error when saving Profile

http://forum.strataframe.net/Topic2713.aspx

By Flavelle Ballem - 9/9/2006

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)
By StrataFrame Team - 9/11/2006

Howdy, Flavelle,

Looks like your StrataFrame design-time data source (connection string) has been changed to something else. 

You can change the connection string through the "Database Connection" option under the StrataFrame menu within Visual Studio.  Changing the database connection within this option does not change the database connection for your application, but for the SF design-time components.

By Flavelle Ballem - 9/11/2006

Ben:

Must be my confusion. I gather that I am dealing with two connections - a StrataFrame connection and a connection that my application requires to access the 'real' data.

Over time, I will get there, but clearly some patience is required.

Thanks,

Flavelle

By StrataFrame Team - 9/12/2006

No, your application only has one connection.  Rather, there is a design-time connection that is used by the Visual Studio AddIn (BOMapper), the DDT, and the Messaging Editor to communicate with the StrataFrame database.  The StrataFrame database is where the StrataFrame stores all of the design-time information (meta-data, BOMapper config, messages & localization values, etc).  To change the design-time connection, you go through the Database Connection option under the StrataFrame menu in Visual Studio.  To change your program's connection (runtime), you change it within the SetDataSources() method in the AppMain.vb or Program.cs file.