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 |