ErrorCode: TrimException
Message:Content Manager Workgroup Server on 'trimwg2' reported an error. Error executing SQL statement: [Microsoft][ODBC Driver 13 for SQL Server]Communication link failure Details: SQL state and native error code are consecutively 08S01 , 0 SQL command: SELECT uri FROM TSRECORD WITH (NOLOCK) WHERE ( rcContainerUri = 5171030 AND currDisp <> 6 AND rcRecTypeUri NOT IN ( 528,530,532,2034,2061 ) AND rcDateRecycled IS NULL AND uri > 0 ) AND EXISTS ( SELECT 1 FROM TSRECORD SECFLTR WITH (NOLOCK) WHERE SECFLTR.uri = TSRECORD.uri AND SECFLTR.rcSecLevel <= 10 AND ( SECFLTR.rc1Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc2Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc3Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc4Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc5Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc6Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc7Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rc8Caveat & ~CAST( 0 as bigint)) = 0 AND ( SECFLTR.rcAclGroupKey IS NULL OR EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = SECFLTR.rcAclGroupKey ) OR ( SECFLTR.rcOrContainerAclUri IS NOT NULL AND EXISTS (SELECT 1 FROM TSRECORD ORCONTACL WITH (NOLOCK) WHERE ORCONTACL.uri = SECFLTR.rcOrContainerAclUri AND ORCONTACL.rcAclGroupKey IS NOT NULL AND EXISTS (SELECT 1 FROM TSLOCACLGR ORCONTACLGR WITH (NOLOCK) WHERE ORCONTACLGR.lagLocUri = 697820 AND ORCONTACLGR.lagAclGroup = ORCONTACL.rcAclGroupKey ) ) ) ) AND ( SECFLTR.rcRecTypeSecFilter = 0 OR EXISTS ( SELECT 1 FROM TSRECTYPE WITH (NOLOCK) WHERE TSRECTYPE.uri = SECFLTR.rcRecTypeSecFilter AND ( TSRECTYPE.rtAclGroupKey IS NULL OR EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSRECTYPE.rtAclGroupKey )) AND ( TSRECTYPE.rtAclExclusion IS NULL OR NOT EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSRECTYPE.rtAclExclusion )) )) AND ( SECFLTR.rcFilePlanUri IS NULL OR EXISTS ( SELECT 1 FROM TSFILEPLAN WITH (NOLOCK) WHERE TSFILEPLAN.uri = SECFLTR.rcFilePlanUri AND ( TSFILEPLAN.fpAclGroupKey IS NULL OR EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSFILEPLAN.fpAclGroupKey )) AND ( TSFILEPLAN.fpAclExclusion IS NULL OR NOT EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSFILEPLAN.fpAclExclusion )) )) AND ( SECFLTR.rcAclExclusion IS NULL OR NOT EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = SECFLTR.rcAclExclusion )) AND ( SECFLTR.rcMatterRecord IS NULL OR NOT EXISTS (SELECT 1 FROM TSRECORD MATTEREXC WITH (NOLOCK) WHERE MATTEREXC.uri = SECFLTR.rcMatterRecord AND MATTEREXC.rcAclExclusion IS NOT NULL AND EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = MATTEREXC.rcAclExclusion ))) AND ( SECFLTR.rcAclContainer IS NULL OR ( SECFLTR.rcAclGroupKey IS NOT NULL AND SECFLTR.rcOrContainerAclUri IS NOT NULL AND EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = SECFLTR.rcAclGroupKey )) OR EXISTS (SELECT 1 FROM TSRECORD CONTTEST WITH (NOLOCK) WHERE CONTTEST.uri = SECFLTR.rcAclContainer AND CONTTEST.rcSecLevel <= 10 AND ( CONTTEST.rc1Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc2Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc3Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc4Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc5Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc6Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc7Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rc8Caveat & ~CAST( 0 as bigint)) = 0 AND ( CONTTEST.rcAclGroupKey IS NULL OR EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = CONTTEST.rcAclGroupKey ) OR ( CONTTEST.rcOrContainerAclUri IS NOT NULL AND EXISTS (SELECT 1 FROM TSRECORD ORCONTACL WITH (NOLOCK) WHERE ORCONTACL.uri = CONTTEST.rcOrContainerAclUri AND ORCONTACL.rcAclGroupKey IS NOT NULL AND EXISTS (SELECT 1 FROM TSLOCACLGR ORCONTACLGR WITH (NOLOCK) WHERE ORCONTACLGR.lagLocUri = 697820 AND ORCONTACLGR.lagAclGroup = ORCONTACL.rcAclGroupKey ) ) ) ) AND ( CONTTEST.rcRecTypeSecFilter = 0 OR EXISTS ( SELECT 1 FROM TSRECTYPE WITH (NOLOCK) WHERE TSRECTYPE.uri = CONTTEST.rcRecTypeSecFilter AND ( TSRECTYPE.rtAclGroupKey IS NULL OR EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSRECTYPE.rtAclGroupKey )) AND ( TSRECTYPE.rtAclExclusion IS NULL OR NOT EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSRECTYPE.rtAclExclusion )) )) AND ( CONTTEST.rcFilePlanUri IS NULL OR EXISTS ( SELECT 1 FROM TSFILEPLAN WITH (NOLOCK) WHERE TSFILEPLAN.uri = CONTTEST.rcFilePlanUri AND ( TSFILEPLAN.fpAclGroupKey IS NULL OR EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSFILEPLAN.fpAclGroupKey )) AND ( TSFILEPLAN.fpAclExclusion IS NULL OR NOT EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = TSFILEPLAN.fpAclExclusion )) )) AND ( CONTTEST.rcAclExclusion IS NULL OR NOT EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = CONTTEST.rcAclExclusion )) AND ( CONTTEST.rcMatterRecord IS NULL OR NOT EXISTS (SELECT 1 FROM TSRECORD MATTEREXC WITH (NOLOCK) WHERE MATTEREXC.uri = CONTTEST.rcMatterRecord AND MATTEREXC.rcAclExclusion IS NOT NULL AND EXISTS ( SELECT 1 FROM TSLOCACLGR WITH (NOLOCK) WHERE TSLOCACLGR.lagLocUri = 697820 AND TSLOCACLGR.lagAclGroup = MATTEREXC.rcAclExclusion ))) )) ) ORDER BY uri ASC