Installing and configuring Gateway servers and databases

The CwPSRGatewayServer, CwDLRGatewayServer, CwLSRGatewayServer, and CwPSRBillingGatewayServer are the gateway event handling servers. They must run on the same machine where the MetaSolv Application Server is running.

To set up the Gateway Servers:

  1. On the MetaSolv Application Server machine, create the following directories:
  2. Copy the following files from %ProductDir%\Connectors\MetaSolv\dependencies to the GWServer subdirectory on the MetaSolv Application Server machine:
  3. Start the MetaSolv Application Server.
  4. Set up event and archive tables:
    1. Create an Oracle database instance for the event and archive tables. The size of the database depends on your event and archive volume. A minimum of 2MB is recommended.
    2. Locate the Event_Table.sql script files in the %ProductDir%\connectors\MetaSolv\dependencies directory.
    3. Run the script in your new Oracle database instance to create event and archive tables.

    Table 1 describes the event and archive table schema.

    Table 1. Event and archive table schema

    Name Description Type Constraint
    event_id Internal identifier of the event NUMBER Primary key
    connector_id Unique ID of the connector for which the event is destined. This value is important when multiple connectors poll the same table NUMBER
    object_key Primary key of the business object. Multiple keys can be concatenated with a colon or other configurable delimiter, for example, 1000065:10056:23333 VARCHAR Not null
    object_name Name of the Business Object STRING Not null
    object_verb verb associated with the event STRING Not null
    event_priority Event priority (0 is the highest, n is the lowest); which the connector uses to pull events on a priority basis. The connector does not use this value to lower or raise priorities. NUMBER Not null
    event_time Date and time when the event occurred DATE Default current date/time (for archive table, actual event time)
    event_status This attribute is used only in the event table. 0 - Ready for poll 1 - Sent to InterChange Server 2 - Unsubscribed event 3 - In progress -1 = Error processing event -2 = Error sending event to the integration broker NUMBER Not null
    event_comment Name of the tasks that have been completed STRING
    archive_time Date and time when the event was archived (applies only to the archive table) DATE Archive date/time
  5. Locate runcwPSRgatewayserver.bat, runcwDLRgatewayserver.bat, runcwLSRgatewayserver.bat, and runcwpsrbillinggatewayserver.bat in the %ProductDir%\connectors\MetaSolv\dependencies directory. Edit the files to include the required path information and parameters as indicated in the file comments.

    The following example illustrates how to set the parameters in the .bat files. Remember to set the directories specific to your environment. Do not delete the comments provided in the .bat files. Table 2 describes the parameters in the Gateway Server batch files.

    setlocal
    set PATH=%PATH%
    set CROSSWORLDS=path to the CrossWorlds directory on the API Server 
    machine which was created earlier.
    

    REM name of the directory which contains the appserver.jar, 
    jbroker.jar, jbroker_stubs.jar,
    JBrokerLicenses.class, mail.jar and activation.jar
    set DEPENDENCIES=xxxx
    

    REM name of the directory which contains the jar of the gateway server
    set SOURCE_DIR=xxxx
    

    REM USER_NAME is the Event table user name
    set USER_NAME=system
    

    REM USER_NAME is the Event table password
    set PASSWORD=manager
    

    REM DATABASE_URL is the URL for the event table database
    set DATABASE_URL=xxxx
    

    REM EVENT_TABLE is the name of the Event table
    set EVENT_TABLE=xworlds_events
    

    REM GATEWAY_IOR is the name of the CrossWorlds gateway server IOR file
    set GATEWAY_IOR=CwGatewayServer.ior
    

    REM name of the MetaSolv server file
    set MSVLV_IOR=PSRServer.ior
    

    REM name of the EUB server file for MetaSolv 
    set MSLV_PSR_EVBIOR=PSREUBServer.IOR
    

    REM EMail ID of the database administrator
    set EMAIL_ID=xxxx
    

    REM INI_FILE_NAME is the name of the INI file which has the events names 
    and the BO names
    set INI_FILE_NAME=GatewayEvents.ini
    

    REM MAIL_SERVER is the name of the Mail Server
    set MAIL_SERVER=xxxx
    
  6. Save and close the files.
  7. Run runcwPSRgatewayserver.bat, runcwDLRgatewayserver.bat, runcwLSRgatewayserver.bat, and runcwpsrbillinggatewayserver.bat by double-clicking on their file icons.

    Table 2. Parameters for Gateway server batch files

    Parameter Required Example Description
    -u Yes -usystem Event table user name.
    -p Yes -pmanager Event table password.
    -n Yes -nevt SQL net connect string for event table database name.
    -t Yes -txworlds_events Event table name. The default value is xworlds_events.
    -e Yes admin@CW.com Database Administrator's e-mail ID.
    -m Yes cage Mail Server Name.
    -i Yes GatewayEvents.ini See Setting up the .ini file for more information.

Copyright IBM Corp. 1997, 2004