🐛 "Something went wrong" response from API when fetching the voting power of a newly registered dRep

[sentry-io[bot]]

Environment: production Url:https://dev-sanchonet.govtool.byron.network/ Sentry Issue: GOVTOOL-BACKEND-AK

Context

• When attempting to fetch the voting power of a newly registered dRep via the /drep/get-voting-power endpoint, the API responds with "Something went wrong" instead of returning a value (e.g., 0).

Error Details:

Exception UnexpectedNull {errSQLType = "numeric", errSQLTableOid = Nothing, errSQLField = "amount", errHaskellType = "Scientific", errMessage = ""} while handling request Request {requestMethod = "GET", httpVersion = HTTP/1.1, rawPathInfo = "/drep/get-voting-power/5f3bc5767c5ed2010831d71a6dececfbf084c4e3749d5b2ed3f24f5a", rawQueryString = "", requestHeaders = [("Host","dev-sanchonet.govtool.byron.network"),("User-Agent","Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36"),("Accept","application/json, text/plain, */*"),("Accept-Encoding","gzip, deflate, br, zstd"),("Accept-Language","en-US"),("Origin","http://localhost:5173"),("Priority","u=1, i"),("Referer","http://localhost:5173/"),("Sec-Ch-Ua","\"Chromium\";v=\"129\", \"Not=A?Brand\";v=\"8\""),("Sec-Ch-Ua-Mobile","?0"),("Sec-Ch-Ua-Platform","\"Linux\""),("Sec-Fetch-Dest","empty"),("Sec-Fetch-Mode","cors"),("Sec-Fetch-Site","cross-site"),("X-Forwarded-For","113.199.225.84"),("X-Forwarded-Host","dev-sanchonet.govtool.byron.network"),("X-Forwarded-Port","443"),("X-Forwarded-Prefix","/api"),("X-Forwarded-Proto","https"),("X-Forwarded-Server","1bc69d9655d0"),("X-Real-Ip","113.199.225.84")], isSecure = False, remoteHost = 172.20.0.3:32840, pathInfo = ["drep","get-voting-power","5f3bc5767c5ed2010831d71a6dececfbf084c4e3749d5b2ed3f24f5a"], queryString = [], requestBody = <IO ByteString>, vault = <Vault>, requestBodyLength = KnownLength 0, requestHeaderHost = Just "dev-sanchonet.govtool.byron.network", requestHeaderRange = Nothing}

Steps to Reproduce

1. Register a new dRep.
2. Use the /drep/get-voting-power endpoint with the dRep's identifier.
3. Observe the response.

Expected Behavior

• The endpoint should return 0 for the voting power of a newly registered dRep if no voting activity exists.

  Actual Behavior

• The API responds with "Something went wrong," indicating an unexpected null value encountered in the SQL query (errSQLField = "amount").