Do you by chance have the StrataFrame database installed in multiple locations?  That's the exact error message you receive when the column does not exist on SQL Server.  If you have more than one, chances are you've only updated one of them since the install will only upgrade one database at a time.

Ben,

Here are some pictures that might help a bit. All the other Bus objects are fine. This is the project the will be using replication. I have not opened it in a few weeks as anothe project is the current priority.

When do you get that exception?  Does it show up in a red exception dialog, or does it show within build results when you try to build the partial classes.  Or does it only show up when you click on a business object from the treeview and the BOMapper ties to load the fields list?

Ben,

The fields already exist in the table. There are not any records in this table.

There should be a log file within the C:\Program Files\Common Files\MicroFour\StrataFrame folder that contains the install log listing the steps that were taken and the steps that failed during the database upgrade.  That should give a clue as to what might have happened.

I'm using 2005 as my DB. I'll have a look and see what is happening and let you know

Yes, 1.4.1 has some new database fields in the StrataFrame database that are used for field customization.  You're probably using SQL Server 2000 as your database backend, and the database deployment package did not add the fields properly. 

The easiest fix is to go into Enterprise Manager and alter the DTEproject_item_exceptions table within the StrataFrame database by adding these two fields:

piex_trimoption (int, not null) default value: 0
piex_readonly (bit, not null) default value: 0

Make sure you set the default value and set the columns to NOT NULL so that you won't run into any DbNull.Value problems within the BOMapper.

I tried the upgrade to 1.41 and have an issue when I try to rebuild by bus objects I get the following error. The Fields could not be displayed.

Column 'pix_trimoption' does not belong to table DTEproject_item_expressions.

This only happens on 2 Business Objects out of 15. I don't see anything out of the ordinary about these Tables. any ideas>?

Thanks alot

Paul