Informix Error -2901: Field name contains two conflicting attributes, first and second.

Cause and resolution

Field name contains two conflicting attributes, first and second.

This statement contradicts itself. The UPSHIFT and DOWNSHIFT attributes cannot be applied to the same field; nor can NOENTRY and REQUIRED or NOETNRY and VERIFY. Review the statement, and correct the selection of attributes.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-2901 fires when a field's ATTRIBUTES statement combines two mutually exclusive attributes — per the official guidance, UPSHIFT and DOWNSHIFT cannot apply to the same field, nor can NOENTRY and REQUIRED, nor NOENTRY and VERIFY.

UPSHIFT and DOWNSHIFT applied to the same field, per the official guidance — one named conflicting pair.
NOENTRY and REQUIRED applied to the same field, per the official guidance — a second named conflicting pair.
NOENTRY and VERIFY applied to the same field, per the official guidance — a third named conflicting pair.

Solutions / Resolution

Review the statement and correct the selection of attributes, per the official guidance, removing whichever of the two contradictory attributes wasn't intended.

Examples

Conflicting UPSHIFT/DOWNSHIFT

ATTRIBUTES
  code = item_code, UPSHIFT, DOWNSHIFT;
-- -2901: UPSHIFT and DOWNSHIFT contradict each other

Corrected

ATTRIBUTES
  code = item_code, UPSHIFT;

Diagnostic Checks

Check each field's ATTRIBUTES statement for the known conflicting pairs (UPSHIFT/DOWNSHIFT, NOENTRY/REQUIRED, NOENTRY/VERIFY), and remove the unintended one.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -2901 in this set yet.

Two contradictory attributes are applied to the same field — remove one of the conflicting pair.