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

Marcelo Blank — Fri, 11 Nov 2011 08:53:23 GMT

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

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

Ivan George Borges — Fri, 11 Nov 2011 08:53:23 GMT

You're welcome, Marcelo. :cool:

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

Marcelo Blank — Fri, 11 Nov 2011 08:38:33 GMT

Thanks...

It helped ...

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

Ivan George Borges — Fri, 11 Nov 2011 08:33:03 GMT

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

Marcelo Blank — Fri, 11 Nov 2011 08:14:25 GMT

Yes Ivan ...

Twice ...

Gonna try in another machine and see wath's different in the databases ...

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

Ivan George Borges — Fri, 11 Nov 2011 08:02:06 GMT

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?

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

Marcelo Blank — Fri, 11 Nov 2011 07:35:19 GMT

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

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

Ivan George Borges — Fri, 11 Nov 2011 05:59:35 GMT

Hi Marcelo.

In the instalation process, DO update the Strataframe Database ....

StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Upgrade to version 1.7.3.5 : Invalid column name 'dbe_PackageCompression'.

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

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

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

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

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

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

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

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