1 Installing ASR 49 on MetaSolv Solution 6.2.x

This chapter explains how to install Access Service Request (ASR) 49 on MetaSolv Solution 6.2.x.

Pre-Installation Checklist

Ensure the following:

• You have installed MetaSolv Solution 6.2.x.

  For the specific MetaSolv Solution 6.2.x build numbers that support ASR 49, contact Oracle Global Customer Support.

• The following environmental variables are set:

  PATH= BEA_Home/jdk_version/bin $PATH
  BEA_HOME=/opt/m62Single/single/bea
  JAVA_HOME=/opt/m62Single/single/bea/jdk_version
  

  where:

  • BEA_Home is the path for the directory where Oracle WebLogic Server 10.3.1 is installed.

Installing ASR

To install ASR:

1. From MSLV_Home, enter the following command:

   java -jar Asr.releaseNo.buildNo_M62.jar
   

   where:

   • MSLV_Home is the directory in which the MetaSolv Solution software is installed.

   • releaseNo is the release version of ASR.

   • buildNo is the build number that contains the ASR installer.

   For example:

   java -jar Asr.R49_0_0.b32_M62.jar
   

   The Select MetaSolv home directory window appears.

2. From the Look In list, click the down arrow and select a directory in which the installation program files can be stored and used during the installation process, and then click Select.

   A directory named asr49installer is automatically created in the selected directory. Oracle recommends choosing your MSLV_Home directory for this task. MSLV_Home is the directory in which the MetaSolv Solution software is installed.

   The installation program auto-launches the installation process by invoking setup.sh (UNIX/Linux) or setup.cmd (Windows) in the MSLV_Home/asr49installer directory.

   The welcome screen for the MetaSolv Solution ASR installation appears.

3. Click Next.

   The Details window appears.

4. Enter the path and name of the MetaSolv Home directory, MetaSolv Domain directory, and MetaSolv Server directory or click Open to search for the directories.

5. Click Next.

   The Install Type window appears.

6. Select any one of the following installation types:

   • Install all ASR Files

   • Install Only ASR EAR File

   When prompted for the Install Type, if the environment is a clustered environment, you can choose an option to extract the .EAR file only. Use this option to extract the .EAR file on the administration server for deployment to separate managed servers. For a non-clustered environment, choose the option to install and deploy all files.

7. Click Next.

   The Install Summary window appears.

8. Click Finish.

9. (Perform this step only if you are installing in a clustered environment).

   1. Locate the loggingconfig_ASR49.xml file located in the MSLV_Home/managedserver/appserver/config directory, where managedserver is the WebLogic managed server.

   2. Rename the file to loggingconfig_cluster-ASR49.xml.

10. Restart the application server.

    If there are multiple servers running in the domain, all servers should be restarted before deploying the application from the Management Console.

    Note:

    If there are multiple servers running in the domain, you must run the ASR installation for each server instance.

11. Continue with the procedures in "Applying the Contents of the Stored Procedures and Prodfixsql Directories".

Applying the Contents of the Stored Procedures and Prodfixsql Directories

To apply the contents of the stored procedures and prodfixsql directories:

1. Run the pfixSQL_Master.sql file located in the MSLV_Home/server/appserver/sql/ASR49/prodfixsql directory that was created during the install to apply the contents of the ASR prodfixsql directory to the database.

   where:

   • MSLV_Home is the directory in which the MetaSolv Solution software is installed.

   • server is the name of the WebLogic server.

   MetaSolv created the single pfixSQL_Master.sql script to call all of the other SQL scripts delivered in the directory.

2. Run the asr_master.sql file located in the MSLV_Home/server/appserver/sql/ASR49/procs directory that was created during the installation to apply the contents of the ASR procs directory to the database.

   This file creates or replaces a series of stored procedures used in Ordering and Billing Forum (OBF) validation. These validations are for the Access Services Ordering Guidelines (ASOG) 48 and ASOG 49 versions. MetaSolv Solution created the single asr_master.sql script to call all of the other SQL scripts delivered in the directory.

3. Run DBHealth to recompile all invalid objects.

To run a higher ASR version on a computer that runs a lower version, you must apply the stored procedures and prodfixsql of the higher version.

For example, you may run ASR 49 on a computer where you installed an ASR 48 service pack and applied the associated stored procedures and prodfixsql. To run ASR 49 effectively, you must apply the stored procedures and prodfixsql for ASR 49 to override those you applied for the ASR 48 service pack.

Deploying ASR on the Application Server in a Single Server Environment

Deploying ASR on the application server in a single server environment involves the following steps:

• Undeploying the Existing ASR Application from the Application Server

• Deploying ASR Application on the Application Server

Undeploying the Existing ASR Application from the Application Server

To undeploy the existing ASR from the application server:

1. Start the WebLogic Server Administration Console using the following URL:

   http://ServerName:Port/console

   where:

   • ServerName is the name of the administration server.

   • Port is the administration server port number.

   For example:

   http://wplsunsrvxmlapi:7001/console

2. Enter the administration server user name and password when prompted and press Enter to log on.

3. Under Change Center, click Lock & Edit.

4. Expand the Domain Structure tree and click Deployments.

   The Summary of Deployments window appears.

5. On the Control tab, select ASR49.

6. From the Stop list, select Force Stop Now.

   Ensure that the state of the ASR 49 application has changed from Active to Prepared.

7. Select ASR49 and click Delete.

   The Delete Application Assistant window appears.

8. Click Yes.

   The ASR 49 application is undeployed.

Deploying ASR Application on the Application Server

Before you deploy ASR, ensure that the following server is running:

• Administration server

  If it is not running, start it using the following startup script:

  For UNIX:

  domain_directory/startServerName.sh

  For Windows:

  domain_directory/startServerName.cmd

  where:

  • domain_directory is the WebLogic server domain directory.

  • ServerName is the name of the administration server.

To deploy ASR on the application server:

1. Start the WebLogic Server Administration Console using the following URL:

   http://ServerName:Port/console

   where:

   • ServerName is the name of the administration server.

   • Port is the administration server port number.

   For example:

   http://wplsunsrvxmlapi:7001/console

2. Enter the administration server user name and password when prompted and press Enter.

3. Under Change Center, click Lock & Edit.

4. Expand the Domain Structure tree and click Deployments.

   The Summary of Deployments window appears.

5. On the Control tab, select Install.

   The Install Application Assistant window appears.

6. Under Current Location, navigate to the directory from which you want to deploy ASR 49 (for example, opt/metasolv/mslv01/appserver/deploy), select ASR49.ear, and then click Next.

   The Choose targeting style window appears.

7. Select Install this deployment as an application and click Next.

8. Under Source accessibility, select I will make the deployment accessible from the following location.

9. Click Finish.

10. Under Change Center, click Activate Changes.

11. Expand the Domain Structure tree and click Deployments.

    The Summary of Deployments window appears.

12. Select ASR49.

13. From the Start list, select Servicing all requests.

    The Start Application Assistant window appears.

14. Click Yes.

    Ensure that the state of the ASR 49 application has changed from Prepared to Active.

15. If you receive the following error in the appserver.mss.log file during ASR deployment,

    ”log4j: ERROR Attempted to append to closed appender named [XMLFileApp”
    

    Do the following:

    1. Open the loggingconfig.xml file located in the MSLV_Home/server/appserver/config directory, where server is the name of the WebLogic server.

    2. Remove the following entries:

       category name="cmm.ASR"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLogger"additivity="false"><level value ="error"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLevel"/>
       <appender-ref ref="XMLFileApp"/>
       </category>
       <category name="ASR"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLogger" additivity="false">
       <level value="error"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLevel"/>
       <appender-ref ref="XMLFileApp"/>
       </category>
       <category name="cmm.ASR"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLogger" additivity="false">
       <level value ="error"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLevel"/>
       <appender-ref ref="XMLFileApp"/>
       </category>
       

    3. Save and close the file.

Deploying ASR on the Application Server in a Clustered Environment

If the administration server for the domain is on a machine where no managed server process is running, you can run the ASR installer and select the option to only extract the .EAR file. The .EAR file must reside on the machine where the administration server is running in order to deploy to the managed servers in the domain.

Deploying ASR on the application server in a clustered server environment involves the following steps:

• Undeploying the Existing ASR Application from the Application Server

• Deploying ASR Application on the Application Server

Undeploying the Existing ASR Application from the Application Server

To undeploy the existing ASR from the application server:

1. Start the WebLogic Server Administration Console using the following URL:

   http://ServerName:Port/console

   where:

   • ServerName is the name of the administration server.

   • Port is the administration server port number.

   For example:

   http://wplsunsrvxmlapi:7001/console

2. Enter the administration server user name and password when prompted and press Enter.

3. Under Change Center, click Lock & Edit.

4. Expand the Domain Structure tree and click Deployments.

   The Summary of Deployments window appears.

5. On the Control tab, select cluster-ASR49.

6. From the Stop list, select Force Stop Now.

   Ensure that the state of the ASR 49 application has changed from Active to Prepared.

7. Select cluster-ASR49 and click Delete.

   The Delete Application Assistant window appears.

8. Click Yes.

   The ASR 49 application is undeployed.

Deploying ASR Application on the Application Server

Before you deploy ASR, ensure that the following servers are running:

• Administration server

  If it is not running, start it using the following startup script:

  For UNIX:

  domain_directory/startAdminServer.sh (for non-XML deployment)

  or

  domain_directory/startAdminServer_wli.sh (for XML deployment)

  For Windows:

  domain_directory/startAdminServer.cmd (for non-XML deployment)

  or

  domain_directory/startAdminServer_wli.cmd (for XML deployment)

• Managed server or servers

  Start any managed servers that are not running using the following startup script:

  For UNIX:

  domain_directory/startServerName.sh

  For Windows:

  domain_directory/startServerName.cmd

  where:

  • domain_directory is the WebLogic server domain directory.

  • ServerName is the name of the administration server.

To deploy ASR on the application server:

1. Start the WebLogic Server Administration Console using the following URL:

   http://ServerName:Port/console

   where:

   • ServerName is the name of the administration server.

   • Port is the administration server port number.

   For example:

   http://wplsunsrvxmlapi:7001/console

2. Enter the administration server user name and password when prompted and press Enter.

3. Under Change Center, click Lock & Edit.

4. Expand the Domain Structure tree and click Deployments.

   The Summary of Deployments window appears.

5. On the Control tab, select Install.

   The Install Application Assistant window appears.

6. Under Current Location, navigate to the directory from which you want to deploy ASR 49 (for example, opt/metasolv/mslv01/appserver/deploy), select cluster-ASR49.ear, and then click Next.

   The Choose targeting style window appears.

7. Select Install this deployment as an application and click Next.

   The Select deployment targets window appears.

8. Under Clusters, select All servers in the cluster.

9. Under Source accessibility, select I will make the deployment accessible from the following location.

10. Click Finish.

11. Under Change Center, click Activate Changes.

12. Expand the Domain Structure tree and click Deployments.

    The Summary of Deployments window appears.

13. Select cluster-ASR49.

14. From the Start list, select Servicing all requests.

    The Start Application Assistant window appears.

15. Click Yes.

    Ensure that the state of the ASR 49 application has changed from Prepared to Active.

16. If you receive the following error in the appserver.mss.log file during ASR deployment,

    ”log4j: ERROR Attempted to append to closed appender named [XMLFileApp”
    

    Do the following:

    1. Open the loggingconfig.xml file located in MSLV_Home/managedserver/appserver/config directory, where managedserver is the WebLogic managed server.

    2. Remove the following entries:

       category name="cmm.ASR"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLogger"additivity="false"><level value ="error"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLevel"/>
       <appender-ref ref="XMLFileApp"/>
       </category>
       <category name="ASR"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLogger" additivity="false">
       <level value="error"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLevel"/>
       <appender-ref ref="XMLFileApp"/>
       </category>
       <category name="cmm.ASR"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLogger" additivity="false">
       <level value ="error"
       class="com.metasolv.common.framework.logging.api.log4jext.MSLVLevel"/>
       <appender-ref ref="XMLFileApp"/>
       </category>
       

    3. Save and close the file.

Activating and Deactivating the ASR API

To activate the ASR API:

• Verify that the following entry exists in the gateway.ini file:

  ASR49SERVER=MetaSolv.CORBA.WDIASR49.WDIRoot,MetaSolv.WDIASR49.WDIRootImpl
  

To deactivate the ASR API:

• Place a semi-colon in front of the entry in the gateway.ini file as follows:

  ;ASR49SERVER=MetaSolv.CORBA.WDIASR49.WDIRoot,MetaSolv.WDIASR49.WDIRootImpl
  

  Note:

  You can remove previous ASR##SERVER entries from the gateway.ini file to remove the functionality of those ASOG versions.