Skip to Content

BI System Refresh on Netweaver 04s

   Disable activities on the source BIP system

1.       Ensure that SAP is stopped on BIP.  Set  the SAP services to ‘Manual’.

 

2.       To prevent released jobs from running, edit the profile files and set parameter ‘rdisp/wp_no_btc’ to 0 on BI01.  The original value was 6 and will need to be set back to that BIP after the export.

3.       Map the SAP DVDs from drive to BIP

4.       Run sapinst.exe   

5.       Choose ‘Database and Central Instance Export’

 

image

  

6.       Specify the profile directory

image”  

 

7.       Specify the domain of the current user

   ”  

8.       Use database specific tools

 

image”  

9.       Specify the export directory

 

image”  

 

10.   Start the Export

  image

 

11.   Click OK after the Export has completed.

 image  

12.   Edit the BIP profile file and set the profile parameter back to 6.  Start SAP and set the services to ‘Automatic’ on BIP.

 

13 (a).   According to OSS note 886102, step 2.3, delete the source system assignments on BIQ before the System Copy using RSA1.  This step is necessary to delete all source-system-dependent objects from the source system (the objects of the old source system connection would interfere with the new source system connection, which will be created after the copy.

  image

14. Export the following folders as shown below on BIQ source System before the refresh from the BIQ Qaulity System:

Start OfflineCfgEditor.BAT

  image

1)      PropertySheet Instance.Properties.ID172872 

2)      Cluster_Data -> dispatcher -> ID7287200

3)      Cluster_Data ->server -> ID7287250

4)      Cluster_Data -> server -> ID7287200 -> cfg -> PropertySheet Element.Info ID172872

 

Export the following files before on BIQ System :

 

PropertySheet Instance.Properties.ID172872 

  image

 

           

Export the following folder by Clicking on the export Button

Cluster_Data -> dispatcher -> ID7287200

 image

Export the following folder by Clicking on the export Button

Cluster_Data -> server -> ID7287250

  image” 

 

 

Export the following Folderby Clicking on the export Button

Cluster_Data -> server -> ID7287200 -> cfg -> PropertySheet Element.Info ID172872

 

image 

 

 

15.   On BIQ, stop SAP and set the SAP services to ‘Manual’.

 

16.   Start SAPinst on BIQ.  Begin the ‘Central System Installation’

 image  

16.   Specify the location of the Java Component DVD

 

image

 

 

    

17.   Specify BIQ for the system ID

 

image

 

 

18.   Specify the password for all the userids as well as for biqadm and SAPServiceBIQ

 

image

 

20.   Specify ‘Homogeneous System Copy’

 

image”  

 

21.   Verify system ID ‘BIQ’

  image

 

22.   Specify the location of the export files

 

image 

 

23.   Enter J2EE_ADMIN, and the BIP password

image”  

24.   Enter  DDIC password

image”  

25.   Enter the location for the Kernel DVD

 

image”  

 

26.   Click on ‘Start’ at the ‘Parameter Summary’ window

 

image”  

 

27.   Installation Start:

 

 image  

 

 image  

 

Click ‘Ok’  and the application will exit out.

 

28.   Copy the BIP data files from BIP to BIQ and ensure that the SQL database comes up.

29.   Start the ABAP instance on BIQ, and perform the ABAP follow-up activities according to the System Copy Guide, beginning on page 95. 

30.   Perform the Java-related activities on BIQ, prior to starting the Java instance.

 

31.   Manually start the BIQ Java instance.

     

32.   We encountered Database Connectivity issues between SAP and SQL Server.

As per OSS note 551915,

Create User SAPMSSxpUser at OS level and assign administrators right to it

image

33.   In Enterprise Manager, create a new query

And paste the User_Change_BIQ file into it

Execute the same (PFA the screenshot above)

 

 

Although, you will get these error messages and I guess these messages are due to the compatiability of SQL 2005 with SQL 2000. But it serves our purpose and SAP does come up after running this script

34.   Now Start SAP

Abap would come up,

image

35.   Delete the old license

image

36.   Apply the new license using SLICENSE

 

37.   After applying License, Stop SAP

38.   Make the copy of the original SAP profiles after startup

image

 

 39.   Restore the latest profiles which were backed up before the Refresh

image

40.   Reboot the BI02 Server

41.   Check the Default Profile

42.   The Schema on refreshed BI system would be BIP and SAPBIPDB

We need to change it to BIQ and SAPBIQDB.

 

We need to use the following Script in SQL Server query analyzer to change the Schema:

USE BIQ

DECLARE @OldSchema AS varchar(255)

DECLARE @NewSchema AS varchar(255)

SET @OldSchema = ‘BIP’

SET @NewSchema = ‘BIQ’

DECLARE @sql AS varchar(MAX)

SET @sql = CHAR(13) + CHAR(10)

SELECT @sql = @sql + ‘ALTER SCHEMA [‘ + @NewSchema + ‘] TRANSFER [‘ + TABLE_SCHEMA + ‘].[‘ + TABLE_NAME + ‘]’     + CHAR(13) + CHAR(10)

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA = @OldSchema

PRINT @sql

EXEC (@sql)

43.   Execute the following Script

EXEC sp_grantlogin ‘biqadm’

exec sp_defaultdb ‘biqadm’, ‘BIQ’

EXEC sp_grantlogin ‘SAPServiceBIQ’

exec sp_defaultdb ‘SAPServiceBIQ’, ‘BIQ’

44.   Restart SAP and check the Dispatcher. It should not have a status of “Stopped”.

 

45.   Delete RFC Destinations belonging to BIP

image 

In Order to bring Java up:                       

Start ConfigTool.BATimage

  

Ensure that the password in the secure storage is set because the user masters belong to the production environment

  

image”     

Import the following folders as shown below on BIQ source System after the system copy has completed. (As exported in Step 13(b)).

Start OfflineCfgEditor.BAT

  image

1)      PropertySheet Instance.Properties.ID172872 

2)      Cluster_Data -> dispatcher -> ID7287200

3)      Cluster_Data ->server -> ID7287250

4)      Cluster_Data -> server -> ID7287200 -> cfg -> PropertySheet Element.Info ID172872

 

Import the following files before on Real BIQ System :

 

PropertySheet Instance.Properties.ID172872 

  image

 

           

Import the following folder by Clicking on the export Button

Cluster_Data -> dispatcher -> ID7287200

 image

Import the following folder by Clicking on the export Button

Cluster_Data -> server -> ID7287250

  image” 

 

 

Import the following Folderby Clicking on the export Button

Cluster_Data -> server -> ID7287200 -> cfg -> PropertySheet Element.Info ID172872

 

image 

   

5)      PropertySheet Instance.Properties.ID172872 

6)      Cluster_Data -> dispatcher -> ID7287200

7)      Cluster_Data ->server -> ID7287250

8)      Cluster_Data -> server -> ID7287200 -> cfg -> PropertySheet Element.Info ID172872

 

This is necassary to bring the J2EE engine on BIQ up after the System Copy

 

Delete SAPLogon Group

image

   

 

image     

Client Setting After Restore

 

image

 

Open the Client

image”                IN RSA1, Delete the Source Systems PRD and P11 

image

 

Choose Ignore

 image

  

 image

 

image

 

Choose Delete

  image

 

Delete PROD source system

 

 

   It would prompt you to press enter key for around 200 Odd times. Keep on pressing until all the Info packages are deleted 

 

 

Delete Logical System BIQCLNT001

  image

 

Run BDLS Transaction and enter the following parameters 

 image

 image 

 

   

Increase the parameter for Dialog Work Processes

 

 

image

 

Bring BIQ back into the BID transport domain.  In client 000, run STMS.  Note that IF the transport system is set to DOMAIN_BIQ, click on the ‘System Overview’ button, (with the yellow and two green boxes), and the on the resultant screen, choose to ‘Delete TMS Configuration’.

 

image

 

 

You will get the following message:

 

image

 

Click on the green checkmark.  If you do not get a pop-up to specify the DOMAIN_BID system, log out and log back into client 000, run STMS, and on the following pop-up:

  image

 

 

 

In testing, we found that if we enter ‘DOMAIN_BID’ in the above ‘Name’ field, and ‘Transport domain BID’ in the ‘Description’, the system brought in the domain information from BID as expected, but kept the DOMAIN CONTROLLER as BIQ when it should be BID.

 

So, ‘X’ out of this pop-up, and there is an opportunity to specify ‘BID’ as the domain controller.  BIQ will then connect to BID, and transfer the transport configuration over to BIQ. 

  Choose ‘Yes’ if you get the pop-up to ‘adjust the configuration of the system BIQ with the controller’. 

 

This is the configuration that should result on ALL three BI servers in STMS, button ‘System Overview’.

 

image

 

 

The BID transport domain is now visible in STMS on BIQ.

 

 

  

In RZ10, Import the BIQ_DVEBMGS01_BI02 instance profile, and ‘save’ and ‘activate’ the profile.  You will be prompted to stop and start SAP for the settings to take effect.

 

After importing and activating the instance profile that was created during the installation, and ensuring that SAP comes up, note that there are very few SAP processes configured in SM50:

 

image

 

In order to use the instance profile parameters that have been modified and increased over the years on BIQ, make a backup copy of the new instance profile at the Windows level, and create a copy of the BIQ_DVEBMGS01_BI02.Version23 instance profile.  Rename this copy to ‘BIQ_DVEBMGS01_BI02’.  This is the instance profile that is used in the live BIQ system.  The parameters on the live system should be consistent with newly-copied BIQ system.

 

After renaming this original file used on the live BIQ system, run RZ10 again and ‘Import’ this instance profile, ‘Save’ and restart SAP after the system says to restart SAP in order to ‘Activate’ the profile.

 
Additional ABAP Activities – Please also refer to page 95 – 106 of the SAP System Copy Guide, Follow-Up Activities Check the RFC connections (See in Copy Guide, 5.2.2 Performing Follow-up Activities for ABAP) 

Check the SAPOSS RFC connection in SM59.  The password for OSS_RFC is ‘CPIC’.

 

Create the BIQCLNT001 RFC as a prerequisite for the QAI Source System connection.  The easiest way to create this RFC is to us a copy of the BIQ RFC.

  image

 

 

 

Check to ensure that the QAS RFC for the QAI Source System connection exists.  Enter the BWREMOTE password.  On the clone BIQ system, this RFC will not work since the QAI system does not exist.

   

Under TCP/IP Connections, recreate the BIQ_BI02_BIQ portal RFC. 

  image

 

This RFC is required in order to connect to the JCO Connector, configured later in J2EE Admin Tool.

image

image

 

Further portal configuration is required in the J2EE Visual Administrator in order to have a successful Connection Test on BIQ.

 

 

 

Work with the functional team to test the jobs needed on the BIQ system.  Jobs may need to be copied, modified, or deleted on the refreshed BIQ system.

 

Check the consistency of the Temporary Sequential Objects (TemSe) by searching for files of TemSe objects for which no TemSe objects exist.  Run t-code SP12, pull-down  ‘TemSe Data Storage’, ‘Consistency Check’.

Choose ‘Delete All’ to delete all of the orphaned TemSe objects.

 

image 

 

After deleting the orphaned objects, run the Consistency Check again and verify the following result:

image

 

 

Adapt the definition of the printers to meet the new system requirements.  Run SPAD.

 

image

 

Update the ‘Spool  servers’ to bi02_BIQ_01 for the three printers listed, and investigate the necessity for the LP01 (?) printer.

   

Delete all of the old transactional RFC errors in SM58:

 

 image

 

In order to remove the ALEREMOTE entries, temporarily change the ALEREMOTE user from a SYSTEM user to a DIALOG user, log in as ALEREMOTE, and run SM58 and click the trash can multiple times until the errors are all deleted.

 

Change the ALEREMOTE back to a SYSTEM user.

 

Start transaction SECSTORE using ‘Check Entries’.  Click the ‘Execute’ button.  Note the passwords that will need to be updated for the RFCs.  After updating the passwords (for example, the ADS password is probably set, and should be changed. Also, for the ADS RFC, the Target Host needs to be changed from ‘bi01’ to ‘bi02’), run SECSTORE again.  When updating the passwords on the clone BIQ, these RFCs probably still will error out depending upon if they need to connect to a separate server.

 

image

 

Per SECSTORE, change the ALEREMOTE password

for RFC RS_IMPORT_POST_PROCESSING in SM59.   

 

Fix the password issues for the remaining RFCs after turning the system over to the FI team as these RFCs are not necessary for the running of the BW system.  Also, the clone BIQ will still not be able to verify the passwords since they cannot connect to servers other than the servers in the isolated network.

 

The SAP System Copy Guide mentions in step 14 – 16 on page 97 to adapt the operation mode time table, but since BIQ is a refreshed version of BIP, keep the updated time table from BIP in order to be consistent between the two systems.  On the original BIQ system prior to any refresh, there are no exceptions specified, which may or may not be correct.  If the refreshed BIQ causes problems due to this new time table, set it back to the following default

  

The time table copied from the BIP to the BIQ system is currently:

 

 

 

Using SU01, make the necessary modifications and authorization changes to the BIQ users copied from BIP.   Coordinate this with the security administrator.

 

Adapt other CCMS settings, for example, alert thresholds, reorganization parameters of CCMS table MONI, if required.

 

Use SE14 to delete all entries from tables TPFET and TPFHT.  These contain information about changes made to the profile of the BIP system.  Click on ‘Delete data’, and then ‘Activate and adjust database’.

 

image

  

Delete all entries from table TLOCK, using SE14.  This holds the repair requests from BIP.

 

Using SCC4, set the 001 client to the following settings:

 

 

 

Run SGEN in order to generate any missing ABAP program loads.  Since part of the refresh involved installing SAP, SGEN may need to run in order to recompile programs.

 

Checking the Target System

 

Perform initial consistency check SM28.  Currently, this transaction is failing, possibly because the number of batch processes is set to 0.  When ready, set the parameter ‘rdisp/wp_no_btc’ in the instance profile back to 6 and re-run SM28.

 

Check the system log, transaction SM21.

 Check the consistency of the database, transaction DB02. 

Perform server check, transaction SM51.

 

Have the functional team members run jobs SAPF190, RFUMSV00, RAGITT01, RAZUGA01, RAABGA01, and compare the results to those gained on the source system before the system copy.

 

Have the CO team run report 1SIP and compare the results to those gained on the source system before the system copy.

Replacing the PSEs in the Target System 

Replace all existing PSEs in the target systems with new ones which contain the new system’s information.

 

In t-code STRUSTSSO2, the PSE information on the refreshed BIQ reflects BIP copied information:

  image

 

 

Make a copy of the D:\usr\sap\BIQ\DVEBMGS01\sec \SAPSYS.pse file.

 

Select/highlight the Certificate CN=bi01.net certificate, and delete it.

 

Select/highlight the Logon Ticket CN=bi01.net, and delete it.

 

From the BIQ D:\certificate directory, copy the original bi02.net.crt certificate to your local Desktop\Username\SapWorkDir directory.

 

Click on the ‘Import Certificate’ button in the ‘Certificate’ section, and specify the bi02.net.crt file in the SapWorkDir directory

 

 

 

Click on the green checkmark to import the BIQ certificate.

Click on the ‘Add to Certificate List’ button to add this

certificate to the ‘Certificate List’.  Also,  click on ‘Add to ACL’ to add the certificate to the Access Control List (ACL).

  image 

 

image

 

 

 

 

After exiting out of STRUSTSSO2, the information in the ‘Certificate’ section will go away if STRUSTSSO2 is run again.

 

 

 

Configuration Steps for the SAP Java Connector

 

In the J2EE Visual Administrator, under BIQ, Server, Services, JCo RFC Provider, two ‘Available RFC Listeners’ under the ‘Runtime’ Tab exist named ‘BI01_PORTAL_BIQ’ and SAP.CCMS.J2EE.BIP’.  Since they have invalid information, they have stop signs next to them. 

 

 image

 

Highlight the BI01_PORTAL_BIP listener, and update the right pane indicating the correct ‘bi02’ host and Program ID ‘BI02_PORTAL_BIQ’.  Also, update the SAPJSF password to the master password, which was chosen during the installation.  Click on the ‘Set’ button at the bottom, and a new listener will be created next to the original BI01_PORTAL_BIP listener.  Click the ‘Remove’ button to remove the BI01_PORTAL_BIP listener.

 

image

 

 

Similarly, create an SAP.CCMS.J2EE.BIQ listener by highlighting the SAP.CCMS.J2EE.BIP entry, change the Program Id to ‘SAP.CCMS.J2EE.BIQ’, and the hostname entries to ‘bi02’ and clicking on ‘Set’.   Delete the SAP.CCMS.J2EE.BIP listener with the ‘Remove’ button.

 

 

 

Now, the two entries have a running man next to them.

 

Test the BIQ_BI02_BIQimage RFC created earlier in this document.

 

 

 

In Visual Admin, underKeystorage service,

 

Select TicketKeystore, Click on Create

image

 

Enter Country Name: US

Common Name:  BIQ

 

Entry Name: BIQ_BW

 

Repeat the steps for remaining entries:

BIQ_Certificate

SAPLogonKeypair

SAPLogonKeypair-cert

              

Reference Documentation 

·         http://service.sap.com/systemcopy

Download the Homogeneous System Copy Guide

·         http://service.sap.com/solutionmanagerbp

Download the SAP Best practices documentation for SAP System Landscape Copy for SAP Netweaver and SAP Solutions.

·         Refer the following OSS Notes:

Note 886102 – System Landscape Copy for SAP BW and NW BI

Note 551915  R3 wont start after database restore or database copy

Note 831812 – Config Tool shows incorrect parameters after System Copy

Note 610640 – sp_check_sap_login

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply