When submitting a calc request for a large number of variables WIMS returns error:
"Hach WIMS failed to submit calculation request"
This is because the OPSROOT.CALCQUEUE.VLIST column in NVARCHAR(2000). The calc is a comma separated list of varids. Therefore, if the total list length is greater than 2000, this error will be displayed.
Workaround: (THIS ONLY WORKS IN SQL SERVER, ORACLE max length is 2000 characters).
1. Turn off the Calc Engine
2. Clear CalcQueue
3. Execute the following commands against OPSROOT.
ALTER TABLE CALCQUEUE DROP COLUMN VLIST
ALTER TABLE CALCQUEUE ADD VLIST NVARCHAR(4000) NULL DEFAULT (NULL)