RuntimeError: The data types numeric and int are incompatible in the '&' operator.

Author: Kellen Fields

Date: April 3, 2025

Audience: Self-hosted Administrators 

Environmental details: Replicated - KOTS, Self-Hosted, MSSQL

Summary

When deploying a new version of KOTS, upon navigating to the hosted URL, you receive an error message: 'Tenant does not exist'


And logging in the contour.log (core pod) states:

RuntimeError: An error occurred while upgrading tenant jama_prod: java.sql.SQLException: The data types numeric and int are incompatible in the '&' operator.

Solution

Run the following query to ensure the column is set to BIGINT. Run the following commands on the Database:

ALTER TABLE aclpermissionentry 
ALTER COLUMN mask BIGINT

Then run the following command on the application server to delete the core statefulset:
 
 kubectl delete sts core
 
After that, redeploy from the KOTS Admin Console as usual.

Cause

This is caused by a Column mask in the database that is of type 'numeric' when it is supposed to be of type 'BigInt'.

References

• Success Programs
• Success Catalog
• Datasheets
• Request a Solution Offering or Training from the Success Catalog

Please feel free to leave feedback in the comments below.