Chapter 5. 5000 ~ 5999

5001: Datetime/interval precision is out of range.

CauseThe values of DATETIME and INTERVAL do not match with the specified precision.
ActionCorrect the specified precision and try again.

5002: Invalid data type for this operation.

CauseAn invalid data type was entered for an operation or function.
ActionCheck the entered data type.

5003: Invalid TIME value.

CauseInvalid TIME value.
ActionCheck each field of TIME.

5004: Invalid TIMESTAMP value.

CauseInvalid TIMESTAMP value.
ActionCheck each field of TIMESTAMP.

5005: Invalid DATE value.

CauseInvalid DATE value.
ActionCheck each field of DATE.

5006: Invalid DATETIME unit type.

CauseInvalid unit type for the entered DATETIME type.
ActionCheck the entered unit type.

5007: Invalid string length.

CauseInvalid format string or input string length.
ActionCheck if format string or input string is null or less than than 0.

5008: Invalid precision specified for fractions of a second.

CauseThe precision specified for fraction of a second in TIMESTAMP and TIME is invalid.
ActionCheck whether the precision is between 0 and 9.

5009: Input string is too short for DATE format.

CauseThe input string to be converted into the specified format string is incomplete.
ActionLengthen the input string to match the given format string.

5010: Format ends before the entire input string is converted.

CauseAdditional unconverted data exists in the input string after conversion.
ActionCheck the definition of the DATETIME format code and correct the input string.

5011: Invalid DATE format.

CauseInvalid format code for DATE type is entered.
ActionVerify the DATE format code used is valid.

5012: Invalid TIME format.

CauseInvalid format code for TIME/TIMESTAMP type is entered.
ActionVerify the TIME/TIMESTAMP format code used is valid.

5013: Specified format code cannot be used as input format.

CauseThe given format code cannot be used as input format.
ActionDelete the invalid format code from format string.

5014: Specified format code is invalid.

CauseUnable to verify the specified format code.
ActionDelete the invalid format code from format string.

5015: Duplicated YEAR format exists.

CauseA YEAR format code has already been provided.
ActionDelete the duplicate YEAR format code.

5016: Duplicated MONTH format exists.

CauseA MONTH format code has already been provided.
ActionDelete the duplicate MONTH format code.

5017: Duplicated DAY format exists.

CauseA DAY format code has already been provided.
ActionDelete the duplicate DAY format code.

5018: Duplicated HOUR format exists.

CauseAn HOUR format code has already been provided.
ActionDelete the duplicate HOUR format code.

5019: Duplicated MINUTE format exists.

CauseA MINUTE format code has already been provided.
ActionDelete the duplicate MINUTE format code.

5020: Duplicated SECOND format exists.

CauseA SECOND format code has already been provided.
ActionDelete the duplicate SECOND format code.

5021: Duplicated fractions of a second format exists.

CauseFractions of a second format code has already been provided.
ActionDelete the duplicate fractions of a second format code.

5022: Duplicated AD/BC format exists.

CauseAn AD/BC format code has already been provided.
ActionDelete the duplicate AD/BC format code.

5023: Duplicated AM/PM format exists.

CauseAn AM/PM format code has already been provided.
ActionDelete the duplicate AM/PM format code.

5024: Month conflicts with Julian date.

CauseDDD format code and month-related format code cannot be used together.
ActionDelete the month-related format code to use the DDD format code.

5025: Day of the month conflicts with Julian date.

CauseDDD format code and date-related format code cannot be used together.
ActionDelete the date-related format code to use the DDD format code.

5026: Hour of the day conflicts with seconds in the day.

CauseSSSSS format code and hour-related format code cannot be used together.
ActionDelete the hour-related format code to use the SSSSS format code.

5027: Minutes of the hour conflicts with seconds in the day.

CauseSSSSS format code and minute-related format code cannot be used together.
ActionDelete the minute-related format code to use the SSSSS format code.

5028: Seconds of the minute conflicts with seconds in the day.

CauseSSSSS format code and second-related format code cannot be used together.
ActionDelete the second-related format code to use the SSSSS format code.

5029: Invalid year value: must be a non-zero integer between -4713 and +9999.

CauseInvalid value specified for the year.
ActionInput a non-zero integer value between -4713 and +9999.

5030: Invalid month value.

CauseInvalid value specified for the month.
ActionInput an integer value between 1 and 12.

5031: Invalid month name.

CauseInvalid value specified for the month name.
ActionInput a valid month name.

5032: Invalid day value.

CauseInvalid value specified for the day name.
ActionInput a valid day name.

5033: Invalid hour value.

CauseInvalid value specified for the hour.
ActionInput an integer value between 0 and 23.

5034: Invalid minute value.

CauseInvalid value specified for the minutes.
ActionInput an integer value between 0 and 59.

5035: Invalid second value.

CauseInvalid value specified for the seconds.
ActionInput an integer value between 0 and 60.

5036: Invalid fractions of a second value.

CauseInvalid value specified for the fractions of a second.
ActionInput an integer value between 0 and 999999999.

5037: Invalid AD/BC value.

CauseInvalid value specified for AD/BC.
ActionInput a valid value for AD/BC.

5038: Invalid AM/PM value.

CauseInvalid value specified for AM/PM.
ActionInput a valid value for AM/PM.

5039: Signed year cannot be used with AD/BC.

CauseThe signed year format cannot be used with the AD/BC format.
ActionDelete one of the two formats to make a valid format string.

5040: HH24 cannot be used with AM/PM.

CauseThe HH24 format cannot be used with the AM/PM format simultaneously.
ActionDelete one of the two formats to make a valid format string.

5041: Invalid precision specified for fractions of a second.

CauseThe precision for fractions of a second in TIMESTAMP and TIME is invalid in the format string.
ActionVerify the precision is between 0 and 9.

5042: Invalid decimal input.

CauseInvalid value specified for decimal.
ActionInput a valid decimal number ('.').

5043: Invalid seconds of the day input.

CauseInvalid value was entered in SSSSS format.
ActionInput an integer value between 0 and 86400.

5044: Insufficient space in string buffer for DATETIME type.

CauseThe buffer is not large enough to convert the DATETIME type to a string.
ActionIncrease the buffer size.

5045: Only TIME format can be omitted.

CauseAll format codes except hour/minute/second/fraction of a second are omitted from the input string.
ActionInput valid values for the format codes or delete the formats.

5046: Day of the year must be between 1 and 365 (366 for leap year).

CauseInvalid value specified for a day of the year
ActionInput an integer value between 1 and 366.

5047: Invalid day name.

CauseInvalid value specified for a day of the week
ActionInput a valid value for a day of the week.

5048: Too many truncation format specifiers.

CauseMore than one truncate format code is set.
ActionInput only one format code.

5049: Too many round-up format specifiers.

CauseMore than one round-up format code is set.
ActionInput only one format code.

5050: Invalid use of the escape character.

CauseInvalid use of the escape character.
ActionCheck the search pattern string of LIKE function.

5051: Invalid hexadecimal number.

CauseThe given character is not a valid hexadecimal number.
ActionCheck the character to be converted to hexadecimal number.

5052: Invalid string sequence.

CauseThe character is not included in the given character set.
ActionCheck the input string and character set.

5053: Invalid Unicode.

CauseInvalid Unicode.
ActionCheck the input string.

5054: Not implemented.

CauseUnsupported format string.
ActionCheck the input format string.

5055: Invalid type of UNIT used for INTERVAL.

CauseInvalid UNIT type for the INTERVAL type that was entered.
ActionCheck the UNIT type.

5056: Invalid input string for INTERVAL.

CauseAn error occurred while converting the input string to INTERVAL type.
ActionCheck the input string.

5057: Invalid input precision for interval.

CauseInvalid leading precision value.
ActionCheck the leading precision value.

5058: Invalid precision value for fractions of a second.

CauseInvalid precision value for fractions of a second.
ActionInput a valid precision value for fractions of a second.

5059: Invalid INTERVAL format.

CauseUnsupported interval format string.
ActionCheck the input format string.

5060: Month value is out of range.

CauseValue of months in YEAR-TO-MONTH INTERVAL type is out of range.
ActionInput a valid month value.

5061: Hour value is out of range.

CauseValue of hour in DAY-TO-SECOND INTERVAL type is out of range.
ActionInput a valid hour value.

5062: Minutes value is out of range.

CauseValue of minutes in DAY-TO-SECOND INTERVAL type is out of range.
ActionInput a valid minutes value.

5063: Seconds value is out of range.

CauseValue of seconds in DAY-TO-SECOND INTERVAL type is out of range.
ActionInput a valid seconds value.

5064: INTERVAL exceeds given precision value.

CauseThe INTERVAL value does not match the given precision value.
ActionCorrect the values and try again.

5065: Divide by zero error.

CauseThe INTERVAL type was divided by 0.
ActionModify the expression to remove the error.

5066: Insufficient space in buffer for conversion.

CauseThe buffer is not large enough to convert the INTERVAL type into string.
ActionIncrease the buffer size.

5067: Output was altered or truncated to fit into buffer, resulting in a possible loss of precision.

CauseThe buffer is not large enough to contain the results of the converted string.
ActionIncrease the buffer size.

5068: Overflow error.

CauseOverflow occurred as a result of an operation.
ActionDecrease the value of an operand.

5069: Underflow error.

CauseUnderflow occurred as a result of an operation.
ActionIncrease the value of an operand.

5070: Divide by zero error.

CauseThe NUMBER type was divided by 0.
ActionModify the expression to remove the error.

5071: NUMBER exceeds given precision.

CauseThe NUMBER value does not match the given precision value.
ActionCorrect the values and try again.

5072: Failure converting NUMBER to or from a native type.

CauseAn error occurred while converting the NUMBER value.
ActionCheck that the value is within the appropriate range.

5073: Invalid NUMBER provided for the operation.

CauseAn invalid NUMBER value was entered for the operation or function.
ActionChange the value and try again.

5074: Given string does not represent a number in proper format.

CauseThe given string does not represent a proper number.
ActionCheck the type of string.

5075: Invalid format string.

CauseInvalid format string.
ActionCorrect the format string.

5076: NUMBER is not printable in this format. Numbers were filled in output buffer.

CauseThe NUMBER value does not match the given format.
ActionModify the NUMBER value or format string.

5077: NUMBER precision is out of range.

CauseThe precision of the NUMBER type is out of range.
ActionSpecify a precision value for the NUMBER type between 1 and 38.

5078: NUMBER scale is out of range.

CauseThe scale of the NUMBER type is out of range.
ActionSpecify a scale value for the NUMBER type between -125 and +130.

5079: Data type length is out of range.

CauseThe length is out of range.
ActionModify the length to the one that is defined for each type.

5080: Invalid ROWID.

CauseInvalid ROWID
ActionChoose a valid ROWID.

5081: Invalid ROWID segment info.

CauseInvalid ROWID segment information.
ActionInput valid segment information for the ROWID.

5082: Invalid ROWID file.

CauseInvalid ROWID file information.
ActionInput valid file information for the ROWID.

5083: Invalid ROWID block.

CauseInvalid ROWID block information.
ActionInput valid block information for the ROWID.

5084: Invalid ROWID row.

CauseInvalid ROWID row information.
ActionInput valid row information for the ROWID.

5085: Invalid IP string.

CauseInvalid IP string.
ActionCheck the input IP string.

5086: String buffer is too small for string conversion or copy.

CauseThe string buffer is too small to handle the task.
ActionCheck the size of the input string.

5087: The date value is out of range.

CauseThe date value of the YEAR-TO-MONTH INTERVAL type is out of range.
ActionInput a valid date value.

5088: Numeric digits are not matched.

CauseThe number of digits of a given number and the length of the datetime format are not matched.
ActionUse the same number of digits as the length of the datetime format.

5089: Punctuation characters are not matched.

CauseThe character of a given punctuation mark does not match the character of the datetime format.
ActionUse the same character as that of the datetime format.

5090: Not a numeric value.

CauseCannot use a character for numeric data.
ActionUse numeric data.

5091: Invalid timezone format.

CauseInvalid timezone format is used for the TIMESTAMP type.
ActionVerify that you have entered a valid timezone format.

5092: Duplicate TZH format.

CauseThe TZH format code already exists.
ActionDelete the duplicated timezone (hour) format code.

5093: Duplicate TZM format.

CauseThe TZM format code already exists.
ActionDelete the duplicated timezone (minute) format code.

5094: Duplicate TZR format.

CauseThe TZR format code already exists.
ActionDelete the duplicated timezone (region) format code.

5095: Duplicate TZD format.

CauseThe TZD format code already exists.
ActionDelete the duplicated timezone (abbreviation) format code.

5096: TZR/TZD format conflicts with TZH/TZM format.

Causetimezone region format cannot be used with timezone time format.
ActionDelete the region format.

5097: TZH/TZM format conflicts with TZR/TZD format.

Causetimezone time format cannot be used with timezone region format.
ActionDelete the time format.

5098: Invalid hour value of UTC offset.

CauseThe hour value of UTC offset must be between -12 and 14.
ActionVerify that you have entered a valid hour value of UTC offset.

5099: Invalid minute value of UTC offset.

CauseThe minute value of UTC offset must be between 0 and 59.
ActionVerify that you have entered a valid minute value of UTC offset.

5100: Invalid second value of UTC offset.

CauseThe second value of UTC offset must be between 0 and 59.
ActionVerify that you have entered a valid second value of UTC offset.

5101: Invalid hour value of daylight saving time.

CauseThe hour value of daylight saving time must be between 0 and 24.
ActionVerify that you have entered a valid hour value of daylight saving time.

5102: Invalid minute value of daylight saving time.

CauseThe minute value of daylight saving time must be between 0 and 59.
ActionVerify that you have entered a valid minute value of daylight saving time.

5103: Invalid timezone offset.

CauseThe timezone offset value must be in the format of '[
Action-]hh:mm'.

5104: Invalid timezone region value.

CauseThe timezone region value is invalid or unsupported.
ActionVerify that you have entered a valid timezone region value.

5105: Invalid timezone index '%1$d'.

CauseThe timezone index value is not supported.
ActionContact the technical support team.

5106: Invalid timezone hour value.

CauseThe timezone hour value is invalid.
ActionVerify that you have entered a valid timezone hour value.

5107: Invalid timezone minute value.

CauseThe timezone minute value is invalid.
ActionVerify that you have entered a valid timezone minute value.

5108: Invalid timezone region value.

CauseThe timezone region value is invalid.
ActionVerify that you have entered a valid timezone region value.

5109: Invalid timezone abbreviation value.

CauseThe timezone abbreviation value is invalid.
ActionVerify that you have entered a valid timezone abbreviation value.

5110: Invalid date/time period according to the daylight saving time rule.

CauseThe date/time period is invalid according to the daylight saving time rule.
ActionCheck the daylight saving time rule.

5111: NUMBER exceeds given precision. (n:%1$s, p:%2$d, s:%3$d)

CauseThe NUMBER value does not match the given precision value.
ActionCorrect the values and try again.

5112: Duplicated '%1$s' format exists.

CauseA format code has already been provided.
ActionDelete the duplicated format code.

5113: Invalid %1$s value '%2$s'. (%3$s)

CauseInvalid value specified for the %1$s.
ActionInput a valid value for %1$s.

5114: Invalid %1$s value '%2$d': must be an integer between %3$d and %4$d.

CauseInvalid value specified for the %1$s.
ActionInput a valid value for %1$s.

5115: Cannot find the timezone file.

CauseThe timezone file does not exist, or you don't have permission to read the file.
ActionCheck the timezone file.

5116: NULL object instance access violation.

CauseAn attempt was made to access the attributes of an object instance whose value is null.
ActionCheck that the value of the object instance is not null.