CPMPROCESS_ERROR



Column Section Top of Page


Table-level Detail

Description: Process Server Errors
Definition: When the Process Server encounters errors processing requests, those errors are written to this table.
Table Type: ACTIVITY





Column Detail - CPMPROCESS_ERROR


Column Name Type Null? Definition
DESTINATION_STEP_ID DOUBLE N This is the server where the request was trying to go when it encountered errors.
ERROR_CODE DOUBLE Y This is the current error status of this process.
ERROR_ID DOUBLE N This is the unique error number created by processing.
FORMAT_SCRIPT VARCHAR(30) Y This is the name of the script that formatted the target request when it got errors.
ORIGINAL_ERROR_CODE DOUBLE Y This is the error code before any recovery was attempted.
QUE_ID DOUBLE N This is the sequence in the error log for this processes errors. This number will wrap.
QUE_SEQ DOUBLE Y This is the unique number to identify this row in the cpmprocess_que table. It does not wrap.
RECOVER_SEQ DOUBLE Y This number represents the order in which the queued sequences will be recovered.
REQUEST_NUMBER DOUBLE N This is the unique number of the step whose process is waiting in the recover queue.
RETRY_ATTEMPTS DOUBLE Y This is the number of times the process server has tried to recover this process in the queue.
SERVICE VARCHAR(50) Y This is the name of the server that the process was attempting to send to when the error occurred.
SRVEXEC_STATUS DOUBLE Y This is the specific status returned by SRVEXEC.
TARGET_REQUEST_NUMBER DOUBLE Y This is the process that was being serviced when this error occurred.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


CPMPROCESS_QUE



Column Section Top of Page


Table-level Detail

Description: Process Server Request Queue
Definition: When the Process Server encounters errors processing requests, the request data is written to this table. Then, one or more cpmprocess_error records are written that point to each row on this table.
Table Type: ACTIVITY





Column Detail - CPMPROCESS_QUE


Column Name Type Null? Definition
MESSAGE LONGBLOB Y This contains the error information.
MESSAGE_SIZE DOUBLE Y This is the size of the error message.
NEXT_QUE_ID DOUBLE N This is the unique queue error ID in the table that followed this one.
QUE_ID DOUBLE N This is the unique ID in this table for this error.
QUE_SEQ DOUBLE Y This is the current position in the table waiting for recovery.
REQUEST_NUMBER DOUBLE Y This is the name of the step whose process was getting service when the error occurred.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.


REQUEST_PROCESSING



Column Section Relationship Section Top of Page


Table-level Detail

Description: Process Server Request Process Configuration
Definition: This is the configuration table for the Process Server. It determines based on inbound request number, what processing should occur when that request is received.
Table Type: REFERENCE





Column Detail - REQUEST_PROCESSING


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
DESTINATION_STEP_ID DOUBLE N This is the ID of the destination of the request through the process server
FORMAT_SCRIPT VARCHAR(30) Y This is the script that formats the request before being set to the process server. This is the script that will executed in order to format the data from the in bound request into the form of the out bound request. This script must be named PFMT_*.
FORWARD_OVERRIDE_IND DOUBLE Y This indicator will allow the request to the destination server to be forwarded back to the process server. In most cases this indicator will not be checked, because this scenario would have the characteristics of a loop. But if there is some condition that the destination needs to send back to the process server this indicator should be checked.
REPROCESS_REPLY_IND DOUBLE Y This field determines if the reply from the server perform should be processed. A value of 1 indicates it should, a value of 0 indicates it should not. The following rules apply to processing THE reply from servers in this manner. 1.The server has to be a RR (Request/Reply) type server. 2.The script handler will be named the same as the format script name with "_EPI" appended to the end of the name. 3.The data structures that are exposed are as follows The request and reply of the original
REQUEST_NUMBER DOUBLE N This is the unique request structure that the processes are being added to.
SEQUENCE DOUBLE N This is the number that identifies which order in the process a request will be executed.
SERVICE VARCHAR(50) Y This is will override the default service of the destination step. The destination could offer more that one service depending on the parameters being passed.
TARGET_REQUEST_NUMBER DOUBLE Y This is the number of a process in the processing chain for the request.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - REQUEST_PROCESSING


Child Column in REQUEST_PROCESSING(FK) Parent Table Name Parent Column Name
Parents: REQUEST_NUMBER REQUEST REQUEST_NUMBER