2025-08-25
2025-08-25
Levels
- Currently broken in Test/Dev - Issue Reported here: https://github.com/USACE/cwms-data-api/issues/1242
- National CDA Missing Data/Down - Reported to CWBI by Mike N. Track here: https://github.com/USACE/cwms-data-api/issues/1247
Notes from Meeting:Cascade delete on level-id? Mitch thinks it could be for multiple dated versions, Charles agrees
- Versions vs Effective Date: A level effective date does NOT overlap but a version (timeseries) can! -NWP
Gold StarsWon't let me specify multiple unit types!
{"message": "Mutually exclusive fields used.", "incidentIdentifier": "user input error", "details": { "Use only one of": [ "Only one of the following can be defined for location levels: constant-value, seasonal-values, seasonable-time-series-id" ] }}
- Bugs
- Trying to patch the level endpoint using the same level ID returns a 404? Possible user error?Caused by: Error : 20048, Position : 0, Sql = BEGIN "CWMS_20"."CWMS_LEVEL"."RENAME_LOCATION_LEVEL" (:1 , :2 , :3 ) ; END;, OriginalSql = { call "CWMS_20"."CWMS_LEVEL"."RENAME_LOCATION_LEVEL" (?, ?, ?) }, Error Msg = ORA-20048: NO_WRITE_PRIVILEGE: User doesnt have write privilege
- Trying to delete a level in CDA Swagger returns error:
- Caused by: Error : 20048, Position : 0, Sql = BEGIN "CWMS_20"."CWMS_LEVEL"."DELETE_LOCATION_LEVEL" (:1 , :2 ) ; END;, OriginalSql = { call "CWMS_20"."CWMS_LEVEL"."DELETE_LOCATION_LEVEL" (?, ?) }, Error Msg = ORA-20048: NO_WRITE_PRIVILEGE: User doesnt have write privileges
- Specified levels patch/delete returns a 204, no content, but when you create that is a 201
- Probably normal response for a POST is 201?