Hey all,



I ran into a strange problem with the StrataFrame Business Object Mapper. When I try to configure my business project by clicking on the "Configure Project" link, I get an error message that says "Invalid column name 'proj_db2connstring'." Before going into the Business Object Mapper, I had debugged the project and set the application's database settings there with no problem. Indeed, I don't see any such column in our StrataFrame database. Any ideas what could be wrong? Here's the entire stack trace of the error if it helps any, and thanks in advance.



SqlException

Invalid column name 'proj_db2connstring'.



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(String Statement, OnChangeEventHandler CallBack)

at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(String Statement, Boolean RegisterNotification)

at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(String SelectStatement)

at MicroFour.StrataFrame.AddIns.DTEprojectsBO.GetAll()

at MicroFour.StrataFrame.AddIns.PartialClassBuilderProjectPicker.PopulateList()

at MicroFour.StrataFrame.AddIns.PartialClassBuilderProjectPicker.PartialClassBuilderProjectPicker_Load(Object sender, EventArgs e)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Windows.Forms.Form.OnLoad(EventArgs e)

at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.OnLoad(EventArgs e)

at System.Windows.Forms.Form.OnCreateControl()

at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

at System.Windows.Forms.Control.CreateControl()

at System.Windows.Forms.Control.WmShowWindow(Message& m)

at System.Windows.Forms.Control.WndProc(Message& m)

at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

at System.Windows.Forms.ContainerControl.WndProc(Message& m)

at System.Windows.Forms.Form.WmShowWindow(Message& m)

at System.Windows.Forms.Form.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.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)

at System.Windows.Forms.Control.SetVisibleCore(Boolean value)

at System.Windows.Forms.Form.SetVisibleCore(Boolean value)

at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.SetVisibleCore(Boolean value)

at System.Windows.Forms.Control.set_Visible(Boolean value)

at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

at System.Windows.Forms.Form.ShowDialog()

at MicroFour.StrataFrame.AddIns.PartialClassBuilderDialog.ConfigureProject(Project Prj)

Yeah, when you installed 1.6.1 you either did not allow the install to update your StrataFrame database or you have a second SF database that needs to be updated.  Just run the StrataFrame installation again and be sure to allow the StrataFrame database to be updated.  This is a new field that must exist in order to run the 1.6.1 release.

Trent,



I was told by a coworker that he had already done that a couple times to no avail, but just to be sure I tried myself and I still encounter the problem. For what it's worth, during the database deployment, I saw a couple failure messages with regards to updating tables but they went by too fast for me to note. I'll continue looking into the problem next week.



Thanks for the help,

Adam

Open the log file so that we can see what the errors were.  You can find them in the c:\program files\common files\microfour\strataframe folder and it will be named something like StrataFrame_Results.log.  You can post it here as an attachment as well so we can take a look to see what is going on and steer you in the right direction.  You may just see the error and know what to do as well.  Either way, let us know.  Thanks.

SQL2000





• 8/3/2007 3:03:55 PM   -> Deploying meta-data for database 'StrataFrame'

• 8/3/2007 3:03:55 PM   -> Ensuring Filegroups exist on database 'StrataFrame'

• 8/3/2007 3:03:55 PM   -> Filegroup verification complete.

• 8/3/2007 3:03:55 PM   -> Ensuring Tables exist on database 'StrataFrame'

• 8/3/2007 3:03:59 PM   -> The table 'DBETables' is being prepared to be modified.

• 8/3/2007 3:03:59 PM   -> The relationship 'fk_table_fields' was successfully dropped.

• 8/3/2007 3:03:59 PM   -> The relationship 'fk_tables_indexes' was successfully dropped.

• 8/3/2007 3:03:59 PM   -> The relationship 'fk_tables_relationships' was successfully dropped.

X 8/3/2007 3:04:02 PM   -> Altering table 'DBETables' failed.FailedOperationException

Alter failed for Table 'dbo.DBETables'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Cannot alter column 'tbl_desc' because it is 'text'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()

at Microsoft.SqlServer.Management.Smo.Table.Alter()

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)



• 8/3/2007 3:04:04 PM   -> The table 'DTEPreferences' is being prepared to be modified.

X 8/3/2007 3:04:04 PM   -> Altering table 'DTEPreferences' failed.FailedOperationException

Alter failed for Table 'dbo.DTEPreferences'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Cannot alter column 'pref_solution' because it is 'text'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()

at Microsoft.SqlServer.Management.Smo.Table.Alter()

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)



• 8/3/2007 3:04:05 PM   -> The table 'DTEproject_computer_tie' is being prepared to be modified.

X 8/3/2007 3:04:06 PM   -> Altering table 'DTEproject_computer_tie' failed.FailedOperationException

Alter failed for Table 'dbo.DTEproject_computer_tie'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Cannot alter column 'pct_fullprojectpath' because it is 'text'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()

at Microsoft.SqlServer.Management.Smo.Table.Alter()

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)



• 8/3/2007 3:04:09 PM   -> The table 'DTEproject_item_exceptions' is being prepared to be modified.

X 8/3/2007 3:04:10 PM   -> Altering table 'DTEproject_item_exceptions' failed.FailedOperationException

Alter failed for Table 'dbo.DTEproject_item_exceptions'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Cannot alter column 'piex_customcode' because it is 'text'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()

at Microsoft.SqlServer.Management.Smo.Table.Alter()

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)



• 8/3/2007 3:04:12 PM   -> The table 'DTEprojects' is being prepared to be modified.

• 8/3/2007 3:04:12 PM   -> The relationship 'fk_projects_computers' was successfully dropped.

• 8/3/2007 3:04:12 PM   -> The relationship 'fk_projects_items' was successfully dropped.

X 8/3/2007 3:04:13 PM   -> Altering table 'DTEprojects' failed.FailedOperationException

Alter failed for Table 'dbo.DTEprojects'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Cannot alter column 'proj_description' because it is 'text'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so)

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker()

at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl()

at Microsoft.SqlServer.Management.Smo.Table.Alter()

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType)



• 8/3/2007 3:04:16 PM   -> Table verification complete.

• 8/3/2007 3:04:16 PM   -> Dropping unneeded filegroups for 'StrataFrame'

• 8/3/2007 3:04:16 PM   -> Unneeded filegroups dropped on database 'StrataFrame'

• 8/3/2007 3:04:16 PM   -> Ensuring Views exist on database 'StrataFrame'

• 8/3/2007 3:04:17 PM   -> The view 'SFSUserPermissionInfo' was successfully dropped.

• 8/3/2007 3:04:17 PM   -> The view 'SFSUserPermissionInfo' was created successfully.

• 8/3/2007 3:04:17 PM   -> The view 'SFSUserRolePermissionInfo' was successfully dropped.

• 8/3/2007 3:04:17 PM   -> The view 'SFSUserRolePermissionInfo' was created successfully.

• 8/3/2007 3:04:17 PM   -> View verification complete.

• 8/3/2007 3:04:17 PM   -> Ensuring Indexes exist on database 'StrataFrame'

• 8/3/2007 3:04:20 PM   -> Index verification complete.

• 8/3/2007 3:04:20 PM   -> Ensuring Foreign Keys exist on database 'StrataFrame'

• 8/3/2007 3:04:20 PM   -> The relationship 'fk_table_fields' was created successfully.

• 8/3/2007 3:04:21 PM   -> The relationship 'fk_tables_indexes' was created successfully.

• 8/3/2007 3:04:21 PM   -> The relationship 'fk_tables_relationships' was created successfully.

• 8/3/2007 3:04:21 PM   -> The relationship 'fk_projects_computers' was created successfully.

• 8/3/2007 3:04:21 PM   -> The relationship 'fk_projects_items' was created successfully.

• 8/3/2007 3:04:23 PM   -> Foreign Key verification complete.

• 8/3/2007 3:04:23 PM   -> Ensuring Stored Procedures exist on database 'StrataFrame'

X 8/3/2007 3:04:23 PM   -> An error occurred while creating a stored procedure.FailedOperationException

ExecuteNonQuery failed for Database 'StrataFrame'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Invalid column name 'pref_ApplicationTheme'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand)

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureStoredProcedures(Database Db, DatabaseInfo DbInfo)



X 8/3/2007 3:04:23 PM   -> An error occurred while creating a stored procedure.FailedOperationException

ExecuteNonQuery failed for Database 'StrataFrame'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Invalid column name 'pref_ApplicationTheme'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand)

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureStoredProcedures(Database Db, DatabaseInfo DbInfo)



X 8/3/2007 3:04:23 PM   -> An error occurred while creating a stored procedure.FailedOperationException

ExecuteNonQuery failed for Database 'StrataFrame'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Invalid column name 'proj_db2connstring'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand)

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureStoredProcedures(Database Db, DatabaseInfo DbInfo)



X 8/3/2007 3:04:23 PM   -> An error occurred while creating a stored procedure.FailedOperationException

ExecuteNonQuery failed for Database 'StrataFrame'.

ExecutionFailureException

An exception occurred while executing a Transact-SQL statement or batch.

SqlException

Invalid column name 'proj_db2connstring'.



Source : Microsoft.SqlServer.Smo



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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

at Microsoft.SqlServer.Management.Smo.Database.ExecuteNonQuery(String sqlCommand)

at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.EnsureStoredProcedures(Database Db, DatabaseInfo DbInfo)



• 8/3/2007 3:04:23 PM   -> Stored Procedure verification complete.

• 8/3/2007 3:04:23 PM   -> Finished verifying databases on server.

• 8/3/2007 3:04:23 PM   -> The meta data conversion to the SQL Server has been completed.

Ben, you're going to have to at least tell me what you did   I can see that you are SQL 2000 and it is having trouble converting the Text field.  Text is treated entirely different in SQL 2000 since the Text data type fields are stored in a separate physical file.  Is your structure defined as a VarChar(MAX)?  Did you change the field name and then try to re-deploy.  Until I know more I can't tell you much more.

If you use the DDT and setup a column as VarChar(MAX) and deploy to SQL 2000 it will automatically convert the VarChar(MAX) field to Text since the MAX data types weren't introduced until 2005.  In any case, there is some process that you have intriduced to your structures that SQL 2000 does not like and behaves different than 2005.

Well, that's what's so confusing. To my knowledge, we haven't done anything to the database. We just upgraded to 1.6.1 and tried to deploy the database.

The problem is not with any of our DDT or Business Objects. The problem is that the Installation file apparently doesn't modify the database correctly. There are several missing fields in the StrataFrame DB...examples...





DTEProjects is missing 'proj_db2connectionstring'

DTEPreferences is missing 'pref_ApplicationTheme'

DTEPreferences is missing 'pref_CustomThemeFullName'

DTEPreferences is missing 'pref_ShowFullBOName'



Those are the ones I've found off hand. I've also noticed that several fields are still 'varchar(x)' when the new ones should be 'nvarchar(x)'



using: MSSQL 2000