Database Maintenance fails in SQL Server Agent with the error "Unknown token received from SQL Server [SQLSTATE HY000] String data, right truncation [SQLSTATE 01004]"

Question

We have verified in SQL Server error log to see if there is any connection drop during the failure. But there is no log as well. SQL Server version used is 2017. DBA after failure restarted the same job and it again fails after running for few hours with the same error. Any suggestions on this?

Answer 1

Hi @Shanoof Basheer ,

Please share us more related information about the maintenance plan. And which step of this agent job failed?
Please check your agent job history and share us more related error message for us.

Sharing a similar discussion thread to you, hope this could help you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Indeed, we need more informations about the job

String data, right truncation [SQLSTATE 01004]

That always means the job want to insert large string data then allowed by the table column definition, e.g. the table have a column defined as varchar(10) and the job tries to insert 50 characters; that fails with this error.