Skip to Content
avatar image
Former Member

Excel Addin: An unexpected error occurred. Try again later. If the problem persists, report the error ID ............ to your system administrator

Hi,  the following error occurs after changing a master data attribute through Excel master data maintenance:

An unexpected error occurred. Try again later. If the problem persists, report the error ID ...... to your system administrator

The following is the configuration and steps to replicate.  Installing latest version of Excel plugin,  reactivating the master data type and planning area does not resolve.   Suggestions anyone?

1)

Configuration:

Master Data Type:    MDT1

Attributes

                     ATTR1   Key

                     ATTR2   Key

                     ATTR3

                     ATTR4

Planning Level:      PL1

                     a.  Time

                             PeriodID   (Root)

                             Weekly

                             Monthly

                     b. MDT1

                             ATTR1       (Root)

                             ATTR2       (Root)

Planning Area:

                     Master Data:        MDT1 (All attributes Selected)

                     

                     Key Figures:

                           KF1 @ PL1

                           KF2 @ PL1

2)

Data Integration:

   1) Load Master Data type MDT1

   2) Load Key figure Data for KF1 and KF2

3)

Planning View Created :

     Planning Levels:   ATTR1,   ATTR2, ATTR4

     Key Figures:       KF1,  KF2

Planning view returns data with no issues.

4)

Master Data Maintenance.

  Thru Excel add-in,  ATTR4 on Master Data Type MDT1 is changed to a different value

5)

Planning View now shows the following error message when run:

An unexpected error occurred. Try again later. If the problem persists, report the error ID (aa8872a0.........)

to your system administrator

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 30, 2015 at 08:41 AM

    Hello

    Did you reopen the planning view again after the MDT is changed?

    Maybe from the Excel menu: Help -> Log and check if you find something useful/hint why the error is happening.

    Nothing works, reports to SAP for checking.

    Regards.

    YS

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2016 at 09:55 AM

    Hi

    I think the relevant message is "Object reference not set to an instance of an object", which can have a lot of root causes.

    Which backene release and which Excel AddOn do you use?

    I had some issues in IBP5 and that could be solved by installing the latest Excel AddIn from Feb 3rd

    https://websmp103.sap-ag.de/~form/handler?_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=Y&FUNCTIONBAR=N&EVENT=TREE&NE=NAVIGATE&ENR=73555000100200001126&V=MAINT

    Yours

    Irmi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 30, 2016 at 04:16 PM

    I have copied SAP6 and have loaded all the master data/time profiles/keyfigures from RDS

    Still getting the following errors while creating the planning view. Tried using standard planning templates basic*, creating from scratch.

    Can some one help

    QUERY_NO_DATA_FOUND

    FILE_TYPE:DAAA96DE-B0FB-4c6e-AF7B-A445F5BF9BE2

    RECORD_SEPARATOR:35

    COLUMN_SEPARATOR:124

    COLUMNS:Time|Severity|Category|Method|User|DSRRootContextID|DSRTransactionID|DSRConnectionID|DSRCounter|Thread|Text

    SEVERITY_MAP:DEBUG|Debug|INFO|Information|VERBOSE|Verbose|WARNING|Warning|ERROR|Error|FATAL|Fatal

    HEADER_END

    2016-07-30 11:06:07,074|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request||||||4|The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Basic realm="SAP NetWeaver Application Server [ZCM/100]"'.#

    2016-07-30 11:06:17,388|ERROR|UILayer|?.?|aagrawal|||||VSTA_Main|SOPRibbonExtension.DLL time stamp: 5/23/2016 2:07:24 PM#

    2016-07-30 11:07:20,906|ERROR|BPCProxy|FPMXLClient.BPCProxy.Common.Wcf.InterceptorChannelFactory`1+InterceptorRequestChannel.Request|aagrawal|||||14|The remote server returned an unexpected response: (400) Bad Request.#

    2016-07-30 11:07:20,951|ERROR|UILayer|?.?|aagrawal|||||14|From SOP - Backend / API Error: Server message:

    code: QUERY_NO_DATA_FOUND

    severity: INFO

    description: No information to display.

    log id:

    -----------------

    Framework message:

    The remote server returned an error: (400) Bad Request.

    #

    2016-07-30 11:07:20,953|ERROR|Dataservice|FPMXLClient.BPCProxy.MetaData_Data.DataServiceHelper.ExecuteReport|aagrawal|||||14|The remote server returned an unexpected response: (400) Bad Request.#

    2016-07-30 11:07:20,956|ERROR|BPC10Connection|FPMXLClient.Connection.RESTConnection.ExecuteReport|aagrawal|||||14|The remote server returned an unexpected response: (400) Bad Request.#

    2016-07-30 11:07:20,959|ERROR|OfficeWrappers|FPMXLClient.Office.EPMReportManager.ExecuteReport|aagrawal|||||14|The remote server returned an unexpected response: (400) Bad Request.#

    2016-07-30 11:07:20,963|ERROR|OfficeWrappers|FPMXLClient.Office.EPMExcelReportManager+<>c__DisplayClass3b.<ExecuteParallelizedReportsFramework4>b__38|aagrawal|||||14|The remote server returned an unexpected response: (400) Bad Request.#

    2016-07-30 11:07:20,982|ERROR|AnalyzerOne|FPMXLClient.AddIn.RefreshSheetWithScan|aagrawal|||||VSTA_Main|Error in refresh sheet#

    2016-07-30 11:07:21,011|ERROR|Automation|FPMXLClient.EPMAddInAutomation.RefreshActiveSheet|aagrawal|||||VSTA_Main|Error in refresh sheet#

    2016-07-30 11:07:21,045|ERROR|AnalyzerOne|FPMXLClient.ReportManagement.Report.IsOnReport|aagrawal|||||VSTA_Main|Object reference not set to an instance of an object.#

    2016-07-30 11:07:23,940|ERROR|AnalyzerOne|FPMXLClient.ReportManagement.Report.IsOnReport|aagrawal|||||VSTA_Main|Object reference not set to an instance of an object.#

    2016-07-30 11:07:24,210|ERROR|OfficeWrappers|FPMXLClient.Office.ExcelReportFormatter.IndentRowsHeader|aagrawal|||||VSTA_Main|Error in indentation process#

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Just to add:

      I tried different planning levels, keyfigures, time profiles etc. But the error is still persisting. I am able to see all the master data in the PA and edit it. However not able to load any keyfigures.