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.

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

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!

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

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

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.

OK...you have a massive database which made it difficult to even test what you were talking about.  So I created a sample profile that was initially decimal PKs and FKs, created some records, then changed the PKs and FKs to integer and deployed.  Everything worked as it should...so....before I even try to get into your structures, as this was going to take an inordinate amount of time to try and discern what is going on with your DB, try deploying these package files to see if you they work.  First deploy the DecToIn.pkg file, open up the database and add some records through SQL Server Management Studio, then deploy the DecToInt_IntegerPks.pkg file.  One thing that we have always done is drop the foreign keys before making changes...this is a requirement before we make any changes otherwise you could never update a PK or FK field.

Next, I would see if you package file deploys to a new instance without issue.  If it does, then next, get one or two tables that fail for your existing database and let's start there instead of trying to "eat the whole elephant at once."  To work through the issue a smaller test sample would be preferred as this is such a large sample that even getting to a point of failure and setting up a test scenario will take a lot of time and we may be chasing our tail versus really focusing on the issue at hand.

So let's start from here and see what we can determine.  Thanks for your patience.

Sounds good.

I have tried to attach both a .rar and .zip but the browser keeps timing out. I will try and send it to you via PM.

You did not attach your SQL Server backup.