Oracle8 Time Series Cartridge User's Guide Release 8.0.4 A57501-01 |
Library | Product | Contents | Index

# A
Error Messages

This appendix lists the Time Series cartridge error messages, including the cause and recommended user action for each.

##### TS-00500, "internal error"

Cause: This is the generic internal error number for Time Series exceptions. This indicates that a process has encountered an exceptional condition.

Action: Report as a bug.

##### TS-00501, "the input patterns are not of the same length"

Cause: The input calendars have patterns of different lengths. For example, '0,1,1,1,1,1,0' and '0,1,1,1,1,0' were specified.

Action: Use calendars with patterns of the same length.

##### TS-00503, "patanchor can be null only if patbits.count=1 or all patbits are the same"

Cause: Pattern anchor was null, and pattern was not acceptable for a null patanchor. The anchor can be null only when using all-zero or all-one pattern bits.

Action: Supply a pattern anchor date, or adjust the pattern bits.

##### TS-00504, "illegal validflag parameter was passed to DisplayValCal/DisplayValTS"

Cause: DisplayValCal or DisplayValTS was called with invalid parameters.

Action: Only call DisplayValCal and DisplayValTS with the output of ValidateCal or ValidateTS, respectively.

##### TS-00505, "illegal outmessage parameter was passed to DisplayValCal/DisplayValTS"

Cause: DisplayValCal or DisplayValTS was called with invalid parameters.

Action: Only call DisplayValCal and DisplayValTS with the output of ValidateCal or ValidateTS, respectively.

##### TS-00506, "the calendar pattern is null"

Cause: The Time Series Cartridge encountered a calendar having a null pattern.

Action: Ensure that all calendars have a non-null pattern.

##### TS-00507, "the calendar has an imprecise mindate or maxdate"

Cause: The Time Series Cartridge encountered a calendar having an imprecise mindate or maxdate.

Action: Ensure that all calendar mindates and maxdates are precise.

##### TS-00510, "datetab has dates outside the bounds of the calendar"

Cause: DeriveExceptions encountered dates outside of the input calendar's mindate/maxdate.

Action: Adjust mindate/maxdate or remove extraneous dates from the input DateTab.

##### TS-00511, "calendar pattern bits array is either empty or null"

Cause: The Time Series Cartridge encountered a calendar with an empty or null array of pattern bits.

Action: Update the calendar to include a valid array of pattern bits.

##### TS-00512, "invalid frequency value - valid frequencies are: 1,2,3,4,6,8"

Cause: The Time Series Cartridge has encountered a calendar with an unsupported frequency.

Action: Restrict all calendars to frequencies: 1,2,3,4,6,8.

##### TS-00513, "the input dates are in the wrong order"

Cause: The date range provided was in reverse order.

Action: When specifying a date range, always list the earlier date first.

##### TS-00514, "calendar pattern has an imprecise anchor date"

Cause: The Time Series Cartridge has encountered a calendar with an anchor having the wrong precision.

Action: Adjust the precision of the anchor to match the calendars frequency.

##### TS-00515, "input date is less than calendar mindate"

Cause: The Time Series Cartridge has encountered a date less than mindate.

Action: Ensure that all input dates are within the mindate-maxdate range of the calendar.

##### TS-00516, "input date is greater than calendar maxdate"

Cause: The Time Series Cartridge has encountered a date greater than maxdate.

Action: Ensure that all input dates are within the mindate-maxdate range of the calendar.

##### TS-00519, "the series attribute of the time series type is null"

Cause: The Time Series Cartridge has encountered a null series within a time series.

Action: Ensure that all time series have a non-null series component.

##### TS-00520, "the input calendar is null"

Cause: The Time Series Cartridge has encountered a null calendar.

Action: Ensure that all calendars are non-null.

##### TS-00522, "error scaling date to calendar"

Cause: Input date cannot be scaled to given calendar.

Action: Ensure that the given calendar is valid and that the calendar's mindate and maxdate encompass all potential timestamp values.

##### TS-00523, "the input date is null"

Cause: Scaleup has encountered a null date. No scaling semantics are defined for a null date.

Action: Ensure that all input to Scaleup is non-null.

##### TS-00525, "the input time series is null"

Cause: The Time Series Cartridge has encountered a null time series.

Action: Ensure that all time series are not atomically null.

##### TS-00526, "the input time series has a null calendar"

Cause: The Time Series Cartridge has encountered a null calendar within a time series.

Action: Ensure that all time series include valid (non-null) calendars.

##### TS-00527, "error scaling up to the target calendar frequency"

Cause: Scaleup encountered a target calendar of finer frequency than that of the input time series' calendar.

Action: Scaleup requires a target calendar of equal or coarser frequency.

##### TS-00528, "calendar has a null mindate or a null maxdate"

Cause: The Time Series Cartridge has encountered a calendar with a null mindate or maxdate.

Action: Ensure that all calendars have a valid mindate and maxdate.

##### TS-00529, "calendar mindate is greater than its maxdate"

Cause: The Time Series Cartridge has encountered a calendar with mindate > maxdate.

Action: Ensure that all calendars have a valid mindate <= maxdate.

##### TS-00530, "series indexes must be greater than 0"

Cause: GetNthElement encountered an index less than 1.

Action: Use indexes greater than 0.

##### TS-00531, "the input time series has a null calendar reference"

Cause: The Time Series Cartridge has encountered a time series with a null calendar reference.

Action: Ensure that all calendar references are valid.

##### TS-00532, "unable to DEREF calendar referenced by time series"

Cause: The Time Series Cartridge was unable to dereference a calendar reference.

Action: Verify that the user executing the query has select privileges for the calendar table storing the object, and that the correct calendar has been referenced by the time series ref.

##### TS-00533, "the time series has data beyond its calendar mindate/maxdate"

Cause: The Time Series Cartridge has encountered a time series with data beyond mindate/maxdate.

Action: Ensure that all timestamps in a time series are within the calendar's mindate/maxdate.

##### TS-00534, "the number of rows requested must be a positive integer"

Cause: The requested number of rows was less than 0.

Action: Use a positive number to specify the number of rows requested.

##### TS-00535, "the time series ref has a null table_name parameter"

Cause: The Time Series Cartridge has encountered a time series ref having a null table_name.

Action: Ensure that all time series refs include a valid table name.

##### TS-00536, "the time series ref has a null tstamp_colname parameter"

Cause: The Time Series Cartridge has encountered a time series ref having a null tstamp_colname.

Action: Ensure that all time series refs include a valid timestamp column name.

##### TS-00537, "the time series ref has a null value_colname parameter"

Cause: The Time Series Cartridge has encountered a time series ref having a null value_colname.

Action: Ensure that all time series refs include a valid value column name.

##### TS-00538, "the time series ref has a null qualifier_colname parameter"

Cause: The Time Series Cartridge has encountered a time series ref having a null qualifier_colname.

Action: Ensure that all time series refs include a valid qualifier column name.

##### TS-00539, "the time series ref has a null qualifier_value parameter"

Cause: The Time Series Cartridge has encountered a time series ref having a null qualifier_value.

Action: Ensure that all time series refs include a valid qualifier value.

##### TS-00540, "the projected lead timestamp is beyond the calendar mindate/maxdate"

Cause: The given parameters result in timestamps outside of mindate/maxdate.

Action: Adjust the lead timestamp or lead units to remain within calendar mindate/maxdate, or extend the mindate/maxdate.

##### TS-00541, "the projected lag timestamp is beyond the calendar mindate/maxdate"

Cause: The given parameters result in timestamps outside of mindate/maxdate.

Action: Adjust the lag timestamp or lag units to remain within calendar mindate/maxdate, or extend the mindate/maxdate.

##### TS-00542, "the window size for mavg/msum must be >= 1"

Cause: Window size parameter passed to moving average/sum was not greater than 0.

Action: Use a window size parameter greater than or equal to 1.

##### TS-00547, "the input fill type is invalid"

Cause: Fill has been called with a filltype less than 0 or greater than 2.

Action: Use a valid filltype: 0, 1, or 2.

##### TS-00551, "error parsing the SQL statement with the time series ref"

Cause: The SQL statement constructed from the time series ref was invalid.

Action: Verify the validity of the time series ref:

- Verify the validity of all components of the time series ref.
- No spaces or invalid punctuation may appear in table or column names.
- The user must have select privileges on the table referenced.
- The table name must be qualified with its schema name.

##### TS-00552, "error executing the SQL statement with the time series ref"

Cause: The SQL statement constructed from the time series ref was invalid.

Action: Verify the validity of the time series ref:

- Verify the validity of all components of the time series ref.
- No spaces or invalid punctuation may appear in table or column names.
- The user must have select privileges on the table referenced.
- The table name must be qualified with its schema name.

##### TS-00553, "divide by zero error"

Cause: An attempt was made to divide by zero with TSDivide.

Action: When dividing by a constant, ensure that the constant is non-zero.

##### TS-00554, "the input calendar patterns are not equal"

Cause: DeriveExceptions requires the reference time series' calendar to have the same pattern as the time series being processed.

Action: Ensure that DeriveExceptions is called only with time series having the same pattern.

##### TS-00555, "the input calendar frequencies are not equal"

Cause: DeriveExceptions requires the reference time series' calendar to have the same frequency as the time series being processed.

Action: Ensure that DeriveExceptions is called only with time series having the same frequency.

##### TS-00556, "mindate of the ref calendar exceeds the mindate of the target calendar"

Cause: DeriveExceptions encountered a reference time series' calendar having a mindate greater than that of the target time series' calendar.

Action: Ensure that DeriveExceptions is called only with appropriate time series.

##### TS-00557, "maxdate of the target calendar exceeds the maxdate of the ref calendar"

Cause: DeriveExceptions encountered a reference time series' calendar having a maxdate less than that of the target time series' calendar.

Action: Ensure that DeriveExceptions is called only with appropriate time series.

##### TS-00558, "the target calendar should have empty on/off exception lists"

Cause: DeriveExceptions encountered a target time series' calendar having non-empty exception lists.

Action: Ensure that DeriveExceptions is called only with target time series having empty exception lists.

##### TS-00559, "the caltype field in the calendar has an illegal value"

Cause: The Time Series Cartridge encountered a calendar with an invalid calendar type.

Action: Ensure that all calendars have valid calendar type value. Valid calendar types are: (Exception-driven calendars = 0)

Prev | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index