Skip to end of metadata
Go to start of metadata

Purpose

The Purpose of this page is to collect all BW on HANA relevant information and also provide technical detail on common issues and how to troubleshoot known problems.

BW on HANA Sizing

If you want to do the sizing for an existing BW system on HANA or you want to  convert system into a BW/4HANA system  please refer to SAP note New Sizing Report for BW/4HANA. If you start a Greenfield implementation you should use the SAP QuickSizer in this case. Please go to SAP Quicksizer for further details. Using SAP QuickSizer, you will get information on both the SAP HANA In-Memory Database and the SAP NetWeaver BW application server. For an existing Enterprise data warehouse solution where there is no existing ABAP application server for BW you can use the sizing scripts from the note 1637145 SAP BW on HANA: Sizing SAP In-Memory Database.

BW on HANA Installation and upgrade guides:

SAP BW Installation/Configuration (also on HANA)

BW on HANA Migration:

Before doing the upgrade and migration, apart from referring to the upgrade and migration guides please also read carefully the information in the SAP First Guidance document at the link below, together with the standard documentation this should provide all the necessary information you need to successfully migrate BW on any SAP supported database to BW on HANA:

Software Application Lifecycle Management for SAP BW 

In general DMO is the recommended tool for the BW on HANA Migration, please see the documentation on the tool at the link below which includes information on how to optimize the BW on HANA Migration performance:

DMO: optimizing system downtime

If you do not use DMO as upgrade of the BW system is not required before migration please refer to the information at the SCN links below for the General steps to follow for the BW on HANA Migration using the Software provisioning manager tool:

http://scn.sap.com/community/bw-hana/blog/2014/10/22/bw-on-hana-scaleout-migration-part-1-preparation-checklist-and-known-issues

http://scn.sap.com/community/bw-hana/blog/2014/10/22/bw-on-hana-scaleout-migration-part-2-migration-process-and-issues-encountered

http://scn.sap.com/community/bw-hana/blog/2014/10/22/bw-on-hana-scaleout-migration-part-3-post-migration-activities-and-issues-encountered

Common Questions:

Q I want to migrate to BW on HANA where can I find further information on technical requirements?

A good starting point is the information in the following note:

1600929 - SAP BW powered by SAP HANA DB: Information

Q Are there SAP tools or programs that I can use to check if my BW system is ready for migraton to HANA?

A Yes, please refer to the information in the SAP notes 1909597 - SAP BW Migration Cockpit for SAP HANA and 1729988 - SAP BW powered by SAP HANA and SAP BW/4HANA - Checklist Tool 

Q BW on HANA queries based on a composite provider have a long runtime, what can I do to improve the performance?

A Check that best practices were followed when creating the Composite provide as described in the SAP note 2103032 - Long runtimes in query on CompositeProvider  

Q I have BW tables with very larger data volumes , how can I mange these tables from perfoamnce and administration point of view?

A Please refer to the information in the SAP notes 2019973 - Handling Very Large Data Volumes in SAP BW on SAP HANA and 1331403 - SIDs, Numberranges and BW Infoobjects 

Troubleshooting, issues and reported problems

POST Migration:

Issue:

Unwanted Secondary Indexes still exist in transaction DB02 after BW on HANA Migration, they can be found in DB02 under 'Unknown objects in ABAP Dictionary' and sub heading 'DB Indexes' :

Solution:

Follow the KBA 2077953 - How to remove unwanted secondary Indexes after a BW on HANA Database migration to remove these secondary Indexes.

Issue:

Delta merge for large BW table fails, you see the HANA Alert 29 in HANA Studio.

Solution:

Use the symptom part of the KBA 2211729 - Not enough memory to execute delta merge, HANA Alert 29 Size of delta storage of column-store tables to confirm that you have followed the standard troubleshooting steps to free up enough memory for the delta merge. If this does not work please follow the Resolution section of the KBA to work around the problem.

Issue:

After the BW on HANA Migration I do not see the expected performance improvement in my BW queries. What can I do?

Solution: 

There is often the expectation that after a BW on HANA migration from another database that all BW queries should be much faster. Of course if the query was slow already before database migration to HANA due to some calculations happening on the BW application server and these calculations cannot be pushed down to HANA DB then HANA cannot help for these use cases without a redesign of the BW Query. The Query run time component that we can expect to see significantly improved with HANA is the database time, this is the Event ID 9000 (Data Manager Time) in the BW Query run time statistics.

To trouble shoot the problem and determine if the problem is HANA Database related or not  please follow the information in the Knowledge based article How to determine if a BW on HANA query performance problem is HANA database related.

In the Knowledge based article Push down of BW OLAP functionalities to SAP HANA you find the current list of OLAP related data intensive operations that are pushed down from BW application server to the HANA Database.

Issue:

I am executing the BW on HANA Post migration report RS_BW_POST_MIGRATION and it fails with error. What can I do to troubleshoot the problem?

Solution:

1: Check that you execute the report in the background with the variant SAP&POSTMGRHDB.

2: If you still get errors check the application log (transaction SLG1) for the time the report failed to find the relevant error messages and the step that the report failed on.

In the majority of cases the report fails on the step Create calc views cubes/infoobjects and the relevant calculation view cannot be created. In most case the calculation views cannot be created for the following infoobjects:

Creation of column view for 0PRODUCT failed
Creation of column view for 0GN_CAT_PUR failed
Creation of column view for 0BCTCOMP failed
Creation of column view for 0GN_CAT_SAL failed
Creation of column view for 0GN_COMPANY failed
Creation of column view for 0GN_VENDOR failed

The errors for infoobject 0BCTCOMP can be ignored if you don't use this content object. It has no D version in the system after BW release 730 so is obsolete. Please see the relevant part of the 1695112 - Activities in BW after migrating to the SAP HANA database below:

"

The InfoObject 0BCTCOMP is obsolete and is no longer delivered by SAP (no D version as of BW Release 7.30). If you do not use 0BCTCOMP, it can be deleted. Otherwise the TXTTAB field value and the CHKTAB field value can be deleted for 0BCTCOMP in the table RSDIOBJFIX using transaction SE16. After this you can open the InfoObject 0BCTCOMP in InfoObject maintenance (RSD1) and you can deselect the short text field. You can then save and activate the InfoObject.

"

For the remaining error messages:

Creation of column view for 0GN_CAT_SAL failed
Creation of column view for 0GN_COMPANY failed
Creation of column view for 0GN_VENDOR failed
Creation of column view for 0PRODUCT failed
Creation of column view for 0GN_CAT_PUR failed

Often the reason why the above column views cannot be created is that they are dependent on the info object 0GN_BWBEOTY which has a missing master data read class in the active version (it is available in the content version of the info object you can check this in RSD1 transaction under the tab master data/texts):

The Solution is to install from BW content the info object 0GN_BWBEOTY and then the active version should have the master data read class and you should then be able to execute RS_BW_POST_MIGRATION and create the HANA views successfully for 0GN_* objects given above.

Please note that you may need to Install the BW objects from content again without flagging the match or copy option, in this case any changes that you have made to the standard object will be overwritten: 

If it is not clear from SLG1 what is the name of the info object that has the problem on HANA, (as in the above case the info object was 0GN_BWBEOTY) if you check the Index server trace file for the time that you get the error in SLG1 you should be able to find the name of the problem info object. In this example the following error message could be found in the Index server trace:

Index creation addViewAttribute error:  [2030] Adding view attribute 0GN_BWBEOTY_TSH: field TXTSH not exist in table SAPABAP1:RSBWBEOTYPTen at ptime/query/plan_executor/trex_wrapper/trex_wrapper_body/trex_joinindex.cc:280.

BW on HANA Eclipse Modeling and External HANA views

Issue:

You are not able to open sub folders like BW infoareas and see objects in BW Modelling tools perspective or the BW search in Transaction RSOSM fails.

Solution:

Please refer to the SAP KBA's 2396002 - Unable to open sub infoareas in BW eclipse Modelling tools perspective in HANA Studio after BW support package update or upgrade and 2551438 - Reactivating BW search in Transaction RSOSM fails with the error message Unable to deploy view for a potential solution. 

BW ON HANA Data Loading

Issue:

BW on HANA Data loads fail with ST22 dump header DBSQL_SQL_ERROR with the short text SQL error "SQL code: -10108" occurred while accessing table "TABLENAME".

Solution:

Follow the troubleshooting steps in the KBA  2308459 - Troubleshooting '10108' + '9300' errors in relation to SAP HANA to resolve the issue. 

Issue:

BW DTP with 'SAP HANA Execution' flag sets fails with out of memory error.

Solution :

Please refer to the information in the SAP note 2230080 - Consulting: DTP: Out of memory situation during 'SAP HANA Execution' and the 'Request by Request' Extraction 

BW Content Activation:

Issue:

In SOLMAN_SETUP the BW Content activation fails with an error like below:

ERROR: EC:2048"column store error: fail to create scenario: [34011] Inconsistent calculation model

Solution:

Follow the steps in the SAP KBA 2374090 - SOLMAN_SETUP - BW Content Activation fails "ERROR: EC:2048" column store error: in Solution Manager 7.2 to resolve the issue. 

RSRT Report Performance Issue

 

 

 

   

  • No labels