Symptom
When trying to access a BW system using SSO in Analysis for Office, the errors below occur:
"Single Sign On failed. (...)"
"LOCATION CPIC (TCP/IP) on local host XXX with Unicode (...)"
The traces contain entries similar to the following:
------------------
General .NET Exception:
LOCATION CPIC (TCP/IP) on local host (...) with Unicode
ERROR SncPDLInit()==SNCERR_INIT
Unable to load GSS-API DLL
named "(...)"
TIME Mon (...)
RELEASE (...)
COMPONENT SNC (Secure Network Communication)
VERSION 6
RC -1
MODULE sncxxdl.c
LINE 462
DETAIL LoadLibrary("...")
Error 193 = "... is not a valid Win32
application."
SYSTEM CALL LoadLibrary
COUNTER 4
------------------
Environment
SAP Analysis for Microsoft Office
Cause
The issue might be related to wrong DLL for the specific version of the application (i.e. Analysis for Office).
Resolution
Depending on the bit version of Analysis for Office, 32 bit or 64 bit, it is necessary to use a DLL for the SSO specific for the version.
Refer to SAP note 2025528 and specify an environment variable specific for the bit size of Analysis for Office.
Refer to SAP note 2115486 to download the DLL for the specific bit size of Analysis for Office.
For example:
If using AO 32 bit, define the environment variable SNC_LIB_32 with a valid 32 bit DLL.
If using AO 64 bit, define the environment variable SNC_LIB_64 with a valid 64 bit DLL.
Keywords
SSO, single sign on, logon, login, error, exception, client , KBA , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , BI-RA-AO-XLA , Excel Addin , Problem