StrataFrame Forum

Upgrade to version 1.7.3.5 : Invalid column name 'dbe_PackageCompression'.

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

By Marcelo Blank - 11/10/2011

I'm just upgrade to new version 1.7.3.5 ... 

1 - I lost my existents DDT projects;

2 - I got an error when try to open a DDT screen : Invalid column name 'dbe_PackageCompression'.



SqlException
  Invalid column name 'dbe_PackageCompression'.

Source     : .Net SqlClient Data Provider

Stack Trace: 
   at System.Data.SqlClient.SqlConnection.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.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.tlmActions_ItemClicked(Object sender, ThemedLinkMenuClickEventArgs e)
   at MicroFour.StrataFrame.UI.Windows.Forms.ThemedLinkMenu.HandleMouseUp(MouseEventArgs e, ThemedLinkMenuItemCollection Items)
   at MicroFour.StrataFrame.UI.Windows.Forms.ThemedLinkMenu.ThemedLinkMenu_MouseUp(Object sender, MouseEventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(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)



In the instalation process I did NOT update the Strataframe Database ....

So, what do I do ? 



Regards,

Marcelo Blank
By Ivan George Borges - 11/10/2011

Hi Marcelo.

In the instalation process, DO update the Strataframe Database ....
By Marcelo Blank - 11/11/2011

Ivan,

I already reinstall it, with update to Database, but still get the same message...

Is there a script That I can run to fix it ? 

Marcelo
By Ivan George Borges - 11/11/2011

That is a new column that should have been created to a StrataFrame database table. Are you sure you are pointing to your developing server when doing the installation?
By Marcelo Blank - 11/11/2011

Yes Ivan ...

Twice ...



Gonna try in another machine and see wath's different in the databases ...
By Ivan George Borges - 11/11/2011

http://forum.strataframe.net/Uploads/Images/721c6233-a44f-4bf6-92bb-3081.png
By Marcelo Blank - 11/11/2011

Thanks...

It helped ...
By Ivan George Borges - 11/11/2011

You're welcome, Marcelo. Cool