Installing and configuring Gateway servers and databases

The CwGatewayServer 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\MetaSolvTBS\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 runcwgatewayserver.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 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 runcwgatewayserver.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.
    -s Yes -sCWGatewayServer .ior Name of the IBM CrossWorlds Gateway Server IOR file.
    -e Yes admin@CW.com Database Administrator's e-mail ID.
    -m Yes cage Mail Server Name.
    -i For CwGatewayServer only GatewayEvents.ini See Setting up the .ini file for more information.

Copyright IBM Corp. 1997, 2003