This chapter explains how to install Access Service Request (ASR) 58 on MetaSolv Solution 6.3.0.
Ensure the following:
You have installed MetaSolv Solution 6.3.0.
For the specific MetaSolv Solution 6.3.0 build numbers that support ASR 58, see MetaSolv Solution 6.3 What's New on Oracle Help Center:
The following environmental variables are set:
PATH={jdk1.8}/bin:$PATH
JAVA_HOME={jdk1.8}
where {jdk1.8} is the location where you installed JDK 1.8.
To install ASR:
From MSLV_Home, enter the following command:
java -jar Asr.R58_0_0.buildNo_M63.jar
where:
MSLV_Home is the directory in which the MetaSolv Solution software is installed.
buildNo is the build number that contains the ASR installer.
For example:
java -jar Asr.R58_0_0.b32_M63.jar
The Select MetaSolv home directory window appears.
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 asr58installer 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/asr58installer directory.
The welcome screen for the MetaSolv Solution ASR installation appears.
Click Next.
The Details window appears.
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.
Click Next.
The Install Type window appears.
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.
Click Next.
The Install Summary window appears.
Click Finish.
(Perform this step only if you are installing in a clustered environment).
Locate the loggingconfig_ASR58.xml file located in the MSLV_Home/managedserver/appserver/config directory, where managedserver is the WebLogic managed server.
Rename the file to loggingconfig_cluster-ASR58.xml and place it in every managed server's config directory at MSLV_Home\mslv01\appserver\config directory, where mslv01 is the name of the directory where the managed server is installed.
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.Continue with the procedures in "Applying the Contents of the Stored Procedures and Prodfixsql Directories".
To apply the contents of the stored procedures and prodfixsql directories:
Run the pfixSQL_Master.sql file located in the MSLV_Home/server/appserver/sql/ASR58/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.
The pfixSQL_Master.sql script calls all of the other SQL scripts delivered in the directory.
Run the asr_master.sql file located in the MSLV_Home/server/appserver/sql/ASR58/procs directory that was created during the installation to apply the contents of the ASR procs directory to the database.
The asr_master.sql 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) 57 and ASOG 58 versions. MetaSolv Solution created the single asr_master.sql script to call all of the other SQL scripts delivered in the directory.
Run the asr_audit_master.sql file located in the MSLV_Home/server/appserver/sql/ASR58/procs directory that was created during the installation to apply the contents of the ASR procs directory to the database.
The asr_audit_master.sql file creates or replaces a series of stored procedures and triggers used in capturing the audit and supplement history for ASR orders.
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 58 on a computer where you installed an ASR 57 service pack and applied the associated stored procedures and prodfixsql. To run ASR 58 effectively, you must apply the stored procedures and prodfixsql for ASR 58 to override those that you applied for the ASR 57 service pack.
Deploying ASR on the application server in a single server environment involves the following steps:
To undeploy the existing ASR from the application server:
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
Enter the administration server user name and password when prompted and press Enter to log on.
Under Change Center, click Lock & Edit.
Expand the Domain Structure tree and click Deployments.
The Summary of Deployments window appears.
On the Control tab, select ASR58.
From the Stop list, select Force Stop Now.
Ensure that the state of the ASR 58 application has changed from Active to Prepared.
On the Configuration tab, select ASR58 and click Delete.
The Delete Application Assistant window appears.
Click Yes.
The ASR 58 application is undeployed along with the ASR 58 Web Services.
Under Change Center, click Activate Changes.
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:
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
Enter the administration server user name and password when prompted and press Enter.
Under Change Center, click Lock & Edit.
Expand the Domain Structure tree and click Deployments.
The Summary of Deployments window appears.
On the Configuration tab, select Install.
The Install Application Assistant window appears.
Under Current Location, navigate to the directory from which you want to deploy ASR 58 (for example, opt/metasolv/mslv01/appserver/deploy), select ASR58.ear, and then click Next.
The Choose targeting style window appears.
Select Install this deployment as an application and click Next.
Under Source accessibility, select I will make the deployment accessible from the following location.
Click Finish.
Under Change Center, click Activate Changes.
Expand the Domain Structure tree and click Deployments.
The Summary of Deployments window appears.
On the Control tab, select ASR58.
From the Start list, select Servicing all requests.
The Start Application Assistant window appears.
Click Yes.
Ensure that the state of the ASR 58 application has changed from Prepared to Active, which indicates that the ASR 58 application has been deployed along with the ASR 58 Web Services.
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:
Open the loggingconfig.xml file located in the MSLV_Home/server/appserver/config directory, where server is the name of the WebLogic server.
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>
Save and close the file.
Restart the server.
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:
To undeploy the existing ASR from the application server:
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
Enter the administration server user name and password when prompted and press Enter.
Under Change Center, click Lock & Edit.
Expand the Domain Structure tree and click Deployments.
The Summary of Deployments window appears.
On the Control tab, select cluster-ASR58.
From the Stop list, select Force Stop Now.
Ensure that the state of the ASR 58 application has changed from Active to Prepared.
On the Configuration tab, select cluster-ASR58 and click Delete.
The Delete Application Assistant window appears.
Click Yes.
The ASR 58 application is undeployed along with the ASR 58 Web Services.
Under Change Center, click Activate Changes.
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 Windows:
domain_directory/startAdminServer.cmd
where:
domain_directory is the WebLogic server domain directory.
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:
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
Enter the administration server user name and password when prompted and press Enter.
Under Change Center, click Lock & Edit.
Expand the Domain Structure tree and click Deployments.
The Summary of Deployments window appears.
On the Configuration tab, select Install.
The Install Application Assistant window appears.
Under Current Location, navigate to the directory from which you want to deploy ASR 58 (for example, opt/metasolv/mslv01/appserver/deploy), select cluster-ASR58.ear, and then click Next.
The Choose targeting style window appears.
Select Install this deployment as an application and click Next.
The Select deployment targets window appears.
Under Clusters, select All servers in the cluster.
Under Source accessibility, select I will make the deployment accessible from the following location.
Click Finish.
Under Change Center, click Activate Changes.
Expand the Domain Structure tree and click Deployments.
The Summary of Deployments window appears.
On the Control tab, select cluster-ASR58.
From the Start list, select Servicing all requests.
The Start Application Assistant window appears.
Click Yes.
Ensure that the state of the ASR 58 application has changed from Prepared to Active, which indicates that the ASR 58 application has been deployed along with the ASR 58 Web Services.
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:
Open the loggingconfig.xml file located in MSLV_Home/managedserver/appserver/config directory, where managedserver is the WebLogic managed server.
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>
Save and close the file.
Restart the server.
To activate the ASR API:
Verify that the following entry exists in the gateway.ini file:
ASR58SERVER=MetaSolv.CORBA.WDIASR58.WDIRoot,MetaSolv.WDIASR58.WDIRootImpl
To deactivate the ASR API:
Place a semi-colon in front of the entry in the gateway.ini file as follows:
;ASR58SERVER=MetaSolv.CORBA.WDIASR58.WDIRoot,MetaSolv.WDIASR58.WDIRootImpl
Note:
You can remove previous ASR##SERVER entries from the gateway.ini file to remove the functionality of those ASOG versions.