Database Deploymen Toolkit Failing to change PK data type
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


««12

Database Deploymen Toolkit Failing to change...Expand / Collapse
Author
Message
Posted 02/11/2008 7:06:57 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 04/07/2008 12:19:07 PM
Posts: 7, Visits: 35
Hello,

I tried to run the pkg you post and am still seeing errors that I am confused about. I have attached the log files. Please advise.

  Post Attachments 
DecToInt_IntegerPKs_results.txt (3 views, 13.56 KB)
DecToInt_results.txt (2 views, 12.63 KB)

Post #14312
Posted 02/12/2008 8:06:31 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
This issue has nothing to do with you decimal to integer stuff.  You have deletions in your Object Historh which is removing file groups and/or databases which is causing the issue.  In the DDT, we keep up with a history of the deletions and renames.  So if you deleted a file group, database, table, or renamed a field and then named it back, you can run into this type of error.  Check the Object Name History and remove anything that is not supposed to be there.

In the next update, the DDT is going to have a checking mechanism to warn you about this type of thing since so many people have a hard time with this.  It is a required component as it allows structures to be updated from version 1 to 3 in a single step withou having to load multiple updates sequentially.  But this is one of those side effects.

Also, be sure to get the most recent version of 1.6.5 as there were quite a few enhancements made to it the other day (there will be more in the next update as well). http://forum.strataframe.net/FindPost14258.aspx

Post #14316
Posted 02/12/2008 8:33:22 PM


Advanced StrataFrame User

Advanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame UserAdvanced StrataFrame User

Group: StrataFrame Users
Last Login: Today @ 10:42:08 PM
Posts: 595, Visits: 11,248
heh, I cant count the number of times I forgot to check that since is usually happens months apart when designing new databases.
Post #14336
Posted 02/12/2008 8:49:18 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
Yeah, it happened to me the other day too...so we are going to add a warning when you build giving you a heads up!
Post #14337
Posted 02/28/2008 12:23:49 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: StrataFrame Users
Last Login: 04/07/2008 12:19:07 PM
Posts: 7, Visits: 35
Hello,

How do I do this:

So if you deleted a file group, database, table, or renamed a field and then named it back, you can run into this type of error.  Check the Object Name History and remove anything that is not supposed to be there.

Cheers

Post #14615
Posted 02/28/2008 1:09:42 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176
First, download the latest 1.6.5 beta, it will tell you where all of your problems are if they exist (http://forum.strataframe.net/FindPost14525.aspx).  When you build your package, it now perform a check and show you if there are object name history items that could "hurt" you .  If so, simply go to the Object Name History node in the profile treeview and select the items in the list (on the right).  Then right-click the items and delete them...be sure not to clear the history altogether if this is not what you need.  Delete them one at a time in this case.
Post #14617
« Prev Topic | Next Topic »

««12

Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 10:57pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.063. 15 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.