SAP Business Planning and Consolidation 10.0, version for Microsoft site is no longer accessible

[Former Member]

Saint-Gobain security have made numerous changes to beef up security, and now SAP BPC no longer functions.

A few weeks back, we could use our SAP BPC installation without problems. Saint-Gobain security in France have been making major changes to all aspects of IT security, and making many and varied changes. I suspect that they have now blocked numerous ports and that in turn is blocking the app from working.

1. Our administrator gets a login window with the Business User Interface, and then after a while a connection timeout.

2. We also receive a "Please wait " from SAP Business Objects. "The system cannot connect to the (HTTP://CSESVNO0279AP28) server. Verify that you have specified a valid server name, or see if the server is unavailable at this time. We know that HTTP is to be phased out and replaced with HTTPS. However, this is not yet in place as far as I know.

3. I installed the EPM add-in for Excel SP 32 on my WIndows 10 computer and tried to connect to EPM. I get an "Object reference not set to an instance of an object" error.

4. Over and above McAfee anti-virus security have installed Carbon Black.

The BPC server connects to an SQL instance on our data-warehouse server (separate server).

I'm wondering if it's possible to get a list of ports that are used by BPC so that we can check if they are now being blocked. Our BPC consultants have not been able to find the problem. The nearest we come error messages is the following:

--------------------------------------------------------------------------------- Web page --------------------------------------------------------------------------------- [NullReferenceException: Object reference not set to an instance of an object.] OSoft.Services.Platform.UserDataBase.DataSwitch.GetDataScalar(CommandType commandType, String sQuery) +179 OSoft.Services.Application.AuthHelper.CMSAuthManager.GetAppSettingsFromDatabase() +1109 OSoft.Services.Application.AuthHelper.CMSAuthManager..ctor() +1984 OSoft.Services.Application.AuthHelper.CMSAuthManager.Instance() +119 BPC.Web.Logon.Page_Load(Object sender, EventArgs e) +1010 System.Web.UI.Control.OnLoad(EventArgs e) +106 System.Web.UI.Control.LoadRecursive() +68 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785 ------------------------------- event viewer ------------------------------- Event code: 3005 Event message: An unhandled exception has occurred. Event time: 08/14/2018 09:35:08 Event time (UTC): 08/14/2018 07:35:08 Event ID: aa2e3ad05dd3436596f7cb5cef0e82a6 Event sequence: 12 Event occurrence: 3 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT/SAP/BPC/WEB-2-131786387165039169 Trust level: Full Application Virtual Path: /SAP/BPC/WEB Application Path: C:\PC_MS\Websrvr\Web\BPC\Web\ Machine name: CSESVNO0279AP28 Process information: Process ID: 22884 Process name: w3wp.exe Account name: IIS APPPOOL\SAP_BPC Exception information: Exception type: NullReferenceException Exception message: Object reference not set to an instance of an object. at OSoft.Services.Platform.UserDataBase.DataSwitch.GetDataScalar(CommandType commandType, String sQuery) at OSoft.Services.Application.AuthHelper.CMSAuthManager.GetAppSettingsFromDatabase() at OSoft.Services.Application.AuthHelper.CMSAuthManager..ctor() at OSoft.Services.Application.AuthHelper.CMSAuthManager.Instance() at BPC.Web.Logon.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Request information: Request URL: http://csesvno0279ap28/sap/bpc/web/logon.aspx Request path: /sap/bpc/web/logon.aspx User host address: 10.100.85.175 User: ZF\f29svc-bpc_sysadmin Is authenticated: True Authentication Type: Negotiate Thread account name: IIS APPPOOL\SAP_BPC Thread information: Thread ID: 34 Thread account name: IIS APPPOOL\SAP_BPC Is impersonating: False Stack trace: at OSoft.Services.Platform.UserDataBase.DataSwitch.GetDataScalar(CommandType commandType, String sQuery) at OSoft.Services.Application.AuthHelper.CMSAuthManager.GetAppSettingsFromDatabase() at OSoft.Services.Application.AuthHelper.CMSAuthManager..ctor() at OSoft.Services.Application.AuthHelper.CMSAuthManager.Instance() at BPC.Web.Logon.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) Custom event details: --------------------------------------------------------------------------------- Last lines of IIS log --------------------------------------------------------------------------------- 2018-08-14 07:35:08 10.100.85.175 GET /sap/bpc/web/logon.aspx - 80 - 10.100.85.175 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.3;+WOW64;+Trident/7.0;+.NET4.0E;+.NET4.0C;+.NET+CLR+3.5.30729;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.30729) - 401 2 5 3 2018-08-14 07:35:08 10.100.85.175 GET /sap/bpc/web/logon.aspx - 80 ZF\f29svc-bpc_sysadmin 10.100.85.175 Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.3;+WOW64;+Trident/7.0;+.NET4.0E;+.NET4.0C;+.NET+CLR+3.5.30729;+.NET+CLR+2.0.50727;+.NET+CLR+3.0.30729) - 500 0 0 95