Skip to main content

Error - 'Check Orchestrate database exists. An object or column name is missing or empty' following upgrade

During the upgrade error generates: An object or column name is missing or empty. For SELECT INFO statements, verify each column has a name. For other statements, look for empty alias names, Aliases defined as "" or [] are not allowed.

J
Written by Jes Foxall-Beckley
Updated over a month ago

If the error generates during the data import, FactoryMaster is linked to the wrong Orchestrate database. Please complete the following steps:-

  1. Click Options, System Maintenance, System Settings

  2. Click Production System Settings, Orchestrate Connection Settings

  3. Click Change Connection

  4. Select relevant server and database name

  5. Click Connect. Now, when you select Production, Schedule Works Orders, Import from Orchestrate, the data import will complete with the correct create date.

If the error generates during the upgrade, click Exit and the upgrade will continue to completion. The error message indicates the Orchestrate Connection setting within FactoryMaster will be reset to default. The above steps will have to be actioned after the upgrade to reinstate the connection to the Orchestrate database.

Did this answer your question?