(Glue-2408) 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.