StrataFrame Forum

1.6 Install

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

By Ben Kim - 2/20/2007

I finally got version 1.6 installed on my computer.  I have recompiled our application and have run it through it's paces. 

I had a difficult time getting this installed without GPFing or coming up with SF errors.  Well now that it is installed, I was going to continue with my MetaData work in the Database Deployment Toolkit.  When I try to run the application, I receive the following error message:

SqlException
 Invalid column name 'dbe_Category'.

Source     : .Net SqlClient Data Provider

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.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(String Statement, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)
   at MicroFour.StrataFrame.Business.DBEProfileBO.FillAllByCategory()
   at MicroFour.StrataFrame.Data.ProfileOpen..ctor()
   at MicroFour.StrataFrame.Data.DatabaseMain.ShowProfileOpenDialog()
   at MicroFour.StrataFrame.Data.DatabaseMain.tmShowOpenDialog_Tick(Object sender, EventArgs e)
   at System.Windows.Forms.Timer.OnTick(EventArgs e)
   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

When installing it appeared to alter all of the database tables successfully so I am at a loose.

Please help!

Ben Kim
Emergitech

By Trent L. Taylor - 2/20/2007

You did not get through the installation.  The data was not deployed to your server.  Rather than telling you the workaround, just download the latest build that was posted yesterday in the My Account area.  Run through the setup again and any data deployment issues you ran into should be resolved.
By Ben Kim - 2/20/2007

Thanks.  Downloaded and installed and it went through without a hitch.  However, since I have "two" StrataFrame databases (one on a server and one local), I thought I would run the install again to upgrade my local database.  When it gets to the "Configuring StrataFrame Phase 1 of 2: Registering StrataFrame Assemblies, please wait...", I have been waiting and waiting to no avail.  To end it I must use the three finger salute ;-)

Is there a way to upgrade other databases without rerunning the install?  I choose the Repair option if you want to test it yourselves.

Ben

By Trent L. Taylor - 2/20/2007

You should be able to run the repair as many times as you need to...I do not know what the Phase 1 of 2 stayed up.  I will test it again just to make sure there is not an issue.  But it has been designed to allow you to do this.