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
Affected Releases
Software
Component
Release
From
Release
To
Release
And
subsequent
SAP_BW
71
730
730
 
SAP_BW
731
731
731
 
SAP_BW
740
740
740
 
Related Notes


 
1783857 - SAP Notes Management: Support Package Stack overview
 
1775293 - Migration/system copy to SAP HANA using latest SWPM 1.0
 
1753759 - Migration / system copy to SAP HANA SWPM 1.0 SP0
 
1738258 - System Copy of Systems Based on SAP NetWeaver 7.1 and Higher
 
1718152 - Spend Performance Management on SAP BW 7.30 Hana
 
1714013 - BPC 7.53 NW on SAP BW 7.3 powered by HANA DB
 
1712334 - Important Notes for SAP BW powered by HANA on SP7
 
1702177 - SAP HANA: Additional info - Software Update Manager 1.0 SP05
 
1681435 - Upgrade NW703 to NW731 (SAP SEM 736, ERECRUIT, LSOFE)
 
1672940 - SAP SEM-CPM 6.34 on SAP BW 7.3 powered by HANA DB
 
1667731 - Rapid database migration of SAP NetWeaver BW to SAP HANA
 
1660125 - SAP HANA database: Table consistency check
 
1659383 - RowStore list for SAP NetWeaver in SAP HANA database
 
1648861 - SAP POS DM on SAP Business Warehouse powered by SAP HANA
 
776186 - ME87: DBIF_RSQL_INVALID_RSQL
 
167242 - Inconsistency in purchase order history material document

51 comments:

Unknown said...

Awesome,
Thank you so much for sharing such an awesome blog...
sap strategic consulting and services

logistic-solutions said...


Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
sap supplier diversity management solutions

Unknown said...

Thanks for sharing great post !!
This information you provided in the blog that is superb.It is amazing. Keep continue..
SAP online training
sap hana online training

logistic-solutions said...

Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
sas implementation services in north america

high technologies solutions said...

Sap training institute in delhi
Sap training institute in Noida
Sap training institute in Gurgaon
Sap training institute in West Delhi

high technologies solutions said...

SAP course in Delhi
SAP course in Noida
SAP course in west Delhi

High Technologies Solutions said...

Lovely post. I learn something new and interesting on Blogs. If you want to learn SAP Training So There are Some Best Training Center for SAP.

SAP Training Institute in Delhi
SAP Training Institute in Noida

Alfred Avina said...

As we know there are many companies which are converting into Google Cloud Big Data Services with the right direction we can definitely predict the future.

SAP Training Delhi said...

Thanks for Sharing a Very Nice Details about SAP & It’s really helpful for everyone. We have Some List OF World Best SAP Training Center in Delhi, India

SAP Training in Delhi
SAP Course in Delhi
sap Institute in Delhi
sap training institute in delhi

sap training center in delhi

SAP Training Delhi said...

Thanks for Sharing a Very Nice Details about SAP & It’s really helpful for everyone. We have Some List OF World Best SAP Training Center in Delhi, India

SAP Training in Delhi
SAP Course in Delhi
sap Institute in Delhi
sap training institute in Delhi
sap training center in Delhi

SAP Training Delhi said...

Thank you for your post. This is outstanding information. It is amazing and wonderful to visit your site. Otherwise if anyone find the best SAP Training Institute in Delhi, India Contact here-9599118710

SAP Training Institute in Delhi
SAP Training Course in Delhi
SAP Training in Delhi
SAP Course in Delhi

SAP Training Delhi said...

Thanks for Sharing a Very Nice Details & It’s really helpful for us otherwise if you want to Save 20% in sap Training Course with Placement offer
sap training center in delhi
sap training institute in delhi
. sap course in delhi

Chetan said...

sap course in delhi

IICT said...

Great article with lots of useful information on SAP Training in Chennai wonderful explanation on SAP module.
SAP Training Center in Chennai | Best SAP Training in Chennai | SAP Training Institute in Chennai

IICT said...

Great article with lots of useful information on SAP Training in Chennai wonderful explanation on SAP module.
SAP Training Center in Chennai | Best SAP Training in Chennai | SAP Training Institute in Chennai

Sapan Singh said...

This is very Informative.
SAP BW Training institute in Noida

Sabrina Pinto said...

Thanks for a great information in your blog
SAP HANA Tutorials

Sudharshan said...


It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
http://chennaitraining.in/sap-mm-training-in-chennai/
http://chennaitraining.in/sap-mss-training-in-chennai/
http://chennaitraining.in/sap-pi-training-in-chennai/
http://chennaitraining.in/sap-pm-training-in-chennai/
http://chennaitraining.in/sap-pp-training-in-chennai/
http://chennaitraining.in/sap-ps-training-in-chennai/
http://chennaitraining.in/sap-qm-training-in-chennai/

Power Mind Technologies said...

Good to Read Your Post & Really it is Knowledgably Post for everyone. Please Try More New Post about Some More Interesting Topics Otherwise if anyone Want to learn SAP Training Course with Reasonable So Contact Here-9310806006 Or Visit the Website- https://www.powermindtech.com/SAP-training-institute-in-Gurgaon

SAP Training Institute in Gurgaon
SAP Training Course in Gurgaon

SAP Enterprise Support and Services said...

Thanks for sharing, that was very informative!

LMTEQ - SAP IT Support Services in USA

saivenkat said...

Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
Cloud Business Management Software Suite

IICT said...

Very Good blog post on SAP Module. We are SAP Training in Chennai

McKinsol Consulting said...

Looking for SAP Consultancy Services. Mckinsol has 25,000-person network of SAP consultants we can engage with on projects, adding nearly 5000 consultants over the last few months.

IICT said...

Very informative blog on SAP WM Module.

robert said...

Hi,
You can find enjoyable and visiting place by this website. so you can go to Visiting Place Bangladesh

robert said...

if you need more information to visiting place off chapai nowabgonj must go to this Choto Sonamojid chapainowabgonj.

IICT Technologies said...

Nice blog
SAP Training in Chennai

Training Institute in Chennai said...

Cool Post.
SAP Training in Chennai
SAP ABAP Training in Chennai
SAP FICO Training in Chennai
SAP MM Training in Chennai
SAP SD Training in Chennai

QuiTec said...

Hi ,

Thanks for your wonderful post ,this post is very helpful for me i search IT Consulting company and found your site post.

Thanks a lot for your post keep it up!

IT Consulting

Experience Letter Consultants said...

Want Experience certificate For Grow Your Career So Contact Now & Get All Details – 9599119376 Or Visit Website- https://fakeexperiencecertificateinpune.blogspot.com/

sudalai said...

the information you have updated is very good and useful,plse update further.
if you required any info regarding TAX & GSTR please visit

Tax consultants in Delhi|
GST consultants in Delhi|
Company registration in Delhi|
Company name regstration in Delhi|
how to register a startup company in Delhi|
company registration cost Delhi|
company registration online Delhi|
pvt ltd company registration fees Delhi|
pvt ltd registration Delhi|
new company registration Delhi

SysAppPro Noida said...

Thanks for sharing this Information. SAP BW Training in Noida

Narender Singh said...

Thanks for sharing this Information. SAP HANA Training in Gurgaon

digitalhts said...


it's really a piece of new information to me, I learn more from this blog, I want to learn more from this blog, keep on it doing, I eagerly waiting for your updates, Thankyou. other anyone wants to learn MIS course so contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/business-analytics/mis-training-instiute-in-delhi

Sushanth said...

I’m not that much of an internet reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your website to come back down the road sap certification in hyderabad

digitalhts said...

Great Blog! I got too much information from this Blog. Thanks for sharing such a helpful Blog. otherwise anyone wants to learn 3d Max training course so contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/cad-cam-cae/autocad-3ds-max-training-course

SAP Training Institute said...

Thanks for Sharing a Valuable Details for Us Otherwise If any One Want to Learn SAP Training Course So Contact Us-

sap training institute in delhi
sap training Course in delhi

saivenkat said...

This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
Cloud Business Management Software Suite

Dark Warmer said...

Our mission is to 'transform Learners into Action takers'. IB Business Management is the online educational publisher and mentoring service provider. We provide a comprehensive range of support resources and services to facilitators, students, parents and educational institutions who follow International Baccalaureate (IB) and Cambridge IGCSE and A-Level programmers.

SAP TRAINING INSTITUTE IN NOIDA said...

SAP BW Course in Noida For Further Inquiry :- +91-706-539-0111

Xforia said...

Great post. Thanks for sharing. IT Corporate Technology Consultants Texas | Managed IT Services Texas

MOUNIKA said...

Nice post.

Telugu movies download
Indian movies download
movies download
Movies watch online
Online movies watch
Hindi movies download

SAP Training Delhi said...

It was really a nice article and I was really impressed by reading this article we are also giving all software Course Training. The Sap FICO Training is one of the leading Online Training institute in the world.

Sap fico training in delhi

dante said...

Do you need a business loan?. I found a fantastic company that provides it in literally 24 hours. No stress or headaches.

Unknown said...

Well It Was Very Good Information for Sap Learners I Was Really happy See This Article

Learn Core to Advanced SAP MM Training with Placement

Amber Taylor said...

We are really grateful for your blog post. We will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.
Checkout Best Inventory Management Software

High Technologies Solutions said...

Nice blog..! I really loved reading through this article... Thanks for sharing such an amazing post with us and keep blogging.

Learn SAP Training Course with Placement

Dreamsoft Consultants said...

Want to Fill Your Career GAP. We provide you with true and genuine experience certificate and documents that are verified from trusted sources and will ensure 100% authenticity. Further Details Here- 9599119376 Or Visit Website- https://fake-experience-certificate.yolasite.com/

Gway ERP said...

Thanks a lot for your help on this. I look forward to reading more articles from you!
Erp Companies In Chennai
Erp Software Companies In Chennai
crm software in chennai

High Technologies Solutions said...

Thanks for the article. It has given me some basic ideas of what I have been searching for. Come up with more such articles.

Top & Best SAP Training Institute in Delhi, NCR

Narender Singh said...

Thanks for Sharing this Information. SAP BW Training Course in Gurgaon