SAP Knowledge Base Article - Public

2914189 - SQL Error 42111 or blank page happens when creating story based on BW import connection.

Symptom

When creating story based on BW import connection, the below error happens or blank page:

Caught exception : exception 42111: SQL Error : search table error: [9] Memory allocation failed

Environment

  • SAP Analytic Cloud 2020.2.19 

Reproducing the Issue

Create Model A and Model B based on BW imported connection.

Create Story S_A based on and create Story S_B based on Model B

Create Story S_C based on S_A and link to Model B.

In linked dimension,choose two dimensions to link.

Add columns to this story the the error will happens or blank page:

Caught exception : exception 42111: SQL Error : search table error: [9] Memory allocation failed

Cause

This issue is currently under investigation of development team.

Resolution

This issue can be caused by the blending subqueries which are generated when linking modles.  If the subqueries are too large to be handled then the error above can occur.

Some suggestions to resolve this issue:

  1. Currently the default link is on description.  Change that to ID so that only truly matching rows from the two models are returned.  Leaving the link as default can cause a significant amount of extra processing to be required.
  2. Select the minimum set from each model needed to be displayed in the story/ widget.  Only choose the minimum fields, records needed.

See Also

Keywords

by design, enhancement, improve, new functionality, SAP Cloud for Planning, cloudforplanning, Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, customer, influence, improvement, ideas, idea place, ideas place, improvement, Is there a product development area where we can make suggestions for improvements  and perhaps know what changes are currently worked on
, KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0