(Glue-2108) v3.1 Process troubleshooting

Resource GET /processes/request/logs serve as the main way to get the job logs for a specific Request. It supports the following input parameters:

Parameter name	Description	Usage	Notes
requestID	Filtering based on Glue request ID	Mandatory	Array input possible

All input parameters are case insensitive.

Example of REST API call:

GET	http://servername:portnumber/dvd/glue/api/v3_1/processes/request/logs?sap-client=800

JSON body:

{ "requestID": [" 284860", " 284859"] }

Example of the REST API output:

{
  "requestLogs": [
    {
      "requestid": 284859,
      "logs": [
        {
          "timestamp": 20200330093306,
          "text": "Run ID 'GL00000039' selected for mass execution.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Run with ID 'GL00000039' initialized successfully.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Start of row based (number of records) split on table 'ZFC_SFLIGHT'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Limit value '1' rows.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Data of DDIC table 'ZFC_SFLIGHT' successfully splitted on field 'PAYMENTSUM'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Data source split into '1' portions.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "'1' tasks created for mass execution.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Start of mass execution.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Execution of run 'GL00000039' started.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Maximum number of parallel jobs: '3'",
          "type": "S"
        }
      ]
    },
    {
      "requestid": 284860,
      "logs": [
        {
          "timestamp": 20200330093307,
          "text": "Source field 'PRICE' and target field 'PRICE' have different data types.",
          "type": "W"
        },
        {
          "timestamp": 20200330093307,
          "text": "Start of extraction: '11:33:06'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Extraction process name: 'ZFC_VAR_TEST_P'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Load type: 'Full Load (Repair) Without Delta Update'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "User name: 'FCABADAJ'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093307,
          "text": "Glue Table 'ZFC_SFLIGHT_VAR' uses Transparent storage 'H_CNN_MSLB'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093308,
          "text": "Open cursor on source table 'ZFC_SFLIGHT' for data load.",
          "type": "S"
        },
        {
          "timestamp": 20200330093308,
          "text": "Cursor opened on source table 'ZFC_SFLIGHT'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093308,
          "text": "Processing package 1 (1 records)...",
          "type": "S"
        },
        {
          "timestamp": 20200330093308,
          "text": "1 records inserted to Glue table 'ZFC_SFLIGHT_VAR'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093308,
          "text": "Closing the Glue table 'ZFC_SFLIGHT_VAR'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093333,
          "text": "Commit successful.",
          "type": "S"
        },
        {
          "timestamp": 20200330093333,
          "text": "Glue table 'ZFC_SFLIGHT_VAR' closed successfully.",
          "type": "S"
        },
        {
          "timestamp": 20200330093333,
          "text": "1 records imported into table 'ZFC_SFLIGHT_VAR'.",
          "type": "S"
        },
        {
          "timestamp": 20200330093333,
          "text": "End of extraction: '11:33:33'.",
          "type": "S"
        }
      ]
    }
  ]
}

Message type values:

S Success, status
I Information
E Error
W Warning
A Abend (abnormal end of task)
X Exit

Functionality is implemented in the SAP class /DVD/GL_EXT2_API_LOGS.