3588311 - Scheduling Analysis for Office workbooks with SNC encryption

• The scheduling of Analysis Office Workbooks fails with Return Code 30 if SNC is configured for the respective OLAP connection.
• Information about SNC BI Platform and BW system when scheduling Analysis Office workbooks is required.
  
  

Analysis_Precalculation_[JobName]_[InstanceID].log
------------------------------------------------------------------------
|PrecalcMain    | Exception while connecting to BW with user : Com.Sap.Cof.Interfaces.Connection.LogonException: Logon attempt failed. Either the logon credentials are wrong or the user is locked, or the user account is not in valid date, or the password is expired or the desired language is not available. Please check user account in backend system.
Unencrypted communication is rejected by the system ---> SAP.Middleware.Connector.RfcLogonException: Logon attempt failed. Either the logon credentials are wrong or the user is locked, or the user account is not in valid date, or the password is expired or the desired language is not available. Please check user account in backend system.
Unencrypted communication is rejected by the system ---> SAP.Middleware.Connector.RfcAbapMessageException: Unencrypted communication is rejected by the system
   at SAP.Middleware.Connector.RfcConnection.ThrowRfcErrorMsg()
   at SAP.Middleware.Connector.RfcConnection.ReadBytes(Byte* buffer, Int32 count)
...
|PrecalcMain    | Finished. Return code: 30 #
------------------------------------------------------------------------

SAP Analysis for Microsoft Office

Having a working Single Sign-On (SSO) solution between the BI Server and BW system is a prerequisite to schedule Analysis Office workbooks in BI Platform.
This SSO solution is usually via a Logon Ticket that BI Platform retrieves from BW system and includes in the information used by AO to trigger the precalculation step of the scheduling process. When using a Logon Ticket, it is not necessary to encrypt the RFC connection established between BI server and the BW system. Until AO 2.8 SP25, only SSO (Single Sign On) without SNC is supported by Analysis Office BIP Addon.

From AO 2.8 SP26 onwards, however, a connection with SNC can be used to schedule AO workbooks.
More information to configure it can be found in SAP Note 3584361 - The Scheduling of Analysis Office Workbooks fails if SNC is used

SAP Note 3584361 - The Scheduling of Analysis Office Workbooks fails if SNC is used

Return code: 30 , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem