Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Error running Minion Reindex

Chuck Goehler Nov 10, 2016 01:33PM CST

Getting the following error running Minion Reindex: MinionReindexDBs-All-REORG

String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed.

Up 1 rated Down
Sean McCown Dec 01, 2016 08:58AM CST MinionWare Agent

I don’t know why I didn’t get a message about this case. Are you still having trouble?

Up 0 rated Down
Dustin Dec 14, 2016 10:03AM CST
I too am having that exact same error.
Up 0 rated Down
Sean McCown Dec 14, 2016 10:09AM CST MinionWare Agent

Hey Dustin, we can fix that. What version of MR are you on? I think it has to do with the log table. Probably the Status col. I’ll load your specific version and see. If you could script out your tables and indexes and send them to me I could load them up and repro it on this side. If not we can do this without it, but it’ll just take longer.

Up 0 rated Down
Dustin Dec 16, 2016 08:08AM CST

I will get them over to you. I sent you an e-mail early this morning with some other information in it. Just give me till this afternoon and I should have everything scripted out and sent over to you. For you too look at, I feel like I read another article where you were talking about common issues and that you just changed a column for VARCHAR(400) to NVARCHAR(MAX), but I am not 100% on that and I cannot seem to find the aritcle again. I am using MR 1.2 and MB 1.2, and ME 2.2.
Up 0 rated Down
Sean McCown May 08, 2017 08:40AM CDT MinionWare Agent

Closed due to inactivity.

Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
Invalid characters found