Internal Server Error on Projects Query

[jtourkos]

Internal Server Error on Projects Query with MAINNET Chain

Description

The projects query fails with an internal server error when filtering by the MAINNET chain.

Query

query Projects($chains: [SupportedChain!]) {
  projects(chains: $chains) {
    account {
      accountId
      driver
    }
    isVisible
    repoMetadata {
      defaultBranch
      description
      forksCount
      stargazersCount
    }
    source {
      url
      repoName
      ownerName
      forge
    }
    chainData {
      ... on ClaimedProjectData {
        avatar {
          ... on EmojiAvatar {
            emoji
          }
          ... on ImageAvatar {
            cid
          }
        }
        chain
        claimedAt
        color
        description
        emoji
        lastProcessedIpfsHash
        latestMetadataIpfsHash
        owner {
          accountId
          address
          driver
        }
        totalEarned {
          amount
          tokenAddress
        }
        verificationStatus
        withdrawableBalances {
          splittableAmount
          receivableAmount
          collectableAmount
          tokenAddress
        }
        withdrawableSubAccountBalances {
          collectableAmount
          receivableAmount
          splittableAmount
          tokenAddress
        }
      }
    }
  }
}

Variables

{
  "chains": ["MAINNET"]
}

Response

{
  "errors": [
    {
      "message": "Internal server error",
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR"
      }
    }
  ],
  "data": null
}

Expected Behavior

Query should return project data for the MAINNET chain or an empty array if no projects exist.

Steps to Reproduce

1. Execute the query with chains: ["MAINNET"] variable
2. Observe internal server error

Additional Context

Removing

withdrawableSubAccountBalances {
          collectableAmount
          receivableAmount
          splittableAmount
          tokenAddress
        }

works.

Investigate the same for Drip Lists.