Skip to Content
avatar image
Former Member

what are the prerequisites checks for upgrade

Hi all ...i want to know what all prerequisites checks we will do before upgarde from BW 3.5 to BI 7.0 ?Plz explain in detail..

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Aug 16, 2007 at 11:26 PM

    Hi:

    Look in SDN for many posts covering this topic.

    Read this famous document. It has stuff like closing Open Requests in Transactional Cube, Complete the loads of Delta Queues, etc.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/2e8e5288-0b01-0010-2ea8-bcd4df5084a7

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/2e8e5288-0b01-0010-2ea8-bcd4df5084a7

    U.P.Ram Chamarthy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 06:17 AM

    hi sid..

    chk this..

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10564d5c-cf00-2a10-7b87-c94e38267742

    pls look in sdn as there are many posts on this...

    here are a few..

    bw-35-to-bi-70-upgrade

    /message/3895272#3895272 [original link is broken]

    hope this helps..

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2007 at 06:23 AM

    Hi Sid,

    Might wish to take a look at some guides available here..

    https://websmp104.sap-ag.de/upgradenw2004s

    Note 893348 - Hardware and Software requirement for NW2004s

    Lessons Learnt - Upgrade

    1)Convert Data Classes of InfoCubes. Set up a new data class as described in SAP OSS Note 46272.

    2)Pay attention to the naming convention. Execute the RSDG_DATCLS_ASSIGN report.

    3)Run the report RSUPGRCHECK to activate objects.

    4)Upgrading ABAP and JAVA in parallel may cause issues. If there is no custom development on J2EE instance, it is recommended to drop the J2EE instance and re-install the latest J2EE instance after the upgrade.

    5)Apply SAP OSS Note 917999 if you include the Support Patch 6 with the upgrade or you will get the error at PARCONV_UPG phase. When you upgrade to a product containing Basis 700, the phase PARCONV_UPG terminates. You included Basis Support Packages up to package level 6 (SAPKB70006) in the upgrade. The job RDDGENBB_n terminates with the error RAISE_EXCEPTION. In addition to this, the syslog contains the short dump TSV_TNEW_PAGE_ALLOC_FAILED. The program SDB2FORA terminates in the statement "LOOP AT stmt_tab". An endless loop occurs when the system creates the database table QCM8TATOPGA.

    6)Apply the OSS note 917999 if you get the following error during PARCONV_UPG phase: PARCONV_UPG terminates with TSV_TNEW_PAGE_ALLOG_FAILED

    Critical OSS Notes:

    819655 – Add. Info: Upgrade to SAP NW 2004s ABAP Oracle

    820062 - Oracle Database 10g: Patchsets/Patches for 10.1.0

    839574 – Oracle database 10g: Stopping the CSS services ocssd.bin

    830576 – Parameter recommendations for Oracle 10g

    868681 – Oracle Database 10g: Database Release Check

    836517 – Oracle Database 10g: Environment for SAP Upgrade

    853507 – Usage Type BI for SAP Netwaevers 2004s

    847019 - BI_CONT 7.02: Installation and Upgrade Information

    818322 – Add. Info: Upgrade to SAP NW 2004s ABAP

    813658 - Repairs for upgrades to products based on SAP NW 2004s AS

    855382 – Upgrade to SAP SEM 6.0

    852008 – Release restrictions for SAP Netweaver 2004s

    884678 - System info shows older release than the deployed one

    558197 – Upgrade hangs in PARCONV_UPG

    632429 – The upgrade strategy for the add-on BI_CONT

    632429 - The upgrade strategy for the add-on FINBASIS

    570810 - The upgrade strategy for the add-on PI_BASIS

    632429 - The upgrade strategy for the add-on SEM-BW

    069455 - The upgrade strategy for the add-on ST-A/PI

    606041 - The upgrade strategy for the add-on ST-PI

    632429 - The upgrade strategy for the add-on WP-PI

    Post upgrade Steps :

    1. Read the Post Installation Steps documented in BW Component Upgrade Guide

    2. Apply the following SAP OSS Notes

    47019 - BI_CONT 7.02: Installation and Upgrade

    558197 - upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2

    836517 – Oracle Database 10g: Environment for SAP Upgrade

    3. Install the J2EE instance as Add-in to ABAP for BI 7.0 and apply the Support Patch that equivalent to ABAP Support Patch.

    4. Run SGEN to recompile programs.

    5. Install the Kernel Patch.

    6. Missing Variants - (also part of test script)

    look at the RSRVARIANT table in SE16. If it is empty, then you will definitely need to run RSR_VARIANT_XPRA

    program - RSR_VARINT_XPRA

    OSS -953346 and 960206 1003481

    7. Trouble Shootauthorizations

    820183 - New authorization concept in BI

    Complete any Logistic V3 data extractions and suspend V3 collection processes (SAP Notes 506694 and 510835)

    The V3 extraction delta queues must be emptied prior to the upgrade to avoid any possible data loss. V3 collector jobs should be suspended for the duration of the upgrade.They can be rescheduled after re-activation of the source systems upon completion

    Complete any data mart data extractions and suspend any data mart extractors (Note 506694 and 510835)

    All ODS data loads must be activated.Activate ODS Object requests. All ODS ‘M’ tables must be emptied prior to the upgrade as a new activate process is implemented.

    Regards,

    Anil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 09:36 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 09:40 AM

    Hi,

    <b>Upgrading to SAP NetWeaver 7.0 BI</b> - The Details doc.If not please take a look at it.

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/10564d5c-cf00-2a10-7b87-c94e38267742

    Please check these blogs for full details:

    Rolling out the New SAP NetWeaver 2004s BI Frontend Tools?page=last&x-showcontent=off&x-order=date [original link is broken]

    https://weblogs.sdn.sap.com/pub/wlg/4668?page=last&x-order=date [original link is broken]

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6a19f233-0e01-0010-6593-c47af5a8df3b

    Some Insights..

    <b>NW2004s Upgrade - Front-End Migration Strategy </b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=2331907

    <b>Migration of Data Sources</b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=3369391

    <b>Migration - Web Templates from 3.x to NW2004s </b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=2052465

    <b>Migration question</b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=2935414

    <b>Migration Transformation NW2004s Datasource</b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=3034054

    <b>Analysis Authorization Migration Question </b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=2537477

    <b>NW2004s Data flow</b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=3447826

    <b>Visual composer migration</b>

    https://forums.sdn.sap.com/click.jspa?searchID=3914335&messageID=3775098

    Rfer thez threads.. u will get good idea..

    Migration of BW 3.x Dataource to BI 7.0

    Migration of ECC BI Content to BW 2004s

    <b>Migrate Transformations</b>

    migration-for-bw-70

    Transformation Rules

    <b>For Data Flow:</b>

    http://help.sap.com/saphelp_nw2004s/helpdata/en/43/f00e2696d24c5fe10000000a155369/content.htm

    Rolling out the New SAP NetWeaver 2004s BI Frontend Tools

    Regards,

    Mani

    Add comment
    10|10000 characters needed characters exceeded