1461247 - How to trace webi SSO to a universe based of SAP BW or SNC logon attempts with sofa logs

• Errors when setting up SNC to refresh webi reports with non SAP users
• Errors when performing SSO to a universe based off SAP BW
• Receive Unable to connect to SAP BW server connection closed without message (CM_NO_DATA_RECEIVED) when refreshing webi reports with SSO

Log snipet with successes and failures below

Wed Apr 21 11:46:42.357 ThreadID<5276> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:46:42.357 ThreadID<5276> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SNC. Calling CanAuthenticate...
Wed Apr 21 11:46:42.544 ThreadID<5276> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SNC
Wed Apr 21 11:46:42.544 ThreadID<5276> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST",SNC_MODE=1,SNC_QOP=1,SNC_LIB="C:\crypto\sapcrypto.dll",SNC_PARTNERNAME="p:CN=T25, OU=CA, O=BOBJ, C=CA",SNC_MYNAME="p:cn=sap,dc=winauthtz,dc=com",EXTIDDATA=TAZ,EXTIDTYPE=UN
Wed Apr 21 11:46:42.544 ThreadID<5276> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:46:43.544 ThreadID<5276> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 1
Wed Apr 21 11:46:43.544 ThreadID<5276> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 1.000 seconds
Wed Apr 21 11:46:43.544 ThreadID<5276> SAPMODULE : SAPAuthenticationService: SAPAuthenticationService::~SAPAuthenticationService
Wed Apr 21 11:48:18.498 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:48:18.498 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SNC. Calling CanAuthenticate...
Wed Apr 21 11:48:18.576 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SNC
Wed Apr 21 11:48:18.576 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST",SNC_MODE=1,SNC_QOP=1,SNC_LIB="C:\crypto\sapcrypto.dll",SNC_PARTNERNAME="p:CN=T251, OU=CA, O=BOBJ, C=CA",SNC_MYNAME="p:cn=sap,dc=winauthtz,dc=com",EXTIDDATA=TAZ,EXTIDTYPE=UN
Wed Apr 21 11:48:18.576 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:48:19.170 ThreadID<2740> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 0
Wed Apr 21 11:48:19.170 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 0.594 seconds
Wed Apr 21 11:48:19.170 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Unable to authenticate using SNC because the URI does not meet the minimum connection requirements.
Wed Apr 21 11:48:19.170 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Warning: SNC was enable and failed. The authentication process is falling back to secondary Credentials...
Wed Apr 21 11:48:19.170 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SSO. Calling CanAuthenticate...
Wed Apr 21 11:48:19.170 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:48:19.264 ThreadID<2740> SAPMODULE : SAPAuthenticationService: The SAP SSO authentication process will fail because the SAP secondary credential are not properly updated and the password is blank.
Wed Apr 21 11:48:19.264 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,R3NAME=T25,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST"
Wed Apr 21 11:48:19.264 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:48:20.045 ThreadID<2740> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 0
Wed Apr 21 11:48:20.045 ThreadID<2740> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 0.782 seconds
Wed Apr 21 11:48:20.045 ThreadID<2740> SAPMODULE : SAPAuthenticationService: SAPAuthenticationService::~SAPAuthenticationService
Wed Apr 21 11:53:05.187 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:53:05.187 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SNC. Calling CanAuthenticate...
Wed Apr 21 11:53:05.265 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SNC
Wed Apr 21 11:53:05.265 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST",SNC_MODE=1,SNC_QOP=1,SNC_LIB="C:\crypto\sapcrypto.dll",SNC_PARTNERNAME="p:CN=T251, OU=CA, O=BOBJ, C=CA",SNC_MYNAME="p:cn=sap,dc=winauthtz,dc=com",EXTIDDATA=TAZ,EXTIDTYPE=UN
Wed Apr 21 11:53:05.265 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:53:05.844 ThreadID<1188> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 0
Wed Apr 21 11:53:05.844 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 0.578 seconds
Wed Apr 21 11:53:05.844 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Unable to authenticate using SNC because the URI does not meet the minimum connection requirements.
Wed Apr 21 11:53:05.844 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Warning: SNC was enable and failed. The authentication process is falling back to secondary Credentials...
Wed Apr 21 11:53:05.844 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SSO. Calling CanAuthenticate...
Wed Apr 21 11:53:05.844 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:53:05.969 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,R3NAME=T25,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST",USER="TAZ",PASSWD=******
Wed Apr 21 11:53:05.969 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:53:06.672 ThreadID<1188> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 5
Wed Apr 21 11:53:06.672 ThreadID<1188> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 0.704 seconds
Wed Apr 21 11:53:06.672 ThreadID<1188> SAPMODULE : SAPAuthenticationService: SAPAuthenticationService::~SAPAuthenticationService
Wed Apr 21 11:54:15.781 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:54:15.781 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SNC. Calling CanAuthenticate...
Wed Apr 21 11:54:15.860 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SNC
Wed Apr 21 11:54:15.860 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST",SNC_MODE=1,SNC_QOP=1,SNC_LIB="C:\crypto\sapcrypto.dll",SNC_PARTNERNAME="p:CN=T251, OU=CA, O=BOBJ, C=CA",SNC_MYNAME="p:cn=sap,dc=winauthtz,dc=com",EXTIDDATA=TAZ,EXTIDTYPE=UN
Wed Apr 21 11:54:15.860 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:54:16.391 ThreadID<4128> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 0
Wed Apr 21 11:54:16.391 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 0.532 seconds
Wed Apr 21 11:54:16.391 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Unable to authenticate using SNC because the URI does not meet the minimum connection requirements.
Wed Apr 21 11:54:16.391 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Warning: SNC was enable and failed. The authentication process is falling back to secondary Credentials...
Wed Apr 21 11:54:16.391 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Determining if we can connect using SSO. Calling CanAuthenticate...
Wed Apr 21 11:54:16.391 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Authentication model for SAP connectivity is SSO
Wed Apr 21 11:54:16.516 ThreadID<4128> SAPMODULE : SAPAuthenticationService: The SAP SSO authentication process will fail because the SAP secondary credential are not properly updated and the password is blank.
Wed Apr 21 11:54:16.516 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Trying to connect to SAP using this URI : occa:sap://;PROVIDER=sapbw_bapi,ASHOST=vanca-erp05.dhcp.pgdev.sap.corp,SYSNR=01,R3NAME=T25,LANG=en,CLIENT=800,CATALOG="Z_BOBJ",CUBE="Z_BOBJ/MN_TIMZ_TEST"
Wed Apr 21 11:54:16.516 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Calling m_pRfcWrapper->RfcOpenEx() ...
Wed Apr 21 11:54:17.110 ThreadID<4128> SAPMODULE : SAPAuthenticationService: RfcOpenEx(...) returned 0
Wed Apr 21 11:54:17.110 ThreadID<4128> SAPMODULE : SAPAuthenticationService: Call to m_pRfcWrapper->RfcOpenEx() took 0.593 seconds
Wed Apr 21 11:54:17.110 ThreadID<4128> SAPMODULE : SAPAuthenticationService: SAPAuthenticationService::~SAPAuthenticationService

These logs were tested on XI 3.1 and should work in all XI 3.x

secure network communications signle sign on sign-on silent automatic zie mnhww , KBA , BI-BIP-IK , Integration; Integration kits for SAP, Baan, PeopleSoft, Sie , BI-BIP-IK-AUT , Authentication for integration kits , How To