Symptom
During CI installation, in "Activate HANA Content (SNHI_DELIVERY_UNIT_MIGRATION), a message pop's up
***************************************************************************************************************************
"One or more delivery units could not be activated. Please check the SAP HANA Database content manually or run SNHI_DELIVERY_UNIT_MIGRATION again.
***************************************************************************************************************************
Upon clicking OK installation is proceeding…, but afterwards the ABAP System is running in errors like this:
In an Open SQL Statement, a table is specified that either does not exists on the database, or that is not known to the ABAP Data Dictonary.
This is table "POHVAL", or another table which the statement wants to access. The database has returned SQL code 2589 with the error text "invalid table name": Could not find table/view POHVAL in Schema...
***************************************************************************************************************************
"One or more delivery units could not be activated. Please check the SAP HANA Database content manually or run SNHI_DELIVERY_UNIT_MIGRATION again.
***************************************************************************************************************************
Upon clicking OK installation is proceeding…, but afterwards the ABAP System is running in errors like this:
In an Open SQL Statement, a table is specified that either does not exists on the database, or that is not known to the ABAP Data Dictonary.
This is table "POHVAL", or another table which the statement wants to access. The database has returned SQL code 2589 with the error text "invalid table name": Could not find table/view POHVAL in Schema...
Other Terms
HANA Content, activation, migration, ci installation, SQL code 2589,
invalid table name, POHVAL error, SNHI_DELIVERY_UNIT_MIGRATION,
Reason and Prerequisites
There is a mismatch, unsync between HDB an ABAP which cannot be corrected in HANA DB.
See SAP Note 1887726 with prerequisites to successful HANA Content activation.
See SAP Note 1887726 with prerequisites to successful HANA Content activation.
Solution
1. If external view POHVAL exists please check in HANA Studio all
content has to be active. Afterwards start ABAP in Eclispe (ABAP
Development Tools for SAP NetWeaver) and execute following steps
(details see attached PDF file)
2. If external view POHVAL is deleted, some manual steps are to be done per ABAP in Eclipse IDE (AiE) in order to re-create the external view POHVAL again.
The external view POHVAL can also be created and activated in the following way.
1.Start your ABAP in Eclipse IDE
2.Create an ABAP Project which uses SAP GUI Connection to your system.
3.Open the ABAP Project.
4. Add MMPUR_HDB Package to your Favorites (because the external view POHVAL should be assigned to this package)
5.Go to this package and navigate to Dictionary -> Views -> New Dictionary View
6.Fill it out as follows:
Name: POHVAL
Desciption: Aggregated PO History Values To Be Used In Reports
Select the radio button External View and specifiy HANA View:
sap.erp.sappl.mm.pur.po-history.AC_MM_PUR_PO_HISTORY_VALUE
7.Press the Next Button and select a transport request.
8.Activate the development object by pressing Ctrl+F3 or by using Activation Button from the AiE Tool Bar (menu Window->Show Toolbar if invisible).
2. If external view POHVAL is deleted, some manual steps are to be done per ABAP in Eclipse IDE (AiE) in order to re-create the external view POHVAL again.
The external view POHVAL can also be created and activated in the following way.
1.Start your ABAP in Eclipse IDE
2.Create an ABAP Project which uses SAP GUI Connection to your system.
3.Open the ABAP Project.
4. Add MMPUR_HDB Package to your Favorites (because the external view POHVAL should be assigned to this package)
5.Go to this package and navigate to Dictionary -> Views -> New Dictionary View
6.Fill it out as follows:
Name: POHVAL
Desciption: Aggregated PO History Values To Be Used In Reports
Select the radio button External View and specifiy HANA View:
sap.erp.sappl.mm.pur.po-history.AC_MM_PUR_PO_HISTORY_VALUE
7.Press the Next Button and select a transport request.
8.Activate the development object by pressing Ctrl+F3 or by using Activation Button from the AiE Tool Bar (menu Window->Show Toolbar if invisible).
Header Data
| Released On | 12.03.2014 10:08:49 |
| Release Status | Released for Customer |
| Component | XX-SER-REL Business Suite Release Information |
| Priority | Correction with medium priority |
| Category | Program error |
No comments:
Post a Comment