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
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:
Business Content Add-On:
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
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
- Patch Level(PL): 100
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
|
Related Notes
51 comments:
Awesome,
Thank you so much for sharing such an awesome blog...
sap strategic consulting and services
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
sap supplier diversity management solutions
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
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
sas implementation services in north america
Sap training institute in delhi
Sap training institute in Noida
Sap training institute in Gurgaon
Sap training institute in West Delhi
SAP course in Delhi
SAP course in Noida
SAP course in west Delhi
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
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.
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
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
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
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
sap course in delhi
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
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
This is very Informative.
SAP BW Training institute in Noida
Thanks for a great information in your blog
SAP HANA Tutorials
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/
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
Thanks for sharing, that was very informative!
LMTEQ - SAP IT Support Services in USA
Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
Cloud Business Management Software Suite
Very Good blog post on SAP Module. We are SAP Training in Chennai
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.
Very informative blog on SAP WM Module.
Hi,
You can find enjoyable and visiting place by this website. so you can go to Visiting Place Bangladesh
if you need more information to visiting place off chapai nowabgonj must go to this Choto Sonamojid chapainowabgonj.
Nice blog
SAP Training in Chennai
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
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
Want Experience certificate For Grow Your Career So Contact Now & Get All Details – 9599119376 Or Visit Website- https://fakeexperiencecertificateinpune.blogspot.com/
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
Thanks for sharing this Information. SAP BW Training in Noida
Thanks for sharing this Information. SAP HANA Training in Gurgaon
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
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
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
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
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
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 BW Course in Noida For Further Inquiry :- +91-706-539-0111
Great post. Thanks for sharing. IT Corporate Technology Consultants Texas | Managed IT Services Texas
Nice post.
Telugu movies download
Indian movies download
movies download
Movies watch online
Online movies watch
Hindi movies download
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
Do you need a business loan?. I found a fantastic company that provides it in literally 24 hours. No stress or headaches.
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
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
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
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/
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
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
Thanks for Sharing this Information. SAP BW Training Course in Gurgaon
Post a Comment