Security Editor Error

Nadr S Rajab — Wed, 21 May 2008 09:07:58 GMT

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

RE: Security Editor Error

Trent L. Taylor — Wed, 21 May 2008 09:07:58 GMT

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

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.

RE: Security Editor Error

Randy Jean — Tue, 20 May 2008 11:46:59 GMT

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

RE: Security Editor Error

Randy Jean — Tue, 20 May 2008 11:41:38 GMT

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

RE: Security Editor Error

Trent L. Taylor — Wed, 02 Apr 2008 13:10:35 GMT

Good to hear :)

RE: Security Editor Error

Nadr S Rajab — Wed, 02 Apr 2008 13:03:23 GMT

Thanks, that did the trick!!

RE: Security Editor Error

Trent L. Taylor — Wed, 02 Apr 2008 09:10:10 GMT

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.

StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Security Editor Error

Security Editor Error

RE: Security Editor Error

RE: Security Editor Error

RE: Security Editor Error

RE: Security Editor Error

RE: Security Editor Error

RE: Security Editor Error