SAP Knowledge Base Article - Public

1915927 - When Previewing Material Supply and Demand Data Sources, System Dumps

Symptom

You are trying to preview a data source like Material Supply and Demand List. The system takes lot of time to open this data sources in preview mode and later it may dump.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Analytics Work center
  2. Go to Design Data Sources view
  3. Select the Data Source that you want to preview.
  4. In this case, Select Material Supply and Demand Keyfigure data source and click on Preview button.
  5. System takes long time in opening the data source and after some time fails.
  6. Same scenario happens when Material Supply and Demand List data source is also attempted to open with Preview button.

Cause

The cause is the huge number of records in this data source. To retrieve information regarding these records, the system is taking more time than the set time limit. Due to this a time out event is triggered and the system crashes.

Resolution

Please follow the below mentioned steps to avoid such crash while trying to preview the data source:

  1. Go to the Business Analytics work center.
  2. Go to the Design Data Source view and select the Material Supply and Demand List data source that you wish to preview. 
  3. Click on the New button and select option Report from drop down. 
  4. A Guided Activity screen opens up. In this screen, please provide a Report name and proceed with default selections.
  5. In step 4:Characteristic Properties, select Planning Area ID, Specification ID and Material ID as Using Variable under Value Selection column.
  6. In step 7: Confirmation step, select the option Create View for this Report in a Web Browser.
  7. Now in the new screen, you will have the Planning Area ID, Specification ID and Material ID as selection parameters for the report.

Generating the report using value by providing any of the selection parameter doesn't result in a dump as the result set contains filtered data as per the selection parameter. Similar steps can be followed to preview Material Supply and Demand Keyfigure data source.

Keywords

data source, time out, material supply and demand, crash, dump, SCMMSDVV02, SCMMSDVV01, memory, internal server error , KBA , scmpdv01 , scmmsdvv02 , scmmsdvv01 , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Product Enhancement

Product

SAP BUSINESS BYDESIGN 1611 ; SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1302 ; SAP Business ByDesign 1305 ; SAP Business ByDesign 1308 ; SAP Business ByDesign 1311 ; SAP Business ByDesign 1602 ; SAP Business ByDesign 1608 ; SAP Business ByDesign 1702 ; SAP Business ByDesign 1711 ; SAP Business ByDesign feature pack 4.0