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

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'm using 2005 as my DB. I'll have a look and see what is happening and let you know

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.

Ben,

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

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,

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.

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.

I don't think I do but the way this day has been going anything is possible. I have spent the entire day chasing a Com+ problem that if it was a rattlesnake I'd be bit. I'll look on my other SQL installations to see if that is what happened.

How could some BO' be mapped to one strata install and some to another>? Is there a way to have them all look at the same strataframe install?

P

All of the business objects will look to the same StrataFrame database instance, but it is possible to have more than one instance.  You can change the database referenced by the StrataFrame design-time components by going to the StrataFrame menu and selecting Database Connection.