SAP BW 7.3 Upgrade Issues and Solutions
actual effort was just under three months utilising one full time and one part time consultant.
Issue | Details / Root Cause | Change / Solution |
---|---|---|
0FISCPER text display as July 2012 as opposed to July 2011 | Entries for table RSADMINS changed with the upgrade. This table controls the text values displayed for the time dimension and implemented read class. |
Update entries in table RSADMINS.
Program ZBW_RSADMINS_UPDATE was custom built for this change.
|
Text variables do not display the text (label) for 0CALDAY |
Refer to SAP Article 1693785.
In BW 7.30 the infoobject 0DATE and other time characteristics do not have a text table maintained in RSD1. Therefore, if you try to use a variable with
replacement path “replaced by label”, you will see that the texts are not replaced. However, in the lower system 7.00 and 7.01, for 0DATE internally set text flags are set and hence you can see text are being replaced. This behaviour has been changed in 7.30. |
|
FM BAPI_ISREQUEST_GETSTATUS returns different results. | This function module is returning a blank TECHSTATUS. |
WHEN ‘Y’. ” Y = Yellow (request still processing)
With this new code:
WHEN ‘Y’ OR ”. ” Y = Yellow (request still processing)
Activate the new version of the program
|
FM RSKC_CHAVL_OF_IOBJ_CHECK returns different results.
|
FM RSKC_CHAVL_OF_IOBJ_CHECK
changed with the upgrade. Before the upgrade, the above FM return RC=00 when there is no InfoObject template in a DSS. After the upgrade the FM returns RC=04.
|
Removed the call to the RSKC_CHAVL_OF_IOBJ_CHECK completely. Replace the FM with corrected code to
perform valid character checks. |
Aggregate roll-up step failed |
Roll up steps where aggregates were deactivated, and the process chain role-up variant did not have flag “”End process successfully if no aggregate exists”
set – failed after the upgrade. The behaviour in BW 7.3 seems to be different for aggregates that have been
deactivated i.e. BW 7.1, – if the flag was not set in the roll up,
and the aggregate was deactivated, the chain would be successful BW 7.3, – if the flag was not set in the roll up, and the aggregate was deactivated,
the chain fails |
Adjust the variants in the following base chains – by checking the flag: “End process successfully if no aggregate exists”. |
Key figure in Bex Queries returns zeroes. |
Caused by a program error.
The key figure is derived from a calculated key figure which uses the
NODIM function. |
Implement SAP Note: 1696274: A calculated key figure outputs the value 0.
|
KFs display “0 ERR” or “*” inconsistently
|
Caused by a program error.
|
Implement notes:
1708084 – Mistaken ‘0 ERROR’ cells for keyfigure with
unit/currency 1698057 – * for currency-dependent and unit-dependent key figures
|
ABAP Programming Error
BIT_OFFSET_NOT_POSITIVE
|
Caused by a program error.
|
Implement
1722725 – Input-ready query terminates with BIT_OFFSET_NOT_POSITIVE |
KFs return blank values | Caused by a program error. | Implement Note 1736862 |
Text variable returns technical name as opposed to characteristic value |
Refer to SAP Article 1693785.
In BW 7.30 the infoobject 0DATE and other time characteristics do not have a text table maintained in RSD1. Therefore, if you try to use a variable with replacement path “replaced by label”, you will see that the texts are not replaced. However, in the lower system 7.00 and 7.01, for 0DATE internally set
text flags are set and hence you can see text are being replaced. This behaviour has been changed in 7.30. |
Apply the following change to the problematic variables:
Change replacement path from “Label” to “Characteristic Value”
|
Queries on MultiProviders without 0CALDAY, where the underlying Cube(s) are non-*** cubes and contain 0CALDAY, generate errors | The participating InfoProvider is a stock InfoCube, meaning that it contains at least one stock key figure. There must therefore be a time characteristic Calendar day[0CALDAY] (NCUMTIM) in the MultiProvider and Calendar day[0CALDAY] can only be assigned to itself. For InfoProvider JSD_B_012, Calendar day[0CALDAY] may not be assigned to the characteristic ”. |
Change the multi provider by including 0CALDAY into the time dimension |
Detail analysis using t/c ST03 fails | Program error | Apply manual steps as per note: 1608989 |
APD filter from a non-cumulative cube fails |
Program error
“The argument ’00″‘ cannot be interpreted as a number”
“An exception with the type CX_SY_CONVERSION_NO_NUMBER occurred”
|
Implement SAP Note 1674845
Symptom
When reading from a non-cumulative InfoProvider using the function RSDRI_INFOPROV_READ, a
termination occurs in the method CL_RSDRS_ORACLE_SQL_STMT->BUILD_FORMULA. Other terms
RSDRI_INFOPROV_READ NCUM, non-cumulative InfoCube, non-cumulative IC,
CL_RSDRS_ORACLE_SQL_STMT BUILD_FORMULA |
Queries with exception aggregation after variable replacement | You are trying to replace a variable from a hierarchy attribute or the text of characteristic [0FISCPER]Fiscal year/period or from characteristic [0FISCPER]Fiscal year/period. This replacement should be made after aggregation by [0FISCPER]Fiscal year/period (see Note 1385580). The variable is used in a context though that forces replacement before aggregation by [0FISCPER]Fiscal year/period. An exception aggregation for [0FISCPER]Fiscal year/period is specified for example on formula Working Days FY2007 or a higher-level formula, or a second variable is used there which also shold be replaced from characteristic [0FISCPER]Fiscal year/period but before aggregation. System Response Procedure For example: F = B * ( Va -Vb) to F = Fa – Fb or G = B* Va * Vb to G = Va * Gb |
Change the exception aggregation from “Summation” to “Use Standard Aggregation” |
ABAP dump when trying to run an SQL query in t/code ST04 |
Program error
OBJECTS_OBJREF_NOT_ASSIGNED
ABAP Program CL_ORA_SQL_EXECUTOR===========CP
Application Component BC-CCM-MON-ORA
|
Implement SAP Note 1709951
Symptom
This SAP Note is valid for the DBA Cockpit on Oracle.
A dump occurs when you execute any SQL statement using the SQL Command Editor
Other terms
CL_ORA_SQL_EXECUTOR st04_sqlc_n CL_ORA_ACTION_SQL_EDITOR
|
Z* Programs deleted after upgrade
|
Programs were assigned to $tmp and not on a transport package.
Programs can be identified by listing all programs on
table TRDIR which are not on table TADIR i.e. If a program is of type “PROG” (excluding classes and function modules) and it is in table TRDIR and not in table TADIR – it might be deleted after performing the upgrade. |
Prior to the upgrade, add the
programs to a package, set the required program attributes i.e. Executable, Customer Production Program and Business Intelligence Program. |
Warning message when executing InfoPackage | File ending does not match the current adapter CSVFLCONV; Ending CSV expected |
Implement SAP note: 1687349 |
The function module call to RSNDI_SHIE_STRUCTURE_GET3 fails |
The issue has 2 root causes. RCA 1 below is the primary issue – it was a “bug” to being with. RCA 2 is only highlighting the bug.
RCA 1 – The object was ’typed’ incorrectly in a custom BW Z-program . It should have been of type RSNDI_S_HIEDIR2 and not RSNDI_S_HIEDIR – to align with the FM interface.
RCA 2 – SAP changed the structure of RSNDI_S_HIEDIR2 and RSNDI_S_HIEDIR
|
If programs use the FM and variable definitions are typed with RSNDI_S_HIEDIR as opposed to RSNDI_S_HIEDIR2, change all calling programs to use the latter i.e. RSNDI_S_HIEDIR2
|
Calculate result as….”Summation” on CKF does not return a summated result. |
Standard functionality as per note 1151957.
It only occurs if a hierarchy info object is in the rows i.e. 0PLANT. If the hierarchy is turned off, the error is resolved – however, this does not satisfy the user requirements
|
Changing the aggregation at CKF level to “Before Aggregation” resolves the problem.
Apply the following change: Open the query, drill to CKFs and uncheck “Calculation After Aggregation”
|
Generating reporting authorizations do not work | Program error caused by OSS note: 1634458 | Implement OSS note 1714370 |
Error when activating data in DSO.
ORA-14400
|
Program error. Activation of a DSO fails
|
Implement OSS note 1807028
Note: RSRV->All Elementary tests->”PSA Tests” will report the error and also “repair” the error. However, when the Activation is performed again, the error will re-appear. RSRV is therefore not a solution for the error.
|
Metadata repository service not active
|
RSA1, Select Metadata Repository, The following error is displayed:
URL http://sndbid10.onesteel.com:8020/SAP/BC
/WEBDYNPRO/SAP/RSO_METADATA_REPOSITORY call was terminated because the corresponding service is not available. Error “Service cannot be reached”
|
|
Data loaded is not visible for reporting in
InfoCubes |
Corrected/changed functionality in one of the Support Packs included in BW 7.3 SP 07.
As per SAP’s response to a customer message, raised for this issue: “This is the intended behaviour for 730 system”
|
Once all the changes were applied, generate the SE 16 list again and ensure no cubes are returned.
|
BEx Exit variable project components deleted |
T/C CMOD, the custom “Component” does not exist after the upgrade. Error “no component exists” is displayed.
The custom abap code is not lost however.
|
**Note. ENhancement
RSR00003 is not required – only enhancement RSR00001 and the related component need to be created. |
Inactive local chains cause process chains to fail |
RCA unknown.
The chains that are inactive are not consistent between clients i.e. not the same chains in development and QA.
|
|
No authorization to maintain routines (Start routines and transformation routines) |
Changed after the upgrade |
The following is required for Auth. S_DEVELOP:
Activity: 02
Package: BWROUT_TRFN
Object name: GP123
Object type: PROG
Authorization group:
$BWROUT _GROUP |
Locks on temporary table RSDD_TMPNM_ADM not deleted | Caused by a program error. | Implement note: 1669796 – RSDD_TMPNM_ADM:Lock conflict that cannot be removed in BW7.3 |
BW Stats loads fail with error ‘Characteristic value ‘20120321143760’ of characteristic 0TCTTIMSTMP is not TIMES-converted’ |
Caused by a change in the BW 7.3 |
Do this for each BW Stats update rule activated in the system that fails after the upgrade.
|
Auth. error when running a WebI report “No RFC authorization for function module “BAPI_IOBJ_GETDETAIL” |
Caused by a change in the BW 7.3 |
Add the following RFC authorizations to user/developer security roles:
|
0GLACCEXT hierarchy data load fails
with the following error: ‘00000610098 A’ of characteristic 0GLACCEXT is not ACCEX-converted
|
Caused by a change in the BW 7.3 |
|
The roll-up for InfoCube has terminated. | Caused by a program error in Note 1663614 – P29:BATCH:RSBATCH_CHECK_PROCESS:Yellow too long; Hold Procs which is part of BW 7.3 SP 07. |
Problem solution – implement SAP Note: 1708027 – P29:BATCH:Rolling up aggregates terminates with RSDD353. |
Error during assignment of Request ODSR_4SY8GZ4IU9G1DU6672D4RC2TU to Partition |
The value of field ‘PARTNO’ in PSA definition table ‘RSTSODS’ for PSA/Changelog table does not match with the value of the highest partition of the corresponding PSA/Changelog table. |
Implement SAP Note 1762200 Execute RS_PSA_PART_HIGH_VALUE_CHECK in repair mode |
When performing an F4 (lookup) on Plant in BEx Analyser, the following error is displayed:
Program error in class SAPMSSY1 method : |
Program error | Implement OSS Note: 1679791 |
Metadata repository graphical display not available
|
Program error |
This note was implemented but did not resolve the issues, and also produce new errors. Need a more extensive analysis, correction and test. |
Did you had a look to the Document - http://scn.sap.com/docs/DOC-7856 before you started the Upgrade?
Esspecially the Document - http://scn.sap.com/docs/DOC-30452 Upgrading to BW 7.3x?
Best Regards Roland
Moved to the BW space. Nice list.
very useful list and thanks for idea to share all contents at once place.
tons of thanks
Hi Stephen, Thanks for sharing your blog. This is very helpful!
We are in the midst of an upgrade and noticed the Before Aggregation Error on a calculated key figure based on a variable value using any aggregation other than standard. We cannot change our calculated key figure to use standard aggregation - is there a solution to this? A lot of our queries are using this functionality, we cannot change all of our queries. We have written a note but haven't recevied response yet.
see the Document - http://scn.sap.com/docs/DOC-30452
In the Upgrade Post Steps there is a Note which describes the new Behaviour. You can switch back to the old Behaviour
Best Regards Roland
steephan ,
Thank you for your document. Can you please tell me the link for the program, which you have used in the upgrade process.
Hi G.S
Happy to share the program - which program are you referring to? Can you refer to the solution/issue perhaps?
Regards
Hello Stephen Fogwill,
Thank you so much for this blog. This is very cool. I specifically love that it is SOLUTION oriented. This is so organised and well described.
Hi
After our SAP BW 7.3 upgrade I am getting below issue. I apply the solution below (uncheck " Calculation after aggregation" and no data appear (just X appear in all the field).
We were able to calculate Calculate Result as Standard Deviation but after upgrade it is not working.
Standard functionality as per note 1151957.
It only occurs if a hierarchy info object is in the rows i.e. 0PLANT. If the hierarchy is turned off, the error is resolved – however, this does not satisfy the user requirements
Changing the aggregation at CKF level to “Before Aggregation” resolves the problem.
Apply the following change: Open the query, drill to CKFs and uncheck “Calculation After Aggregation”
Hi,
This is also described in the "Upgrade Bible" - SAP NetWeaver 7.0 BI Upgrade Specifics for ABAP - Page 13.
Best Regards Roland
Very useful one.
Have anyone faced the Upgrade issue from BW 7.3 to 7.4, if yes then what is the solution?
Hi ,
Do we need upgrade ECC before going to upgrade BW 7.0 to 7.4? Present ECC version is ECC 6.0 EHP5 .
Hi,
No Upgrade of the SAP Source Systems for the Upgrade to SAP BW 7.40 is necessary.
Upgrade to SAP Business Warehouse 7.40 | SCN
Best Regards Roland
Thank for the information Ronald .
Hi,
Sorry for the late comment/question, but only now did I find this post
We just came across a situation where the RFC authorization was missing for function module “BAPI_IOBJ_GETDETAIL”.
Looking at the proposed solution, there's a repeated line:
Should one of these be of type "FUNC" instead of "FUGR" or is it just repeated?
Kind regards and thank you for the great post!
tao