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:
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 |
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
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. |