Issue
The FactoryLogix 8.252.0 upgrade incorrectly changed the judgement setting of Spreadsheet Data Collection activities from Spreadsheet Judgement to Operator Judgement.
Resolution
A SQL script (reference DEV-7401) is available from Aegis Technical Support to revert the affected Spreadsheet Data Collection activities to their correct setting.
The script targets four primary columns that may not have copied correctly during the FactoryLogix upgrade. It pulls original data from the deprecated tables (where the original values are still stored) and copies the relevant data to the matching records in ProcessActivityDataCollectionBases_ProcessActivityCustomCollection. You can run the script in full to address all affected columns, or execute the script on individual sections for specific tables.
Warning
Run this script against a copy of the database first and validate the results before executing it against a production database.
Execute the script
-
Contact Aegis Technical Support to obtain the DEV-7401 script.
-
Log in to SQL Server Management Studio (SSMS) on the SQL Server hosting the FactoryLogix database.
-
Select the FactoryLogix database.
-
Open the DEV-7401 SQL script, paste it into a new query window, and select Execute to run the script. Affected activities are reverted toSpreadsheetJudgement.