Security Editor Error

StrataFrame Forum

Security Editor Error

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

By Nadr S Rajab - 4/2/2008

when I try editing a user or try adding a new user and save the new users details I get the following error:

Note: This error has started since upgrading to 1.6.5, previous to that it had been working fine

SqlException
Invalid column name 'us_DisplayName'.

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(QueryInformation QueryInfo, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(QueryInformation QueryInfo, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillOrGetByPrimaryKey(Object[] PrimaryKeyValues, Boolean ReplaceCurrentDataTable)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillByPrimaryKey(Int32 PrimaryKeyValue)
   at MicroFour.StrataFrame.Security.UserEditor..ctor(Int32 ProjectPK, Int32 UserPK, Int32 ExistingUserPK, Boolean IsCopy)
   at MicroFour.StrataFrame.Security.UserEditor..ctor(Int32 ProjectPK, Int32 UserPK)
   at MicroFour.StrataFrame.Security.SecurityDialog.EditUser()
   at MicroFour.StrataFrame.Security.SecurityDialog.cmType_UserEdit_Click(Object sender, EventArgs e)
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.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)

where is the Us_DisplayName column used?

Thanks in advance

By Trent L. Taylor - 4/2/2008

You didn't update your StrataFrame data structures. There were structure changes between the previous releases and wen you installed the 1.6.5 release you did not allow the install to update your data structures (StrataFrame database). Just re-install 1.6.5 and allow the StrataFrame databases to be updated and this will resolve your error.

By Nadr S Rajab - 4/2/2008

Thanks, that did the trick!!

By Trent L. Taylor - 4/2/2008

Good to hear Smile

By Randy Jean - 5/20/2008

Hi Trent,

Can you tell me if the role based structure changes are documented anywhere? (or is us_Displayname the only thing added?) We currently do not use DDT to deploy RBS table changes (these are in another database) The clients DBA on site want us to send him standard SQL scripts for any changes to this database - we do not even have the rights to change these ourselves.

Thanks,

Randy

By Randy Jean - 5/20/2008

On a related note, the help Topic "Deploying Security Data" does not appear to be current with 1.65 info and SQL scripts.

By Trent L. Taylor - 5/21/2008

Can you tell me if the role based structure changes are documented anywhere? (or is us_Displayname the only thing added?)

That is the only column that was added that will impact you in any way. There are some new auditing tables that have been added...however, they cannot be used as of yet and do not need to be deployed.