MSC-ERR-0008 An error has occurred at the transport layer and OP-ERR-0181 At least one invalid member – Cognos and SSAS errors
A client has found a solution to two errors occurring in an environment with Cognos 10.1 and SQL Server 2008.
- MSC-ERR-008 An error as occurred at the transport layer.
- OP-ERR-0181 At least one invalid member reference was encountered in the query.
A hot-fix was applied to Windows as described in these two following articles and initial testing has been positive. The scenario is a single sign-on Cognos environment with Active Directory using Kerberos to authenticate to SQL Server Analysis Services 2008. The errors seemed intermittent.