Symptom
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"}
Read more...
Environment
SAP Commerce Cloud
Product
Keywords
syntax error, deployment, index , KBA , CEC-SCC-CLA-DEP , Deployments , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.