Help

Hourly Rain Oracle Error ORA-06532 Subscript outside of limit

The oracle error "Oracle Error Msg in WRAINHRLY: ORA-06532: Subscript outside of limit" can occur when extracting hourly rain.

Hourly rain is a synthesis of data from the "RAIN" (tipping bucket) and the "RAIN_RATE" (RIG) tables. Hourly rain will first look in the RAIN_RATE table. If there is no data in the "RAIN_RATE" table then the "RAIN" table will be used. Bad RAIN_RATE data can cause this error.

Solution

De-select the "Hourly" checkbox and check the "Hourly Rain_Table" checkbox and try again. This will get data from the RAIN table only.

See also:

• Rain: Fixed Periods
• Rain: Details
• Rain: Rate
• Rain: Sub Hourly