3212449 - Type System Update failed during deployment with update mode

Type system update failed. As a result new tables were not created. 

Here a snippet of error logs:

{"instant":{"epochSecond":1654743722,"nanoOfSecond":361256000},"thread":"main","level":"ERROR",
"loggerName":"de.hybris.bootstrap.ddl.DefaultDbScriptsExecutor",
"message":
"problem executing sql [reason: StatementCallback; uncategorized SQLException for SQL 

[DROP INDEX pgrels.<idx_pgrels_index_000;  DROP INDEX products.<Name of Missing Index, sysname,>;  

...

SQL state [S0001]; error code [102]; Incorrect syntax near '<'.; nested exception is java.sql.BatchUpdateException: Incorrect syntax near '<'.]","endOfBatch":false,"loggerFqcn":"de.hybris.platform.util.logging.HybrisLogger","contextMap":{"Tenant":""},"threadId":1,"threadPriority":5,"origin":"PLATFORM"}

Commerce Cloud

syntax error, deployment, index , KBA , CEC-SCC-CLA-DEP , Deployments , Problem