Symptom
Logging into Millennium Drive following an upgrade to 2017.1 the following error occurs
SQL databases will also experience a similar error.
SQL databases will also experience a similar error.
Cause
The mgo_attribute was changed to add the position column . The upgrade already updated the standard view with conv2017.exe so if custom views are used, the custom view must be updated.
Resolution
The standard attribute view for attribute is mgo_attribute but the custom view name is mgox_attribute.
The standard view, mgo_attribute, is below, highlighted/underlined is what was added in 2017.1. The custom view name is mgox_attribute, you will need to modify your custom view to add the attrpositn AS Position column.
CREATE OR REPLACE FORCE VIEW mgo_attribute AS
SELECT
attrkey,
attrid AS Id,
attrtype AS TypeCode,
attrtypenm AS TypeVal,
tg.table_val AS GroupDesc,
attrpositn AS Position,
attrstrt AS StartDate,
attrstop AS StopDate,
d1.table_val AS Descriptor1,
d2.table_val AS Descriptor2
FROM attribute
JOIN table_groups tg ON attrgroup=tg.table_code
JOIN attribute_descriptors d1 ON attrdescr1=d1.table_code
JOIN attribute_descriptors2 d2 ON attrdescr2=d2.table_code
Article Type
Product Info
Product Line
Millennium
Product Module/Feature
Table Maintenance
Product Version
2017.1
Ranking