StrataFrame Forum / StrataFrame Database Deployment Toolkit / Issues

merge replication in SQL Server 2000

Julio Cesar Bilitardo — Sat, 03 May 2008 07:50:24 GMT

Hello Guys!

I talk from Sao Paulo, Brazil.

I develop system for industries and all of many then, I use SQL Server 2000 ( Small Business Package ).

My projetcts are all in VB6.

And some time ago I read an article in a Brazilian .Net Magazine about StrataFrame.

I was very interested in use strataframe, and I saw a demonstration.

It´s really fantastic.

But, some questions made think about use strataframe.

one of them is, how I can manage table strutucts manually in merge replication databases?

specially in tables that are in replication. because new tables, we can create in query analiser. but in tables that are in replication, the fields are create using enterprise manager replication monitor, adding columns in articles!

How DDT create all structures alone, this fields will not be create.

Buy.

Auto Generation of Stored Procs

Geoff Hirst — Sun, 20 Apr 2008 11:29:52 GMT

Guys,

Got an issue with the DDT that came about because I wanted to change clustering on some tables to some new indexed columns. Got myself into a right state with it. However, I have discovered this and I don't know if this is by design.

In the DDT create a new table and check boxes for auto proc generation.

Add an ID, integer, not PK, but enable Identity with standard 1,1 incrementation.

Add a couple of varchar 10 columns.

Save structure, then try to deploy.

For me, it all goes south when it tries to create the sprocs for some reason it thinks the Identity column is being updated.

Now, I found a patch version of DDT on another post that looked like it might solve my issues, but I got errors when I launched it.

Any advice would be appreciated.

thanks

Geoff Hirst

Log File Extract

20/04/2008 17:00:46 -> An error occurred while creating the stored procedure [dbo].[zzz_TestTable_Delete].
X 20/04/2008 17:00:46 -> SqlException
X 20/04/2008 17:00:46 -> Incorrect syntax near ';'.
X 20/04/2008 17:00:46 ->
X 20/04/2008 17:00:46 -> Source : .Net SqlClient Data Provider
X 20/04/2008 17:00:46 ->
X 20/04/2008 17:00:46 -> Stack Trace:
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 20/04/2008 17:00:46 -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)
X 20/04/2008 17:00:46 ->
X 20/04/2008 17:00:46 -> An error occurred while creating the stored procedure [dbo].[zzz_TestTable_Update].
X 20/04/2008 17:00:46 -> SqlException
X 20/04/2008 17:00:46 -> Cannot update identity column 'ID'.
X 20/04/2008 17:00:46 ->
X 20/04/2008 17:00:46 -> Source : .Net SqlClient Data Provider
X 20/04/2008 17:00:46 ->
X 20/04/2008 17:00:46 -> Stack Trace:
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
X 20/04/2008 17:00:46 -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
X 20/04/2008 17:00:46 -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)
X 20/04/2008 17:00:46 ->

Errors creating package

Greg McGuffey — Tue, 08 Apr 2008 12:51:43 GMT

I'm getting a 1026 message ID error when I try to create a package. It indicates there is "No row at position zero". Screen shot attached.

Any changes to DatabaseMigrator in 1.6.5?

Keith Chisarik — Wed, 13 Feb 2008 12:05:46 GMT

I have a web project that deploys DDT package files to databases via the DatabaseMigrator class.

I haven't touched this in weeks and it was working, now the database is created but the tables are not deployed. Were there any changes to this class in 1.6.5 that might have caused this before I rip it apart? To the best of my knowledge the SF upgrade is the only thing that has changed in this area of the project.

Thanks.

Deploying to server - error when creating stored procedures

Jiri Brazda — Thu, 20 Mar 2008 08:29:28 GMT

Hi,

I'm using trial version of Database Deployment Toolkit. I'm using automatical creation of stored procedures. When deploying to SQL server for first time, everything is running correctly. When deploying the same database to server again, I receive an error stating that "An error occurred while creating the stored procedure XY" and that "There is already an object named XY" - for all stored procedures. When I delete these procedures from SQL server, it runs correctly.

Is there any possibility to include something like "If exists then drop..."? Or is there any workaround?

Thanks

George

MissingMethodException Error

Purnell W Glenn — Sun, 10 Feb 2008 19:58:34 GMT

When trying to create a New File Group, I get the following error.

MissingMethodException
Method not found: 'Void MicroFour.StrataFrame.UI.Windows.Forms.ChildFormDialog.set_ParentForm(MicroFour.StrataFrame.UI.Windows.Forms.BaseForm)'.

Source : DatabaseDTK

Stack Trace:
at MicroFour.StrataFrame.Data.FileGroupProperties.InitializeComponent()
at MicroFour.StrataFrame.Data.FileGroupProperties..ctor(Int32 DatabasePK, Int32 FileGroupPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.ShowFileGroupProperties(Int32 FileGroupPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.cmi_Profile_AddFileGroup_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)

Database Deploymen Toolkit Failing to change PK data type

Donovan Sobrero — Fri, 01 Feb 2008 11:23:18 GMT

We have an ERP software package with a number of database definiitons that we are hoping to correct. We're trying to use the Database Deployment Toolkit to deploy new definitions to our legacy databases used in the field by our customers. Our first attempt at converting the database schema to an updated schema has not been very sucessful. Primarily, one of the issues that is trying to be corrected is converting PK datatypes from Decimal(10,0) to Int. It appears based on the log error messages that the PK constraints are not dropped prior to the type change being applied.

Is this something that the tool is meant to support?

Thanks,

Aaron

Exceptions while deployng a package

George Nentidis — Fri, 01 Feb 2008 07:33:24 GMT

Hi there guys.

The whole thing started when I tried to modify a foreign key constraint. Then when trying to deploy the package I got an exception saying that a certain field (which is the primary key) could not be renamed because it was a member of a list. I have removed the constraint and add it again, and the same error.

After that I have removed the whole table and recreated it. Not I get four exceptions: One that says that a certain view (which depends on the table) could not be created because the table is not there. I have remove and recreated the view too, but still the same error.

The other two exceptions complain that they cannot verify the existence of the indexes in the table and view which I have removed and recreated.

The fourth complains about not being able to verify the existence of foreign keys in the table that has been removed and recreated.

Is there a chance that I'm doing something terribly wrong with DDT? I have imported the tables from a SQL2005 database and created all indexes and stored procedures and views manually in the DDT. After that all I do is modifying the schema. Is there a certain way I must be using the DDT tool? Is this because DDT is a rather new tool?

I have attached a rar file that contains my database, my StrataFrame database, the package, and the result log files of the deployments, in case you'll need to look more into it.

Thank you in advance.

Update Using Stored Procedure Issue

Larry Caylor — Wed, 11 Jul 2007 16:38:17 GMT

I've run into an issue with update stored procedures generated by DDT are not matching up with the update parameter list created by the framework. I have a table with a non-identity integer pk and a SQL timestamp column that I've configured in DDT to generate insert and update procs.

After mapping the table to an object in BO mapper I've dropped it on a form and set the appropriate properties to use stored procedures for update and insert, set auto ncrement pk = false and configured the BO to use optimstic timestamp concurrency.

When I run the app inserts work. When I try to update I get an error stating the update procedure has too many arguments specified. Looking at the parameters that were generated in debug mode, it shows a "..._ORGPK" parameter containing the original pk value. It would appear that the framework is failing to recognize that timestamp concurrency is being used and is not supressing the original pk parameter or DDT is failing to include it in the proc.

-Larry

Any change in field data changes PK back to clustered

Charles R Hankey — Mon, 06 Aug 2007 13:41:02 GMT

V 1.61. PK is UID. By default DDT created it clustered. Change PK Index props to non-clustered in DDT

Later go back to this table in DDT dirty buffer in any way ( on fields other than pk )

Save and close. PK Index has changed back to clustered. ( Can really bite you if you dont' remember to look for it )

Just something to look at before next release. :)

Deployment of a package leaves some strage stored procedures.

George Nentidis — Fri, 01 Feb 2008 05:08:12 GMT

I have noticed that when deploying my package, there are some stored procedures created that are not declared in the package. They're not mine.

Those have the form of TableNameInsertIgnore and have an insert statement in them. I can also tell you that there's one for each table that I have a data deployment package for. This should make sence I think.

They're not actually causing any trouble, but I think you should know.

Deploying a data package for a table with a timestamp column fails.

George Nentidis — Tue, 15 Jan 2008 05:31:58 GMT

Hi there,

I have seen this problem in another topic, but there was no answer mentioned there.

When trying to deploy a data package for a table with a timestamp column, I get the exception:

SqlException: Cannot insert an explicit value into a timestamp column. User INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.

It seems like the DDT is trying to copy the timestamp values taken from the original table, while it shouldn't, since timestamps are updated by SQL server.

Did you come up with a solution for that?

Thank you.

Only Int primary keys are imported.

George Nentidis — Mon, 14 Jan 2008 04:14:40 GMT

Hi there,

I have already mentioned a bug (that you recorded) in another discussion: When importing a DB to the DDT, all uniqueidentifier primary keys are converted to Int.

I would like to add on this that ALL primary keys that are not integers, are actually imported as integers. This really messes up the primary key and foreigh key definitions. I have to make a lot of job mannualy to update all these until the package works. I hope you solve this quick.

Also, does DDT import user-defined data types? I have the impression that when the DDT package tries to create stored procedures with user-defined data types, failes because the data types are not there, propably because they are not created.

Thank you

Stored Proc Issue

Geoff Hirst — Sun, 02 Dec 2007 09:37:40 GMT

Chaps,

I have a stored proc, that returns the full contents of a table, some 21 columns. Now, I have no parameters on this proc, as I intend to use it for list population etc.

Thing is, it won't deploy. I get an error that says a problem occurred with a stored proc. A problem near the word 'SELECT'.

Now if I add

@ID int

at the top of the proc, it deploys fine.

Proc is

Select ID,JobNo,ProjectName,WorkDescription,ClientID,ClientContact,ContactDetails,JobManager,JobArchitect,

JobType,ClientType,EnduserCLientType,SourceofWork,Timebased,FixedFee,PercentageValueOfProject,

ExpensesID,ProjectFee,EstimatedProjectValue,ProjectPercentage,ProjectFee2 from Job

If I replace the text with SELECT * from Job it also works fine.

Any Ideas chaps?

thanks

Geoff

Relationships Greyed and Locked

Alex M. Lana — Wed, 07 Nov 2007 11:15:08 GMT

Greetings,
I'm experiencing some issues with relationships.
I'm having some FailedOperationException, and it's always related with locked relationships(greyed) as you can see in the snapshot.
I'm trying to change/fix the relationships, but DDT does not allow me.
What can I do? Is there a way to alter/delete those locked relationships?

[img]http://lh6.google.com.br/alexlana.net/RzHx46hx4NI/AAAAAAAAAI8/IVIZJKs1pvw/DDT_FKs.jpg[/img]

Thanks,
[b]Alex[/b]

SDT Error Adding Index

Jerry Jansen — Thu, 01 Nov 2007 12:47:52 GMT

In SDT 1.6.0.0, when I right click on any of my tables index node, and select "New Index" I get an error.

MissingMethodException
Method not found: 'Void MicroFour.StrataFrame.UI.Windows.Forms.ChildFormDialog.set_ParentForm(MicroFour.StrataFrame.UI.Windows.Forms.BaseForm)'.

Source : DatabaseDTK

Stack Trace:
at MicroFour.StrataFrame.Data.IndexProperties.InitializeComponent()
at MicroFour.StrataFrame.Data.IndexProperties..ctor(Int32 ProfilePK, String TableName, Int32 TablePK, Int32 IndexPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.ShowIndexProperties(Int32 IndexPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.cmi_Profile_NewIndex_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)

Thanks

Issue Importing Stored Procedures

Purnell W Glenn — Fri, 02 Nov 2007 08:23:03 GMT

I'm trying to Import my SQL2005 DB files into a DDT pkg. Everything imports accept for the Stored Procedure files. I checked all of the import boxes, but it just does not import the SProcedures. ANy clue on what to check? Also I tried run the package and install it on to another SQL server, the message tells me that installed, but when I look at the files in SQL Manager, they are not there.

Error double-clicking index node

Charles R Hankey — Thu, 04 Oct 2007 12:59:36 GMT

Really need help on this one. Somehow broke my DTT again. Trying to apply fixes and patches as they appear here scattered through the message base and I'm afraid I may have let my ignorance of just how the plumbing of .NET works let me do something dumb.

Here's the error on double-clicking an index node :

MissingMethodException
Method not found: 'Void MicroFour.StrataFrame.UI.Windows.Forms.ChildFormDialog.set_ParentForm(MicroFour.StrataFrame.UI.Windows.Forms.IContainerControl)'.

Source : DatabaseDTK

Stack Trace:
at MicroFour.StrataFrame.Data.IndexProperties.InitializeComponent()
at MicroFour.StrataFrame.Data.IndexProperties..ctor(Int32 ProfilePK, String TableName, Int32 TablePK, Int32 IndexPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.ShowIndexProperties(Int32 IndexPK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.lstDetail_DoubleClick(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnDoubleClick(EventArgs e)
at System.Windows.Forms.ListView.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)

I'm attaching shots of my Strataframe folder and the assembly folder

A little confused in that after installing 1.6.1 the assembly folder still showed 1.6.0 as the version, but I admit to not understanding the GAC yet.

I applied the files from the zip Ben posted on 8-31 ( a DatabaseDTK.EXE dated 8-31 and a StrataframeBO.dll )

Help getting me back on track would be greatly appreciated as the DDT is pretty essential to a major project I'm working on.

TIA

Charles

Login failed while deploying data

Greg McGuffey — Mon, 01 Oct 2007 21:11:53 GMT

I'm attempting to deploy my security tables using the DDT. When I do the deploy, I create a new package, which includes the permissions table as part of the deployment. I first got an error that a login (to a common db user for the dev db) failed because the user needed to change their password. I figure out that this is set on the permission package, so I go to SQL Server and change it and update the password for the permission data. Now I get an error that the login is just failing...sigh... So I open up SQL Management Studio and test the user/password (all sql user/passwords btw). They work...sigh... So I change the user/password to another one. I STILL get an error related to the login failing for the first user.

Now, I decided I didn't want to deploy all the security tables, so I deleted some of the packages. Could there be some residual info that could be causing this problem? I'm stuck until I can get this solved (can't deploy).

Thanks!

SQL Express - Wizard Issue

Bastian Töpfer — Tue, 11 Sep 2007 02:00:25 GMT

Hi,

I found a little issue that I think is worth informing you about. If I use

MicroFour.StrataFrame.DBEngine.Deployment.MDDeployMain to deploy a database on a sql express instance and that instance is the only sql server instance on the computer, the

the ComboBox with the header "Select SQL Server" only shows the computername . If you continue the wizard it will fail to connect to the server. Strange... since I just connected to the server and that worked. After I manually set the sql server to 'COMPUTERNAME\SQLEXPRESS' it worked.

I tried the same with a full sql server version and then it does not seem to matter.

My suggestion would be to always add the Computername + Instancename, even if there is just one sql server instance visible.

Hope you can change that behaviour or tell me if I have done something wrong.

Thanks

Issue with TinyInt

Tim Dol — Wed, 29 Aug 2007 12:24:18 GMT

I have set the data types for a number of fields to 'TinyInt'. These values come accross as System.Byte in the mapper. Is this correct or a small bug?

Tim

Error trying to deploy.

Keith Chisarik — Thu, 09 Aug 2007 09:20:10 GMT

I made a minor change to a table and tried to deploy, I get the error attached during "Step 1-Packaging Stored Procedures", if I hit OK it then takes me to the "Select Meta-Data Package" screen but I don't get the message I am used to that the new package was created successfully. I am afraid to go on. I have confirmed that I can log into the SQL Server specified in the "Strataframe Data Store", please help... naturally things like this happen when you have promised a client an update that afternoon.

I did have to move my SF Database to another physical server, but I did change the SF Store and have had no other issues related to the move in the last two weeks so I doubt it is related, but wanted to toss it in the mix since it seems to be a SQL issue by the error.

DDT Import Database

Fabian R Silva, - — Mon, 06 Aug 2007 15:50:10 GMT

I´m testing the framework and have a little question:

When I import a database from Sql Server (2000) from DDT my comments (description) is lost ("this table / field was imported")

Can I avoid this? thanks

Expected behavior in reimporting from SQL Database

Charles R Hankey — Wed, 01 Aug 2007 10:55:28 GMT

I want to make sure I am clear on how DDT is intended to work and what to expect in certain scenarios.

If I have a SQL database MYDATABASE and I import this into a new DDT project MYPROJECT I would expect it to read all the structures, indexes, PKs etc ( if I have check the right boxes on the import wizard )

Now, I make changes in DDT and I deploy to the server. My changes are deployed.

Now the DBA makes some changes on the server. I want to keep my metadata in DDT in sync. If I import into the same project I get MYDATABASE_1 . Fair enough. I can now use that as the most current version of the metadata ( or use MYDATABASE to fix the server if the DBA has done something boneheaded. )

But I am not sure what is going on in the Strataframe database. If I create a new DDT project - MYPROJECT2 - and import the MYDATABASE, am I going to confuse any of the data stored in Strataframe? ie. are surrogate keys keeping all this straight? Suppose I import MYDATABASE into MYPROJECT2 and then deploy a changed version of it to MYDATABASE2 on the same server?

In other words, is there anything like this I have to be careful of when using DDT ?

TIA

Adding Messaging and Localization Tables Error in DDT 1.6.0.0

Jerry J Jansen — Tue, 17 Jul 2007 12:44:12 GMT

I am testing DDT and I imported my data structure from VFP and then added from the Profile menu, "Add Messaging and Localization Tables". I kept getting an error when deploying the database to SQL server. The error mention something about an empty procedure field. I checked all of the my data tables procedures and everything looked ok. I checked all of the Messaging and Localization Tables in DDT and they looked ok.

Then I checked the actual DBETables in SQL server and found the field tbl_insertsprocname EMPTY for the MessageItems and MessageLanguages tables with the fields tbl_insertprocs set to true. However, the insert procedures showed up OK in DDT.

So there must be an error in the importing of the Messaging and Localization Tables in DDT in updating the SQL table.

I then went back to DDT and unchecked/rechecked the "Create INSERT Stored Procedure" in the table properties for both MessageItems and MessageLanguages tables and then the fields tbl_insertsprocname were filled in the SQL DBETables table.

Moving/Deleting fields in DDT 1.6.0.0

Jerry J Jansen — Tue, 17 Jul 2007 13:07:36 GMT

Testing out DDT and when I modify a table's structure, then move a field up in the list, then delete a field, then the field that I moved up reverts back to it's original position. Then try to move the field again and it is not the same field but now the field actually shows up at the top of the list!

DDT erasing Triggers

Keith Chisarik — Fri, 13 Jul 2007 09:33:44 GMT

I know triggers aren't supported by the DDT yet, but here is my issue.

I have triggers in my SQL database, I just updated a table in the DDT to add some fields and deployed it to the server, it erased all my triggers.

How can I avoid this? I thought the rule was if the DDT doesn't need to update something it leaves it alone?

What is the Current SF Release ?

Michael Reese — Wed, 16 May 2007 18:11:40 GMT

Are we at release 1.6.0 or 1.6.1?

Problem with Version 1.6.1

Ben Hayat — Tue, 15 May 2007 10:07:23 GMT

To SF Team:

I started to change my VarChar to NVarChar and noticed a problem. First SF, changes the field to 50, which needs to be reentered again (Can we just enter our own column size without default). But the worst part comes after. When you move to the next field, the [b][u]50[/u][/b] keeps overwriting the next field size. This is trouble for anyone doesn't notice it.

Could we please get a fix to this soon? Thanks!

Updating table with identity field

softaca — Mon, 30 Apr 2007 15:34:57 GMT

Hi,

In the process of migrating my database update systeem to the strataframe system, i've made several definition errors. A few of them were PK fields with identity specification where there should not be a identity specification. So i made the corrections in the DDT and generated a new deployment package. When i applied the package to my test server i found out that the identity specification stills exsist!!! Is this a bug or do i do something wrong?

Error deployment data

softaca — Thu, 19 Apr 2007 15:18:47 GMT

As i am a newbie with the Strataframe framework, i am not sure to post this as a question or an issue. At the moment i am implementing the deployment of a database within one of my projects. It includes some deployment data as well. That is the data for the security and the data for the localization. When i deploy only the structure and the above mentioned data everything runs smootly. If a add the data from another table and try to deploy then i always get an error, see the attached logfile. The table is a very simple table with only one field and one record.

Do you have any idea what the problem is here? I attach the package file as file.

Error adding a table

Flavelle Ballem — Tue, 10 Apr 2007 19:32:47 GMT

BusinessLayerException
The CurrentRow could not be evaluated because the CurrentRowIndex is out of range. Business object record count: 0. CurrentRowIndex: -1.

Source : MicroFour StrataFrame Business

Stack Trace:
at MicroFour.StrataFrame.Business.BusinessLayer.get_CurrentRow()
at MicroFour.StrataFrame.Business.DBEFileGroupsBO.get_fg_pk()
at MicroFour.StrataFrame.Data.TableProperties..ctor(Int32 ProfilePK, String DatabaseName, Int32 DatabasePK, Int32 TablePK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.ShowTableProperties(Int32 TablePK)
at MicroFour.StrataFrame.Data.ProfileEditorDialog.cmi_Profile_AddTable_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)

NullReferenceException while deploying

GRocchi — Wed, 28 Mar 2007 16:18:14 GMT

Deplying a DB to an SQL Server 2000 DB called SPS, I receive some errors and an Application Exception that stops the deploy process.

This leaves the DB in un unstable status and I didn’t recover it yet.

The deploy window showing error and the package that raises it are attached to this post

Gianpaolo Rocchi

Database Physical File Location

Tim Dol — Wed, 28 Feb 2007 10:02:29 GMT

I am using a separate database for the role based security files and when I deploy for the first time it automatically creates the physical database files in a default folder. We have customers that implement policies for the physical location of database files. Is there any way to specify the folder location if the database does not exist? I basically use your standard deployment routines, which I have wrapped for customer use, so does your standard deployment routine currently support this?.

Tim

Error using DDT

Kent Meyer — Wed, 28 Feb 2007 10:46:36 GMT

I am having difficulty using the DDT. I installed a 1.5 test version and then installed the 1.6 test version. Recently purchased a license and activated it. When I try to use the DDT, I get an error. It seems to be connecting to the DB. It looks like some sort of version issue. Error included below.

Thanks

TargetInvocationException
Exception has been thrown by the target of an invocation.
SqlException
Invalid column name 'dbe_Category'.

Source : mscorlib

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.Business.DBEProfileBO.FillWithDistinctCategories()
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.ListControl.PopulateComboFromBusinessObject(IListControl lstControl, Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ListControl.PopulateCombo(Control lstControl, Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ComboBox.PopulateCombo(Object[] Parameters)
at MicroFour.StrataFrame.UI.Windows.Forms.ComboBox.Requery()
at MicroFour.StrataFrame.UI.Windows.Forms.ComboBox.InitializeObject()
at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.InitializeFormLoadObjects()
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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

DDT Data Deployment Error

Tim Dol — Sun, 11 Feb 2007 14:48:41 GMT

I wrote a database installer DLL to deploy the role based security files, based on the installer example on the forum. (DataProgress)

In my AppMain I added some code to check if the security database exists. If not, I automatically call the installer DLL.

Everything works perfectly when I run my application within visual studio, however, When I run the exe, I get the attached error. The error occurs at the start of the data deployment phase. The meta data is deployed without errors.

Any idea why this is happening?

Thanks

Tim

Broken Rule can't be fixed

Greg McGuffey — Tue, 13 Feb 2007 15:46:57 GMT

When modifying a table's structure, if I accidentally hit the "new" button twice, I end up with two blank columns in the list of columns. I can then enter the information for both columns. It doesn't complain and it appears that all is well. But when I go to save, I get a broken rule, saying the name of the column can't contain spaces. I get this on EVERY column and can't save at all. I must exit without saving and then reenter any thing lost.

To Reproduce
1. In DDT, add a new table
2. Add a column and define it
3. Add another column and define it
4. Hit the new button twice...not two blank lines in list of columns
5. Enter information in these two columns, including name, no spaces
6. Try to save, I get a Broken rule on name
7. Delete that column and try to save again...get broken rule on another column

Importing from a package file

Keith Chisarik — Tue, 23 Jan 2007 21:39:03 GMT

When importing a DDT project from a package file it seems that unwanted syntax is added to the CREATE PROCEDURE area.

It adds the following which I have had to delete from 50+ stored procs......am I missing something?

IF EXISTS(SELECT [name] FROM [sysobjects] WHERE [name] = 'aspnet_CheckSchemaVersion')
DROP PROCEDURE [dbo].[aspnet_CheckSchemaVersion]
GO
[b]set ANSI_NULLS ON[/b]
[b]set QUOTED_IDENTIFIER ON[/b]
[b]GO[/b] -----> already added in the 'Pre-Create/Environment Code area

[b]CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion][/b] ----> Added via the tool

It also throws up on the "IF EXISTS...." line, is this misplaced as well?

Image in DDT help wrong

Greg McGuffey — Tue, 23 Jan 2007 12:59:27 GMT

In the edit relationship topic, the image that is to illustrate the Edit Relationship instead shows Edit Index.

Database Deployment Activation Error

choyt — Tue, 02 Jan 2007 15:19:56 GMT

Hi Folks

I'm having the same problem with activtating my DDT as I was about a month ago but the last time, my network adapter seemed to be the problem. This time, I'm not sure what has happened.

My Activation Client says Activated: Yes / Network Adapter: Unknown
I have 3 network adapters (wired, wireless and 1394) all of which are connected and have not changed.
I activated using the DLL. (does that make a difference)?
I went online and saw that my old laptop was still activated so I deactivated it (I'm thinking that this is the root of the problem)
The error I get when I open the DDT is Feature Not Purchased
When I try to Deactivate using the Activation client (its the only option I'm given) I get Activation Error !! Exception: Unknown Adapter...yada yada...

I'm stuck but have a critical need for this to work very soon. What are my options?

Thanks