StrataFrame Forum

Error during deployment

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

By Derrick Bell - 11/17/2006

I received an error during my initial deployment. I don't know if it's significant.

Please advise.

Derrick

By Trent L. Taylor - 11/17/2006

I cannot see the errors.  You can attach the image as an attachment.  But bascially, when you see errors like this, it is because something in the deployment package does not adhere to the SQL Server rules.  One very common cause that people run into in the beginning is having a table with data in it and then not providing a default value (or allow null) for a new field.

But I will have to see the error in order to give any better advice.

By Derrick Bell - 11/17/2006

Hmm the database is empty. And now is dropped due to the deployment process. I'm in SQLServer 2005 Express.
By Trent L. Taylor - 11/17/2006

Look in your History...is there a delete of the database? This is another common "oops".  Is so, remove the deletion record or clear your history.
By Derrick Bell - 11/17/2006

Fix it.. the keys in one of my tables where wrong. Just the error really didnt seem to tell me.
By Derrick Bell - 11/17/2006

However the deployment then drops the database... Guess there is a setting. Looking now
By Trent L. Taylor - 11/17/2006

Look at my previous post....I am willing to bet that you deleted a database then added that same database name bak into the DDT.  This will have a history record of a delete of the database with that name.

So in this example, if I when and created another database named "appt", it will delete that database during the deployment after it has already been created.  Remove this line from the history and you will be good to go.

By Derrick Bell - 11/17/2006

Yes I did delete the database in my history. I deleted the individual row I saw in history where I deleted the database, then rebuilt the package and now it worked. Cool
By Trent L. Taylor - 11/17/2006

Good deal!