SUMMARY:
This document shows that TM1 data source with security mode 5 is not supported by Strategy MDX Cube provider 10.4. The workaround is to change security mode to 1, 2, or 3.
SYMPTOM:
The following error appears when attempting to connect to TM1 data source with security mode 5 and Strategy MDX Cube provider in Strategy Developer 10.4:
Fault occurred at Service.Discover(String RequestType, XmlElement Restrictions, XmlElement Properties)</faultstring><detail><MSTRXmlaErrorCode xmlns=urn:schemas-microsoft-com:xml-analysis Code="00000000" ></MSTRXmlaErrorCode><MSTRXmlaErrorString xmlns=urn:schemas-microsoft-com:xml-analysis String="SessionHandler: ConnectionError: UID=corp\mizhu;Location=ts-tm1x64-102;Catalog=Tutorial_Sample;OLAPProvider=TM1OLAP;AuthMode=0; (Server message -1)" ></MSTRXmlaErrorString><InternalErrorCode xmlns=urn:schemas-microsoft-com:xml-analysis Code="0" ></InternalErrorCode><InternalErrorString xmlns=urn:schemas-microsoft-com:xml-analysis String="" ></InternalErrorString><StackTrace xmlns=urn:schemas-microsoft-com:xml-analysis String=" at XMLA.OCI.DiscoverHandler.getSchemaInfo(String iSchemaType, StringBuilder sbRowXml, XmlElement RestrictionList, XmlElement PropertyList, XmlElement connectionInfo, String iUserID, String iPwd, String iUsePool)
at Service.Discover(String RequestType, XmlElement Restrictions, XmlElement Properties)" ></StackTrace></detail>. The embedded SOAP error is: onnectionError: UID=corp\mizhu;Location=ts-tm1x64-102;Catalog=Tutorial_Sample;OLAPProvider=TM1OLAP;AuthMode=0; (Server message -1)" xmlns:MSTRXmla="urn:schemas-microsoft-com:xml-analysis" xmlns="urn:schemas-microsoft-com:xml-analysis" /><InternalErrorCode MSTRXmla:Code="0" xmlns:MSTRXmla="urn:schemas-microsoft-com:xml-analysis" xmlns="urn:schemas-microsoft-com:xml-analysis" /><InternalErrorString MSTRXmla:String="" xmlns:MSTRXmla="urn:schemas-microsoft-com:xml-analysis" xmlns="urn:schemas-microsoft-com:xml-analysis" /><StackTrace MSTRXmla:String=" at XMLA.OCI.DiscoverHandler.getSchemaInfo(String iSchemaType, StringBuilder sbRowXml, XmlElement RestrictionList, XmlElement PropertyList, XmlElement connectionInfo, String iUserID, String iPwd, String iUsePool)
at Service.Discover(String RequestType, XmlElement Restrictions, XmlElement Properties)" xmlns:MSTRXmla="urn:schemas-microsoft-com:xml-analysis" xmlns="urn:schemas-microsoft-com:xml-analysis" /></detail></soap:Fault></soap:Body></soap:Envelope>. Connection String: TS-TM1X64-102;. Connection String: TS-TM1X64-102;. SQL Statement: MDSCHEMA_CUBES.
CAUSE:
This is working by design. TM1 data source has 5 possible security modes outlined in the following page:
https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_inst.10.2.2.doc/c_integratedsecuritymode_param_n0437.html%23IntegratedSecurityMode_param_N0437
Only security mode 1, 2 and 3 are supported but security mode 4 or 5 are not supported in Strategy MDX Cube provider 10.4.
ACTION:
There is one enhancement request logged in Strategy to support security mode 5 in Strategy MDX Cube provider. Contact Strategy Technical Support for the latest update on this request.
WORKAROUND:
Changing TM1 data source security mode to 1, 2 or 3 as workaround.
The Strategy Internal Reference Number for the issue discussed in this technical note is US46312.
KB319142
