Basis and others: Note 1600929 - SAP BW powered by SAP HANA DB: Information

Note 1600929 - SAP BW powered by SAP HANA DB: Information

Summary

Symptom
You want to migrate your SAP Business Information Warehouse (BW) system to the SAP HANA database (DB).
You are using an SAP BW system with SAP HANA as the database.
You are looking for additional SAP Notes regarding SAP BW with SAP HANA as the database.
Other terms
Support Package, BW on HANA
Reason and Prerequisites
You receive the following SAP HANA appliance from an SAP hardware partner:
SAP In-Memory Platform Edition
or
SAP In-Memory Enterprise Edition
or
SAP In-Memory Extended Edition

You receive a preinstalled SAP HANA database with this hardware.
Solution
Ensure the following:
1) You are not using a dual stack system (ABAP and JAVA have the same master data ID (SID) in the same database). Any functions for splitting are provided using the dual-stack split tool in the Software Logistics (SL) Toolset.
For information about the SL Toolset and its release schedule, see the central note for the SL Toolset 1.0 (Note 1563579).
2) Support Package 06 or higher is imported for your SAP in-memory DB. We recommend to use the latest available revision from SMP

Only a standard installation and a distributed installation with a separate database server is supported. Other applications must not be installed on the database server apart from the preinstalled SAP HANA database (DB) and additional applications that it requires because these other applications may have a negative affect on performance. This also includes parts of the distributed central instance (for example, an application server must not be installed on the DB server).

SAP recommends you to always use the latest available revison of SAP HANA. At minimum we require HANA SP06 Revision 60.
Information relevant for SAP NW BW 7.30 / 7.31 on HANA

Migration

Kernel Recommendation (minimum):
720_EXT - Kernel

Patch Level(PL): 300

721_EXT - Kernel

Patch Level(PL): 100

           Information about Red Hat 5 can be found below.
Export:
Use your existing installation CD or DVD for the export. For the question with regard to the target database, select your source database in case that there is no entry for SAP HANA DB. This has no effect on the created files.
In the step "Confirm Report Execution", select "No, run the import of the target system without SQL files". After the export, create a subdirectory called <export>/ABAP/DB/HDB under your export directory. Then, start the report SMIGR_CREATE_DDL. Select SAP In-Memory Database with the additional parameter for the installation directory <export>/ABAP/DB/HDB.
If the report stops, move the file SQLFILES.LST from <export>/ABAP/DB/HDB to <export>/ABAP/DB.
Import:
For the import to the SAP HANA DB, use the newly delivered media.
Note that only the asynchronous file-based export/import method is available for the system copy (that is, socket mode, and ftp mode are not supported).

Detailed information about Migration /Systemcopy using SAP HANA DB with special view on performance improvements in R3Load: see note 1753759

Additional important SAP Notes and known problems:
-----
A dump occurs while uploading data via DTP on an SLS 11 SP1 Linux Server due to a wrong timestamp.
To correct this error, install Linux kernel version 2.6.32.19.
You can check which kernel version is installed on your system using the command "cat /proc/version".
-----
There is the following restriction with regard to the use of Embedded Search with TREX. At the moment this functionality is not released for the SAP HANA database. It is also not released if you want to have an existing TREX alongside it. However, we are working on a solution for this restriction.
-----
Please see note 1657994 for SP06 passwords for SPAM update.
-----
Please have also a look at note 1678047 COMPUTE_INT_PLUS_OVERFLOW during activation.
-----
ATTENTION! After Applying NW 7.30 SP09 / NW 7.31 SP07 you need to add the SQL privileges mentioned in note 1776186 to your SAP<SID> User on HANA if your ABAP System is running on kernel 7.21 and your HANA DB is distributed(scale out).

Prerequisite for installation when using latest Kernel media 51045124 (BW 7.30) or 51045125 (BW 7.31) containing optimized R3load:
-----

1) During installation you might recieve  following error in the dev traces of the application server during phase start instance:

C  invalid secure store entry, rc = -10104 (Invalid value for KEY(DEFAULT))
C  Try to connect via environment (localhost:7878) on connection 0 ...
C  *** ERROR => Connect to database failed, rc=1, rcSQL=-10709
(Connection failed (RTE:[89006] System call 'connect' failed,
rc=146:Connection refused))

If you encounter this situation please make sure that you update your HANA Client to rev >=38. Afterwards retry.

2) After installation/import of your system is finished successful please ensure that you update the kernel version of your system to at least 318. Otherwise you won't be able to upload any correction instructions via SNOTE.

Information relevant for SAP NW BW 7.30 on HANA

Please ensure that Support Package 07 or higher is imported for your SAP NetWeaver (NW) BW Installation (ABAP) before migration/ after installation. Please keep in mind that you have to apply SP06 which was only available for BW on HANA Ramp up customers. For your convenience we have created a note mentioning important notes after SP07: 1712334

SAP NW 7.30 BW on the SAP HANA DB uses the SAP kernel 7.20_EXT_REL by default.If you use the operating system RedHat5 for your application server, order the relevant kernel DVD using the material number 51042007 under the component XX-SER-SWFL-SHIP.

The following source databases are supported for the migration:
Oracle 11.2
IBM DB2 LUW 9.7
MaxDB 7.8
MS SQL server 2008
DB2 for i61, 7.1
DB2 for z/OS V9, V10
SAP Sybase ASE 15.7

Please check if the following tables are part of the row store in the SAP HANA DB before you start to implement Support Packages or other Add-Ons like Business Content, SEM or BPC to ensure a performant import:
DOKIL, TADIR, E070, E071, PAT01. VRSD and SMODILOG.
If the tables are nit in the row store you can use the SQL Tool which has been delivered with SAP HANA Studio to move the table within schema SAP<SID>:
alter table DOKIL row;
The tables can stay in the row store.
You can find alternative options and an exact description of the change process in SAP Note 1660125.
See SAP Note 1659383 for more information about which tables are located in the row store.

General:

For now, all products and components of the SAP Business Suite are not released for BW 7.30 SP5(and higher) powered by SAP HANA DB.

This restriction does not apply to the following:

In the area of SEM-BW, the component SEM-BCS 6.34 is available as of now and supports the productive use of SAP Netweaver Business Warehouse 7.3 powered by SAP HANA. For more details, see SAP Note 1648413.

The components VIRSANH and GRCPINW of the SAP GRC Access Control Solution are released.

The components ST-A/PI and ST-PI are released.

SAP Notes Management 10.0 HANA compatible. Details can be found in note 1783857

SBOP PC 10.0 FOR SAP NW is released. For more details please see SAP note 1676242. BPC will offer BW 7.31 on HANA support end of Jan. 2013.

SPM 3.0 is supported on SAP BW 7.30 on HANA. For details please see SAP note 1718152

Business Content Add-On:

SAP POS Data Management on SAP Business Warehouse powered by SAP HANA

In the BI Content Releases 7.35 and 7.36 on SAP Business Warehouse powered by SAP HANA (SAP BW 7.3 SP05 and HANA 1.0 SP03), there may be restrictions with regard to the processing, compression, and size of the TLOG data table for users of the POS Inbound Processing Engine (PIPE) as the central component of SAP POS Data Management.

For more information, see SAP Note 1648861 "SAP POS Data Management on SAP Business Warehouse powered by SAP HANA".

Information relevant for SAP NW BW 7.31 on HANA

Please ensure that Support Package 04 or higher is imported for your SAP NetWeaver (NW) 7.31 BW installation (ABAP) before migration/after installation.

The following source databases are supported for the migration:
Oracle 11.2
IBM DB2 LUW 9.7
MaxDB 7.9
MS SQL server 2008
DB2 for i61, 7.1
DB2 for z/OS V9, V10
SAP Sybase ASE 15.7

SAP NW 7.31 BW on the SAP HANA DB uses the SAP Kernel 7.20_EXT_REL by default.

General:

For system copy of systems based on SAP NetWEaver 7.3 EhP1 please check the "SAP HANA database - specific Topics section" in note 1620515.

For application server IBM i again HANA DB please check note 1713523.

The upgrade procedure for "SAP NW BW 7.30 on HANA DB" to "SAP NW BW 7.31 on HANA DB" is supported as of SL Toolset 1.0 SP5. For further information please have a look at notes 1702177 and 1680769.

Information relevant for SAP NW BW 7.40 on HANA

Please find BW specific information about timeline, scope and recommedations at http://scn.sap.com/docs/DOC-35096.

For details about changes relevant for customer-specific programs please see note 1823174 - These note is also relevant for SAP SCM Customers.

For general NW 7.40 Informatiion please go to: http://scn.sap.com/docs/DOC-35002

PAM Information can be found here: https://service.sap.com/sap/support/pam?hash=s%3DSAP%2520NETWEAVER%25207.4%26filter%3D%26o%3Dmost_viewed%257Cdesc%26st%3Dl%26rpp%3D20%26page%3D1%26pvnr%3D67838200100900005868%26pt%3Dg%257Cd

HANA Revision: Please use SAP HANA SP06 (Revision 60) as minimum level for SAP NW BW 7.40 on HANA. We recommend to always use the latest available revision.

We recommend to use at least PL 11(740_REL)

Upgrade:

These activites are also relevant for customers using SAP SCM.

Please see note 1879618 for BW specific actities before the upgrade/update to SAP NW BW 7.40

For compatibility of the BI-JAVA Stack with SAP NW BW 7.40 please have a look at note 1645590

Necessary changes in customer owned coding: seen note 1823174

Add-on Compatibilty SAP NW 7.40 please see note 1826531.

For SAP SEM 747 / SEM-BW 747 (planned for Aug. 2013) see also notes: 1602357, 1491922

Add-on Compatibility Suite on HANA: 1812713

Header Data


Release Status:	Released for Customer
Released on:	05.08.2013 08:09:26
Master Language:	English
Priority:	Recommendations/additional info
Category:	Upgrade information
Primary Component:	BW-SYS-DB-HDB BW HDB
Secondary Components:	BW-WHM Data Warehouse Management