3151681 - AO OLAP Connection Missing in Excel

• AO users Cannot see OLAP Connections to HANA in AO client after upgrading both BIP (to 4.2 sp08 or SP09)  and HANA systems.
• Same AO client shows olap connections on PROD but fails to show connections on QA
• on QA they get blank with HTTP 400 bad request error in logs (see snapshots in documents attached)
• ERRORS: from AO Logs

  General .NET Exception [a167-f1f5-87]:
  Get exception (Error: WBP 99999)
     at BusinessObjects.DSWS.BIPlatform.BIPlatform.Get(String pathURI, GetOptions options)
     at com.sap.ip.bi.pioneer.core.boe.CrBiPlatformWrap.Get(String iQuery, GetOptions iOptions)
     at com.sap.ip.bi.pioneer.core.boe.CrBoePlatformServiceBase.GetRootFolder()
  #

  22:34:36.471 |FATAL  |AoPlugin |CrSession.ProcessUnhandledException                                             |VSTA_Main      |
  General .NET Exception [a167-f1f5-87]:
  The remote server returned an unexpected response: (400) Bad Request.The remote server returned an error: (400) Bad Request.
     at com.sap.ip.bi.pioneer.core.boe.CrBoeUtil.RaiseException(Exception e, ILogCategory logCategory)
     at com.sap.ip.bi.pioneer.core.boe.CrBoePlatformServiceBase.GetRootFolder()
     at com.sap.ip.bi.pioneer.core.boe.CrBoePlatformServiceBase.get_RootFolder()
     at com.sap.ip.bi.pioneer.core.boe.CrBoePlatformService4_1.GetConnectionRootFolderContents()
  ....
     at com.sap.ip.bi.pioneer.controls.utils.UserActionProcessor.DoUserAction(UserActionDelegate iDelegate, CoUseWaitCursorEnum iWaitCursor, ISupportDialogResultSettable iSupportDialogResult)

  >>

  General .NET Exception [a167-f1f5-87]:
  Get exception (Error: WBP 99999)
     at BusinessObjects.DSWS.BIPlatform.BIPlatform.Get(String pathURI, GetOptions options)
     at com.sap.ip.bi.pioneer.core.boe.CrBiPlatformWrap.Get(String iQuery, GetOptions iOptions)
     at com.sap.ip.bi.pioneer.core.boe.CrBoePlatformServiceBase.GetRootFolder() 

• ERRORS: from fiddler logs
  [ on url https://<FQDN>/dswsbobje/services/BIPlatform ]
  

  The 400 bad request response looks like this:
  Something went wrong with your request.
  Your Support-ID is: 812345678968055
  If you feel this is an error, please provide the support ID above in your report.
  
  

• BI 4.2 SP09 P500 (upgrade from 4.2 SP08 p1)
• AO 2.8.4.1 Client [*Add-on is only on windows node - not linux]
• HANA (HND) upgraded to 2.0
• HEC / Linux 

KBA , BI-BIP-DEP , Webapp Deployment, Networking, Vulnerabilities, Webservices , Problem