Business Records error messages

A list of Business Records error messages. For messages that are not self-explanatory, additional information is provided.

Table 1. Business Records Error Messages
Number	Description
GS-24001	`Error loading file file.` An error occurred loading the file. Check the filename and permissions .
GS-24002	`Malformed XML.` XML file content is invalid. Select the correct file or correct the XML.
GS-24004	`Invalid value for %1 property.` Check the property syntax in the documentation and correct any errors.
GS-24201	`Missing master Record.` The document must contain at least one record that is master. Create a record.
GS-24202	`Unique query key must be set.` At least one field must be declared the unique key in a record. Set a unique key.
GS-24203	`Record used in relation must be active.` Change the record to active, or remove the relation.
GS-24204	`Empty relation.` This relation has no field definition. Add foreign/primary (or source/destination) fields.
GS-24205	`Database table column referenced more than once in the form.` In one form, a database table column can be referred only once. Table aliases should be used to attach more than one field to a database. Select one of the wrong Formfields and change the fieldType attribute from table_column to table_alias. Select one of the wrong Formfields and change fieldType attribute to non_database.
GS-24206	`Missing master table for record record.` Set the master table property.
GS-24207	`Table %1 unused in query.` A database table is used in the record, but there is no join for it in the query. Add a join for the table in the record query.
GS-24208	`No schema attached.` A database is required for the business records. Set the database name property to an existing database.
GS-24209	`Invalid relation, primaryField and foreignField must have same number of fields.` Modify the relation fields so that a primary field corresponds to each foreign field.
GS-24210	`Invalid query, left and right join must have same number of columns.` Check the query fields so that a left field corresponds to each right field.
GS-24212	`Relation field fieldname not found.` The relation refers a field that is missing in the record. Modify the relation or add the field to the record.
GS-24213	`Non existing schema schema attached to document.` Check the schema being referenced.
GS-24214	`Nonexistent table table referenced in document.` The document uses a database table that is not present in the schema. Update the schema, or change the field using the table.
GS-24215	`Nonexistent column table.column referenced in document.` The document uses a database column that is not present in the schema. Update the schema or change the field using the `table.column`.
GS-24216	`Database table defined in "no database" document.` Set the database property to an existing schema or remove the field.
GS-24217	`Table alias referenced more than once in the form.` The same table alias is associated with two columns in the form. Change one table alias name. Change either the table or column name.
GS-24218	`Alias alias referenced for different tables in document.` The same alias is used for different tables. Rename the alias so that it refers to the same database table.
GS-24219	`Alias Lookup field is ignored on %1 as it is the master table of the record.` A `lookup` field is dedicated to foreign field update in the master table; do not set it on a master table column. Remove the `lookup` property value or update the field database settings.
GS-24220	`Name value %1 is already used.` Duplicate name used in the document. Rename the element so that the name is unique.
GS-24221	`Invalid INTERVAL qualifier.` The `qual1` or `qual2` set for the INTERVAL `sqlType` is not valid. It should belong to the INTERVAL classes (i.e., YEAR-MONTH or DAY-TIME) Change either `qual1` or `qual2` to fit the respective class range or change the `sqlType` property from INTERVAL to another `sqlType`.
GS-24222	`Startfield of DATETIME or INTERVAL qualifiers must come earlier in the time-list than its endfield.` The `qual1` value should be greater than the `qual2` value, when the `sqlType` is either DATETIME or INTERVAL. Ensure `qual1` is greater than `qual2` or change the sqlType property from INTERVAL to another sqlType.
GS-24223	`Query properties set without attached database schema.` Some query properties (join, order, additional tables or where) are defined without a database schema attached. Clear the query properties or attach a database schema to document.
GS-24224	Table `table` referenced by `property` is not present in the record. A table is referenced in a query property (join or order), but is not referenced in any record's field or additional tables. Remove the join or order that references this table. Add a field referencing a column from this table to the record. Add the table to the 'additional properties' property. In the join or order, change the table to another one that is present in the record.
GS-24225	`Invalid relation, it must have at least one field.` Remove the relation. Add one or more source, destination field pair.
GS-24226	`Value not compatible with dataType.` The value is not compatible with dataType set. This error occurs when `defaultValue` and `include` property value is incompatible with dataType property. Change `defaultValue/include`, enter a value compatible to dataType format.
GS-24227	`Invalid join between %1 and %2.` A join between the two tables is not correct (another one exists with a different operator). Remove the join Change the operator Change the join table(s)
GS-24228	`There is no join between table %1 and master table.` The specified table is joined to another one, but not to the master table, creating a Cartesian product. Add the missing join for the %1 table Remove the table %1
GS-24229	`Invalid initializer.` The initializer format is incorrect. Change the value of the initializer field to use a valid identifier.
GS-24230	`Invalid source %1 for initializer %2.` The initializer source (left of “:”) is unknown. Change the initializer to respect the format.
GS-24231	`Initializer property %1 is missing.` The property used in the initializer does not exist. Change the property name in the initializer.
GS-24232	`Cannot resolve initializer value.` The initializer cannot be resolved, the database element is not found, or the property is missing. Change the initializer to point to a valid element.
GS-24235	`File type not defined in Application Generator settings.` A file used in Application Generator to generate code ($generate) is of an undefined file type in settings.agconf. Add the item type definition to the settings.agconf.
GS-24236	`Cannot resolve initializer without a valid database schema.` The property initializer uses the database schema but the file doesn’t have a schema. Set the database. Set the property value so that the initializer is not resolved. Remove the initializer.
GS-24237	`Unique key field %1 is not present in the Record.` The unique key field value contains one field which is not in the record. Remove the field from the unique key. Add the field to the record.
GS-24239	`Inactive table %1 in the database schema.` The database table active flag is set to false, the table is inactive and cannot be used for code generation. Make the table active or do not use it.
GS-24240	`Duplicate uid '%1'.` Invalid file format. A unique identifier has been used more than once. Contact your local support center.
GS-24242	`Table Alias '%1' is a database table name` The table alias used on the record field corresponds to a database schema table name. To use this database table: Change the table alias property, or Change the field type to table column.