SAP Knowledge Base Article - Preview

3794610 - Design Stories are show 'failed to fetch data' and error 42014 & exception 42111: SQL Error : search table error: [34023] Instantiation of calculation model failed;exception 306002 in SAP Sales Cloud and SAP Service Cloud

Symptom

  • Users experience access issues and runtime errors when opening design stories.
  • "Failed to Fetch Data".
  • "Error Code: 42014 Internal error occurred while processing. For assistance, please contact your administrator or the product support team, if needed".
  • Detailed error in logs: "Instantiation of calculation model failed" with "Sql expression conversion failed: '\"acl_accountservice_account_delegateId\" IN()'; Condition 'csExpression.has_value()' failed."
  • Additional error observed: "exception 42201: Column not found".


Read more...

Environment

  • SAP Sales Cloud and SAP Service Cloud
  • Design Stories

Keywords

failed to fetch data, 42014, internal error occurred while processing, design stories, story preview, embedded sac, analytics, instantiation of calculation model failed, sql expression conversion failed, empty IN condition, column not found, runtime error, sso, data source preview , KBA , LOD-ANA-OEM , Embedded usage of SAP Analytics Cloud , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.