Symptom
You are attempting to import a support package using transaction SPAM and encounter errors during import similar to the following:
Error 391-invalidated view: cannot create synonym for in when executing ADD-FIELD of
Error in DDL statement for when executing ADD-FIELD of
No DDL commands found for activation of <ABAP view>
From transaction SE14, you find that the <ABAP view> does not exist on the database. Attempting to run Create Database view with any of the processing types:
results in the following error logs:
Request: Create View <ABAP view> (<user>/<date>/<time>)
Process: <app server + work process used>
Delete dependent views
Dependent views deleted
Execute generated statements for View <ABAP view>
sql:
CREATE SYNONYM "<ABAP view>" FOR
_SYS_BIC."<HANA repo package>/<HANA calculation view>"
SQL error 391: invalidated view: cannot create synonym for invalidated view: lin
e 1 col 48 (at pos 47)
DDL time(___1): ........10 milliseconds
The SQL statement was not executed
Statements for View <ABAP view> could not be executed
Request for <ABAP view> could not be executed
Read more...
Environment
- SAP NetWeaver
- SAP HANA, platform edition
Product
SAP HANA, platform edition all versions ; SAP NetWeaver all versions
Keywords
KBA , HAN-AS-RPO , SAP HANA Repository , BC-UPG-OCS-SPA , Support package tools for ABAP , BC-CTS-HTA , SAP HANA object transport for ABAP , 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.
SAP Knowledge Base Article - Preview