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.

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

heh, I cant count the number of times I forgot to check that since is usually happens months apart when designing new databases.

Keith Chisarik

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!

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

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.