Skip to Content

IBP Error: Error in refresh sheet

Hi,

I'm not able to use the simulations in any Planning View after changing any key figure. I tried different key figures like Sales Fcst Qty, Supply Capacity or Safety Stock. Already tried to clear the metadata cash but that is not the issue. Error Message is "Error in refresh sheet". Log looks as followed:

Thanks in advance

regards,

Log:

2016-10-24 11:48:07,297|ERROR|OfficeWrappers|?.?|Bastian Koll|||||1|Error while ensure active workbook is properly displayed.# 2016-10-24 11:48:11,807|ERROR|UILayer|?.?|Bastian Koll|||||1|From S&OP - CountWorkbooks: non-COM exception encountered for workbook with report ID 710f1a40f38e497fa6834b104e02812a# 2016-10-24 11:48:11,808|ERROR|UILayer|?.?|Bastian Koll|||||1|From S&OP - CountWorkbooks: non-COM exception was of type System.Runtime.InteropServices.InvalidComObjectException# 2016-10-24 11:48:11,808|ERROR|UILayer|SOPRibbonExtension.Object.ReportBuffer.CountWorkbooks|Bastian Koll|||||1|From S&OP: Removing workbook with report ID 710f1a40f38e497fa6834b104e02812a from buffer# 2016-10-24 11:48:27,062|ERROR|UILayer|?.?|Bastian Koll|||||1|From SOP - Backend / API Error: An error has occured on the server# 2016-10-24 11:48:27,063|ERROR|Dataservice|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.ExecuteReport|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:48:27,064|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.ExecuteReport|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:48:27,064|ERROR|OfficeWrappers|FPMXLClient.Office.EPMReportManager.ExecuteReport|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:48:27,067|ERROR|OfficeWrappers|FPMXLClient.Office.EPMExcelReportManager+<>c__DisplayClass3b.<ExecuteParallelizedReportsFramework4>b__38|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:48:27,078|ERROR|AnalyzerOne|FPMXLClient.AddIn.RefreshSheetWithScan|Bastian Koll|||||1|Error in refresh sheet# 2016-10-24 11:48:27,115|ERROR|Automation|FPMXLClient.EPMAddInAutomation.RefreshActiveSheet|Bastian Koll|||||1|Error in refresh sheet# 2016-10-24 11:56:50,884|ERROR|UILayer|?.?|Bastian Koll|||||1|From SOP - Backend / API Error: An error has occured on the server# 2016-10-24 11:56:50,885|ERROR|Dataservice|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.ExecuteReport|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:56:50,885|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.ExecuteReport|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:56:50,887|ERROR|OfficeWrappers|FPMXLClient.Office.EPMReportManager.ExecuteReport|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:56:50,889|ERROR|OfficeWrappers|FPMXLClient.Office.EPMExcelReportManager+<>c__DisplayClass3b.<ExecuteParallelizedReportsFramework4>b__38|Bastian Koll|||||1|An error has occured on the server# 2016-10-24 11:56:50,900|ERROR|AnalyzerOne|FPMXLClient.AddIn.RefreshSheetWithScan|Bastian Koll|||||1|Error in refresh sheet# 2016-10-24 11:56:50,945|ERROR|Automation|FPMXLClient.EPMAddInAutomation.RefreshActiveSheet|Bastian Koll|||||1|Error in refresh sheet#

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

11 Answers

  • Best Answer
    Oct 26, 2016 at 07:53 AM

    Thanks Ivan,

    ticked is already open.

    Regards

    Bastian

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Bastian,

      we are facing the same eeror message, but still cannot solve it.
      Could you you solve the issue already? Is there any OSS Note, which describes the solution.
      Thanks in Advance,

      Igor

  • Oct 24, 2016 at 01:24 PM

    Hi Bastian,

    I expect an issue with the configuration. After the KF changes you made, was the planning area activation successful?

    Best

    Alecsandra

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Alecsandra,

      I'm working on the delivered UNIPA04 which is already active. By changing my KF I meant that I changed the value (for example increased the supply capacity) and wanted to run see the simualtion to see the impact of the value change, maybe I explained it cloudy.

  • Oct 25, 2016 at 01:37 PM

    Hi Bastian,

    Did you have any upgrade recently?

    What about batch jobs? Did you try running heuristics or any other background job like stat fcst, copy operator etc. Are they running ok or ending with error?

    Before having this issue, did you make any configuration changes?

    Best

    Alecsandra

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 02:07 PM

    Hi Alecsandra,

    we only got the IBP Solution one week ago, so I suppose it should be the newest update. All I did so far was running copy operator as explained in the RDS simulation. They are running without problems. Same with data integration. I went through the test script and as soon as I have to run the simulation or try to save data, I'm running into that error. Found similar problems during my online research, but they all got the log "Invalid member" which I don't. so there must be some other problems. since my excel is a German installation, I tried to get the English version (had some problems before solved by using English Versions) but was not able to get one yet

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 04:02 PM

    Hi Bastian,

    Unfortunately the Excel log does not provide much information on the cause of the error for further analysis. Please can you raise an OSS message in the Launchpad informing SID and URL so our support team can replicate the issue and check the root cause in the index server logs?

    Thanks,

    Ivan

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 16, 2016 at 10:32 AM

    Dear All,

    the problem is solved in my case, it was apparently a server problem or anything like that.

    Regards

    Bastian

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2016 at 12:56 PM

    Having the same problem with a new planning area

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2016 at 02:13 PM

    Dear all,

    we are facing the same issue. Is there already a solution for it?

    Thanks a lot in advance,

    Igor

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 02, 2016 at 11:36 AM

    Hi Igor,

    I'm still waiting for a response on my ticket.

    I will let you all know as soon as I get a solution.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 08, 2016 at 03:35 PM

    Dear All,

    we have same issue too. Maybe someone can help...

    Regards,
    Benjamin

    Add comment
    10|10000 characters needed characters exceeded