(Glue-2411) v3.1 Process troubleshooting

Resource GET /processes/requests/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

Parameter name

Description

Usage

Notes

requestID

Filtering based on SNP 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/requests/logs?sap-client=clientnumber

GET

http://servername:portnumber/dvd/glue/api/v3_1/processes/requests/logs?sap-client=clientnumber

JSON body:

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

 

{ "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.