Version 1.41 Upgrade problem


Author
Message
Paul Chase
Paul Chase
Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
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

Replies
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
OK, you only have one StrataFrame connection configured in the Database Connection, but I'm betting that it's pointed at the wrong database.  You probably have more that one StrataFrame database installed, and you're pointed at the one that did not get upgraded.  The reason that error is being thrown is that there are fields customizations on those two business objects, but you said that the DTEproject_item_exceptions table in the database has both fields but does not have any rows.  So, if there are no row, then that database does not think that there are any field customizations and the BOMapper does, so it's probably looking at a different database.
Paul Chase
Paul Chase
Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)Advanced StrataFrame User (806 reputation)
Group: Forum Members
Posts: 414, Visits: 2.8K
Maybe it is going through the VPN to home and looking there? I looked on the servers here and did not find any other installations. I was able to copy the code from the BO deleted it and re-add and seems to work ok not sure what the heck I customized but guess I will find out.

Like I said it has been one of those days,I am off to get a cold beer thanks for all the help you guys are the best.

Paul

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Well, get that beer.  There is certainly a possibility that it could be looking at home.  You can always check your connection through the Database Connection on the StrataFrame menu and selecting "Edit..." and viewing the properties.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Paul Chase - 19 Years Ago
StrataFrame Team - 19 Years Ago
Paul Chase - 19 Years Ago
StrataFrame Team - 19 Years Ago
Paul Chase - 19 Years Ago
StrataFrame Team - 19 Years Ago
                         Ben, Here are some pictures that might help a bit. All the other Bus...
Paul Chase - 19 Years Ago
                             Do you by chance have the StrataFrame database installed in multiple...
StrataFrame Team - 19 Years Ago
                                 I don't think I do but the way this day has been going anything is...
Paul Chase - 19 Years Ago
                                     All of the business objects will look to the same StrataFrame database...
StrataFrame Team - 19 Years Ago
                                         OkI havemultiple business objects and 2 of them are having this...
Paul Chase - 19 Years Ago
                                             I forgot thereis only one StataFrame data store defined under the...
Paul Chase - 19 Years Ago
                                                 ooops wrong attachment before. here is the correct one
Paul Chase - 19 Years Ago
                                                     Here is a picture of the stack trace
Paul Chase - 19 Years Ago
                                                         OK, you only have one StrataFrame connection configured in the...
StrataFrame Team - 19 Years Ago
                                                             Maybe it is going through the VPN to home and looking there? I looked...
Paul Chase - 19 Years Ago
                                                                 Well, get that beer. There is certainly a possibility that it could be...
StrataFrame Team - 19 Years Ago
                                             Oh, no, all of the business objects will look at the same instance. I...
StrataFrame Team - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search