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


Author
Message
Marcelo Blank
Marcelo Blank
StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)
Group: StrataFrame Users
Posts: 0, Visits: 414
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
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Marcelo.

In the instalation process, DO update the Strataframe Database ....
Edited 13 Years Ago by Ivan George Borges
Marcelo Blank
Marcelo Blank
StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)
Group: StrataFrame Users
Posts: 0, Visits: 414
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
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
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?
Marcelo Blank
Marcelo Blank
StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)
Group: StrataFrame Users
Posts: 0, Visits: 414
Yes Ivan ...

Twice ...



Gonna try in another machine and see wath's different in the databases ...
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
http://forum.strataframe.net/Uploads/Images/721c6233-a44f-4bf6-92bb-3081.png
Marcelo Blank
Marcelo Blank
StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)StrataFrame Novice (120 reputation)
Group: StrataFrame Users
Posts: 0, Visits: 414
Thanks...

It helped ...
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)Strategic Support Team Member (3.5K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
You're welcome, Marcelo. Cool
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search