Description of Issue:
The following error is received while running a report:
Fixes:
Run this script on the Manitou db, need to run the reconfigure of the max text repl size in the primary and standby database(s).
This will give you the current size
sp_configure 'max text repl size'
This will set the new value
sp_configure 'max test repl size'.2147483647
This will set the current run value
reconfigure
go
Then check the value to ensure that it is set
sp_configure 'max text repl size'
Script to Use:
/* FIX MAX TEXT REPL SIZE SCRIPT */
-- This will give you the current size
sp_configure 'max text repl size'
-- This will set the new value
sp_configure 'max text repl size', 2147483647
-- This will set the current run value
reconfigure
go
-- Then check the value to ensure that it is set
sp_configure 'max text repl size'
