Audit Vulnerability showing no data in latest version of Dependency Track

[tech-surajrk]

Current Behavior

When I run the Dependency Track on latest version that is 4.12.3 - The audit vulnerability section is showing no data but the vulnerability count is visible where as if I run it on 4.11.x then all the vulnerabilities data and count both are visible.

Kindly guide me to resolve this issue

Dependency-Track Version

4.12.3

Dependency-Track Distribution

Container Image

Database Server

MySQL

Database Server Version

No response

Browser

Google Chrome

Checklist

• I have read and understand the contributing guidelines
• I have checked the existing issues for whether this defect was already reported

[tech-surajrk]

Hello @stevespringett @nscuro can you help with the above query ?

[tech-surajrk]

While checking the API Server logs I am getting the below Error -

2025-02-11 12:09:38,862 INFO [UpgradeExecutor] Upgrade class org.dependencytrack.upgrade.v4110.v4110Updater about to run.
2025-02-11 12:09:38,863 INFO [v4110Updater] Dropping foreign key constraint from "VULNERABILITY"."CWE"
2025-02-11 12:09:38,888 ERROR [UpgradeExecutor] Error in executing upgrade class: org.dependencytrack.upgrade.v4110.v4110Updater
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONSTRAINT IF EXISTS "VULNERABILITY_FK1"' at line 1

Also I check the mysql database - There is no key named as "VULNERABILITY_FK1" in Vulnerability table

Please help to resolve this issue