Kafka Connect Offset Commit Error on AWS MSK

I'm encountering an issue with Kafka Connect deployed on AWS Managed Streaming for Apache Kafka (MSK). Specifically, I'm observing an error related to offset committing when using Kafka Connect sink connectors.

Error Message:

2024-02-12 01:11:26,142 ERROR || WorkerSinkTask{id=XXXXX.public.XXXXX2-0} Commit of offsets threw an unexpected exception for sequence number 2506: {XXXXX.public.XXXXX-0=OffsetAndMetadata{offset=437542, leaderEpoch=null, metadata=''}}

Context:

I have Kafka Connect deployed on AWS MSK to stream data into various external systems. The error occurs intermittently during offset committing for sink tasks. Offset committing is critical for ensuring data consistency and fault tolerance in my data pipeline. What I've Tried:

Reviewed Kafka Connect logs, but the error message provides limited insight into the root cause. Verified the configuration settings for Kafka Connect and the sink connectors, ensuring alignment with best practices. Consulted Kafka documentation and online forums for troubleshooting guidance but haven't found a specific solution for this error. Attempted to restart Kafka Connect, but the error persists even after service restarts.

Expectations: I expected offset commits to be performed without errors, ensuring the reliability of my Kafka Connect setup. Given the importance of offset committing for data consistency, I'm seeking guidance on resolving this issue effectively.