Information 1/20/2022 12:42:09 PM Preparing to execute: FTPALL-TO-R4 Information 1/20/2022 12:42:11 PM Executing Package: System Check Information 1/20/2022 12:42:11 PM Executing Package: VOIP Circuit DOWN Information 1/20/2022 12:42:11 PM Executing PING Server: Greensboro att-01 Information 1/20/2022 12:42:12 PM Done! Information 1/20/2022 12:42:12 PM Executing PING Server: Greensboro Charter-01 Information 1/20/2022 12:42:12 PM Done! Information 1/20/2022 12:42:12 PM Executing PING Server: Eatonton Charter-01 Information 1/20/2022 12:42:12 PM Done! Information 1/20/2022 12:42:13 PM Executing PING Server: Utah Comcast-01 Information 1/20/2022 12:42:14 PM Done! Information 1/20/2022 12:42:14 PM Executing PING Server: a2bf-app3 Information 1/20/2022 12:42:14 PM Done! Information 1/20/2022 12:42:14 PM Executing PING Server: a2bf-web1 Information 1/20/2022 12:42:14 PM Done! Information 1/20/2022 12:42:15 PM Executing PING Server: a2bf-wmsapp-03 Information 1/20/2022 12:42:15 PM Done! Information 1/20/2022 12:42:15 PM Executing Package: EWISE System Check Information 1/20/2022 12:42:16 PM Executing PING Server: Ping a2bf-wmsapp-02 Information 1/20/2022 12:42:16 PM Done! Information 1/20/2022 12:42:16 PM Executing PING Server: Ping a2bf-wmsdb Information 1/20/2022 12:42:16 PM Done! Information 1/20/2022 12:42:17 PM Executing PING Server: Ping a2bf-sql1 Information 1/20/2022 12:42:17 PM Done! Information 1/20/2022 12:42:17 PM Executing PING Server: ping a2bf-web1 Information 1/20/2022 12:42:18 PM Done! Information 1/20/2022 12:42:18 PM Executing PING Server: Ping Server a2bf-ftp-01 Information 1/20/2022 12:42:18 PM Done! Information 1/20/2022 12:42:19 PM Executing PING Server: Ping Server a2bf-ftps-02 Information 1/20/2022 12:42:19 PM Done! Information 1/20/2022 12:42:19 PM Executing PING Server: Ping Server a2bf-adsi Information 1/20/2022 12:42:19 PM Done! Information 1/20/2022 12:42:20 PM Executing PING Server: Ping Server a2bf-app3 Information 1/20/2022 12:42:20 PM Done! Information 1/20/2022 12:42:20 PM Executing Check Connection Information 1/20/2022 12:42:20 PM Connection Name: R4WMSIMP Information 1/20/2022 12:42:20 PM Connection Type is: ODBC Information 1/20/2022 12:42:20 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:42:20 PM Done! Information 1/20/2022 12:42:21 PM Executing Check Connection Information 1/20/2022 12:42:21 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:42:21 PM Connection Type is: ODBC Information 1/20/2022 12:42:21 PM Source DSN: r4wms72-64b Information 1/20/2022 12:42:21 PM Done! Information 1/20/2022 12:42:21 PM Executing File Operation: delete D:\ETLDATA\System\Scheduleoff.csv Information 1/20/2022 12:42:21 PM Path: D:\ETLDATA\System\ Information 1/20/2022 12:42:21 PM Mask: Scheduleoff.csv Information 1/20/2022 12:42:21 PM Path Is Valid: True Information 1/20/2022 12:42:21 PM Include Directory: False Information 1/20/2022 12:42:21 PM In Sub Folders: False Information 1/20/2022 12:42:21 PM Attributes: ReadOnly Information 1/20/2022 12:42:21 PM Attribute: Hidden Information 1/20/2022 12:42:21 PM Attribute: SysFile Information 1/20/2022 12:42:21 PM Attribute: aArchive Information 1/20/2022 12:42:21 PM File Age: 30 Information 1/20/2022 12:42:21 PM Which File: 0 Error 1/20/2022 12:42:21 PM Could not find any files Information 1/20/2022 12:42:22 PM Executing Sql Check Data: verify schedule on Information 1/20/2022 12:42:22 PM Connection Name: Information 1/20/2022 12:42:22 PM Connection Type is: Unknown Information 1/20/2022 12:42:22 PM Source File(s): Information 1/20/2022 12:42:22 PM Using Following Sql: select count(*) from a2bf_etl9_prod.dbo.SCHEDULE where ENABLE_EXECUTION = 0 and SCHEDULE_ID in (45,46,47,48,77, 1145,1146,1149,1151,1152,1153,1174) Error 1/20/2022 12:42:22 PM verify schedule on, connection does not exist Information 1/20/2022 12:42:22 PM Executing Package: Future Date Orders Information 1/20/2022 12:42:22 PM Executing Sql Script: Future Date Orders - Update Group Information 1/20/2022 12:42:23 PM Connection Name: R4WMSIMP Information 1/20/2022 12:42:23 PM Connection Type is: ODBC Information 1/20/2022 12:42:23 PM Executing Sql Check Data: Future Date Orders - Check REL Information 1/20/2022 12:42:23 PM Connection Name: R4WMSIMP Information 1/20/2022 12:42:23 PM Connection Type is: ODBC Information 1/20/2022 12:42:23 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:42:23 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wOrder WHERE ReqDate > SYSDATE AND AllocationGroup > 6 AND StatusCode IN ('REL','WFI') AND CarrierID NOT IN ('XXX','CXL','LTL') AND SYSTIME BETWEEN '08:30:00:00' AND '17:30:00:00' AND SenderId NOT LIKE '%DC%' AND DAYOFWEEK(SYSDATE) BETWEEN 2 AND 6 Error 1/20/2022 12:42:25 PM First Field is less or equals to zero Information 1/20/2022 12:42:25 PM Executing Check Connection Information 1/20/2022 12:42:25 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:42:25 PM Connection Type is: ODBC Information 1/20/2022 12:42:25 PM Source DSN: r4wms72-64b Information 1/20/2022 12:42:25 PM Done! Information 1/20/2022 12:42:26 PM Executing Check Connection Information 1/20/2022 12:42:26 PM Connection Name: R4WMSIMP Information 1/20/2022 12:42:26 PM Connection Type is: ODBC Information 1/20/2022 12:42:26 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:42:26 PM Done! Information 1/20/2022 12:42:26 PM Executing Check Connection Information 1/20/2022 12:42:27 PM Connection Name: R4WMSIMP Information 1/20/2022 12:42:27 PM Connection Type is: ODBC Information 1/20/2022 12:42:27 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:42:27 PM Done! Information 1/20/2022 12:42:27 PM Executing Sql Check Data: Unprocessed HALT Information 1/20/2022 12:42:28 PM Connection Name: ETLWms-Read Information 1/20/2022 12:42:28 PM Connection Type is: ODBC Information 1/20/2022 12:42:28 PM Source DSN: it-r4wms-read-64b Information 1/20/2022 12:42:28 PM Using Following Sql: select count(*) from pub.wimporter_a2b where processed <> '1' Error 1/20/2022 12:42:28 PM First Field is less or equals to zero Information 1/20/2022 12:42:28 PM Executing Package: A2BF Witem Information 1/20/2022 12:42:29 PM Executing Import: witem Information 1/20/2022 12:43:52 PM Processed: 39474 Records Information 1/20/2022 12:43:52 PM Errors: 0 Information 1/20/2022 12:43:52 PM Records per second: 485 Information 1/20/2022 12:43:52 PM Execution of Import Script: witem has completed Information 1/20/2022 12:43:53 PM Executing Import: a2bf witem qtyonhand Information 1/20/2022 12:43:55 PM Processed: 7 Records Information 1/20/2022 12:43:55 PM Errors: 0 Information 1/20/2022 12:43:55 PM Records per second: 7 Information 1/20/2022 12:43:55 PM Execution of Import Script: a2bf witem qtyonhand has completed Information 1/20/2022 12:43:55 PM Executing Package: Inbound Files Information 1/20/2022 12:43:56 PM Executing Package: IN-GENERIC Information 1/20/2022 12:43:56 PM Checking File(s): Generic import file check Information 1/20/2022 12:43:56 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Generic\ Information 1/20/2022 12:43:56 PM Mask: *.csv Information 1/20/2022 12:43:56 PM Path Is Valid: True Information 1/20/2022 12:43:56 PM Include Directory: False Information 1/20/2022 12:43:56 PM In Sub Folders: False Information 1/20/2022 12:43:56 PM Attributes: ReadOnly Information 1/20/2022 12:43:56 PM Attribute: Hidden Information 1/20/2022 12:43:56 PM Attribute: SysFile Information 1/20/2022 12:43:56 PM Attribute: aArchive Information 1/20/2022 12:43:56 PM File Age: 0 Information 1/20/2022 12:43:56 PM Which File: 0 Error 1/20/2022 12:43:56 PM Could not find any files Information 1/20/2022 12:43:56 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Generic\*.csv Error 1/20/2022 12:43:56 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Generic\*.csv Information 1/20/2022 12:43:56 PM Executing Check Connection Information 1/20/2022 12:43:56 PM Connection Name: bi-wms-read Information 1/20/2022 12:43:56 PM Connection Type is: ODBC Information 1/20/2022 12:43:56 PM Source DSN: bi-wms-read-64b Information 1/20/2022 12:43:56 PM Done! Information 1/20/2022 12:43:56 PM Checking File(s): Check File olxinb Information 1/20/2022 12:43:56 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ Information 1/20/2022 12:43:56 PM Mask: *.csv Information 1/20/2022 12:43:56 PM Path Is Valid: True Information 1/20/2022 12:43:56 PM Include Directory: False Information 1/20/2022 12:43:56 PM In Sub Folders: False Information 1/20/2022 12:43:56 PM Attributes: ReadOnly Information 1/20/2022 12:43:56 PM Attribute: Hidden Information 1/20/2022 12:43:56 PM Attribute: SysFile Information 1/20/2022 12:43:56 PM Attribute: aArchive Information 1/20/2022 12:43:56 PM File Age: 0 Information 1/20/2022 12:43:56 PM Which File: 0 Information 1/20/2022 12:43:56 PM Found: 1 File(s) Information 1/20/2022 12:43:56 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\*.csv Information 1/20/2022 12:43:56 PM File(s) exists: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\*.csv Information 1/20/2022 12:43:56 PM Executing Package: IN-OLX Information 1/20/2022 12:43:57 PM Checking File(s): Check OLX files exist Information 1/20/2022 12:43:57 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ Information 1/20/2022 12:43:57 PM Mask: *.csv Information 1/20/2022 12:43:57 PM Path Is Valid: True Information 1/20/2022 12:43:57 PM Include Directory: False Information 1/20/2022 12:43:57 PM In Sub Folders: False Information 1/20/2022 12:43:57 PM Attributes: ReadOnly Information 1/20/2022 12:43:57 PM Attribute: Hidden Information 1/20/2022 12:43:57 PM Attribute: SysFile Information 1/20/2022 12:43:57 PM Attribute: aArchive Information 1/20/2022 12:43:57 PM File Age: 0 Information 1/20/2022 12:43:57 PM Which File: 0 Information 1/20/2022 12:43:57 PM Found: 1 File(s) Information 1/20/2022 12:43:57 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\*.csv Information 1/20/2022 12:43:57 PM File(s) exists: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\*.csv Information 1/20/2022 12:43:57 PM Executing Import: Filesystem In-OLX Information 1/20/2022 12:43:58 PM Processed: 1 Records Information 1/20/2022 12:43:58 PM Errors: 0 Information 1/20/2022 12:43:58 PM Records per second: 13 Information 1/20/2022 12:43:58 PM Execution of Import Script: Filesystem In-OLX has completed Information 1/20/2022 12:43:58 PM Executing File Operation: move tobe processed Information 1/20/2022 12:43:58 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ Information 1/20/2022 12:43:58 PM Mask: *.csv Information 1/20/2022 12:43:58 PM Path Is Valid: True Information 1/20/2022 12:43:58 PM Include Directory: False Information 1/20/2022 12:43:58 PM In Sub Folders: False Information 1/20/2022 12:43:58 PM Attributes: ReadOnly Information 1/20/2022 12:43:58 PM Attribute: Hidden Information 1/20/2022 12:43:58 PM Attribute: SysFile Information 1/20/2022 12:43:58 PM Attribute: aArchive Information 1/20/2022 12:43:58 PM File Age: 30 Information 1/20/2022 12:43:58 PM Which File: 0 Information 1/20/2022 12:43:58 PM Found: 1 File(s) Information 1/20/2022 12:43:58 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\All_Clients_A2BFulfillment_20220120123034.csv into \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ToBeProcessed Information 1/20/2022 12:43:58 PM Executing Import: OLX Information 1/20/2022 12:44:00 PM Processed: 1 Records Information 1/20/2022 12:44:00 PM Errors: 0 Information 1/20/2022 12:44:00 PM Records per second: 6 Information 1/20/2022 12:44:00 PM Execution of Import Script: OLX has completed Information 1/20/2022 12:44:00 PM Executing Package: In-OLX-Customers Information 1/20/2022 12:44:01 PM Executing Sql Check Data: In-OLX-Data-Check Information 1/20/2022 12:44:01 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:01 PM Connection Type is: ODBC Information 1/20/2022 12:44:01 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:01 PM Using Following Sql: select count(*) from pub.wimporter_a2b where ((processed <> 1) or(processed = 1 and lotid = 'olxhld')) Information 1/20/2022 12:44:01 PM First Field is bigger than zero Information 1/20/2022 12:44:01 PM Executing Sql Script: OLX HANEQU SQL Information 1/20/2022 12:44:01 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:01 PM Connection Type is: ODBC Information 1/20/2022 12:44:02 PM Executing Sql Script: OLX BOSTON SQL Information 1/20/2022 12:44:02 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:02 PM Connection Type is: ODBC Information 1/20/2022 12:44:02 PM Executing Sql Script: OLX RETCAR SQL Information 1/20/2022 12:44:03 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:03 PM Connection Type is: ODBC Information 1/20/2022 12:44:03 PM Executing Sql Script: OLX Willab SQL Information 1/20/2022 12:44:03 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:03 PM Connection Type is: ODBC Information 1/20/2022 12:44:04 PM Executing Sql Script: OLX Genmar SQL Information 1/20/2022 12:44:04 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:04 PM Connection Type is: ODBC Information 1/20/2022 12:44:06 PM Executing Package: OLX-JUNESB IN Information 1/20/2022 12:44:06 PM Executing Sql Script: OLX JUNESB Information 1/20/2022 12:44:06 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:06 PM Connection Type is: ODBC Information 1/20/2022 12:44:07 PM Executing Sql Script: JUNESB_Insert Information 1/20/2022 12:44:07 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:07 PM Connection Type is: ODBC Information 1/20/2022 12:44:08 PM Executing Package: OLX-JUNEVL IN Information 1/20/2022 12:44:08 PM Executing Sql Script: OLX JUNEVL Information 1/20/2022 12:44:08 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:08 PM Connection Type is: ODBC Information 1/20/2022 12:44:09 PM Executing Sql Script: JUNEVL_Insert Information 1/20/2022 12:44:09 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:09 PM Connection Type is: ODBC Information 1/20/2022 12:44:10 PM Executing Sql Script: JUNEVL_Insert_Supplements Information 1/20/2022 12:44:10 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:10 PM Connection Type is: ODBC Information 1/20/2022 12:44:11 PM Executing Package: OLX-Parkav-In Information 1/20/2022 12:44:11 PM Executing Sql Script: PARKAV SQL Information 1/20/2022 12:44:11 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:11 PM Connection Type is: ODBC Information 1/20/2022 12:44:12 PM Executing Sql Check Data: OLX rush order error test Information 1/20/2022 12:44:12 PM Connection Name: bi-wms-read Information 1/20/2022 12:44:12 PM Connection Type is: ODBC Information 1/20/2022 12:44:12 PM Source DSN: bi-wms-read-64b Information 1/20/2022 12:44:12 PM Using Following Sql: select count(*) from pub.wimporter_a2b WHERE custid = 'parkav' and proofnumber = 'olxrush' AND processed <> 1 Error 1/20/2022 12:44:12 PM First Field is less or equals to zero Information 1/20/2022 12:44:12 PM Executing Sql Script: PARKAV SQL02 Information 1/20/2022 12:44:12 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:12 PM Connection Type is: ODBC Information 1/20/2022 12:44:13 PM Executing Package: OLX-AKIDAH IN Information 1/20/2022 12:44:13 PM Executing Sql Script: AKIDAH SQL Information 1/20/2022 12:44:13 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:13 PM Connection Type is: ODBC Information 1/20/2022 12:44:14 PM Executing Sql Check Data: Check AKIDAH Fraudulent Orders Information 1/20/2022 12:44:14 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:14 PM Connection Type is: ODBC Information 1/20/2022 12:44:14 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:14 PM Using Following Sql: SELECT COUNT(*) FROM pub.wimporter_a2b WHERE custid = 'AKIDAH' AND processed <> 1 AND AUX4 = 'OLX' --AND shiptoname IN ('JAEHO KIM','JOON SOO CHANG') AND address1 IN ('312 CHERRY LANE #KS57796','5510 NE COURIER CT STE 100') AND city IN ('NEW CASTLE','PORTLAND') AND state IN ('DE','OR') Error 1/20/2022 12:44:14 PM First Field is less or equals to zero Information 1/20/2022 12:44:15 PM Executing Check Connection Information 1/20/2022 12:44:15 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:15 PM Connection Type is: ODBC Information 1/20/2022 12:44:15 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:15 PM Done! Information 1/20/2022 12:44:15 PM Executing Sql Script: OLX LIFSEA SQL Information 1/20/2022 12:44:15 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:15 PM Connection Type is: ODBC Information 1/20/2022 12:44:16 PM Executing Sql Script: OLX STRUNO SQL Information 1/20/2022 12:44:16 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:16 PM Connection Type is: ODBC Information 1/20/2022 12:44:17 PM Executing Sql Script: OLX ESNTLS SQL Information 1/20/2022 12:44:17 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:17 PM Connection Type is: ODBC Information 1/20/2022 12:44:17 PM Executing Sql Script: FISHER SQL Information 1/20/2022 12:44:17 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:17 PM Connection Type is: ODBC Information 1/20/2022 12:44:18 PM Executing Sql Script: OLX STELTH SQL Information 1/20/2022 12:44:18 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:18 PM Connection Type is: ODBC Information 1/20/2022 12:44:18 PM Executing Sql Script: OLX BANJOM SQL Information 1/20/2022 12:44:19 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:19 PM Connection Type is: ODBC Information 1/20/2022 12:44:19 PM Executing Sql Script: OLX LEVOIT SQL Information 1/20/2022 12:44:19 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:19 PM Connection Type is: ODBC Information 1/20/2022 12:44:20 PM Executing Sql Script: Release-Final Clean OLX customers Information 1/20/2022 12:44:20 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:20 PM Connection Type is: ODBC Information 1/20/2022 12:44:21 PM Executing Sql Script: Send to hold incomplete orders Information 1/20/2022 12:44:21 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:21 PM Connection Type is: ODBC Information 1/20/2022 12:44:21 PM Executing Sql Check Data: Check Incomplete Orders Information 1/20/2022 12:44:22 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:22 PM Connection Type is: ODBC Information 1/20/2022 12:44:22 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:22 PM Using Following Sql: SELECT COUNT(*) FROM pub.wimporter_a2b WHERE processed = 1 AND lotid = 'OLXHLD' AND ProofNumber <> '' Error 1/20/2022 12:44:22 PM First Field is less or equals to zero Information 1/20/2022 12:44:22 PM Executing Sql Check Data: OLX ORDERS ON HOLD Information 1/20/2022 12:44:22 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:22 PM Connection Type is: ODBC Information 1/20/2022 12:44:22 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:22 PM Using Following Sql: SELECT count(*) FROM pub.wimporter_a2b where processed = 1 and lotid = 'OLXHLD2' Error 1/20/2022 12:44:22 PM First Field is less or equals to zero Information 1/20/2022 12:44:22 PM Executing File Operation: File MOVE Information 1/20/2022 12:44:22 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ToBeProcessed\ Information 1/20/2022 12:44:22 PM Mask: *.csv Information 1/20/2022 12:44:22 PM Path Is Valid: True Information 1/20/2022 12:44:22 PM Include Directory: False Information 1/20/2022 12:44:22 PM In Sub Folders: False Information 1/20/2022 12:44:22 PM Attributes: ReadOnly Information 1/20/2022 12:44:22 PM Attribute: Hidden Information 1/20/2022 12:44:22 PM Attribute: SysFile Information 1/20/2022 12:44:22 PM Attribute: aArchive Information 1/20/2022 12:44:22 PM File Age: 30 Information 1/20/2022 12:44:22 PM Which File: 0 Information 1/20/2022 12:44:22 PM Found: 1 File(s) Information 1/20/2022 12:44:22 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ToBeProcessed\All_Clients_A2BFulfillment_20220120123034.csv into \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\PROCESSED Information 1/20/2022 12:44:23 PM Executing Sql Script: Flexsl olx sourcedoc -one Information 1/20/2022 12:44:23 PM Connection Name: IT-R4WMS-Update Information 1/20/2022 12:44:23 PM Connection Type is: ODBC Information 1/20/2022 12:44:23 PM Executing File Operation: OLX move to processed Information 1/20/2022 12:44:23 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\OLX\ToBeProcessed\ Information 1/20/2022 12:44:23 PM Mask: *.* Information 1/20/2022 12:44:23 PM Path Is Valid: True Information 1/20/2022 12:44:23 PM Include Directory: False Information 1/20/2022 12:44:23 PM In Sub Folders: False Information 1/20/2022 12:44:23 PM Attributes: ReadOnly Information 1/20/2022 12:44:23 PM Attribute: Hidden Information 1/20/2022 12:44:23 PM Attribute: SysFile Information 1/20/2022 12:44:23 PM Attribute: aArchive Information 1/20/2022 12:44:23 PM File Age: 30 Information 1/20/2022 12:44:23 PM Which File: 0 Error 1/20/2022 12:44:23 PM Could not find any files Information 1/20/2022 12:44:24 PM Executing Check Connection Information 1/20/2022 12:44:24 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:24 PM Connection Type is: ODBC Information 1/20/2022 12:44:24 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:44:24 PM Done! Information 1/20/2022 12:44:24 PM Executing Package: IN-ShipWorks Information 1/20/2022 12:44:25 PM Executing Package: IN-Amazon-SW Information 1/20/2022 12:44:26 PM Executing Sql Check Data: Amazon-SW Check Data Information 1/20/2022 12:44:26 PM Connection Name: ShipWorks Information 1/20/2022 12:44:26 PM Connection Type is: ODBC Information 1/20/2022 12:44:26 PM Source DSN: DRIVER=SQL Server Native Client 11.0;SERVER=A2BF-SQL1;UID=sa;PWD=**;DATABASE=ShipWorks;WSID=0000100001; Information 1/20/2022 12:44:26 PM Using Following Sql: SELECT count(*) FROM dbo.[Order] o INNER JOIN dbo.[Store] s ON o.StoreID = s.StoreID WHERE s.StoreName IN ('WILLAB','BROWNI-AMZ','FLEXSL','JUNEVL','BOODYW-AMZ','DOZPET-AMZ','HANEQU','QULACO-AMZ','BRND44','IAEAST-GZ','IAEAST-OS','SEEDLP-AMZ','STELTH','AVGJOE','MBTUSA','BCKLNG','ACTEGY','DELSAF-AMZ') AND o.LocalStatus = 'New' AND o.OnlineStatus = 'Unshipped' Information 1/20/2022 12:44:26 PM First Field is bigger than zero Information 1/20/2022 12:44:27 PM Executing Sql Script: Amazon-SW UPDATES Information 1/20/2022 12:44:27 PM Connection Name: ShipWorks Information 1/20/2022 12:44:27 PM Connection Type is: ODBC Information 1/20/2022 12:44:28 PM Executing Import: Amazon-SW Import Information 1/20/2022 12:44:30 PM Processed: 13 Records Information 1/20/2022 12:44:30 PM Errors: 0 Information 1/20/2022 12:44:30 PM Records per second: 419 Information 1/20/2022 12:44:30 PM Execution of Import Script: Amazon-SW Import has completed Information 1/20/2022 12:44:30 PM Executing Package: Amazon - CustID Updates Information 1/20/2022 12:44:31 PM Executing Sql Script: IAEAST - Updates Information 1/20/2022 12:44:31 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:31 PM Connection Type is: ODBC Information 1/20/2022 12:44:32 PM Executing Sql Script: SEEDLP-AMZ - Updates Information 1/20/2022 12:44:32 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:32 PM Connection Type is: ODBC Information 1/20/2022 12:44:32 PM Executing Sql Script: STELTH-AMZ - Updates Information 1/20/2022 12:44:32 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:32 PM Connection Type is: ODBC Information 1/20/2022 12:44:32 PM Executing Sql Script: AVGJOE-AMZ - Updates Information 1/20/2022 12:44:33 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:33 PM Connection Type is: ODBC Information 1/20/2022 12:44:33 PM Executing Sql Script: MBTUSA-AMZ - Updates Information 1/20/2022 12:44:33 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:33 PM Connection Type is: ODBC Information 1/20/2022 12:44:33 PM Executing Sql Script: BCKLNG-AMZ - Updates Information 1/20/2022 12:44:33 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:33 PM Connection Type is: ODBC Information 1/20/2022 12:44:34 PM Executing Sql Script: ACTEGY-AMZ - Updates Information 1/20/2022 12:44:34 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:34 PM Connection Type is: ODBC Information 1/20/2022 12:44:34 PM Executing Sql Script: DELSAF-AMZ - Updates Information 1/20/2022 12:44:34 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:34 PM Connection Type is: ODBC Information 1/20/2022 12:44:35 PM Executing Import: Amazon-SW Update Information 1/20/2022 12:44:36 PM Processed: 12 Records Information 1/20/2022 12:44:36 PM Errors: 0 Information 1/20/2022 12:44:36 PM Records per second: 43 Information 1/20/2022 12:44:36 PM Execution of Import Script: Amazon-SW Update has completed Information 1/20/2022 12:44:36 PM Executing Package: IN-WILLAB-Amazon-SW Information 1/20/2022 12:44:36 PM Executing Sql Check Data: WILLAB-Amazon-SW Check Data Information 1/20/2022 12:44:36 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:36 PM Connection Type is: ODBC Information 1/20/2022 12:44:36 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:36 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'WILLAB' AND SenderID = 'WILLAB-AMZ-DS' AND processed = 0 Error 1/20/2022 12:44:36 PM First Field is less or equals to zero Information 1/20/2022 12:44:37 PM Executing Check Connection Information 1/20/2022 12:44:37 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:37 PM Connection Type is: ODBC Information 1/20/2022 12:44:37 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:37 PM Done! Information 1/20/2022 12:44:37 PM Executing Package: IN-BROWNI-Amazon-SW Information 1/20/2022 12:44:38 PM Executing Sql Check Data: BROWNI-Amazon-SW Check Data Information 1/20/2022 12:44:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:38 PM Connection Type is: ODBC Information 1/20/2022 12:44:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:38 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BROWNI' AND SenderID = 'BROWNI-AMZ-DS' AND processed = 0 Error 1/20/2022 12:44:38 PM First Field is less or equals to zero Information 1/20/2022 12:44:38 PM Executing Check Connection Information 1/20/2022 12:44:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:38 PM Connection Type is: ODBC Information 1/20/2022 12:44:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:38 PM Done! Information 1/20/2022 12:44:38 PM Executing Package: IN-FLEXSL-Amazon-SW Information 1/20/2022 12:44:39 PM Executing Sql Check Data: FLEXSL-Amazon-SW Check Data Information 1/20/2022 12:44:39 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:39 PM Connection Type is: ODBC Information 1/20/2022 12:44:39 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:39 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'FLEXSL' AND SenderID = 'FLEXSL-AMZ-DS' AND processed = 0 Information 1/20/2022 12:44:39 PM First Field is bigger than zero Information 1/20/2022 12:44:40 PM Sending Email: FLEXSL-Amazon-SW Info Email Information 1/20/2022 12:44:40 PM To: rhadkar@a2bf.com Information 1/20/2022 12:44:41 PM Done! Information 1/20/2022 12:44:42 PM Executing Package: IN-BOODYW-Amazon-SW Information 1/20/2022 12:44:42 PM Executing Sql Check Data: BOODYW-Amazon-SW Check Data Information 1/20/2022 12:44:43 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:43 PM Connection Type is: ODBC Information 1/20/2022 12:44:43 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:43 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BOODYW' AND SenderID = 'BOODYW-AMZ-DS' AND processed = 0 Error 1/20/2022 12:44:43 PM First Field is less or equals to zero Information 1/20/2022 12:44:43 PM Executing Check Connection Information 1/20/2022 12:44:43 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:43 PM Connection Type is: ODBC Information 1/20/2022 12:44:43 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:43 PM Done! Information 1/20/2022 12:44:43 PM Executing Package: IN-QULACO-Amazon-SW Information 1/20/2022 12:44:44 PM Executing Sql Check Data: QULACO-Amazon-SW Check Data Information 1/20/2022 12:44:44 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:44 PM Connection Type is: ODBC Information 1/20/2022 12:44:44 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:44 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'QULACO' AND SenderID = 'QULACO-AMZ-DS' AND processed = 0 Error 1/20/2022 12:44:44 PM First Field is less or equals to zero Information 1/20/2022 12:44:44 PM Executing Check Connection Information 1/20/2022 12:44:45 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:45 PM Connection Type is: ODBC Information 1/20/2022 12:44:45 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:45 PM Done! Information 1/20/2022 12:44:45 PM Executing Package: IN-BRND44-Amazon-SW Information 1/20/2022 12:44:45 PM Executing Sql Check Data: BRND44-Amazon-SW Check Data Information 1/20/2022 12:44:46 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:46 PM Connection Type is: ODBC Information 1/20/2022 12:44:46 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:46 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BRND44' AND SenderID = 'BRND44-AMZ-DS' AND processed = 0 Error 1/20/2022 12:44:46 PM First Field is less or equals to zero Information 1/20/2022 12:44:46 PM Executing Check Connection Information 1/20/2022 12:44:46 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:46 PM Connection Type is: ODBC Information 1/20/2022 12:44:46 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:46 PM Done! Information 1/20/2022 12:44:47 PM Executing Package: IN-SEEDLP-Amazon-SW Information 1/20/2022 12:44:47 PM Executing Sql Check Data: SEEDLP-Amazon-SW Check Data Information 1/20/2022 12:44:47 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:47 PM Connection Type is: ODBC Information 1/20/2022 12:44:47 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:47 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'SEEDLP' AND SenderID = 'SEEDLP-AMZ-DS' AND processed = 0 Information 1/20/2022 12:44:47 PM First Field is bigger than zero Information 1/20/2022 12:44:48 PM Sending Email: SEEDLP-Amazon-SW Info Email Information 1/20/2022 12:44:48 PM To: ingrid.chase@seedlipdrinks.com, rob.coles@seedlipdrinks.com, craig.armstrong@seedlipdrinks.com Information 1/20/2022 12:44:48 PM Done! Information 1/20/2022 12:44:48 PM Executing Package: IN-DELSAF-Amazon-SW Information 1/20/2022 12:44:49 PM Executing Sql Check Data: DELSAF-Amazon-SW Check Data Information 1/20/2022 12:44:49 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:49 PM Connection Type is: ODBC Information 1/20/2022 12:44:49 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:49 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'DELSAF' AND SenderID = 'DELSAF-AMZ-DS' AND processed = 0 Error 1/20/2022 12:44:49 PM First Field is less or equals to zero Information 1/20/2022 12:44:49 PM Executing Check Connection Information 1/20/2022 12:44:50 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:44:50 PM Connection Type is: ODBC Information 1/20/2022 12:44:50 PM Source DSN: r4wms72-64b Information 1/20/2022 12:44:50 PM Done! Information 1/20/2022 12:44:50 PM Executing Package: IN-Shopify-SW Information 1/20/2022 12:44:50 PM Executing Sql Check Data: Shopify-SW Check Data Information 1/20/2022 12:44:51 PM Connection Name: ShipWorks Information 1/20/2022 12:44:51 PM Connection Type is: ODBC Information 1/20/2022 12:44:51 PM Source DSN: DRIVER=SQL Server Native Client 11.0;SERVER=A2BF-SQL1;UID=sa;PWD=**;DATABASE=ShipWorks;WSID=0000100001; Information 1/20/2022 12:44:51 PM Using Following Sql: SELECT count(*) FROM dbo.[Order] o INNER JOIN dbo.[Store] s ON o.StoreID = s.StoreID INNER JOIN dbo.ShopifyOrder so ON so.OrderID = o.OrderID WHERE s.StoreName IN ('DELSAF','DOZPET','AKIDAH', 'FISHER','SHREDS','BOODYW', 'EQUINE','BROWNI-SPF','AWHAIR', 'GENIUS','PARKAV-VIEW','PARKAV-LBP', 'PARKAV-M&M','PARKAV-GMA','GRTYSL', 'QULACO','FISHER-2','SEEDLP', 'SEEDLP-2','BAJABB','WILLAB-SPF', 'SIMTEC','SHIKOB','GENIUS-1','DEFUNK','DEFUNK-CS','DEFUNK-WS', 'BUNGIE','FLEXSL-SPF','AMALAB','AMALAB-HK', 'AMALAB-P','LUXINC','BRCSHT','IONSKN','BHEART') AND o.LocalStatus = 'New' AND o.OnlineStatus = 'Open' AND so.PaymentStatusCode <> 4 AND so.FulfillmentStatusCode in (0, 1) Information 1/20/2022 12:44:51 PM First Field is bigger than zero Information 1/20/2022 12:44:51 PM Executing Sql Script: Shopify-SW UPDATES- Fraudulent Test NonA2B Orders Information 1/20/2022 12:44:51 PM Connection Name: ShipWorks Information 1/20/2022 12:44:51 PM Connection Type is: ODBC Information 1/20/2022 12:44:52 PM Executing Import: Shopify-SW Import Information 1/20/2022 12:44:56 PM Processed: 1183 Records Information 1/20/2022 12:44:56 PM Errors: 0 Information 1/20/2022 12:44:56 PM Records per second: 508 Information 1/20/2022 12:44:56 PM Execution of Import Script: Shopify-SW Import has completed Information 1/20/2022 12:44:56 PM Executing Package: Shopify - CustId Updates Information 1/20/2022 12:44:57 PM Executing Sql Script: DELSAF Update Information 1/20/2022 12:44:57 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:57 PM Connection Type is: ODBC Information 1/20/2022 12:44:57 PM Executing Sql Script: SEEDLP Update Information 1/20/2022 12:44:58 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:58 PM Connection Type is: ODBC Information 1/20/2022 12:44:58 PM Executing Sql Script: WILLAB-SPF Update Information 1/20/2022 12:44:58 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:58 PM Connection Type is: ODBC Information 1/20/2022 12:44:59 PM Executing Sql Script: SIMTEC Update Information 1/20/2022 12:44:59 PM Connection Name: R4WMSIMP Information 1/20/2022 12:44:59 PM Connection Type is: ODBC Information 1/20/2022 12:45:00 PM Executing Sql Script: SHIKOB Update Information 1/20/2022 12:45:00 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:00 PM Connection Type is: ODBC Information 1/20/2022 12:45:00 PM Executing Sql Script: EQUINE Update Information 1/20/2022 12:45:00 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:00 PM Connection Type is: ODBC Information 1/20/2022 12:45:01 PM Executing Sql Script: FISHER Update Information 1/20/2022 12:45:01 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:01 PM Connection Type is: ODBC Information 1/20/2022 12:45:01 PM Executing Sql Script: QULACO Update Information 1/20/2022 12:45:01 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:01 PM Connection Type is: ODBC Information 1/20/2022 12:45:03 PM Executing Sql Script: GRTYSL Update Information 1/20/2022 12:45:03 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:03 PM Connection Type is: ODBC Information 1/20/2022 12:45:06 PM Executing Sql Script: DEFUNK Update Information 1/20/2022 12:45:06 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:06 PM Connection Type is: ODBC Information 1/20/2022 12:45:08 PM Executing Sql Script: BUNGIE Update Information 1/20/2022 12:45:08 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:08 PM Connection Type is: ODBC Information 1/20/2022 12:45:10 PM Executing Sql Script: FLEXSL-SPF Update Information 1/20/2022 12:45:10 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:10 PM Connection Type is: ODBC Information 1/20/2022 12:45:11 PM Executing Sql Script: AMALAB-SPF Update Information 1/20/2022 12:45:11 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:11 PM Connection Type is: ODBC Information 1/20/2022 12:45:12 PM Executing Sql Script: LUXINC-SPF Update Information 1/20/2022 12:45:12 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:12 PM Connection Type is: ODBC Information 1/20/2022 12:45:13 PM Executing Sql Script: BRCSHT-SPF Update Information 1/20/2022 12:45:13 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:13 PM Connection Type is: ODBC Information 1/20/2022 12:45:15 PM Executing Sql Script: IONSKN-SPF Update Information 1/20/2022 12:45:15 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:15 PM Connection Type is: ODBC Information 1/20/2022 12:45:17 PM Executing Sql Script: BHEART-SPF Update Information 1/20/2022 12:45:17 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:17 PM Connection Type is: ODBC Information 1/20/2022 12:45:19 PM Executing Check Connection Information 1/20/2022 12:45:19 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:19 PM Connection Type is: ODBC Information 1/20/2022 12:45:19 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:19 PM Done! Information 1/20/2022 12:45:20 PM Executing Package: Shopify-ShipWorks Data to RDS Information 1/20/2022 12:45:21 PM Executing Import: Shopify-ShipWorks Order to RDS Information 1/20/2022 12:45:22 PM Processed: 175 Records Information 1/20/2022 12:45:22 PM Errors: 0 Information 1/20/2022 12:45:22 PM Records per second: 431 Information 1/20/2022 12:45:22 PM Execution of Import Script: Shopify-ShipWorks Order to RDS has completed Information 1/20/2022 12:45:23 PM Executing Import: Shopify-ShipWorks OrderItem to RDS Information 1/20/2022 12:45:25 PM Processed: 250 Records Information 1/20/2022 12:45:25 PM Errors: 0 Information 1/20/2022 12:45:25 PM Records per second: 729 Information 1/20/2022 12:45:25 PM Execution of Import Script: Shopify-ShipWorks OrderItem to RDS has completed Information 1/20/2022 12:45:25 PM Executing Import: Shopify-ShipWorks ShopifyOrder to RDS Information 1/20/2022 12:45:28 PM Processed: 175 Records Information 1/20/2022 12:45:28 PM Errors: 0 Information 1/20/2022 12:45:28 PM Records per second: 509 Information 1/20/2022 12:45:28 PM Execution of Import Script: Shopify-ShipWorks ShopifyOrder to RDS has completed Information 1/20/2022 12:45:28 PM Executing Import: Shopify-ShipWorks ShopifyOrderItem to RDS Information 1/20/2022 12:45:31 PM Processed: 250 Records Information 1/20/2022 12:45:31 PM Errors: 0 Information 1/20/2022 12:45:31 PM Records per second: 172 Information 1/20/2022 12:45:31 PM Execution of Import Script: Shopify-ShipWorks ShopifyOrderItem to RDS has completed Information 1/20/2022 12:45:32 PM Executing Import: Shopify-SW Update Information 1/20/2022 12:45:32 PM Processed: 8 Records Information 1/20/2022 12:45:32 PM Errors: 0 Information 1/20/2022 12:45:32 PM Records per second: 86 Information 1/20/2022 12:45:32 PM Execution of Import Script: Shopify-SW Update has completed Information 1/20/2022 12:45:34 PM Executing Sql Script: Shopify-SW UPDATES Information 1/20/2022 12:45:34 PM Connection Name: ShipWorks Information 1/20/2022 12:45:34 PM Connection Type is: ODBC Information 1/20/2022 12:45:35 PM Executing Package: IN-EQUINE-Shopify-SW Information 1/20/2022 12:45:37 PM Executing Sql Check Data: Shopify-SW EQUINE Check Data Information 1/20/2022 12:45:37 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:37 PM Connection Type is: ODBC Information 1/20/2022 12:45:37 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:37 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'EQUINE' AND processed = 0 Information 1/20/2022 12:45:37 PM First Field is bigger than zero Information 1/20/2022 12:45:37 PM Executing Sql Script: EQUINE_EQTRIFOLD insert Information 1/20/2022 12:45:37 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:37 PM Connection Type is: ODBC Information 1/20/2022 12:45:37 PM Executing Package: IN-BROWNI-Shopify-SW Information 1/20/2022 12:45:37 PM Executing Sql Check Data: Shopify-SW BROWNI Check Data Information 1/20/2022 12:45:37 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:37 PM Connection Type is: ODBC Information 1/20/2022 12:45:37 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:37 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BROWNI' AND SenderID = 'Shopify' AND processed = 0 Error 1/20/2022 12:45:37 PM First Field is less or equals to zero Information 1/20/2022 12:45:37 PM Executing Check Connection Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Done! Information 1/20/2022 12:45:38 PM Executing Package: IN-SHREDS-Shopify-SW Information 1/20/2022 12:45:38 PM Executing Sql Check Data: Shopify-SW SHREDS Check Data Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'SHREDS' AND processed = 0 Error 1/20/2022 12:45:38 PM First Field is less or equals to zero Information 1/20/2022 12:45:38 PM Executing Check Connection Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Done! Information 1/20/2022 12:45:38 PM Executing Package: IN-DOZPET-Shopify-SW Information 1/20/2022 12:45:38 PM Executing Sql Check Data: Shopify-SW DOZPET Check Data Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'DOZPET' AND processed = 0 Error 1/20/2022 12:45:38 PM First Field is less or equals to zero Information 1/20/2022 12:45:38 PM Executing Check Connection Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Done! Information 1/20/2022 12:45:38 PM Executing Package: IN-BOODYW-Shopify-SW Information 1/20/2022 12:45:38 PM Executing Sql Check Data: Shopify-SW BOODYW Check Data- Fraudulent Orders Information 1/20/2022 12:45:38 PM Connection Name: ShipWorks Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: DRIVER=SQL Server Native Client 11.0;SERVER=A2BF-SQL1;UID=sa;PWD=**;DATABASE=ShipWorks;WSID=0000100001; Information 1/20/2022 12:45:38 PM Using Following Sql: SELECT COUNT(o.OrderID) FROM dbo.[Order] o, dbo.Store s WHERE s.StoreName IN ('BOODYW') AND o.LocalStatus = 'HRL-HOLD' AND o.OnlineStatus = 'Open' AND o.StoreID = s.StoreID Error 1/20/2022 12:45:38 PM First Field is less or equals to zero Information 1/20/2022 12:45:38 PM Executing Check Connection Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Done! Information 1/20/2022 12:45:38 PM Executing Package: IN-DELSAF-Shopify-SW Information 1/20/2022 12:45:38 PM Executing Sql Check Data: Shopify-SW DELSAF Check Data Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'DELSAF' AND processed = 0 Error 1/20/2022 12:45:38 PM First Field is less or equals to zero Information 1/20/2022 12:45:38 PM Executing Check Connection Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Done! Information 1/20/2022 12:45:38 PM Executing Package: IN-SEEDLP-Shopify-SW Information 1/20/2022 12:45:38 PM Executing Sql Check Data: Shopify-SW SEEDLP Check Data Information 1/20/2022 12:45:38 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:38 PM Connection Type is: ODBC Information 1/20/2022 12:45:38 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:38 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'SEEDLP' AND SenderID = 'Shopify' AND processed = 0 Information 1/20/2022 12:45:38 PM First Field is bigger than zero Information 1/20/2022 12:45:38 PM Sending Email: SEEDLP-Shopify-SW Info Email Information 1/20/2022 12:45:38 PM To: ingrid.chase@seedlipdrinks.com, rob.coles@seedlipdrinks.com, craig.armstrong@seedlipdrinks.com Information 1/20/2022 12:45:39 PM Done! Information 1/20/2022 12:45:39 PM Executing Package: IN-BAJABB-Shopify-SW Information 1/20/2022 12:45:39 PM Executing Sql Check Data: Shopify-SW BAJABB Check Data Information 1/20/2022 12:45:39 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:39 PM Connection Type is: ODBC Information 1/20/2022 12:45:39 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:39 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BAJABB' AND SenderID = 'Shopify' AND processed = 0 Error 1/20/2022 12:45:39 PM First Field is less or equals to zero Information 1/20/2022 12:45:39 PM Executing Check Connection Information 1/20/2022 12:45:39 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:39 PM Connection Type is: ODBC Information 1/20/2022 12:45:39 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:39 PM Done! Information 1/20/2022 12:45:39 PM Executing Package: IN-WILLAB-Shopify-SW Information 1/20/2022 12:45:40 PM Executing Sql Check Data: WILLAB-Shopify SW Check Data Information 1/20/2022 12:45:40 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:40 PM Connection Type is: ODBC Information 1/20/2022 12:45:40 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:40 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'WILLAB' AND SenderID = 'Shopify' AND processed = 0 Error 1/20/2022 12:45:40 PM First Field is less or equals to zero Information 1/20/2022 12:45:42 PM Executing Check Connection Information 1/20/2022 12:45:42 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:42 PM Connection Type is: ODBC Information 1/20/2022 12:45:42 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:42 PM Done! Information 1/20/2022 12:45:43 PM Executing Package: IN-BRCSHT-Shopify-SW Information 1/20/2022 12:45:44 PM Executing Sql Check Data: BRCSHT-Shopify SW Check Data Information 1/20/2022 12:45:45 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:45 PM Connection Type is: ODBC Information 1/20/2022 12:45:45 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:45 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BRCSHT' AND SenderID = 'Shopify' AND processed = 0 Error 1/20/2022 12:45:45 PM First Field is less or equals to zero Information 1/20/2022 12:45:46 PM Executing Check Connection Information 1/20/2022 12:45:46 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:46 PM Connection Type is: ODBC Information 1/20/2022 12:45:46 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:46 PM Done! Information 1/20/2022 12:45:48 PM Executing Package: IN-IONSKN-Shopify-SW Information 1/20/2022 12:45:48 PM Executing Sql Check Data: IONSKN-Shopify SW Check Data Information 1/20/2022 12:45:48 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:48 PM Connection Type is: ODBC Information 1/20/2022 12:45:48 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:48 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'IONSKN' AND SenderID = 'Shopify' AND processed = 0 Error 1/20/2022 12:45:48 PM First Field is less or equals to zero Information 1/20/2022 12:45:48 PM Executing Check Connection Information 1/20/2022 12:45:48 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:48 PM Connection Type is: ODBC Information 1/20/2022 12:45:48 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:48 PM Done! Information 1/20/2022 12:45:49 PM Executing Package: IN-BHEART-Shopify-SW Information 1/20/2022 12:45:49 PM Executing Sql Check Data: BHEART-Shopify SW Check Data Information 1/20/2022 12:45:49 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:49 PM Connection Type is: ODBC Information 1/20/2022 12:45:49 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:49 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'BHEART' AND SenderID = 'Shopify' AND processed = 0 Error 1/20/2022 12:45:49 PM First Field is less or equals to zero Information 1/20/2022 12:45:49 PM Executing Check Connection Information 1/20/2022 12:45:49 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:49 PM Connection Type is: ODBC Information 1/20/2022 12:45:49 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:49 PM Done! Information 1/20/2022 12:45:50 PM Executing Package: IN-Walmart-SW Information 1/20/2022 12:45:50 PM Executing Sql Check Data: Walmart-SW Check Data Information 1/20/2022 12:45:50 PM Connection Name: ShipWorks Information 1/20/2022 12:45:50 PM Connection Type is: ODBC Information 1/20/2022 12:45:50 PM Source DSN: DRIVER=SQL Server Native Client 11.0;SERVER=A2BF-SQL1;UID=sa;PWD=**;DATABASE=ShipWorks;WSID=0000100001; Information 1/20/2022 12:45:50 PM Using Following Sql: SELECT count(*) FROM dbo.[Order] o INNER JOIN dbo.[Store] s ON o.StoreID = s.StoreID JOIN dbo.[OrderItem] i ON i.OrderID = o.OrderID JOIN dbo.WalmartOrder a ON a.OrderID = o.OrderID JOIN dbo.WalmartOrderItem b ON b.OrderItemID = i.OrderItemID WHERE s.StoreName IN ('WILLAB-WLM', 'FLEXSL-WLM') AND o.LocalStatus = 'New' AND o.OnlineStatus = '' and b.OnlineStatus = 'Acknowledged' Information 1/20/2022 12:45:50 PM First Field is bigger than zero Information 1/20/2022 12:45:50 PM Executing Import: Walmart-SW Import Information 1/20/2022 12:45:52 PM Processed: 1 Records Information 1/20/2022 12:45:52 PM Errors: 0 Information 1/20/2022 12:45:52 PM Records per second: 7 Information 1/20/2022 12:45:52 PM Execution of Import Script: Walmart-SW Import has completed Information 1/20/2022 12:45:52 PM Executing Package: Walmart - CustId Updates Information 1/20/2022 12:45:52 PM Executing Sql Script: FLEXSL-WLM Update Information 1/20/2022 12:45:52 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:52 PM Connection Type is: ODBC Information 1/20/2022 12:45:53 PM Executing Check Connection Information 1/20/2022 12:45:53 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:53 PM Connection Type is: ODBC Information 1/20/2022 12:45:53 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:53 PM Done! Information 1/20/2022 12:45:53 PM Executing Import: Walmart-SW Update Information 1/20/2022 12:45:53 PM Processed: 0 Records Information 1/20/2022 12:45:53 PM Errors: 0 Information 1/20/2022 12:45:53 PM Records per second: 0 Information 1/20/2022 12:45:53 PM Execution of Import Script: Walmart-SW Update has completed Information 1/20/2022 12:45:53 PM Executing Package: IN-WILLAB-Walmart-SW Information 1/20/2022 12:45:53 PM Executing Sql Check Data: WILLAB-Walmart-SW Check Data Information 1/20/2022 12:45:53 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:53 PM Connection Type is: ODBC Information 1/20/2022 12:45:53 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:53 PM Using Following Sql: SELECT COUNT(*) FROM PUB.wIMPORTER_A2B WHERE custid = 'WILLAB' AND SenderID = 'WILLAB-WLM-DS' AND processed = 0 Error 1/20/2022 12:45:55 PM First Field is less or equals to zero Information 1/20/2022 12:45:55 PM Executing Check Connection Information 1/20/2022 12:45:55 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:55 PM Connection Type is: ODBC Information 1/20/2022 12:45:55 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:55 PM Done! Information 1/20/2022 12:45:55 PM Executing Package: IN-Ebay-SW Information 1/20/2022 12:45:55 PM Executing Sql Check Data: Ebay-SW Check Data Information 1/20/2022 12:45:55 PM Connection Name: ShipWorks Information 1/20/2022 12:45:55 PM Connection Type is: ODBC Information 1/20/2022 12:45:55 PM Source DSN: DRIVER=SQL Server Native Client 11.0;SERVER=A2BF-SQL1;UID=sa;PWD=**;DATABASE=ShipWorks;WSID=0000100001; Information 1/20/2022 12:45:55 PM Using Following Sql: SELECT count(*) FROM dbo.[Order] o INNER JOIN dbo.[Store] s ON o.StoreID = s.StoreID JOIN dbo.[OrderItem] i ON i.OrderID = o.OrderID JOIN dbo.EbayOrderItem a ON a.OrderID = o.OrderID WHERE s.StoreName IN ('FLEXSL-EBY') AND o.LocalStatus = 'New' AND a.CompleteStatus = 1 AND a.MyEbayShipped = 0 Error 1/20/2022 12:45:55 PM First Field is less or equals to zero Information 1/20/2022 12:45:55 PM Executing Check Connection Information 1/20/2022 12:45:55 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:45:55 PM Connection Type is: ODBC Information 1/20/2022 12:45:55 PM Source DSN: r4wms72-64b Information 1/20/2022 12:45:55 PM Done! Information 1/20/2022 12:45:55 PM Executing Package: IN-Magento-SW Information 1/20/2022 12:45:56 PM Executing Sql Check Data: Magento-SW Check Data Information 1/20/2022 12:45:56 PM Connection Name: ShipWorks Information 1/20/2022 12:45:56 PM Connection Type is: ODBC Information 1/20/2022 12:45:56 PM Source DSN: DRIVER=SQL Server Native Client 11.0;SERVER=A2BF-SQL1;UID=sa;PWD=**;DATABASE=ShipWorks;WSID=0000100001; Information 1/20/2022 12:45:56 PM Using Following Sql: SELECT count(*) FROM dbo.[Order] o INNER JOIN dbo.[Store] s ON o.StoreID = s.StoreID JOIN dbo.[OrderItem] i ON i.OrderID = o.OrderID WHERE s.StoreName IN ('BUNGIE-MGT') AND o.LocalStatus = 'New' AND o.OnlineStatus = 'processing' Information 1/20/2022 12:45:56 PM First Field is bigger than zero Information 1/20/2022 12:45:56 PM Executing Sql Script: Magento-SW UPDATES- NonA2B Orders Information 1/20/2022 12:45:56 PM Connection Name: ShipWorks Information 1/20/2022 12:45:56 PM Connection Type is: ODBC Information 1/20/2022 12:45:57 PM Executing Import: Magento-SW Import Information 1/20/2022 12:45:59 PM Processed: 75 Records Information 1/20/2022 12:45:59 PM Errors: 0 Information 1/20/2022 12:45:59 PM Records per second: 102 Information 1/20/2022 12:45:59 PM Execution of Import Script: Magento-SW Import has completed Information 1/20/2022 12:45:59 PM Executing Package: Magento - CustId Updates Information 1/20/2022 12:45:59 PM Executing Sql Script: BUNGIE Magento Update Information 1/20/2022 12:45:59 PM Connection Name: R4WMSIMP Information 1/20/2022 12:45:59 PM Connection Type is: ODBC Information 1/20/2022 12:46:00 PM Executing Check Connection Information 1/20/2022 12:46:00 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:46:00 PM Connection Type is: ODBC Information 1/20/2022 12:46:00 PM Source DSN: r4wms72-64b Information 1/20/2022 12:46:00 PM Done! Information 1/20/2022 12:46:00 PM Executing Import: Magento-SW Update Information 1/20/2022 12:46:00 PM Processed: 23 Records Information 1/20/2022 12:46:00 PM Errors: 0 Information 1/20/2022 12:46:00 PM Records per second: 365 Information 1/20/2022 12:46:00 PM Execution of Import Script: Magento-SW Update has completed Information 1/20/2022 12:46:00 PM Executing Package: Parkav-M&m Item swap Information 1/20/2022 12:46:00 PM Executing Sql Check Data: PARKAV - Item Swap Check Information 1/20/2022 12:46:00 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:46:00 PM Connection Type is: ODBC Information 1/20/2022 12:46:00 PM Source DSN: r4wms72-64b Information 1/20/2022 12:46:00 PM Using Following Sql: SELECT count(*) as Cnt FROM pub.wimporter_a2b a WHERE a.custid = 'PARKAV' AND a.processed <> 1 Error 1/20/2022 12:46:00 PM First Field is less or equals to zero Information 1/20/2022 12:46:00 PM Executing Check Connection Information 1/20/2022 12:46:01 PM Connection Name: IT-R4WMS-Read Information 1/20/2022 12:46:01 PM Connection Type is: ODBC Information 1/20/2022 12:46:01 PM Source DSN: it-r4wms-read-64b Information 1/20/2022 12:46:01 PM Done! Information 1/20/2022 12:46:01 PM Executing Package: IN-BOODYW Information 1/20/2022 12:46:01 PM Checking File(s): boodyw file check01 Information 1/20/2022 12:46:01 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\ Information 1/20/2022 12:46:01 PM Mask: *.txt Information 1/20/2022 12:46:01 PM Path Is Valid: True Information 1/20/2022 12:46:01 PM Include Directory: False Information 1/20/2022 12:46:01 PM In Sub Folders: False Information 1/20/2022 12:46:01 PM Attributes: ReadOnly Information 1/20/2022 12:46:01 PM Attribute: Hidden Information 1/20/2022 12:46:01 PM Attribute: SysFile Information 1/20/2022 12:46:01 PM Attribute: aArchive Information 1/20/2022 12:46:01 PM File Age: 0 Information 1/20/2022 12:46:01 PM Which File: 0 Error 1/20/2022 12:46:01 PM Could not find any files Information 1/20/2022 12:46:01 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\*.txt Error 1/20/2022 12:46:01 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\*.txt Information 1/20/2022 12:46:01 PM Checking File(s): Check Files[5] Information 1/20/2022 12:46:01 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\inbound\ Information 1/20/2022 12:46:01 PM Mask: *.csv Information 1/20/2022 12:46:01 PM Path Is Valid: True Information 1/20/2022 12:46:01 PM Include Directory: False Information 1/20/2022 12:46:01 PM In Sub Folders: False Information 1/20/2022 12:46:01 PM Attributes: ReadOnly Information 1/20/2022 12:46:01 PM Attribute: Hidden Information 1/20/2022 12:46:01 PM Attribute: SysFile Information 1/20/2022 12:46:01 PM Attribute: aArchive Information 1/20/2022 12:46:01 PM File Age: 0 Information 1/20/2022 12:46:01 PM Which File: 0 Error 1/20/2022 12:46:01 PM Could not find any files Information 1/20/2022 12:46:01 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\inbound\*.csv Error 1/20/2022 12:46:01 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\inbound\*.csv Information 1/20/2022 12:46:01 PM Executing File Operation: Copy from PCI to FTP Information 1/20/2022 12:46:01 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\BOODYW-NPCI\Inbound\ Information 1/20/2022 12:46:01 PM Mask: *.csv Information 1/20/2022 12:46:01 PM Path Is Valid: True Information 1/20/2022 12:46:01 PM Include Directory: False Information 1/20/2022 12:46:01 PM In Sub Folders: False Information 1/20/2022 12:46:01 PM Attributes: ReadOnly Information 1/20/2022 12:46:01 PM Attribute: Hidden Information 1/20/2022 12:46:01 PM Attribute: SysFile Information 1/20/2022 12:46:01 PM Attribute: aArchive Information 1/20/2022 12:46:01 PM File Age: 30 Information 1/20/2022 12:46:01 PM Which File: 0 Error 1/20/2022 12:46:01 PM Could not find any files Information 1/20/2022 12:46:01 PM Checking File(s): Boodyw inbound file check Information 1/20/2022 12:46:01 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\Inbound\ Information 1/20/2022 12:46:01 PM Mask: *.csv Information 1/20/2022 12:46:01 PM Path Is Valid: True Information 1/20/2022 12:46:01 PM Include Directory: False Information 1/20/2022 12:46:01 PM In Sub Folders: False Information 1/20/2022 12:46:01 PM Attributes: ReadOnly Information 1/20/2022 12:46:01 PM Attribute: Hidden Information 1/20/2022 12:46:01 PM Attribute: SysFile Information 1/20/2022 12:46:01 PM Attribute: aArchive Information 1/20/2022 12:46:01 PM File Age: 0 Information 1/20/2022 12:46:01 PM Which File: 0 Error 1/20/2022 12:46:01 PM Could not find any files Information 1/20/2022 12:46:01 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\Inbound\*.csv Error 1/20/2022 12:46:01 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\Inbound\*.csv Information 1/20/2022 12:46:01 PM Executing File Operation: Boodyw file move Information 1/20/2022 12:46:01 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\Inbound\ Information 1/20/2022 12:46:01 PM Mask: *.* Information 1/20/2022 12:46:01 PM Path Is Valid: True Information 1/20/2022 12:46:01 PM Include Directory: False Information 1/20/2022 12:46:01 PM In Sub Folders: False Information 1/20/2022 12:46:01 PM Attributes: ReadOnly Information 1/20/2022 12:46:01 PM Attribute: Hidden Information 1/20/2022 12:46:01 PM Attribute: SysFile Information 1/20/2022 12:46:01 PM Attribute: aArchive Information 1/20/2022 12:46:01 PM File Age: 30 Information 1/20/2022 12:46:01 PM Which File: 0 Error 1/20/2022 12:46:01 PM Could not find any files Information 1/20/2022 12:46:01 PM Executing File Operation: Move PCI to Processed Information 1/20/2022 12:46:01 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\BOODYW-NPCI\Inbound\ Information 1/20/2022 12:46:01 PM Mask: *.csv Information 1/20/2022 12:46:01 PM Path Is Valid: True Information 1/20/2022 12:46:01 PM Include Directory: False Information 1/20/2022 12:46:01 PM In Sub Folders: False Information 1/20/2022 12:46:01 PM Attributes: ReadOnly Information 1/20/2022 12:46:01 PM Attribute: Hidden Information 1/20/2022 12:46:01 PM Attribute: SysFile Information 1/20/2022 12:46:01 PM Attribute: aArchive Information 1/20/2022 12:46:01 PM File Age: 30 Information 1/20/2022 12:46:01 PM Which File: 0 Error 1/20/2022 12:46:01 PM Could not find any files Information 1/20/2022 12:46:01 PM Executing Check Connection Information 1/20/2022 12:46:01 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:01 PM Connection Type is: ODBC Information 1/20/2022 12:46:01 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:01 PM Done! Information 1/20/2022 12:46:01 PM Executing Package: IN-HLATEC Information 1/20/2022 12:46:02 PM Checking File(s): Check HLATEC inbound Information 1/20/2022 12:46:02 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\kane\ Information 1/20/2022 12:46:02 PM Mask: *.csv Information 1/20/2022 12:46:02 PM Path Is Valid: True Information 1/20/2022 12:46:02 PM Include Directory: False Information 1/20/2022 12:46:02 PM In Sub Folders: False Information 1/20/2022 12:46:02 PM Attributes: ReadOnly Information 1/20/2022 12:46:02 PM Attribute: Hidden Information 1/20/2022 12:46:02 PM Attribute: SysFile Information 1/20/2022 12:46:02 PM Attribute: aArchive Information 1/20/2022 12:46:02 PM File Age: 0 Information 1/20/2022 12:46:02 PM Which File: 0 Error 1/20/2022 12:46:02 PM Could not find any files Information 1/20/2022 12:46:02 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\kane\*.csv Error 1/20/2022 12:46:02 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\kane\*.csv Information 1/20/2022 12:46:02 PM Executing Check Connection Information 1/20/2022 12:46:02 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:02 PM Connection Type is: ODBC Information 1/20/2022 12:46:02 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:02 PM Done! Information 1/20/2022 12:46:02 PM Executing Package: IN-VGHSOL Information 1/20/2022 12:46:02 PM Checking File(s): VGHSOL AAFES Check File Information 1/20/2022 12:46:02 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\ Information 1/20/2022 12:46:02 PM Mask: AAFES*.* Information 1/20/2022 12:46:02 PM Path Is Valid: True Information 1/20/2022 12:46:02 PM Include Directory: False Information 1/20/2022 12:46:02 PM In Sub Folders: False Information 1/20/2022 12:46:02 PM Attributes: ReadOnly Information 1/20/2022 12:46:02 PM Attribute: Hidden Information 1/20/2022 12:46:02 PM Attribute: SysFile Information 1/20/2022 12:46:02 PM Attribute: aArchive Information 1/20/2022 12:46:02 PM File Age: 0 Information 1/20/2022 12:46:02 PM Which File: 0 Error 1/20/2022 12:46:02 PM Could not find any files Information 1/20/2022 12:46:02 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\AAFES*.* Error 1/20/2022 12:46:02 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\AAFES*.* Information 1/20/2022 12:46:02 PM Checking File(s): Check VGHSOL Information 1/20/2022 12:46:02 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\ Information 1/20/2022 12:46:02 PM Mask: *.txt Information 1/20/2022 12:46:02 PM Path Is Valid: True Information 1/20/2022 12:46:02 PM Include Directory: False Information 1/20/2022 12:46:02 PM In Sub Folders: False Information 1/20/2022 12:46:02 PM Attributes: ReadOnly Information 1/20/2022 12:46:02 PM Attribute: Hidden Information 1/20/2022 12:46:02 PM Attribute: SysFile Information 1/20/2022 12:46:02 PM Attribute: aArchive Information 1/20/2022 12:46:02 PM File Age: 0 Information 1/20/2022 12:46:02 PM Which File: 0 Error 1/20/2022 12:46:02 PM Could not find any files Information 1/20/2022 12:46:02 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\*.txt Error 1/20/2022 12:46:02 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\*.txt Information 1/20/2022 12:46:02 PM Checking File(s): Check VGHSOL csv Information 1/20/2022 12:46:02 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\ Information 1/20/2022 12:46:02 PM Mask: *.csv Information 1/20/2022 12:46:02 PM Path Is Valid: True Information 1/20/2022 12:46:02 PM Include Directory: False Information 1/20/2022 12:46:02 PM In Sub Folders: False Information 1/20/2022 12:46:02 PM Attributes: ReadOnly Information 1/20/2022 12:46:02 PM Attribute: Hidden Information 1/20/2022 12:46:02 PM Attribute: SysFile Information 1/20/2022 12:46:02 PM Attribute: aArchive Information 1/20/2022 12:46:02 PM File Age: 0 Information 1/20/2022 12:46:02 PM Which File: 0 Error 1/20/2022 12:46:02 PM Could not find any files Information 1/20/2022 12:46:02 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\*.csv Error 1/20/2022 12:46:02 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\*.csv Information 1/20/2022 12:46:02 PM Executing Sql Script: VGHSOL Update Information 1/20/2022 12:46:02 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:02 PM Connection Type is: ODBC Information 1/20/2022 12:46:02 PM Executing File Operation: File Op Information 1/20/2022 12:46:02 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\vghsol\ Information 1/20/2022 12:46:02 PM Mask: *.csv Information 1/20/2022 12:46:02 PM Path Is Valid: True Information 1/20/2022 12:46:02 PM Include Directory: False Information 1/20/2022 12:46:02 PM In Sub Folders: False Information 1/20/2022 12:46:02 PM Attributes: ReadOnly Information 1/20/2022 12:46:02 PM Attribute: Hidden Information 1/20/2022 12:46:02 PM Attribute: SysFile Information 1/20/2022 12:46:02 PM Attribute: aArchive Information 1/20/2022 12:46:02 PM File Age: 30 Information 1/20/2022 12:46:02 PM Which File: 0 Error 1/20/2022 12:46:02 PM Could not find any files Information 1/20/2022 12:46:02 PM Executing Check Connection Information 1/20/2022 12:46:02 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:02 PM Connection Type is: ODBC Information 1/20/2022 12:46:02 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:02 PM Done! Information 1/20/2022 12:46:02 PM Executing Package: In-DIC-850 Information 1/20/2022 12:46:02 PM Executing Package: DICentral-FTP-GET-850 Information 1/20/2022 12:46:02 PM Executing External Application: Get-BerryB Information 1/20/2022 12:46:02 PM Application Name: "D:\Program Files (x86)\WinSCP\DIC-BerryB-Get.bat" Information 1/20/2022 12:46:02 PM Waiting for: "D:\Program Files (x86)\WinSCP\DIC-BerryB-Get.bat" to finish Information 1/20/2022 12:46:04 PM Executing External Application: Get-DIC-Genmar-In850 Information 1/20/2022 12:46:04 PM Application Name: "D:\Program Files (x86)\WinSCP\DIC-Genmar-Get.bat" Information 1/20/2022 12:46:04 PM Waiting for: "D:\Program Files (x86)\WinSCP\DIC-Genmar-Get.bat" to finish Information 1/20/2022 12:46:06 PM Executing External Application: Get-DIC-Boodyw-in850 Information 1/20/2022 12:46:06 PM Application Name: "D:\Program Files (x86)\WinSCP\DIC-Boodyw-Get850.cmd" Information 1/20/2022 12:46:06 PM Waiting for: "D:\Program Files (x86)\WinSCP\DIC-Boodyw-Get850.cmd" to finish Information 1/20/2022 12:46:07 PM Executing External Application: get dic-SEEDLP 850 Information 1/20/2022 12:46:07 PM Application Name: "D:\Program Files (x86)\WinSCP\DIC-SEEDLP-Get850.bat" Information 1/20/2022 12:46:07 PM Waiting for: "D:\Program Files (x86)\WinSCP\DIC-SEEDLP-Get850.bat" to finish Information 1/20/2022 12:46:11 PM Executing External Application: get dic-ionskn 850 Information 1/20/2022 12:46:11 PM Application Name: "D:\Program Files (x86)\WinSCP\DIC-Ionskn-Get850.bat" Information 1/20/2022 12:46:11 PM Waiting for: "D:\Program Files (x86)\WinSCP\DIC-Ionskn-Get850.bat" to finish Information 1/20/2022 12:46:15 PM Executing Check Connection Information 1/20/2022 12:46:15 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:15 PM Connection Type is: ODBC Information 1/20/2022 12:46:15 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:15 PM Done! Information 1/20/2022 12:46:15 PM Executing Package: Import-DICentral-850 Information 1/20/2022 12:46:16 PM Executing Sql Script: DIC - Ensure Duplicate records Information 1/20/2022 12:46:16 PM Connection Name: IT-R4WMS-Update Information 1/20/2022 12:46:16 PM Connection Type is: ODBC Information 1/20/2022 12:46:16 PM Executing Import: Filesystem In-Dicentral 850 Information 1/20/2022 12:46:17 PM Processed: 0 Records Information 1/20/2022 12:46:17 PM Errors: 0 Information 1/20/2022 12:46:17 PM Records per second: 10 Error 1/20/2022 12:46:17 PM Execution of Import Script: Filesystem In-Dicentral 850 has failed Information 1/20/2022 12:46:17 PM Executing Import: DIC 850 Sequence Reset Information 1/20/2022 12:46:18 PM Processed: 1 Records Information 1/20/2022 12:46:18 PM Errors: 0 Information 1/20/2022 12:46:18 PM Records per second: 4 Information 1/20/2022 12:46:18 PM Execution of Import Script: DIC 850 Sequence Reset has completed Information 1/20/2022 12:46:19 PM Checking File(s): Check File Information 1/20/2022 12:46:19 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\DICentral\ Information 1/20/2022 12:46:19 PM Mask: *.any Information 1/20/2022 12:46:19 PM Path Is Valid: True Information 1/20/2022 12:46:19 PM Include Directory: False Information 1/20/2022 12:46:19 PM In Sub Folders: False Information 1/20/2022 12:46:19 PM Attributes: ReadOnly Information 1/20/2022 12:46:19 PM Attribute: Hidden Information 1/20/2022 12:46:19 PM Attribute: SysFile Information 1/20/2022 12:46:19 PM Attribute: aArchive Information 1/20/2022 12:46:19 PM File Age: 0 Information 1/20/2022 12:46:19 PM Which File: 0 Error 1/20/2022 12:46:19 PM Could not find any files Information 1/20/2022 12:46:19 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\DICentral\*.any Error 1/20/2022 12:46:19 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\DICentral\*.any Information 1/20/2022 12:46:19 PM Executing Package: In-SPS-EDI Information 1/20/2022 12:46:19 PM Executing Package: In-Clevna-SPS Information 1/20/2022 12:46:19 PM Executing File Operation: Clevna ftp File Operation Information 1/20/2022 12:46:19 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\CLEVNA\Inbound_SPS\ToBeProcessed\ Information 1/20/2022 12:46:19 PM Mask: *.csv Information 1/20/2022 12:46:19 PM Path Is Valid: True Information 1/20/2022 12:46:19 PM Include Directory: False Information 1/20/2022 12:46:19 PM In Sub Folders: False Information 1/20/2022 12:46:19 PM Attributes: ReadOnly Information 1/20/2022 12:46:19 PM Attribute: Hidden Information 1/20/2022 12:46:19 PM Attribute: SysFile Information 1/20/2022 12:46:19 PM Attribute: aArchive Information 1/20/2022 12:46:19 PM File Age: 30 Information 1/20/2022 12:46:19 PM Which File: 0 Error 1/20/2022 12:46:19 PM Could not find any files Information 1/20/2022 12:46:19 PM Executing External Application: get clena ftp inbound850 Information 1/20/2022 12:46:19 PM Application Name: "D:\Program Files (x86)\WinSCP\SPS-Clevna-Get850.bat" Information 1/20/2022 12:46:19 PM Waiting for: "D:\Program Files (x86)\WinSCP\SPS-Clevna-Get850.bat" to finish Information 1/20/2022 12:46:20 PM Executing File Operation: move clevna inbound ftp files Information 1/20/2022 12:46:20 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\clevna\Inbound_SPS\ Information 1/20/2022 12:46:20 PM Mask: *.csv Information 1/20/2022 12:46:20 PM Path Is Valid: True Information 1/20/2022 12:46:20 PM Include Directory: False Information 1/20/2022 12:46:20 PM In Sub Folders: False Information 1/20/2022 12:46:20 PM Attributes: ReadOnly Information 1/20/2022 12:46:20 PM Attribute: Hidden Information 1/20/2022 12:46:20 PM Attribute: SysFile Information 1/20/2022 12:46:20 PM Attribute: aArchive Information 1/20/2022 12:46:20 PM File Age: 30 Information 1/20/2022 12:46:20 PM Which File: 0 Error 1/20/2022 12:46:20 PM Could not find any files Information 1/20/2022 12:46:20 PM Checking File(s): clevna ftp file exits Information 1/20/2022 12:46:20 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\clevna\inbound_SPS\tobeprocessed\ Information 1/20/2022 12:46:20 PM Mask: *.csv Information 1/20/2022 12:46:20 PM Path Is Valid: True Information 1/20/2022 12:46:20 PM Include Directory: False Information 1/20/2022 12:46:20 PM In Sub Folders: False Information 1/20/2022 12:46:20 PM Attributes: ReadOnly Information 1/20/2022 12:46:20 PM Attribute: Hidden Information 1/20/2022 12:46:20 PM Attribute: SysFile Information 1/20/2022 12:46:20 PM Attribute: aArchive Information 1/20/2022 12:46:20 PM File Age: 0 Information 1/20/2022 12:46:20 PM Which File: 0 Error 1/20/2022 12:46:20 PM Could not find any files Information 1/20/2022 12:46:20 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\clevna\inbound_SPS\tobeprocessed\*.csv Error 1/20/2022 12:46:20 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\clevna\inbound_SPS\tobeprocessed\*.csv Information 1/20/2022 12:46:20 PM Executing Check Connection Information 1/20/2022 12:46:20 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:20 PM Connection Type is: ODBC Information 1/20/2022 12:46:20 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:20 PM Done! Information 1/20/2022 12:46:20 PM Executing Check Connection Information 1/20/2022 12:46:20 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:20 PM Connection Type is: ODBC Information 1/20/2022 12:46:20 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:20 PM Done! Information 1/20/2022 12:46:20 PM Executing Import: DIC 850 Sequnece Update Information 1/20/2022 12:46:22 PM Processed: 0 Records Information 1/20/2022 12:46:22 PM Errors: 0 Information 1/20/2022 12:46:22 PM Records per second: 0 Information 1/20/2022 12:46:22 PM Execution of Import Script: DIC 850 Sequnece Update has completed Information 1/20/2022 12:46:22 PM Executing Import: DIC 850 Sequence Reset Information 1/20/2022 12:46:23 PM Processed: 1 Records Information 1/20/2022 12:46:23 PM Errors: 0 Information 1/20/2022 12:46:23 PM Records per second: 2 Information 1/20/2022 12:46:23 PM Execution of Import Script: DIC 850 Sequence Reset has completed Information 1/20/2022 12:46:23 PM Executing Sql Check Data: inbound 850 record check Information 1/20/2022 12:46:23 PM Connection Name: IT-R4WMS-Read Information 1/20/2022 12:46:23 PM Connection Type is: ODBC Information 1/20/2022 12:46:23 PM Source DSN: it-r4wms-read-64b Information 1/20/2022 12:46:23 PM Using Following Sql: select count(*) FROM A2BF.dic_in850 where sentr4 = 'H' Error 1/20/2022 12:46:23 PM First Field is less or equals to zero Information 1/20/2022 12:46:24 PM Executing Check Connection Information 1/20/2022 12:46:24 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:24 PM Connection Type is: ODBC Information 1/20/2022 12:46:24 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:24 PM Done! Information 1/20/2022 12:46:24 PM Executing Check Connection Information 1/20/2022 12:46:24 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:24 PM Connection Type is: ODBC Information 1/20/2022 12:46:24 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:24 PM Done! Information 1/20/2022 12:46:24 PM Executing Package: IN-WILLAB Information 1/20/2022 12:46:24 PM Executing Package: IN-WILLAB-Ebay Information 1/20/2022 12:46:24 PM Executing File Operation: Copy from PCI to FTP Information 1/20/2022 12:46:24 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\WILLAB-NPCI\Inbound\ Information 1/20/2022 12:46:24 PM Mask: *ebay.csv Information 1/20/2022 12:46:24 PM Path Is Valid: True Information 1/20/2022 12:46:24 PM Include Directory: False Information 1/20/2022 12:46:24 PM In Sub Folders: False Information 1/20/2022 12:46:24 PM Attributes: ReadOnly Information 1/20/2022 12:46:24 PM Attribute: Hidden Information 1/20/2022 12:46:24 PM Attribute: SysFile Information 1/20/2022 12:46:24 PM Attribute: aArchive Information 1/20/2022 12:46:24 PM File Age: 30 Information 1/20/2022 12:46:24 PM Which File: 0 Error 1/20/2022 12:46:24 PM Could not find any files Information 1/20/2022 12:46:24 PM Checking File(s): Check Ebay File Information 1/20/2022 12:46:24 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Willab-Ebay\Inbound\TobeProcessed\ Information 1/20/2022 12:46:24 PM Mask: FileExchange*.csv Information 1/20/2022 12:46:24 PM Path Is Valid: True Information 1/20/2022 12:46:24 PM Include Directory: False Information 1/20/2022 12:46:24 PM In Sub Folders: False Information 1/20/2022 12:46:24 PM Attributes: ReadOnly Information 1/20/2022 12:46:24 PM Attribute: Hidden Information 1/20/2022 12:46:24 PM Attribute: SysFile Information 1/20/2022 12:46:24 PM Attribute: aArchive Information 1/20/2022 12:46:24 PM File Age: 0 Information 1/20/2022 12:46:24 PM Which File: 0 Error 1/20/2022 12:46:24 PM Could not find any files Information 1/20/2022 12:46:24 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Willab-Ebay\Inbound\TobeProcessed\FileExchange*.csv Error 1/20/2022 12:46:24 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Willab-Ebay\Inbound\TobeProcessed\FileExchange*.csv Information 1/20/2022 12:46:24 PM Executing Package: IN-WILLAB-Steals Information 1/20/2022 12:46:24 PM Executing File Operation: Copy from PCI to FTP Information 1/20/2022 12:46:24 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\WILLAB-NPCI\Inbound\ Information 1/20/2022 12:46:24 PM Mask: *steals.csv Information 1/20/2022 12:46:24 PM Path Is Valid: True Information 1/20/2022 12:46:24 PM Include Directory: False Information 1/20/2022 12:46:24 PM In Sub Folders: False Information 1/20/2022 12:46:24 PM Attributes: ReadOnly Information 1/20/2022 12:46:24 PM Attribute: Hidden Information 1/20/2022 12:46:24 PM Attribute: SysFile Information 1/20/2022 12:46:24 PM Attribute: aArchive Information 1/20/2022 12:46:24 PM File Age: 30 Information 1/20/2022 12:46:24 PM Which File: 0 Error 1/20/2022 12:46:24 PM Could not find any files Information 1/20/2022 12:46:24 PM Checking File(s): Check Steals File Information 1/20/2022 12:46:24 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Willab-Steals\Inbound\TobeProcessed\ Information 1/20/2022 12:46:24 PM Mask: *steals.csv Information 1/20/2022 12:46:24 PM Path Is Valid: True Information 1/20/2022 12:46:24 PM Include Directory: False Information 1/20/2022 12:46:24 PM In Sub Folders: False Information 1/20/2022 12:46:24 PM Attributes: ReadOnly Information 1/20/2022 12:46:24 PM Attribute: Hidden Information 1/20/2022 12:46:24 PM Attribute: SysFile Information 1/20/2022 12:46:24 PM Attribute: aArchive Information 1/20/2022 12:46:24 PM File Age: 0 Information 1/20/2022 12:46:24 PM Which File: 0 Error 1/20/2022 12:46:24 PM Could not find any files Information 1/20/2022 12:46:24 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Willab-Steals\Inbound\TobeProcessed\*steals.csv Error 1/20/2022 12:46:24 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Willab-Steals\Inbound\TobeProcessed\*steals.csv Information 1/20/2022 12:46:24 PM Executing Package: IN-WILLAB-Walmart Information 1/20/2022 12:46:24 PM Executing External Application: External Application Information 1/20/2022 12:46:24 PM Application Name: "D:\Program Files (x86)\WinSCP\WILLAB_WMT_Download.bat" Information 1/20/2022 12:46:24 PM Waiting for: "D:\Program Files (x86)\WinSCP\WILLAB_WMT_Download.bat" to finish Information 1/20/2022 12:46:26 PM Executing Sql Check Data: Check Willab Walmart Information 1/20/2022 12:46:26 PM Connection Name: A2BF_R4 Information 1/20/2022 12:46:26 PM Connection Type is: MS Sql Server Information 1/20/2022 12:46:26 PM Source MS Sql Server: a2b-prod-db.cih3cksd3z4h.us-east-1.rds.amazonaws.com Information 1/20/2022 12:46:26 PM Using Following Sql: select count(*) from A2BF_R4.dbo.wIMPORTER_A2B_Tmp WHERE processed = 0 AND Custid = 'WILLAB' AND SenderID = 'WILLAB-WALMART-DS' Error 1/20/2022 12:46:27 PM First Field is less or equals to zero Information 1/20/2022 12:46:27 PM Executing Check Connection Information 1/20/2022 12:46:27 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:46:27 PM Connection Type is: ODBC Information 1/20/2022 12:46:27 PM Source DSN: r4wms72-64b Information 1/20/2022 12:46:27 PM Done! Information 1/20/2022 12:46:27 PM Executing Package: IN-Genmar-Direksys Information 1/20/2022 12:46:27 PM Executing File Operation: Copy from PCI to FTP Information 1/20/2022 12:46:27 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\ Information 1/20/2022 12:46:27 PM Mask: *.txt Information 1/20/2022 12:46:27 PM Path Is Valid: True Information 1/20/2022 12:46:27 PM Include Directory: False Information 1/20/2022 12:46:27 PM In Sub Folders: False Information 1/20/2022 12:46:27 PM Attributes: ReadOnly Information 1/20/2022 12:46:27 PM Attribute: Hidden Information 1/20/2022 12:46:27 PM Attribute: SysFile Information 1/20/2022 12:46:27 PM Attribute: aArchive Information 1/20/2022 12:46:27 PM File Age: 30 Information 1/20/2022 12:46:27 PM Which File: 0 Information 1/20/2022 12:46:27 PM Found: 2 File(s) Information 1/20/2022 12:46:27 PM Copied file \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\18309_220120.txt into \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\18309_220120.txt Information 1/20/2022 12:46:27 PM Copied file \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\18310_220120.txt into \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\18310_220120.txt Information 1/20/2022 12:46:28 PM Checking File(s): genmar inbound check Information 1/20/2022 12:46:28 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\ Information 1/20/2022 12:46:28 PM Mask: *.txt Information 1/20/2022 12:46:28 PM Path Is Valid: True Information 1/20/2022 12:46:28 PM Include Directory: False Information 1/20/2022 12:46:28 PM In Sub Folders: False Information 1/20/2022 12:46:28 PM Attributes: ReadOnly Information 1/20/2022 12:46:28 PM Attribute: Hidden Information 1/20/2022 12:46:28 PM Attribute: SysFile Information 1/20/2022 12:46:28 PM Attribute: aArchive Information 1/20/2022 12:46:28 PM File Age: 0 Information 1/20/2022 12:46:28 PM Which File: 0 Information 1/20/2022 12:46:28 PM Found: 2 File(s) Information 1/20/2022 12:46:28 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\*.txt Information 1/20/2022 12:46:28 PM File(s) exists: \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\*.txt Information 1/20/2022 12:46:28 PM Executing Import: Filesystem In-Genmar-Direksys Information 1/20/2022 12:46:29 PM Processed: 2 Records Information 1/20/2022 12:46:29 PM Errors: 0 Information 1/20/2022 12:46:29 PM Records per second: 21 Information 1/20/2022 12:46:29 PM Execution of Import Script: Filesystem In-Genmar-Direksys has completed Information 1/20/2022 12:46:29 PM Executing Import: Genmar-Direksys import-New Information 1/20/2022 12:46:31 PM Processed: 12 Records Information 1/20/2022 12:46:31 PM Errors: 0 Information 1/20/2022 12:46:31 PM Records per second: 33 Information 1/20/2022 12:46:31 PM Execution of Import Script: Genmar-Direksys import-New has completed Information 1/20/2022 12:46:31 PM Executing Package: IN-Direksys-Genpet Information 1/20/2022 12:46:31 PM Executing Import: Direksys-Genpet Item Count Information 1/20/2022 12:46:32 PM Processed: 0 Records Information 1/20/2022 12:46:32 PM Errors: 0 Information 1/20/2022 12:46:32 PM Records per second: 0 Information 1/20/2022 12:46:32 PM Execution of Import Script: Direksys-Genpet Item Count has completed Information 1/20/2022 12:46:32 PM Executing Sql Script: GENPETUpdates Information 1/20/2022 12:46:32 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:32 PM Connection Type is: ODBC Information 1/20/2022 12:46:33 PM Executing Sql Script: genmar 3rd party Information 1/20/2022 12:46:33 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:33 PM Connection Type is: ODBC Information 1/20/2022 12:46:34 PM Executing File Operation: Genmar-Direksys file delete Information 1/20/2022 12:46:34 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\ Information 1/20/2022 12:46:34 PM Mask: *.* Information 1/20/2022 12:46:34 PM Path Is Valid: True Information 1/20/2022 12:46:34 PM Include Directory: False Information 1/20/2022 12:46:34 PM In Sub Folders: False Information 1/20/2022 12:46:34 PM Attributes: ReadOnly Information 1/20/2022 12:46:34 PM Attribute: Hidden Information 1/20/2022 12:46:34 PM Attribute: SysFile Information 1/20/2022 12:46:34 PM Attribute: aArchive Information 1/20/2022 12:46:34 PM File Age: 30 Information 1/20/2022 12:46:34 PM Which File: 0 Information 1/20/2022 12:46:34 PM Found: 2 File(s) Information 1/20/2022 12:46:34 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\18309_220120.txt into \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\processed\ Information 1/20/2022 12:46:34 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\18310_220120.txt into \\amznfsxxwk04bhm.corp.a2bf.com\share\Genmar\Direksys\processed\ Information 1/20/2022 12:46:34 PM Executing File Operation: Move PCI to Processed Information 1/20/2022 12:46:34 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\ Information 1/20/2022 12:46:34 PM Mask: *.txt Information 1/20/2022 12:46:34 PM Path Is Valid: True Information 1/20/2022 12:46:34 PM Include Directory: False Information 1/20/2022 12:46:34 PM In Sub Folders: False Information 1/20/2022 12:46:34 PM Attributes: ReadOnly Information 1/20/2022 12:46:34 PM Attribute: Hidden Information 1/20/2022 12:46:34 PM Attribute: SysFile Information 1/20/2022 12:46:34 PM Attribute: aArchive Information 1/20/2022 12:46:34 PM File Age: 30 Information 1/20/2022 12:46:34 PM Which File: 0 Information 1/20/2022 12:46:34 PM Found: 2 File(s) Information 1/20/2022 12:46:34 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\18309_220120.txt into \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\Processed Information 1/20/2022 12:46:34 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\18310_220120.txt into \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\Genmar-Direksys\Inbound\Processed Information 1/20/2022 12:46:34 PM Executing Package: In-Retcar Information 1/20/2022 12:46:34 PM Executing External Application: Get Retcar-GF Files Information 1/20/2022 12:46:34 PM Application Name: "D:\Program Files (x86)\WinSCP\RETCARMove01.bat" Information 1/20/2022 12:46:34 PM Waiting for: "D:\Program Files (x86)\WinSCP\RETCARMove01.bat" to finish Error 1/20/2022 12:46:36 PM External Application: "Get Retcar-GF Files" has failed Information 1/20/2022 12:46:36 PM Checking File(s): Check for new Retcar-GF imports Information 1/20/2022 12:46:36 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Retcar\Inbound\ Information 1/20/2022 12:46:36 PM Mask: *.csv Information 1/20/2022 12:46:36 PM Path Is Valid: True Information 1/20/2022 12:46:36 PM Include Directory: False Information 1/20/2022 12:46:36 PM In Sub Folders: False Information 1/20/2022 12:46:36 PM Attributes: ReadOnly Information 1/20/2022 12:46:36 PM Attribute: Hidden Information 1/20/2022 12:46:36 PM Attribute: SysFile Information 1/20/2022 12:46:36 PM Attribute: aArchive Information 1/20/2022 12:46:36 PM File Age: 0 Information 1/20/2022 12:46:36 PM Which File: 0 Error 1/20/2022 12:46:36 PM Could not find any files Information 1/20/2022 12:46:36 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Retcar\Inbound\*.csv Error 1/20/2022 12:46:36 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Retcar\Inbound\*.csv Information 1/20/2022 12:46:36 PM Executing PING Server: Ping Server Information 1/20/2022 12:46:36 PM Done! Information 1/20/2022 12:46:36 PM Executing Package: IN-CTRYST Information 1/20/2022 12:46:36 PM Checking File(s): Check File Information 1/20/2022 12:46:36 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\CTRYST\Inbound\ Information 1/20/2022 12:46:36 PM Mask: *.CSV Information 1/20/2022 12:46:36 PM Path Is Valid: True Information 1/20/2022 12:46:36 PM Include Directory: False Information 1/20/2022 12:46:36 PM In Sub Folders: False Information 1/20/2022 12:46:36 PM Attributes: ReadOnly Information 1/20/2022 12:46:36 PM Attribute: Hidden Information 1/20/2022 12:46:36 PM Attribute: SysFile Information 1/20/2022 12:46:36 PM Attribute: aArchive Information 1/20/2022 12:46:36 PM File Age: 0 Information 1/20/2022 12:46:36 PM Which File: 0 Error 1/20/2022 12:46:36 PM Could not find any files Information 1/20/2022 12:46:36 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\CTRYST\Inbound\*.CSV Error 1/20/2022 12:46:36 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\CTRYST\Inbound\*.CSV Information 1/20/2022 12:46:37 PM Executing Check Connection Information 1/20/2022 12:46:37 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:37 PM Connection Type is: ODBC Information 1/20/2022 12:46:37 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:37 PM Done! Information 1/20/2022 12:46:37 PM Executing Package: IN-Actegy Information 1/20/2022 12:46:37 PM Checking File(s): Check File - Actegy inbound Information 1/20/2022 12:46:37 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Actegy\Inbound\ Information 1/20/2022 12:46:37 PM Mask: *.csv Information 1/20/2022 12:46:37 PM Path Is Valid: True Information 1/20/2022 12:46:37 PM Include Directory: False Information 1/20/2022 12:46:37 PM In Sub Folders: False Information 1/20/2022 12:46:37 PM Attributes: ReadOnly Information 1/20/2022 12:46:37 PM Attribute: Hidden Information 1/20/2022 12:46:37 PM Attribute: SysFile Information 1/20/2022 12:46:37 PM Attribute: aArchive Information 1/20/2022 12:46:37 PM File Age: 0 Information 1/20/2022 12:46:37 PM Which File: 0 Error 1/20/2022 12:46:37 PM Could not find any files Information 1/20/2022 12:46:37 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Actegy\Inbound\*.csv Error 1/20/2022 12:46:37 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Actegy\Inbound\*.csv Information 1/20/2022 12:46:37 PM Executing Check Connection Information 1/20/2022 12:46:37 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:46:37 PM Connection Type is: ODBC Information 1/20/2022 12:46:37 PM Source DSN: r4wms72-64b Information 1/20/2022 12:46:37 PM Done! Information 1/20/2022 12:46:37 PM Executing Package: IN-FITOND Information 1/20/2022 12:46:38 PM Executing File Operation: FITOND File Move Inbound tobeprocessed Information 1/20/2022 12:46:38 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\FITOND\ Information 1/20/2022 12:46:38 PM Mask: *.csv Information 1/20/2022 12:46:38 PM Path Is Valid: True Information 1/20/2022 12:46:38 PM Include Directory: False Information 1/20/2022 12:46:38 PM In Sub Folders: False Information 1/20/2022 12:46:38 PM Attributes: ReadOnly Information 1/20/2022 12:46:38 PM Attribute: Hidden Information 1/20/2022 12:46:38 PM Attribute: SysFile Information 1/20/2022 12:46:38 PM Attribute: aArchive Information 1/20/2022 12:46:38 PM File Age: 30 Information 1/20/2022 12:46:38 PM Which File: 0 Error 1/20/2022 12:46:38 PM Could not find any files Information 1/20/2022 12:46:38 PM Checking File(s): FITOND Check File Inbound Information 1/20/2022 12:46:38 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\FITOND\Inbound\tobeprocessed\ Information 1/20/2022 12:46:38 PM Mask: *.csv Information 1/20/2022 12:46:38 PM Path Is Valid: True Information 1/20/2022 12:46:38 PM Include Directory: False Information 1/20/2022 12:46:38 PM In Sub Folders: False Information 1/20/2022 12:46:38 PM Attributes: ReadOnly Information 1/20/2022 12:46:38 PM Attribute: Hidden Information 1/20/2022 12:46:38 PM Attribute: SysFile Information 1/20/2022 12:46:38 PM Attribute: aArchive Information 1/20/2022 12:46:38 PM File Age: 0 Information 1/20/2022 12:46:38 PM Which File: 0 Error 1/20/2022 12:46:38 PM Could not find any files Information 1/20/2022 12:46:38 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\FITOND\Inbound\tobeprocessed\*.csv Error 1/20/2022 12:46:38 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\FITOND\Inbound\tobeprocessed\*.csv Information 1/20/2022 12:46:38 PM Executing Check Connection Information 1/20/2022 12:46:38 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:38 PM Connection Type is: ODBC Information 1/20/2022 12:46:38 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:38 PM Done! Information 1/20/2022 12:46:38 PM Executing Package: IN-GENPET-WOO-FTPS Information 1/20/2022 12:46:38 PM Executing External Application: genpet ftps get Information 1/20/2022 12:46:38 PM Application Name: "D:\Program Files (x86)\WinSCP\GENPETMove01.bat" Information 1/20/2022 12:46:38 PM Waiting for: "D:\Program Files (x86)\WinSCP\GENPETMove01.bat" to finish Information 1/20/2022 12:46:39 PM Checking File(s): GENPET inbound check Information 1/20/2022 12:46:39 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\GENPET\Inbound\ Information 1/20/2022 12:46:39 PM Mask: *.csv Information 1/20/2022 12:46:39 PM Path Is Valid: True Information 1/20/2022 12:46:39 PM Include Directory: False Information 1/20/2022 12:46:39 PM In Sub Folders: False Information 1/20/2022 12:46:39 PM Attributes: ReadOnly Information 1/20/2022 12:46:39 PM Attribute: Hidden Information 1/20/2022 12:46:39 PM Attribute: SysFile Information 1/20/2022 12:46:39 PM Attribute: aArchive Information 1/20/2022 12:46:39 PM File Age: 0 Information 1/20/2022 12:46:39 PM Which File: 0 Error 1/20/2022 12:46:39 PM Could not find any files Information 1/20/2022 12:46:39 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\GENPET\Inbound\*.csv Error 1/20/2022 12:46:39 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\GENPET\Inbound\*.csv Information 1/20/2022 12:46:39 PM Executing Check Connection Information 1/20/2022 12:46:39 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:39 PM Connection Type is: ODBC Information 1/20/2022 12:46:39 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:39 PM Done! Information 1/20/2022 12:46:39 PM Executing Package: IN-FLEXSL Information 1/20/2022 12:46:39 PM Executing File Operation: Copy from PCI to FTP Information 1/20/2022 12:46:39 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\FLEXSL-NPCI\Inbound\ Information 1/20/2022 12:46:39 PM Mask: *.txt Information 1/20/2022 12:46:39 PM Path Is Valid: True Information 1/20/2022 12:46:39 PM Include Directory: False Information 1/20/2022 12:46:39 PM In Sub Folders: False Information 1/20/2022 12:46:39 PM Attributes: ReadOnly Information 1/20/2022 12:46:39 PM Attribute: Hidden Information 1/20/2022 12:46:39 PM Attribute: SysFile Information 1/20/2022 12:46:39 PM Attribute: aArchive Information 1/20/2022 12:46:39 PM File Age: 30 Information 1/20/2022 12:46:39 PM Which File: 0 Error 1/20/2022 12:46:39 PM Could not find any files Information 1/20/2022 12:46:39 PM Checking File(s): Check FLEXSL File Information 1/20/2022 12:46:39 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\FLEXSL\Inbound\ToBeProcessed\ Information 1/20/2022 12:46:39 PM Mask: *.txt Information 1/20/2022 12:46:39 PM Path Is Valid: True Information 1/20/2022 12:46:39 PM Include Directory: False Information 1/20/2022 12:46:39 PM In Sub Folders: False Information 1/20/2022 12:46:39 PM Attributes: ReadOnly Information 1/20/2022 12:46:39 PM Attribute: Hidden Information 1/20/2022 12:46:39 PM Attribute: SysFile Information 1/20/2022 12:46:39 PM Attribute: aArchive Information 1/20/2022 12:46:39 PM File Age: 0 Information 1/20/2022 12:46:39 PM Which File: 0 Error 1/20/2022 12:46:39 PM Could not find any files Information 1/20/2022 12:46:39 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\FLEXSL\Inbound\ToBeProcessed\*.txt Error 1/20/2022 12:46:39 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\FLEXSL\Inbound\ToBeProcessed\*.txt Information 1/20/2022 12:46:39 PM Executing Check Connection Information 1/20/2022 12:46:39 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:39 PM Connection Type is: ODBC Information 1/20/2022 12:46:39 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:39 PM Done! Information 1/20/2022 12:46:40 PM Executing Package: IN-BROWNI Information 1/20/2022 12:46:40 PM Executing Sql Script: BROWNI SQL Information 1/20/2022 12:46:40 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:40 PM Connection Type is: ODBC Information 1/20/2022 12:46:41 PM Executing Package: IN-TLTALE Information 1/20/2022 12:46:41 PM Executing File Operation: Copy from PCI to FTP Information 1/20/2022 12:46:41 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\TLTALE-NPCI\Inbound\ Information 1/20/2022 12:46:41 PM Mask: order*.csv Information 1/20/2022 12:46:41 PM Path Is Valid: True Information 1/20/2022 12:46:41 PM Include Directory: False Information 1/20/2022 12:46:41 PM In Sub Folders: False Information 1/20/2022 12:46:41 PM Attributes: ReadOnly Information 1/20/2022 12:46:41 PM Attribute: Hidden Information 1/20/2022 12:46:41 PM Attribute: SysFile Information 1/20/2022 12:46:41 PM Attribute: aArchive Information 1/20/2022 12:46:41 PM File Age: 30 Information 1/20/2022 12:46:41 PM Which File: 0 Error 1/20/2022 12:46:41 PM Could not find any files Information 1/20/2022 12:46:41 PM Checking File(s): Check File Information 1/20/2022 12:46:41 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\TLTALE\Inbound\ Information 1/20/2022 12:46:41 PM Mask: Order*.csv Information 1/20/2022 12:46:41 PM Path Is Valid: True Information 1/20/2022 12:46:41 PM Include Directory: False Information 1/20/2022 12:46:41 PM In Sub Folders: False Information 1/20/2022 12:46:41 PM Attributes: ReadOnly Information 1/20/2022 12:46:41 PM Attribute: Hidden Information 1/20/2022 12:46:41 PM Attribute: SysFile Information 1/20/2022 12:46:41 PM Attribute: aArchive Information 1/20/2022 12:46:41 PM File Age: 0 Information 1/20/2022 12:46:41 PM Which File: 0 Error 1/20/2022 12:46:41 PM Could not find any files Information 1/20/2022 12:46:41 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\TLTALE\Inbound\Order*.csv Error 1/20/2022 12:46:41 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\TLTALE\Inbound\Order*.csv Information 1/20/2022 12:46:41 PM Checking File(s): Check File Information 1/20/2022 12:46:41 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\TLTALE-NPCI\Inbound\ Information 1/20/2022 12:46:41 PM Mask: er*.csv Information 1/20/2022 12:46:41 PM Path Is Valid: True Information 1/20/2022 12:46:41 PM Include Directory: False Information 1/20/2022 12:46:41 PM In Sub Folders: False Information 1/20/2022 12:46:41 PM Attributes: ReadOnly Information 1/20/2022 12:46:41 PM Attribute: Hidden Information 1/20/2022 12:46:41 PM Attribute: SysFile Information 1/20/2022 12:46:41 PM Attribute: aArchive Information 1/20/2022 12:46:41 PM File Age: 0 Information 1/20/2022 12:46:41 PM Which File: 0 Error 1/20/2022 12:46:41 PM Could not find any files Information 1/20/2022 12:46:41 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\TLTALE-NPCI\Inbound\er*.csv Error 1/20/2022 12:46:41 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Non-PCI Files\TLTALE-NPCI\Inbound\er*.csv Information 1/20/2022 12:46:41 PM Executing Check Connection Information 1/20/2022 12:46:41 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:41 PM Connection Type is: ODBC Information 1/20/2022 12:46:41 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:41 PM Done! Information 1/20/2022 12:46:41 PM Executing Package: IN-SHREDS Information 1/20/2022 12:46:41 PM Checking File(s): Check File Information 1/20/2022 12:46:41 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\SHREDS\Inbound\ Information 1/20/2022 12:46:41 PM Mask: IMP_SO_*.csv Information 1/20/2022 12:46:41 PM Path Is Valid: True Information 1/20/2022 12:46:41 PM Include Directory: False Information 1/20/2022 12:46:41 PM In Sub Folders: False Information 1/20/2022 12:46:41 PM Attributes: ReadOnly Information 1/20/2022 12:46:41 PM Attribute: Hidden Information 1/20/2022 12:46:41 PM Attribute: SysFile Information 1/20/2022 12:46:41 PM Attribute: aArchive Information 1/20/2022 12:46:41 PM File Age: 0 Information 1/20/2022 12:46:41 PM Which File: 0 Error 1/20/2022 12:46:41 PM Could not find any files Information 1/20/2022 12:46:41 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\SHREDS\Inbound\IMP_SO_*.csv Error 1/20/2022 12:46:41 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\SHREDS\Inbound\IMP_SO_*.csv Information 1/20/2022 12:46:42 PM Executing Check Connection Information 1/20/2022 12:46:42 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:42 PM Connection Type is: ODBC Information 1/20/2022 12:46:42 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:42 PM Done! Information 1/20/2022 12:46:42 PM Executing Package: IN-VORTEX Information 1/20/2022 12:46:42 PM Checking File(s): Check FTP File Information 1/20/2022 12:46:42 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\VORTEX\Inbound\ Information 1/20/2022 12:46:42 PM Mask: *.csv Information 1/20/2022 12:46:42 PM Path Is Valid: True Information 1/20/2022 12:46:42 PM Include Directory: False Information 1/20/2022 12:46:42 PM In Sub Folders: False Information 1/20/2022 12:46:42 PM Attributes: ReadOnly Information 1/20/2022 12:46:42 PM Attribute: Hidden Information 1/20/2022 12:46:42 PM Attribute: SysFile Information 1/20/2022 12:46:42 PM Attribute: aArchive Information 1/20/2022 12:46:42 PM File Age: 0 Information 1/20/2022 12:46:42 PM Which File: 0 Error 1/20/2022 12:46:42 PM Could not find any files Information 1/20/2022 12:46:42 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\VORTEX\Inbound\*.csv Error 1/20/2022 12:46:42 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\VORTEX\Inbound\*.csv Information 1/20/2022 12:46:42 PM Checking File(s): Check Wrong folder Information 1/20/2022 12:46:42 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\VORTEX\ Information 1/20/2022 12:46:42 PM Mask: *.csv Information 1/20/2022 12:46:42 PM Path Is Valid: True Information 1/20/2022 12:46:42 PM Include Directory: False Information 1/20/2022 12:46:42 PM In Sub Folders: False Information 1/20/2022 12:46:42 PM Attributes: ReadOnly Information 1/20/2022 12:46:42 PM Attribute: Hidden Information 1/20/2022 12:46:42 PM Attribute: SysFile Information 1/20/2022 12:46:42 PM Attribute: aArchive Information 1/20/2022 12:46:42 PM File Age: 0 Information 1/20/2022 12:46:42 PM Which File: 0 Error 1/20/2022 12:46:42 PM Could not find any files Information 1/20/2022 12:46:42 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\VORTEX\*.csv Error 1/20/2022 12:46:42 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\VORTEX\*.csv Information 1/20/2022 12:46:42 PM Executing Check Connection Information 1/20/2022 12:46:42 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:42 PM Connection Type is: ODBC Information 1/20/2022 12:46:42 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:42 PM Done! Information 1/20/2022 12:46:42 PM Executing Package: IN-PARKAV Information 1/20/2022 12:46:42 PM Executing File Operation: File Operation Information 1/20/2022 12:46:42 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\PARKAV-KNOCK\Inbound\ Information 1/20/2022 12:46:42 PM Mask: knock*.txt Information 1/20/2022 12:46:42 PM Path Is Valid: True Information 1/20/2022 12:46:42 PM Include Directory: False Information 1/20/2022 12:46:42 PM In Sub Folders: False Information 1/20/2022 12:46:42 PM Attributes: ReadOnly Information 1/20/2022 12:46:42 PM Attribute: Hidden Information 1/20/2022 12:46:42 PM Attribute: SysFile Information 1/20/2022 12:46:42 PM Attribute: aArchive Information 1/20/2022 12:46:42 PM File Age: 30 Information 1/20/2022 12:46:42 PM Which File: 0 Error 1/20/2022 12:46:42 PM Could not find any files Information 1/20/2022 12:46:42 PM Executing Check Connection Information 1/20/2022 12:46:42 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:42 PM Connection Type is: ODBC Information 1/20/2022 12:46:42 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:42 PM Done! Information 1/20/2022 12:46:42 PM Executing Package: In-Struno-HSN Information 1/20/2022 12:46:42 PM Executing External Application: Struno-HSN-get-850 Information 1/20/2022 12:46:42 PM Application Name: "D:\Program Files (x86)\WinSCP\Struno-HSN-Get-850.bat" Information 1/20/2022 12:46:42 PM Waiting for: "D:\Program Files (x86)\WinSCP\Struno-HSN-Get-850.bat" to finish Information 1/20/2022 12:46:45 PM Checking File(s): Struno-hsn import check Information 1/20/2022 12:46:45 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Struno\HSN\Inbound-850\ Information 1/20/2022 12:46:45 PM Mask: *.csv Information 1/20/2022 12:46:45 PM Path Is Valid: True Information 1/20/2022 12:46:45 PM Include Directory: False Information 1/20/2022 12:46:45 PM In Sub Folders: False Information 1/20/2022 12:46:45 PM Attributes: ReadOnly Information 1/20/2022 12:46:45 PM Attribute: Hidden Information 1/20/2022 12:46:45 PM Attribute: SysFile Information 1/20/2022 12:46:45 PM Attribute: aArchive Information 1/20/2022 12:46:45 PM File Age: 0 Information 1/20/2022 12:46:45 PM Which File: 0 Error 1/20/2022 12:46:45 PM Could not find any files Information 1/20/2022 12:46:45 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Struno\HSN\Inbound-850\*.csv Error 1/20/2022 12:46:45 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\Struno\HSN\Inbound-850\*.csv Information 1/20/2022 12:46:45 PM Executing Check Connection Information 1/20/2022 12:46:46 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:46 PM Connection Type is: ODBC Information 1/20/2022 12:46:46 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:46 PM Done! Information 1/20/2022 12:46:46 PM Executing Package: IN-SEEDLP Information 1/20/2022 12:46:46 PM Executing File Operation: File Operation Information 1/20/2022 12:46:46 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Goop\Inbound\ Information 1/20/2022 12:46:46 PM Mask: *.csv Information 1/20/2022 12:46:46 PM Path Is Valid: True Information 1/20/2022 12:46:46 PM Include Directory: False Information 1/20/2022 12:46:46 PM In Sub Folders: False Information 1/20/2022 12:46:46 PM Attributes: ReadOnly Information 1/20/2022 12:46:46 PM Attribute: Hidden Information 1/20/2022 12:46:46 PM Attribute: SysFile Information 1/20/2022 12:46:46 PM Attribute: aArchive Information 1/20/2022 12:46:46 PM File Age: 30 Information 1/20/2022 12:46:46 PM Which File: 0 Error 1/20/2022 12:46:46 PM Could not find any files Information 1/20/2022 12:46:46 PM Checking File(s): Check File Information 1/20/2022 12:46:46 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Goop\Inbound\ToBeProcessed\ Information 1/20/2022 12:46:46 PM Mask: *.csv Information 1/20/2022 12:46:46 PM Path Is Valid: True Information 1/20/2022 12:46:46 PM Include Directory: False Information 1/20/2022 12:46:46 PM In Sub Folders: False Information 1/20/2022 12:46:46 PM Attributes: ReadOnly Information 1/20/2022 12:46:46 PM Attribute: Hidden Information 1/20/2022 12:46:46 PM Attribute: SysFile Information 1/20/2022 12:46:46 PM Attribute: aArchive Information 1/20/2022 12:46:46 PM File Age: 0 Information 1/20/2022 12:46:46 PM Which File: 0 Error 1/20/2022 12:46:46 PM Could not find any files Information 1/20/2022 12:46:46 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Goop\Inbound\ToBeProcessed\*.csv Error 1/20/2022 12:46:46 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Goop\Inbound\ToBeProcessed\*.csv Information 1/20/2022 12:46:46 PM Executing File Operation: File Operation Information 1/20/2022 12:46:46 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Food52\Inbound\ Information 1/20/2022 12:46:46 PM Mask: *.csv Information 1/20/2022 12:46:46 PM Path Is Valid: True Information 1/20/2022 12:46:46 PM Include Directory: False Information 1/20/2022 12:46:46 PM In Sub Folders: False Information 1/20/2022 12:46:46 PM Attributes: ReadOnly Information 1/20/2022 12:46:46 PM Attribute: Hidden Information 1/20/2022 12:46:46 PM Attribute: SysFile Information 1/20/2022 12:46:46 PM Attribute: aArchive Information 1/20/2022 12:46:46 PM File Age: 30 Information 1/20/2022 12:46:46 PM Which File: 0 Error 1/20/2022 12:46:46 PM Could not find any files Information 1/20/2022 12:46:46 PM Checking File(s): Check File Information 1/20/2022 12:46:46 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Food52\Inbound\ToBeProcessed\ Information 1/20/2022 12:46:46 PM Mask: *.csv Information 1/20/2022 12:46:46 PM Path Is Valid: True Information 1/20/2022 12:46:46 PM Include Directory: False Information 1/20/2022 12:46:46 PM In Sub Folders: False Information 1/20/2022 12:46:46 PM Attributes: ReadOnly Information 1/20/2022 12:46:46 PM Attribute: Hidden Information 1/20/2022 12:46:46 PM Attribute: SysFile Information 1/20/2022 12:46:46 PM Attribute: aArchive Information 1/20/2022 12:46:46 PM File Age: 0 Information 1/20/2022 12:46:46 PM Which File: 0 Error 1/20/2022 12:46:46 PM Could not find any files Information 1/20/2022 12:46:46 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Food52\Inbound\ToBeProcessed\*.csv Error 1/20/2022 12:46:46 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\SEEDLP\Food52\Inbound\ToBeProcessed\*.csv Information 1/20/2022 12:46:47 PM Executing Check Connection Information 1/20/2022 12:46:47 PM Connection Name: R4 WMS READ ONLY Information 1/20/2022 12:46:47 PM Connection Type is: ODBC Information 1/20/2022 12:46:47 PM Source DSN: r4wms72-64b Information 1/20/2022 12:46:47 PM Done! Information 1/20/2022 12:46:47 PM Executing Package: In-MBTUSA Information 1/20/2022 12:46:47 PM Checking File(s): Check MBTUSA inbound file Information 1/20/2022 12:46:47 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\MBTUSA\Inbound\ Information 1/20/2022 12:46:47 PM Mask: *.csv Information 1/20/2022 12:46:47 PM Path Is Valid: True Information 1/20/2022 12:46:47 PM Include Directory: False Information 1/20/2022 12:46:47 PM In Sub Folders: False Information 1/20/2022 12:46:47 PM Attributes: ReadOnly Information 1/20/2022 12:46:47 PM Attribute: Hidden Information 1/20/2022 12:46:47 PM Attribute: SysFile Information 1/20/2022 12:46:47 PM Attribute: aArchive Information 1/20/2022 12:46:47 PM File Age: 0 Information 1/20/2022 12:46:47 PM Which File: 0 Error 1/20/2022 12:46:47 PM Could not find any files Information 1/20/2022 12:46:47 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\MBTUSA\Inbound\*.csv Error 1/20/2022 12:46:47 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\MBTUSA\Inbound\*.csv Information 1/20/2022 12:46:47 PM Checking File(s): Check MBTUSA file in tobeprocessed Information 1/20/2022 12:46:47 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\MBTUSA\Inbound\ToBeProcessed\ Information 1/20/2022 12:46:47 PM Mask: *.csv Information 1/20/2022 12:46:47 PM Path Is Valid: True Information 1/20/2022 12:46:47 PM Include Directory: False Information 1/20/2022 12:46:47 PM In Sub Folders: False Information 1/20/2022 12:46:47 PM Attributes: ReadOnly Information 1/20/2022 12:46:47 PM Attribute: Hidden Information 1/20/2022 12:46:47 PM Attribute: SysFile Information 1/20/2022 12:46:47 PM Attribute: aArchive Information 1/20/2022 12:46:47 PM File Age: 0 Information 1/20/2022 12:46:47 PM Which File: 0 Error 1/20/2022 12:46:47 PM Could not find any files Information 1/20/2022 12:46:47 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\MBTUSA\Inbound\ToBeProcessed\*.csv Error 1/20/2022 12:46:47 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\MBTUSA\Inbound\ToBeProcessed\*.csv Information 1/20/2022 12:46:47 PM Executing Check Connection Information 1/20/2022 12:46:47 PM Connection Name: R4WMSIMP Information 1/20/2022 12:46:47 PM Connection Type is: ODBC Information 1/20/2022 12:46:47 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:46:47 PM Done! Information 1/20/2022 12:46:47 PM Executing Package: IN-BOODYW-AIMS360 Information 1/20/2022 12:46:48 PM Executing External Application: boodyw aims360-940 ftps get Information 1/20/2022 12:46:48 PM Application Name: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360940Move01.bat" Information 1/20/2022 12:46:48 PM Waiting for: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360940Move01.bat" to finish Information 1/20/2022 12:47:02 PM Executing External Application: boddyw aims360-940 ftps move Information 1/20/2022 12:47:02 PM Application Name: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360940Move02.bat" Information 1/20/2022 12:47:02 PM Waiting for: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360940Move02.bat" to finish Information 1/20/2022 12:47:08 PM Checking File(s): BOODYW inbound check Information 1/20/2022 12:47:08 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\ Information 1/20/2022 12:47:08 PM Mask: *940*.xml Information 1/20/2022 12:47:08 PM Path Is Valid: True Information 1/20/2022 12:47:08 PM Include Directory: False Information 1/20/2022 12:47:08 PM In Sub Folders: False Information 1/20/2022 12:47:08 PM Attributes: ReadOnly Information 1/20/2022 12:47:08 PM Attribute: Hidden Information 1/20/2022 12:47:08 PM Attribute: SysFile Information 1/20/2022 12:47:08 PM Attribute: aArchive Information 1/20/2022 12:47:08 PM File Age: 0 Information 1/20/2022 12:47:08 PM Which File: 0 Information 1/20/2022 12:47:08 PM Found: 26 File(s) Information 1/20/2022 12:47:08 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\*940*.xml Information 1/20/2022 12:47:08 PM File(s) exists: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\*940*.xml Information 1/20/2022 12:47:08 PM Executing Import: Filesystem In-BOODYW AIMS360 940 Information 1/20/2022 12:47:08 PM Processed: 26 Records Information 1/20/2022 12:47:08 PM Errors: 0 Information 1/20/2022 12:47:08 PM Records per second: 184 Information 1/20/2022 12:47:08 PM Execution of Import Script: Filesystem In-BOODYW AIMS360 940 has completed Information 1/20/2022 12:47:08 PM Executing External Application: BOODYW AIMS360-940 Import Information 1/20/2022 12:47:08 PM Application Name: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360-940.bat" Information 1/20/2022 12:47:08 PM Waiting for: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360-940.bat" to finish Information 1/20/2022 12:47:09 PM Executing Sql Check Data: Check BOODYW AIMS360 Information 1/20/2022 12:47:09 PM Connection Name: A2BF_R4 Information 1/20/2022 12:47:09 PM Connection Type is: MS Sql Server Information 1/20/2022 12:47:09 PM Source MS Sql Server: a2b-prod-db.cih3cksd3z4h.us-east-1.rds.amazonaws.com Information 1/20/2022 12:47:09 PM Using Following Sql: select count(*) from A2BF_R4.dbo.wIMPORTER_A2B_Tmp WHERE processed = 0 AND Custid = 'BOODYW' Information 1/20/2022 12:47:10 PM First Field is bigger than zero Information 1/20/2022 12:47:10 PM Executing Import: BOODYW AIMS360 - 940 Import Information 1/20/2022 12:47:11 PM Processed: 72 Records Information 1/20/2022 12:47:11 PM Errors: 0 Information 1/20/2022 12:47:11 PM Records per second: 271 Information 1/20/2022 12:47:11 PM Execution of Import Script: BOODYW AIMS360 - 940 Import has completed Information 1/20/2022 12:47:11 PM Executing Import: BOODYW AIMS360 - Update ItemId Information 1/20/2022 12:47:13 PM Processed: 72 Records Information 1/20/2022 12:47:13 PM Errors: 0 Information 1/20/2022 12:47:13 PM Records per second: 242 Information 1/20/2022 12:47:13 PM Execution of Import Script: BOODYW AIMS360 - Update ItemId has completed Information 1/20/2022 12:47:13 PM Executing Sql Script: BOODYW-AIMS360 -A2BF Processed Orders Information 1/20/2022 12:47:13 PM Connection Name: A2BF_R4 Information 1/20/2022 12:47:13 PM Connection Type is: MS Sql Server Information 1/20/2022 12:47:14 PM Executing File Operation: File Operation Information 1/20/2022 12:47:14 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\ Information 1/20/2022 12:47:14 PM Mask: *940*.xml Information 1/20/2022 12:47:14 PM Path Is Valid: True Information 1/20/2022 12:47:14 PM Include Directory: False Information 1/20/2022 12:47:14 PM In Sub Folders: False Information 1/20/2022 12:47:14 PM Attributes: ReadOnly Information 1/20/2022 12:47:14 PM Attribute: Hidden Information 1/20/2022 12:47:14 PM Attribute: SysFile Information 1/20/2022 12:47:14 PM Attribute: aArchive Information 1/20/2022 12:47:14 PM File Age: 30 Information 1/20/2022 12:47:14 PM Which File: 0 Information 1/20/2022 12:47:14 PM Found: 26 File(s) Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091314.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091357.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091406.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091407.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091528.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091545.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091838.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091945.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120091947.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120092015.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120092116.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120092540.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120092750.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120092801.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120092805.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120093313.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120093329.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120093408.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120093507.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:14 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120093829.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120094029.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120094232.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120094358.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120094417.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120094439.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Moved file : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\AIMS940_20220120094607.xml into \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\Processed Information 1/20/2022 12:47:15 PM Executing External Application: boddyw aims360-943 ftps get Information 1/20/2022 12:47:15 PM Application Name: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360943Move01.bat" Information 1/20/2022 12:47:15 PM Waiting for: "D:\Program Files (x86)\WinSCP\BOODYWAIMS360943Move01.bat" to finish Information 1/20/2022 12:47:16 PM Checking File(s): BOODYW inbound check Information 1/20/2022 12:47:16 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\ Information 1/20/2022 12:47:16 PM Mask: *943*.xml Information 1/20/2022 12:47:16 PM Path Is Valid: True Information 1/20/2022 12:47:16 PM Include Directory: False Information 1/20/2022 12:47:16 PM In Sub Folders: False Information 1/20/2022 12:47:16 PM Attributes: ReadOnly Information 1/20/2022 12:47:16 PM Attribute: Hidden Information 1/20/2022 12:47:16 PM Attribute: SysFile Information 1/20/2022 12:47:16 PM Attribute: aArchive Information 1/20/2022 12:47:16 PM File Age: 0 Information 1/20/2022 12:47:16 PM Which File: 0 Error 1/20/2022 12:47:16 PM Could not find any files Information 1/20/2022 12:47:16 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\*943*.xml Error 1/20/2022 12:47:16 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\BOODYW\AIMS360\Inbound\*943*.xml Information 1/20/2022 12:47:16 PM Executing Check Connection Information 1/20/2022 12:47:16 PM Connection Name: R4WMSIMP Information 1/20/2022 12:47:16 PM Connection Type is: ODBC Information 1/20/2022 12:47:16 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:47:16 PM Done! Information 1/20/2022 12:47:17 PM Executing Package: IN-ADVRDB Information 1/20/2022 12:47:17 PM Executing FTP Operation (Download): ADVRDB - FTP Information 1/20/2022 12:47:17 PM Using File Transfer Protocol Information 1/20/2022 12:47:17 PM Connecting to: ftp.tendercorp.com Information 1/20/2022 12:47:17 PM Connected! Information 1/20/2022 12:47:17 PM Changing Remote directory to: /A2B_Dropship/Export Information 1/20/2022 12:47:17 PM Done! Information 1/20/2022 12:47:17 PM Getting List of files Information 1/20/2022 12:47:17 PM Mask: *.txt Information 1/20/2022 12:47:17 PM Done! Information 1/20/2022 12:47:17 PM Found: 0 File(s) Information 1/20/2022 12:47:17 PM Files : Information 1/20/2022 12:47:17 PM Finished Execution Ftp: ADVRDB - FTP Information 1/20/2022 12:47:18 PM Checking File(s): Check File Information 1/20/2022 12:47:18 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\ADVRDB\Inbound\ Information 1/20/2022 12:47:18 PM Mask: A2B*.txt Information 1/20/2022 12:47:18 PM Path Is Valid: True Information 1/20/2022 12:47:18 PM Include Directory: False Information 1/20/2022 12:47:18 PM In Sub Folders: False Information 1/20/2022 12:47:18 PM Attributes: ReadOnly Information 1/20/2022 12:47:18 PM Attribute: Hidden Information 1/20/2022 12:47:18 PM Attribute: SysFile Information 1/20/2022 12:47:18 PM Attribute: aArchive Information 1/20/2022 12:47:18 PM File Age: 0 Information 1/20/2022 12:47:18 PM Which File: 0 Error 1/20/2022 12:47:18 PM Could not find any files Information 1/20/2022 12:47:18 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\ADVRDB\Inbound\A2B*.txt Error 1/20/2022 12:47:18 PM File(s) not found: \\amznfsxxwk04bhm.corp.a2bf.com\share\ADVRDB\Inbound\A2B*.txt Information 1/20/2022 12:47:18 PM Executing Check Connection Information 1/20/2022 12:47:18 PM Connection Name: R4WMSIMP Information 1/20/2022 12:47:18 PM Connection Type is: ODBC Information 1/20/2022 12:47:18 PM Source DSN: R4WMSIMP-64b Information 1/20/2022 12:47:18 PM Done! Information 1/20/2022 12:47:18 PM Executing Package: In-Luxinc-HSN Information 1/20/2022 12:47:18 PM Executing External Application: Luxinc-HSN-get-850 Information 1/20/2022 12:47:18 PM Application Name: "D:\Program Files (x86)\WinSCP\Luxinc-HSN-Get-850.bat" Information 1/20/2022 12:47:18 PM Waiting for: "D:\Program Files (x86)\WinSCP\Luxinc-HSN-Get-850.bat" to finish Information 1/20/2022 12:47:22 PM Checking File(s): Luxinc-hsn import check Information 1/20/2022 12:47:22 PM Path: \\amznfsxxwk04bhm.corp.a2bf.com\share\Luxinc\HSN\Inbound-850\ Information 1/20/2022 12:47:22 PM Mask: *.csv Information 1/20/2022 12:47:22 PM Path Is Valid: True Information 1/20/2022 12:47:22 PM Include Directory: False Information 1/20/2022 12:47:22 PM In Sub Folders: False Information 1/20/2022 12:47:22 PM Attributes: ReadOnly Information 1/20/2022 12:47:22 PM Attribute: Hidden Information 1/20/2022 12:47:22 PM Attribute: SysFile Information 1/20/2022 12:47:22 PM Attribute: aArchive Information 1/20/2022 12:47:22 PM File Age: 0 Information 1/20/2022 12:47:22 PM Which File: 0 Information 1/20/2022 12:47:22 PM Found: 2 File(s) Information 1/20/2022 12:47:22 PM File(s) : \\amznfsxxwk04bhm.corp.a2bf.com\share\Luxinc\HSN\Inbound-850\*.csv Information 1/20/2022 12:47:22 PM File(s) exists: \\amznfsxxwk04bhm.corp.a2bf.com\share\Luxinc\HSN\Inbound-850\*.csv Information 1/20/2022 12:47:22 PM Executing Import: Filesystem In-Luxinc-HSN Information 1/20/2022 12:47:22 PM Processed: 2 Records Information 1/20/2022 12:47:22 PM Errors: 0 Information 1/20/2022 12:47:22 PM Records per second: 21 Information 1/20/2022 12:47:22 PM Execution of Import Script: Filesystem In-Luxinc-HSN has completed Information 1/20/2022 12:47:23 PM Executing Import: Luxinc-HSN DTL wimporter_c300 load Information 1/20/2022 12:47:24 PM Processed: 9 Records Information 1/20/2022 12:47:24 PM Errors: 0 Information 1/20/2022 12:47:24 PM Records per second: 58 Information 1/20/2022 12:47:24 PM Execution of Import Script: Luxinc-HSN DTL wimporter_c300 load has completed Information 1/20/2022 12:47:24 PM Executing Import: Luxinc-HSN DTL wimporter_c300 Update01 Information 1/20/2022 12:47:25 PM Processed: 9 Records Information 1/20/2022 12:47:25 PM Errors: 0 Information 1/20/2022 12:47:25 PM Records per second: 58 Error 1/20/2022 12:47:25 PM Execution of Import Script: Luxinc-HSN DTL wimporter_c300 Update01 has failed Error 1/20/2022 12:47:25 PM Access violation at address 00000000015F26A0 in module 'vpr.exe'. Read of address 0000000000000040 Error 1/20/2022 12:47:25 PM Failed