Upgrade to SAP Agile Data Preparation Version 1.0 SP 14

Upgrade to SAP Agile Data Preparation Version 1.0 SP 14 from SAP Agile Data Preparation Version 1.0 SP 08, Version 1.0 SP 09, or Version 1.0 SP 11.

1. If your version of SAP HANA Rules Framework is lower than version SP08, update it by following these steps:
   1. Download the delivery unit for the latest patch level for version SP08 by following the instructions in Download SAP HANA Rules Framework.
   2. Import the HANA Rules Framework delivery unit file HCORULEFW.tgz by following the instructions in Deploy SAP HANA Rules Framework.
2. With either the SYSTEM user or a user name with the equivalent SYSTEM privileges, run the following script on the SQL Console of SAP HANA studio to grant the appropriate role to a user name that will run the upgrade and setup scripts:

   CALL "_SYS_REPO"."GRANT_ACTIVATED_ROLE"('sap.hana.im.adp.db.roles::Administrator', '<HANA USER>');

3. As <HANA USER>, perform the following steps:
   1. If you are upgrading from Version 1.0 SP 09, run all of the following upgrade scripts on the SQL Console of SAP HANA studio:

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP110::setup" ( );

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP112::setup" ( );

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP113::setup" ( );

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP114::setup" ( );

   2. If you are upgrading from Version 1.0 SP 11, run all of the following upgrade scripts on the SQL Console of SAP HANA studio:

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP112::setup" ( );

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP113::setup" ( );

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.upgrade.ADP114::setup" ( );

   3. Browse to the following URL address, which removes generated HANA Rules Framework artifacts that are no longer valid:

      http://<server>:<port>/sap/hana/im/adp/services/rules/resetRuleServices/

      A success message appears when the artifacts have been successfully removed. Otherwise, error messages appear.

   4. On the SQL Console of SAP HANA studio, run the following script to create the required roles for HANA Rules Framework:

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.db.procedures::setupHRF" ( );

4. With either the SYSTEM user or a user name with the equivalent SYSTEM privileges, run the following script on the SQL Console of SAP HANA studio:

   CALL "_SYS_REPO"."REVOKE_ACTIVATED_ROLE"('sap.hana.im.adp.db.roles::Administrator', '<HANA USER>');

5. If you need to reconfigure the SMTP server for the user self-service mail for the forgotten password feature, do the following steps:
   1. Start the Web-based SAP HANA XS Administration Tool.

      The SAP HANA XS Administration Tool is available on the SAP HANA XS Web server at the following URL:

      http://<<WebServerHost>>:80<<2-digit instance>>/sap/hana/xs/admin/

   2. Start the SMTP Configurations tool.

      Select the XS Administrations tool menu icon and choose SMTP Configurations to display the screen where you can manage the configuration of the SMTP server used by SAP HANA XS applications.

   3. Click the Edit button, and enter the mail server host and server port parameter values that are pertinent to your SMTP server.
   4. Save the changes you have made to the SMTP configuration.