Deletion of a field from a table which is participating in Table Rotation/Extension can cause excessive errors - Support and Troubleshooting

Deletion of a field from a table which is participating in Table Rotation/Extension can cause excessive errors Issue  Deletion of a field from a table which is participating in Table Rotation/Extension can cause excessive errors.

Error: Syntax Error or Access Rule Violation detected by database (Unknown column 'XYZ' in 'field list')

Release All

Cause When we delete a field from a table which is participating in Table Rotation/Extension, It might not get deleted from all the shards it has. It causes excessive errors in syslog table which in turn can cause rapid growth in syslog table since they have all the shards in the failing statement and each entry is massive.

Resolution Delete the field from all shards.