Skip to content

GET /ratings/metdata requires office, swagger spec does not #1522

@krowvin

Description

@krowvin

Describe the bug
Attempting to query for all offices in /ratings/metadata returns a trace about needing session set

Expected behavior
See all metadata for all offices (metadata description for office)

Logs/Incident Identifier

Incident: 84704e84-b161-4f16-9b92-2bd40fc6dcb8

{
  "message": "Failed to process request: org.jooq.exception.DataAccessException: SQL [{ call \"CWMS_20\".\"CWMS_ENV\".\"SET_SESSION_OFFICE_ID\" (?) }]; ORA-20998: ERROR: Unable to set a default SESSION_OFFICE_ID. The user: <CAC_USER_ID_REDACTED> either has no assigned CWMS database privileges or has privileges to more than one office. Please see your CWMS Application Admin.\nORA-06512: at \"CWMS_20.CWMS_ERR\", line 80\nORA-06512: at \"CWMS_20.CWMS_ENV\", line 85\nORA-20047: SESSION_OFFICE_ID_NOT_SET: Session office id is not set by the application\nORA-06512: at \"CWMS_20.CWMS_ERR\", line 80\nORA-06512: at \"CWMS_20.CWMS_UTIL\", line 605\nORA-01422: exact fetch returns more than requested number of rows\nORA-06512: at \"CWMS_20.CWMS_UTIL\", line 599\nORA-06512: at \"CWMS_20.CWMS_UTIL\", line 725\nORA-06512: at \"CWMS_20.CWMS_ENV\", line 79\nORA-06512: at line 1\n",
  "incidentIdentifier": "84704e84-b161-4f16-9b92-2bd40fc6dcb8",
  "source": "Unknown",
  "details": {}
}

CURL Commands

curl -X 'GET' \
  'https://water.dev.cwbi.us/cwms-data/ratings/metadata?_cb=1767030399722' \
  -H 'accept: application/json;version=2' \
  -H 'Cache-Control: no-cache, no-store, max-age=0' \
  -H 'Pragma: no-cache'

CDA Version (please complete the following information):
At the top of any instance of CDA you will see a version. Please provide that version.

  • Version 2025.12.29-develop

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions