Error: An error occurred before executing the process 'Export Process' : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as " or []

When running an export process through Administration > Export, you may receive the error: An error occurred before executing the process 'Export Process' : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
 
This error is caused by an invalid field name in your export definition. Check the following until the issue is resolved: 
  1. If the Lookup ID is renamed, highlight the field under Selected Fields and click the pencil icon to edit the field name. Erase the name you have and allow Altru to use the default field name
  2. Check the field names to ensure there is no duplication in field names (for example: Comment, and Comment)

Environment

 4.1

Was this article helpful?