|
| | | 
StrataFrame User
 
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | 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 |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890 |
| | 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.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | I'm using 2005 as my DB. I'll have a look and see what is happening and let you know |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890 |
| 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.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | Ben, The fields already exist in the table. There are not any records in this table. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890 |
| 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?
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | 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.
|
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 12/02/2008 4:42:46 PM
Posts: 2,686, Visits: 1,890 |
| 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.
www.bungie.net |
| |
| | |
StrataFrame User
Group: StrataFrame Users
Last Login: Yesterday @ 4:29:41 PM
Posts: 367, Visits: 2,446 |
| | 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 |
| |
| | |
|