SQL General Report Error Messages
These generalized errors may occur during the validation phase of this process.
??? is replaced by the column name that is in error; ?? is replaced by a numeric value that indicates the length or value limit.
Error Message | Additional Info/Remedy |
|---|---|
??? is required. | Modify the input file to provide a valid value for the indicated column. |
??? is not a valid number. | Modify the input file to provide a valid numeric value for the indicated column. |
Length > ??. | Column can contain only ?? characters. Modify the input file to provide a smaller value (less than or equal to the number of characters indicated) for the indicated column. |
??? is not a valid date. | Modify the input file to provide a valid date value for the indicated column. The date format is YYYY-MM-DD. |
??? (Number) cannot be > ??. | Modify the input file to provide a valid numeric value less than or equal to the amount indicated for the indicated column. |
|
??? (Number) cannot be < ??. | Modify the input file to provide a valid numeric value greater than or equal to the amount indicated for the indicated column. |
??? (Number) cannot contain decimals. | The number being uploaded contains a decimal point that is not allowed for this column. Modify the input file to provide a whole number for the indicated column. |
??? (Number) cannot be negative. | The number being uploaded contains a minus sign that is not allowed for this column. Modify the input file to provide a positive number for the indicated column. |
Invalid ???. | The value being uploaded contains a value that is not allowed for this column. Modify the input file to provide a valid value. This message is usually (if space allows) followed by a list of the acceptable values. |
Start Date cannot be > End Date. | The Start Date must fall before the End Date provided. Double check both dates to ensure they comply with this rule. |
Item used in PSP. U/M cannot be changed | Required only if MRP Settings > Plan Substitute Part = ‘Y’ and Part has an existing proj. substitute part(s) or used as proj. substitute part |
Item used in SPT. U/M cannot be changed | Required only if MRP Settings > Plan Substitute Part = ‘Y’ and Part has an existing substitute part(s) or used as substitute part |
PSP rejected, U/M does not match | Required only if MRP Settings > Plan Substitute Part = ‘Y’ Proj substitute part’s U/M is not equal to original part’s U/M |
Item used in SPT. U/M cannot be changed | Required only if MRP Settings > Plan Substitute Part = ‘Y’. Part has an existing proj. Substitute part(s) or used as. substitute part |
SPT rejected, U/M does not match. | Required only if MRP Settings > Plan Substitute Part = ‘Y’ and Substitute part’s U/M is not equal to original part’s U/M |
Line XX is invalid. | Conditions: Invalid line type, invalid delimiter, record do not have valid data and contains only the line type. |
Inventory exist for this part. Changing the serial/lot tracking is not allowed. | Conditions: From Serial/Lot Tracked OFF to ON WITHOUT project requirements From Serial/Lot Tracked ON to OFF WITH part project requirements From Serial/Lot Tracked ON to OFF WITH part project requirements |