Debezium Error : ConnectException: Data row is smaller than a column index
I believe your source table schema does not conform tou the change table schema in CDC. Have you updated table schema recently? Have you followed https://debezium.io/docs/connectors/sqlserver/#schema-evolution ?
If not you should probably recover from this situation by removing connector offsets from offsets topic and by cleaning up topic configured in database.history.kafka.topic. And don't forget that this topic must be unqiue per connector!
J.