Problem after upgrade to version 1.7.0


Author
Message
Jiri Brazda
Jiri Brazda
StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)
Group: StrataFrame Users
Posts: 78, Visits: 356
When clicking Stored procedures in DDT i receive the following error:

UIException
  Dynamically populating the ListView failed.  Could not create and fill the business object of type 'MicroFour.StrataFrame.Business.DBEProceduresBO'
TargetInvocationException
  Exception has been thrown by the target of an invocation.
SqlException
  Invalid column name 'as_Rank'.

Source     : MicroFour StrataFrame UI

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.FillOrGetByParentPrimaryKey(Object[] ParentPrimaryKeys, Boolean ReplaceCurrentDataTable)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillByParentPrimaryKey(Int32 ParentPrimaryKey)
   at MicroFour.StrataFrame.Business.DBEProceduresBO.GetAll(Int32 DatabasePK, Boolean IncludeTableInsertAndUpdateProcedures, Boolean byCategory, String categoryName)
   at MicroFour.StrataFrame.Business.DBEProceduresBO.GetAll(Int32 DatabasePK, Boolean IncludeTableInsertAndUpdateProcedures)
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at MicroFour.StrataFrame.UI.Windows.Forms.ListView.GetFilledBusinessObject(Object[] Parameters)
   at MicroFour.StrataFrame.UI.Windows.Forms.ListView.PopulateListView(Object[] Parameters)
   at MicroFour.StrataFrame.UI.Windows.Forms.ListView.Requery()
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.Load_StoredProceduresDetails()
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.PopulateDetailList(DBEObjectType tvitem)
   at MicroFour.StrataFrame.Data.ProfileEditorDialog.ProcessTreeviewSelection(DBETVItem tvItem)

Edhy Rijo
E
StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Jiri Brazda (08/03/2009)
When clicking Stored procedures in DDT i receive the following error:



UIException

Dynamically populating the ListView failed. Could not create and fill the business object of type 'MicroFour.StrataFrame.Business.DBEProceduresBO'

TargetInvocationException

Exception has been thrown by the target of an invocation.

SqlException

Invalid column name 'as_Rank'.





Hi Jiri,



Did you rebuild your BO in the BOM as per instructions for this upgrade?



Also the error clearly state a missing/invalid column named "as_Rank", make sure this column exist in your table.

Edhy Rijo

Jiri Brazda
Jiri Brazda
StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)
Group: StrataFrame Users
Posts: 78, Visits: 356
Hi Edhy,

Yes, I did rebuild in my BOM. However it seems to me that it has nothing to do with DDT. The error doesn't occur in my application but in DDT itself - so there must be problem in SF core database?

The upgrade itself has been finished successfully.

Thank You

Jiri

Edhy Rijo
E
StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Humm, could it be that the installer did not update the SF database? by any chance did you click on the checkbox to skip updating the StrataFrame database?



If so, then try downloading the installation again and re-run it.

Edhy Rijo

Jiri Brazda
Jiri Brazda
StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)StrataFrame Novice (124 reputation)
Group: StrataFrame Users
Posts: 78, Visits: 356
I have re-run SF installer and now it works fine. I must have accidentally check skipping SF database upgrade during my first attempt.

So thank You and sorry my distractibility w00t

Jiri

Edhy Rijo
E
StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)StrataFrame VIP (3.7K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Jiri,



Glad it is working fine now.

Edhy Rijo

Trent Taylor
Trent Taylor
StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)StrataFrame Developer (8.5K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
I have re-run SF installer and now it works fine. I must have accidentally check skipping SF database upgrade during my first attempt.




I imagine that is exactly what happened. Glad you are going now! Smile
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