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
- Go to Business Analytics Work center
- Go to Design Data Sources view
- Select the Data Source that you want to preview.
- In this case, Select Material Supply and Demand Keyfigure data source and click on Preview button.
- System takes long time in opening the data source and after some time fails.
- 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:
-
Go to the Business Analytics work center.
-
Go to the Design Data Source view and select the Material Supply and Demand List data source that you wish to preview.
-
Click on the New button and select option Report from drop down.
-
A Guided Activity screen opens up. In this screen, please provide a Report name and proceed with default selections.
-
In step 4:Characteristic Properties, select Planning Area ID, Specification ID and Material ID as Using Variable under Value Selection column.
-
In step 7: Confirmation step, select the option Create View for this Report in a Web Browser.
-
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