2078149 - SAP GRC AC 10.1 - Missing Schema Mapping for HANA based optimization and HCO_GRC_APPL_AC content activation.

Symptom

In time of installing SAP GRC AC 10.1 SP05 or SP06, HANA stored procedure deployable with use of transparent container from ABAP may not be activated because of the missing mapping in the SAP HANA between Authoring Schema SAP_GRC and Physical Schema SAP<SID>, between Authoring Schema SAP_GRC_OPT and Physical Schema SAP<SID>

Other Terms

Install SAP GRC AC 10.1 SP05 or SP06, SAP GRC AC 10.1 HANA optimization, GRC-SAC-ARA, GRC-SAC-EAM

Reason and Prerequisites

Missing mapping in the SAP HANA between Authoring Schema SAP_GRC and Physical Schema SAP<SID>, between Authoring Schema SAP_GRC_OPT and Physical Schema SAP<SID> need to be created in the  HANA System.

Solution

1. Start HANA Studio and Connect to HANA Server used to support NW 7.40 and SAP GRC AC 10.1

• Start HANA Studio and Open Modeler perspective.
• Add System (where HCO_GRC_APPL_AC content will be deployed) in the HANA Studio by providing 

        Host Name, Instance Number, Description, HANA User ID and Password.
        Note: Use SYSTEM as User ID to connect to the HANA System where HCO_GRC_APPL_AC content will be deployed. It is required for deployment time only.
2. Create Schema Mapping between Authoring Schema SAP_GRC and Physical Schema SAP<SID>, between Authoring Schema SAP_GRC_OPT and Physical Schema SAP<SID> need to be created in the  HANA System.
3. Deploy Delivery Unit (use attached file HCO_GRC_APPL_AC_PATCH01_05122014.tgz) with Content for the SAP HANA Optimization for the SAP GRC AC 10.1 by using HANA Studio.

• Start HANA Studio and Open Modeler perspective.

After System Registration is completed and Connection verified, Open Modeler perspective and use "Select System" button in the Modeler perspective to select a System you just registered in the previous step.

• In the same Modeler Perspective Click "Import" link located under "Content" label and in the open dialog select "Delivery Unit" under SAP HANA Content and Click "Next" button.
• In the opened window Select file location as "Client" and use "Browse" button to navigate to the location where you save attached this note file HCO_GRC_APPL_AC_PATCH01_05122014.tgz with SAP HANA Content.       
• When HCO_GRC_APPL_AC_PATCH01_05122014.tgz file is selected you will see Delivery Unit details in the Object import simulation.
• Click "Finish" button to complete Delivery Unit deployment and Object Activation process.
• Verify deployment by navigating in the "Modeler" perspective to "SAP HANA Systems" where you registered HANA Server.
• Expend from Content node, following packages sap --> grc --> appl --> ac  and under ac package you should be able to see 4 SP objects in the active state.
• In this point Delivery Unit was deployed successfully.

Header Data

Released On	09.10.2014 19:05:35
Release Status	Released for Customer
Component	GRC-SAC-UPG Installation & Upgrade
Other Components	GRC-SAC-ARA Access Risk Management GRC-SAC-EAM Emergency Access Management
Priority	Correction with medium priority
Category	Installation information

Attachment: HCO_GRC_APPL_AC_PATCH01_05122014.tgz