3229219 - It takes ...
 
Notifications
Clear all

3229219 - It takes a long time to display inventory posting list by items form

1 Posts
1 Users
0 Likes
46 Views
admin
Posts: 309
Admin
Topic starter
(@admin)
Prominent Member
Joined: 2 years ago

Symptom

It takes a long time to display the Inventory Posting List by Items form.

 

Reproducing the issue

Prerequisites:

You are working in a company database on MS SQL Server with more than 800,000 records in B1_OinmWithBinTransfer view. Distinguish this issue with the one described in SAP Note 3360703.

Scenario 1:

  1. Open a production order with more than one item.
  2. Choose Actual Item Component Cost under Summary tab.

Scenario 2:

  1. Go to Inventory  Inventory Reports  Inventory Posting List.
  2. In the selection criteria, select item with date range of a month.
  3. Try to run the report.

 

Expected behavior:

Inventory Posting List by Items form is displayed without application hang issue.

Actual behavior:

It takes several minutes to display the Inventory Posting List by Items form.

 

Solution

Set "Legacy cardinality estimator"

Execute the following SQL query: 

ALTER DATABASE SCOPED CONFIGURATION
SET LEGACY_CARDINALITY_ESTIMATION = ON;

or right click the database to show Properties window. Options → Database Scoped Configurations → Legacy Cardinality Estimation, set its value to ON.

Reply
Share:
x Logo: Shield Security
This Site Is Protected By
Shield Security