Closed
Description
03-13 11:42:09 DEBUG INIT [DPRUN0075847] GetRunListRequest public[metric_instance] Runlist=DPRUN0075848
03-13 11:42:09 INFO INIT [DPRUN0075847] MultiThreadScanner public[metric_instance] Runlist=DPRUN0075848
03-13 11:42:09 DEBUG INIT [DPRUN0075847] DateCalculator public[metric_instance] getDate(2025-03-11 17:00:00)=2025-03-11 17:00:00
03-13 11:42:09 DEBUG INIT [DPRUN0075847] AppConfigFactory public[metric_instance] jobConfig: {"sys_id":"4bffaf2c1bd06e105b6b1131b24bcb30","number":"DPRUN0075848","status":"READY","start":"2025-03-12 13:51:10","name":"sysapproval_approver","source":"sysapproval_approver","target":"sysapproval_approver","action":"UPDATE","autocreate":true,"since":"2025-03-11 17:00:00","filter":"sys_created_on>javascript:gs.dateGenerate('2023-09-30','23:59:59')^EQ"}
03-13 11:42:09 INFO INIT [DPRUN0075847] MultiThreadScanner public[metric_instance] {"sys_id":"4bffaf2c1bd06e105b6b1131b24bcb30","number":"DPRUN0075848","status":"READY","start":"2025-03-12 13:51:10","name":"sysapproval_approver","source":"sysapproval_approver","target":"sysapproval_approver","action":"UPDATE","autocreate":true,"since":"2025-03-11 17:00:00","filter":"sys_created_on>javascript:gs.dateGenerate('2023-09-30','23:59:59')^EQ"}
03-13 11:42:09 INFO REQUEST [DPRUN0075847] AppStatusLogger public[metric_instance] putRunStatus request={"runkey":"4bffaf2c1bd06e105b6b1131b24bcb30","status":"prepare"}
03-13 11:42:09 DEBUG REQUEST [DPRUN0075847] JsonRequest public[metric_instance] PUT https://******.service-now.com/api/x_108443_sndml/jobrunstatus/4bffaf2c1bd06e105b6b1131b24bcb30
03-13 11:42:09 DEBUG RESPONSE [DPRUN0075847] JsonRequest public[metric_instance] status="HTTP/1.1 200 OK" contentType=application/json;charset=UTF-8 len=457
03-13 11:42:09 DEBUG REQUEST [DPRUN0075847] AppStatusLogger public[metric_instance] putRunStatus response={"runkey":"4bffaf2c1bd06e105b6b1131b24bcb30","number":"DPRUN0075848","action":"UPDATE","status":"PREPARE","start":"2025-03-12 13:51:10","source":"sysapproval_approver","target":"sysapproval_approver","since":"2025-03-11 17:00:00","pagesize":"5000","filter":"sys_created_on>javascript:gs.dateGenerate('2023-09-30','23:59:59')^EQ","records_expected":null,"records_inserted":null,"records_updated":null,"records_deleted":null,"records_skipped":null}
03-13 11:42:09 DEBUG RESPONSE [DPRUN0075847] AppStatusLogger public[metric_instance] putRunStatus 4bffaf2c1bd06e105b6b1131b24bcb30 {"result":{"runkey":"4bffaf2c1bd06e105b6b1131b24bcb30","number":"DPRUN0075848","action":"UPDATE","status":"PREPARE","start":"2025-03-12 13:51:10","source":"sysapproval_approver","target":"sysapproval_approver","since":"2025-03-11 17:00:00","pagesize":"5000","filter":"sys_created_on>javascript:gs.dateGenerate('2023-09-30','23:59:59')^EQ","records_expected":null,"records_inserted":null,"records_updated":null,"records_deleted":null,"records_skipped":null}}
03-13 11:42:09 DEBUG RESPONSE [DPRUN0075847] AppStatusLogger public[metric_instance] setStatus 4bffaf2c1bd06e105b6b1131b24bcb30 {"runkey":"4bffaf2c1bd06e105b6b1131b24bcb30","number":"DPRUN0075848","action":"UPDATE","status":"PREPARE","start":"2025-03-12 13:51:10","source":"sysapproval_approver","target":"sysapproval_approver","since":"2025-03-11 17:00:00","pagesize":"5000","filter":"sys_created_on>javascript:gs.dateGenerate('2023-09-30','23:59:59')^EQ","records_expected":null,"records_inserted":null,"records_updated":null,"records_deleted":null,"records_skipped":null}
03-13 11:42:09 DEBUG INIT [DPRUN0075847] Resources DPRUN0075848[metric_instance] getReaderSession
03-13 11:42:09 INFO INIT [DPRUN0075847] ReaderSession DPRUN0075848[metric_instance] instance=https://******.service-now.com/ user=datapump.reader.public
03-13 11:42:09 DEBUG REQUEST [DPRUN0075847] JsonRequest DPRUN0075848[sys_user] GET https://******.service-now.com/api/now/table/sys_user?user_name=datapump.reader.public&sysparm_display_value=false&sysparm_exclude_reference_link=true
03-13 11:42:09 DEBUG RESPONSE [DPRUN0075847] JsonRequest DPRUN0075848[sys_user] status="HTTP/1.1 200 OK" contentType=application/json;charset=UTF-8 len=2729
03-13 11:42:09 DEBUG RESPONSE [DPRUN0075847] RestTableAPI DPRUN0075848[sys_user] get user_name=datapump.reader.public returned 1 records
03-13 11:42:09 DEBUG INIT [DPRUN0075847] Resources DPRUN0075848[sys_user] getGenerator
03-13 11:42:09 DEBUG INIT [DPRUN0075847] Resources DPRUN0075848[sys_user] getSchemaReader
03-13 11:42:09 DEBUG INIT [DPRUN0075847] Resources DPRUN0075848[sys_user] getAppSession
03-13 11:42:09 INFO INIT [DPRUN0075847] AppSession DPRUN0075848[sys_user] instance=https://******.service-now.com/ user=datapump.agent
03-13 11:42:09 DEBUG REQUEST [DPRUN0075847] JsonRequest DPRUN0075848[sys_user] GET https://******.service-now.com/api/x_108443_sndml/tableschema/sys_user
03-13 11:42:09 DEBUG RESPONSE [DPRUN0075847] JsonRequest DPRUN0075848[sys_user] status="HTTP/1.1 200 OK" contentType=application/json;charset=UTF-8 len=7810
03-13 11:42:09 INFO INIT [DPRUN0075847] Resources DPRUN0075848[sys_user] schemaReader=AppSchemaReader
03-13 11:42:09 INFO INIT [DPRUN0075847] Generator DPRUN0075848[sys_user] dialect=postgresql schema=public namecase=LOWER namequotes=DOUBLE autocommit=true
03-13 11:42:09 INFO INIT [DPRUN0075847] DatabaseWrapper DPRUN0075848[sys_user] database=jdbc:postgresql://localhost/servicenow-gbq-stg_db GMT user=app schema=public
03-13 11:42:09 INFO INIT [DPRUN0075847] Generator DPRUN0075848[sys_user] SET TIME ZONE 'UTC'
03-13 11:42:09 DEBUG INIT [DPRUN0075847] Resources DPRUN0075848[sys_user] getAppSession
03-13 11:42:09 INFO
4987
INIT [DPRUN0075847] WorkerPool DPRUN0075848[sys_user] submit DPRUN0075848
03-13 11:42:09 INFO PROCESS [DPRUN0075847] WorkerPool DPRUN0075848[sys_user] 1 active jobs
03-13 11:42:10 DEBUG FINISH [main] WorkerPool public[] Begin stop
03-13 11:42:10 INFO FINISH [main] WorkerPool public[] End stop
Metadata
Metadata
Assignees
Labels
No labels