Symptom
Runtime error while opening Manage Billing Documents app:
"Sorry, a technical error has occurred. Please try again later.{ "message": "HTTP request failed", "headers": [], "statusCode": 500, "statusText": "", "responseText": "RAISE_SHORTDUMP
Runtime Error: 'RAISE_SHORTDUMP'. The OData request processing has been abnormally terminated. If you use SAP S/4HANA Cloud Public Edition, please create an case. Otherwise, if \"Runtime Error\" is not initial, launch ADT feed \"Runtime Errors\" or transaction ST22 / SM21 (system log analysis) for details and analysis.20220413101934" }".
Environment
SAP S/4HANA Cloud Public Edition
Cause
"Database returned the SQL code 391. Error text: invalidated view".
This error indicates that the view <view> is invalid.
This can happen if, for example, the definition of an underlying object has changed or an object was dropped.
Publishing custom fields triggers an activation of dependent CDS views.
Resolution
Make sure that the view is consistent and valid or avoid accesses / drop the view.
Refer to 2985592 - Database returned the SQL code 391. Error text: invalidated view.
See Also
1732157 - Collecting diagnosis information for SAP HANA [VIDEO]
2985592 - Database returned the SQL code 391. Error text: invalidated view
2658020 - List of SAP HANA SQL Error Codes
2399990 - How-To: Analyzing ABAP Short Dumps in SAP HANA Environments
2224634 - HANA: error code = 391 (invalidated view) from function module TREX_EXT_LIST_INDEXES
2848455 - ALTER TABLE MOVE or PARTITION ONLINE Invalidates Views or Removes Privileges
3065633 - A View That is Dependent on a Calculation View Becomes Invalidated When a Dependency of Calculation View is Changed
1732157 - Collecting diagnosis information for SAP HANA [VIDEO]
Keywords
ST22, RAISE_SHORTDUMP, CX_SADL_DUMP_DATABASE_FAILURE, Manage Billing Documents, SADL_GW 040, SD_CUSTOMER_INVOICES_MANAGE, IWPR SD_CUSTOMER_INVOICES_MANAGE, IWPR SD_F1814_SO_FS, IWPR SD_CUSTOMER_INVOICES_CREATE, CRELTDBILDOCITM, C_RELATEDBILLINGDOCUMENTITEM, CBDLIF0798, C_BILLINGDUELISTITEM_F0798, CBDOCITEMF0797, C_BILLINGDOCUMENTITEM_F0797, IWPR SD_SO_LIST_F0804_PBS, C_SO_F0804PBSCDS, C_SO_F0804_PBS_CDS, IWPR SD_BILLINGDOC_PROCFLOW, CBILLGDOCPROC, C_BILLINGDOCPROCFLOW, scfd_fieldviewer, scfd_fieldviewer_ro, , KBA , HAN-DB , SAP HANA Database , SD-SLS , Sales , SD-FIO-BIL , Fiori UIs for Billing , Problem