|
| | | StrataFrame Beginner
 
Group: Forum Members
Last Login: 11/30/2006 10:58:13 AM
Posts: 33, Visits: 71 |
| I received an error during my initial deployment. I don't know if it's significant.
 Please advise. Derrick |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | 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. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 11/30/2006 10:58:13 AM
Posts: 33, Visits: 71 |
| | Hmm the database is empty. And now is dropped due to the deployment process. I'm in SQLServer 2005 Express. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | 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. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 11/30/2006 10:58:13 AM
Posts: 33, Visits: 71 |
| | Fix it.. the keys in one of my tables where wrong. Just the error really didnt seem to tell me. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 11/30/2006 10:58:13 AM
Posts: 33, Visits: 71 |
| | However the deployment then drops the database... Guess there is a setting. Looking now |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | 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. |
| |
| | | StrataFrame Beginner
Group: Forum Members
Last Login: 11/30/2006 10:58:13 AM
Posts: 33, Visits: 71 |
| 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.  |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 4:58:13 AM
Posts: 4,379, Visits: 4,421 |
| | |
|
|