2026-02-23

Clobs + Pools + Projects

• Clobs - recommended just use Blob for anything new
• Pools - read only, based on location levels, most likely used in A2W at present time.
• Projects - Started

Forecast

• spec not returning list unless office is set
• instance just not returning anything but empty list.

Projects
curl -X 'GET' \ 'https://cwms-data-test.cwbi.us/cwms-data/projects/locations?office=SWT&_cb=1771868168619' \ -H 'accept: application/json' \ -H 'Cache-Control: no-cache, no-store, max-age=0' \ -H 'Pragma: no-cache'
returned
{ "message": "One or more provided values exceeds the maximum length for the parameter.", "incidentIdentifier": "4b64c3e9-ea03-4a5d-8d6b-41f57374d9c3", "source": "User Input", "details": {}}
Embankments
curl -X 'GET' \ 'https://cwms-data-test.cwbi.us/cwms-data/projects/embankments?project-id=.%2A&_cb=1771868808084' \ -H 'accept: application/json;version=1' \ -H 'Cache-Control: no-cache, no-store, max-age=0' \ -H 'Pragma: no-cache'
{ "message": "One or more provided values exceeds the maximum length for the parameter.", "incidentIdentifier": "50623915-f09a-4e04-8796-0264e0a35508", "source": "User Input", "details": {}}
Logs:
info 23-Feb-2026 17:46:48.460 INFO [http-nio-7000-exec-57] cwms.cda.ApiServlet.lambda$init$3 50623915-f09a-4e04-8796-0264e0a35508: One or more provided values exceeds the maximum length for the parameter.. Originates from User Input at java.base/java.lang.reflect.Method.invoke(Method.java:566) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at jdk.internal.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) at com.sun.proxy.$Proxy17.execute(Unknown Source) at org.apache.tomcat.jdbc.pool.interceptor.AbstractQueryReport$StatementProxy.invoke(AbstractQueryReport.java:214) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at jdk.internal.reflect.GeneratedMethodAccessor33.invoke(Unknown Source) at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1081) at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4251) at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3778) at oracle.jdbc.driver.T4CCallableStatement.executeInternal(T4CCallableStatement.java:1358) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:86) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) ORA-06512: at line 1 ORA-06512: at "CWMS_20.CWMS_EMBANK", line 280 ORA-06512: at "CWMS_20.CWMS_EMBANK", line 280 ORA-06512: at line 1 ORA-06512: at "CWMS_20.LOCATION_REF_T", line 72 ORA-06512: at "CWMS_20.CWMS_LOC", line 274 ORA-06512: at "CWMS_20.CWMS_LOC", line 182 ORA-06512: at "CWMS_20.CWMS_LOC", line 213 ORA-06512: at "CWMS_20.CWMS_UTIL", line 324 ORA-06512: at "CWMS_20.CWMS_ERR", line 80 ORA-06512: at "CWMS_20.CWMS_LOC", line 256 Caused by: java.sql.SQLException: ORA-20041: INVALID_FULL_ID: ".*" is an invalid id.
Turbine Changes
curl -X 'GET' \ 'https://cwms-data-test.cwbi.us/cwms-data/projects/SWT/{name}/turbine-changes?begin=1900-01-01T00%3A00%3A00.000Z&end=2026-02-23T22%3A00%3A00.000Z&start-time-inclusive=true&end-time-inclusive=true&unit-system=EN&_cb=1771869297090' \ -H 'accept: application/json;version=1' \ -H 'Cache-Control: no-cache, no-store, max-age=0' \ -H 'Pragma: no-cache'
responds with
{ "message": "ORA-20025: LOCATION_ID_NOT_FOUND: The Location: \"{name}\" does not exist.", "incidentIdentifier": "42b5b26f-74a6-415a-bfef-1988db4fb477", "source": "Database", "details": {}}