Length of LOB data (325023) to be replicated exce
description
Looks like I was going past the default threshold for storing the XML result on some of my servers.
I found running this command on the server that I ran the powershell scriit form fixed the issue.
EXEC sp_configure 'max text repl size', -1 reconfigure with override
Took me 30 min to find and resolve this hopefully my post saves you some of that time...!
This is the full dump of the error ( 3 times in one run )
Invoke-Sqlcmd : Command execution stopped because the shell variable "ErrorActionPreference" is set to Stop: Length of LOB data (221282)
to be replicated exceeds configured maximum 65536.
The statement has been terminated.
At C:\EPM_EnterpriseEvaluation_3.0.0.ps1:34 char:15+ Invoke-Sqlcmd <<<< -ServerInstance $sqlServerVariable -Database $sqlDatabaseVariable -Query $sqlQueryText -ErrorAction Stop
Invoke-Sqlcmd : Command execution stopped because the shell variable "ErrorActionPreference" is set to Stop: Length of LOB data (362720)
to be replicated exceeds configured maximum 65536.
The statement has been terminated.
At C:\EPM_EnterpriseEvaluation_3.0.0.ps1:34 char:15+ Invoke-Sqlcmd <<<< -ServerInstance $sqlServerVariable -Database $sqlDatabaseVariable -Query $sqlQueryText -ErrorAction Stop
Invoke-Sqlcmd : Command execution stopped because the shell variable "ErrorActionPreference" is set to Stop: Length of LOB data (325023)
to be replicated exceeds configured maximum 65536.
The statement has been terminated.
At C:\EPM_EnterpriseEvaluation_3.0.0.ps1:34 char:15+ Invoke-Sqlcmd <<<< -ServerInstance $sqlServerVariable -Database $sqlDatabaseVariable -Query $sqlQueryText -ErrorAction Stop