C.2 Table Information About Message Execution Log Management

(a) Execution log information table

• CSCMSG_Ccluster-name_EXECHISTORY table

  No.	Column name	Description	HiRDB type	ORACLE type	Use of index	Null value	UNIQUE attribute
  1	MESSAGE_ID	Unique identifier assigned to each message CSC + HCSC-server-name + current-time-(milliseconds) + serial-number	VARCHAR(75)	VARCHAR2(75)	Yes	Yes	None
  2	MESSAGE_ID_CSC_MSG	Unique identifier used to identify a message for the messaging infrastructure at the HCSC server MSG + HCSC-server-name + acceptance-type + current-time-(milliseconds) + serial-number	VARCHAR(84)	VARCHAR2(84)	None	Yes	None
  3	REQUEST_CSC_SERVER_NAME	Name of the HCSC server that accepted the request	VARCHAR(8)	VARCHAR2(8)	None	Yes	None
  4	HISTORY_KIND_DIRECTION	Direction of execution log collection Service Request Direction/Service Response Direction/Service Error/Service Fault	VARCHAR(26)	VARCHAR2(26)	None	Yes	None
  5	TIME_STAMP	Execution log collection time stamp (milliseconds)	TIMESTAMP(4)	NUMBER(20.0)	None	Yes	None
  6	REQUEST_SYNCHRONOUS_KIND	Requester's protocol WebService/SessionBean/MDB_WSR/MDB_DBQ	VARCHAR(16)	VARCHAR2(16)	None	Yes	None
  7	SERVICE_REQUEST_TYPE	Type of service requester ClientProgram (client program) BusinessProcess (business process)	VARCHAR(24)	VARCHAR2(24)	None	Yes	None
  8	REQUEST_USER_TEL_TYPE	Type of request user message XML/BINARY/ANY	VARCHAR(8)	VARCHAR2(8)	None	Yes	None
  9	RESPONSE_USER_TEL_TYPE	Type of reply user message XML/BINARY/ANY	VARCHAR(8)	VARCHAR2(8)	None	Yes	None
  10	SERVICE_NAME	Input service name from requester (request target service module)	MVARCHAR(64)	NVARCHAR2(64)	None	Yes	None
  11	CLIENT_ID	Correlation identifier used to identify the message specified by the client program	VARCHAR(255)	VARCHAR2(255)	Yes	Yes	None
  12	SERVICE_OPERATION_NAME	Operation of service modules required in the case of Synchronous (Web Services) Operation of WSDL <wsdl:operation>	MVARCHAR(255)	NVARCHAR2(255)	None	Yes	None
  13	REPLY_TO_QUEUE_NAME	Name of queue for receiving response for asynchronous service (MDB (WS-R), MDB (database queue))	VARCHAR(30)	VARCHAR2(30)	None	Yes	None
  14	ADAPTER_NAME	Service ID of service adapter or business process	VARCHAR(8)	VARCHAR2(8)	None	Yes	None
  15	ADAPTER_SERVICE_NAME	Service name Service name of service adapter Service name of business process Service group name	MVARCHAR(64)	NVARCHAR2(64)	None	Yes	None
  16	ADAPTER_CLUSTER_NAME	Information about the cluster to which the adapter belongs	VARCHAR(8)	VARCHAR2(8)	None	Yes	None
  17	ADAPTER_KIND	Type of service modules for adapter ServiceAdapter/BusinessProcess/ServiceGroup	VARCHAR(32)	VARCHAR2(32)	None	Yes	None
  18	ADAPTER_SYNCHRONOUS_KIND	Service module protocol at the adapter target WebService/SessionBean/MDB_WSR/MDB_DBQ/Custom	VARCHAR(16)	VARCHAR2(16)	None	Yes	None
  19	INTERLOCK_CSC_PROTOCOL	Protocol used for transfer to the linked HCSC server WebService/SessionBean/MDB_WSR	VARCHAR(32)	VARCHAR2(32)	None	Yes	None
  20	MESSAGE_ID_CSC_BP_ACTIVITY	Business process activity number (number used to identify a business process activity instance) No value: -1	INTEGER#1	NUMBER(10,0) #2	None	Yes	None
  21	MESSAGE_ID_CSC_BP_PROCESS	Process ID of business process	MVARCHAR(240)	NVARCHAR2(240)	None	Yes	None
  22	CSC_BP_REQUEST_TYPE	Type of requests for business processes REPLY_AFTER: Request for continuous execution after reply RECOVER: Request for process re-execution WAIT_AFTER: Request for process execution after wait	VARCHAR(32)	VARCHAR2(32)	None	Yes	None
  23	JMS_HEADER_JMS_MESSAGE_ID	JMS header JMSMessageID	VARCHAR(255)	VARCHAR2(255)	None	Yes	None
  24	JMS_HEADER_JMS_CORRELATION_ID	JMS header JMSCorrelationID	VARCHAR(255)	VARCHAR2(255)	None	Yes	None
  25	ROUTE_HISTORY	Information passed as route history (Displaying with a character string to which HCSC-server-name or service-ID is attached by '->')	VARCHAR(255)	VARCHAR2(255)	None	Yes	None
  26	ERROR_CODE	Error (Fault) information from a service module, business process, or custom adapter	MVARCHAR(4000)	NVARCHAR2(1333)	None	Yes	None
  27	USER_TEL_ORG_BINARY	User message	BINARY(2147483639)	LONG RAW	None	Yes	None
  28	OPTION1	Reserve 1	BINARY(2000)	RAW(2000)	None	Yes	None
  29	OPTION2	Reserve 2	BINARY(2000)	RAW(2000)	None	Yes	None
  30	OPTION3	Reserve 3	BINARY(2000)	RAW(2000)	None	Yes	None

  #1

  "SMALLINT" in versions prior to the version 08-10.

  Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "SMALLINT" because the area does not change.

  #2

  "NUMBER(5)" in versions prior to the version 08-10.

  Also, if overwrite installation is performed from a version prior to the version 08-10, the type is "NUMBER(5)" because the area does not change.