Skip to main content

We upgraded to version 20.207.0012.  The upgrade path was:

from 19.205.0023 to 19.206.0036

then to 20.201.0051

then to 20.202.0043

finally to 20.207.0012

We did all of these update is one night and did not test inbetween updates.

Testing seems to show most things are fine, however we now cannot open the Project Quotes listing page.  We are able to open the Project Quotes form (PM304500) and we can open existing quotes using that form, but any attempt to visit the Project Quotes listing (PM3045PL) results in this error:

A table with the alias Owner cannot be found.

 

We have in the past applied a customization project pertaining to quotes, but we unpublished before the upgrade and have not yet republished.  Those customization projects did not affect PM3045PL, but they did make changes to PM304500 and they did add a couple of columns to the CROpportunitiesProducts database table.  Of course, those columns are still in the database.

Any help sorting this out would be much appreciated.

We sorted this out, thanks to our consultant, Bill at Premier Computing.  He helped us understand that there was a relation defined for the PM-Quotes generic inquiry referencing the Owner table.  I am not sure how or when that relation came about, but disabling the relation fixed the problem.  Apparently the Owner table is no longer a thing in 2020 R2.  All of this is very closely related to this post:  

 

Reply


Terms & ConditionsCookie settings