4/25/2021 2:30:01 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/25/2021 2:30:02 AM : StartProcess  ### 4/25/2021 2:30:02 AM

4/25/2021 2:30:02 AM : 11  ### 4/25/2021 2:30:02 AM

4/25/2021 2:30:02 AM : 22  ### 4/25/2021 2:30:02 AM

4/25/2021 2:30:02 AM : 33  ### 4/25/2021 2:30:02 AM

4/25/2021 2:30:02 AM : Application Started  ### 4/25/2021 2:30:02 AM

4/25/2021 2:30:02 AM : Start Process : checkAllTablesExists()  ### 
4/25/2021 2:30:02 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/25/2021 2:30:02 AM
4/25/2021 2:30:02 AM : MainForm_Load  ### AlertSystem ON
4/25/2021 2:30:02 AM : No. of Files to import (RECEIVEFINAL):  ### 1
4/25/2021 2:30:02 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/25/2021 2:30:02 AM : PostData() --->>  ### 4/25/2021 2:30:02 AM
4/25/2021 2:30:02 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 4/25/2021 2:30:02 AM
4/25/2021 2:30:03 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '25/Apr/2021' ### 4/25/2021 2:30:03 AM
4/25/2021 2:30:03 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '25/Apr/2021' ### 4/25/2021 2:30:03 AM
4/25/2021 2:30:03 AM :  ### 
4/25/2021 2:30:03 AM : UNLINKEDSALES Record Count Before --->> 0 ### 4/25/2021 2:30:03 AM
4/25/2021 2:30:03 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 4/25/2021 2:30:03 AM
4/25/2021 2:30:10 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '25/Apr/2021' ### 4/25/2021 2:30:10 AM
4/25/2021 2:30:10 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/25/2021 2:30:10 AM
4/25/2021 2:30:10 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/25/2021 2:30:10 AM
4/25/2021 2:30:10 AM :  ### 
4/25/2021 2:30:10 AM : Posting Supplierlink Query for Purchases --->>  ### 4/25/2021 2:30:10 AM
4/25/2021 2:30:15 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '25/Apr/2021' ### 4/25/2021 2:30:15 AM
4/25/2021 2:30:21 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '25/Apr/2021' ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '25/Apr/2021' ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Posting ClosingStock Successful --->>  ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:21 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4054525_TEMPLATE1.txt ### 4/25/2021 2:30:21 AM
4/25/2021 2:30:21 AM : Count:: ### TEMPLATE1:6
4/25/2021 2:30:22 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 2:30:22 AM
4/25/2021 2:30:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/25/2021 2:30:22 AM
4/25/2021 2:30:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:22 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/25/2021 2:30:22 AM
4/25/2021 2:30:22 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:22 AM : Template Import Complete  ### 4/25/2021 2:30:22 AM
4/25/2021 2:30:24 AM : Completed Updating Has Transaction Flag  ### 4/25/2021 2:30:24 AM
4/25/2021 2:30:24 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/25/2021 2:30:24 AM
4/25/2021 2:30:24 AM : Zylem Access Unblocked  ### 4/25/2021 2:30:24 AM
4/25/2021 2:30:24 AM : Application Ended  ### 4/25/2021 2:30:24 AM

4/25/2021 7:30:02 AM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/25/2021 7:30:03 AM : StartProcess  ### 4/25/2021 7:30:03 AM

4/25/2021 7:30:03 AM : 11  ### 4/25/2021 7:30:03 AM

4/25/2021 7:30:03 AM : 22  ### 4/25/2021 7:30:03 AM

4/25/2021 7:30:03 AM : 33  ### 4/25/2021 7:30:03 AM

4/25/2021 7:30:03 AM : Application Started  ### 4/25/2021 7:30:03 AM

4/25/2021 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
4/25/2021 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/25/2021 7:30:03 AM
4/25/2021 7:30:03 AM : MainForm_Load  ### AlertSystem ON
4/25/2021 7:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 1235
4/25/2021 7:30:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/25/2021 7:30:04 AM : For Distributor 000000000001142 Insert Count::5 ### Delete Count::0
4/25/2021 7:30:04 AM : Import AD File --->> AD_1142_20210425_5d027e08eb852d20288c1ce8f642ea51.TXT ### 4/25/2021 7:30:04 AM
4/25/2021 7:30:04 AM : For Distributor 000000000000411 Insert Count::1 ### Delete Count::0
4/25/2021 7:30:04 AM : Import AD File --->> AD_411_20210425_5edde0c9bdbb98892cb2a84b7e352b0b.TXT ### 4/25/2021 7:30:04 AM
4/25/2021 7:30:04 AM : For Distributor 000000000000667 Insert Count::0 ### Delete Count::142
4/25/2021 7:30:04 AM : Import AD File --->> AD_667_20210425_e88babd1c29b83cd6b2ce7109760a573.TXT ### 4/25/2021 7:30:04 AM
4/25/2021 7:30:05 AM : For Distributor 000000000000918 Insert Count::5 ### Delete Count::0
4/25/2021 7:30:05 AM : Import AD File --->> AD_918_20210425_f5b3cd4d4357b39311bc194c386fd237.TXT ### 4/25/2021 7:30:05 AM
4/25/2021 7:30:17 AM : For Distributor 000000000000405 Insert Count::2 ### Delete Count::0
4/25/2021 7:30:17 AM : Import DN File --->> DN_405_20210424_92bf54270f3c83795a0035403eb7b480.TXT ### 4/25/2021 7:30:17 AM
4/25/2021 7:30:29 AM : For Distributor 000000000000918 Insert Count::7 ### Delete Count::7
4/25/2021 7:30:29 AM : Import DN File --->> DN_918_20210301_62e225398630d5e6e7ef4c2ac0331a44.TXT ### 4/25/2021 7:30:29 AM
4/25/2021 7:30:30 AM : For Distributor 000000000000918 Insert Count::3 ### Delete Count::3
4/25/2021 7:30:30 AM : Import DN File --->> DN_918_20210311_efaea926dce6d187f7c97cf476920378.TXT ### 4/25/2021 7:30:30 AM
4/25/2021 7:30:31 AM : For Distributor 000000000000918 Insert Count::1 ### Delete Count::0
4/25/2021 7:30:31 AM : Import DN File --->> DN_918_20210409_75055b85299658b7df80346bc9c675b5.TXT ### 4/25/2021 7:30:31 AM
4/25/2021 7:30:33 AM : For Distributor 000000000001142 Insert Count::2 ### Delete Count::0
4/25/2021 7:30:33 AM : Import IN File --->> IN_1142_20210412_dace5ba8e08686a49ad44d9e74edee59.TXT ### 4/25/2021 7:30:33 AM
4/25/2021 7:30:33 AM : For Distributor 000000000001142 Insert Count::6 ### Delete Count::0
4/25/2021 7:30:33 AM : Import IN File --->> IN_1142_20210413_d713417a7b2a1cf3f7be38e5aa90286a.TXT ### 4/25/2021 7:30:33 AM
4/25/2021 7:30:33 AM : For Distributor 000000000001142 Insert Count::14 ### Delete Count::0
4/25/2021 7:30:33 AM : Import IN File --->> IN_1142_20210414_3ab0cfc79ec9e9a0a1530ae0361fd395.TXT ### 4/25/2021 7:30:33 AM
4/25/2021 7:30:33 AM : For Distributor 000000000001142 Insert Count::3 ### Delete Count::0
4/25/2021 7:30:33 AM : Import IN File --->> IN_1142_20210415_c626d7f1777d316945266340f4a4d7cd.TXT ### 4/25/2021 7:30:33 AM
4/25/2021 7:30:34 AM : For Distributor 000000000001142 Insert Count::1 ### Delete Count::0
4/25/2021 7:30:34 AM : Import IN File --->> IN_1142_20210421_b558d018073710c71848ec75ec8acef1.TXT ### 4/25/2021 7:30:34 AM
4/25/2021 7:30:34 AM : For Distributor 000000000001142 Insert Count::3 ### Delete Count::0
4/25/2021 7:30:34 AM : Import IN File --->> IN_1142_20210424_93000079365c1f1989b58a4cfe91846b.TXT ### 4/25/2021 7:30:34 AM
4/25/2021 7:30:34 AM : Import IN File --->> IN_1142_20210425_453cda86d087b6172f2feefa578df6f1.TXT ### 4/25/2021 7:30:34 AM
4/25/2021 7:30:34 AM : NO Previous File For Distributor 000000000001142 ### Insert Count::10
4/25/2021 7:30:42 AM : Exception  ### Index was outside the bounds of the array.
4/25/2021 7:30:42 AM : Error ### Index was outside the bounds of the array. Line 
4/25/2021 7:30:43 AM : For Distributor 000000000000400 Insert Count::2 ### Delete Count::0
4/25/2021 7:30:43 AM : Import IN File --->> IN_400_20210402_73b4a5fc5255177a10359a66e4e16c66.TXT ### 4/25/2021 7:30:43 AM
4/25/2021 7:30:43 AM : For Distributor 000000000000400 Insert Count::3 ### Delete Count::0
4/25/2021 7:30:43 AM : Import IN File --->> IN_400_20210406_0bee0266171967d4129225360ee1d3b2.TXT ### 4/25/2021 7:30:43 AM
4/25/2021 7:30:57 AM : For Distributor 000000000000667 Insert Count::1 ### Delete Count::1
4/25/2021 7:30:57 AM : Import IN File --->> IN_667_20210329_8726ef11cb5f5f549e92517c33a56a98.TXT ### 4/25/2021 7:30:57 AM
4/25/2021 7:30:57 AM : For Distributor 000000000000667 Insert Count::103 ### Delete Count::2
4/25/2021 7:30:57 AM : Import IN File --->> IN_667_20210331_a98e6cc32edff4360a63c642ffc67918.TXT ### 4/25/2021 7:30:57 AM
4/25/2021 7:31:04 AM : For Distributor 000000000000918 Insert Count::3 ### Delete Count::0
4/25/2021 7:31:04 AM : Import IN File --->> IN_918_20210404_77cc827f285f6c3e26ea7a8d2fac0588.TXT ### 4/25/2021 7:31:04 AM
4/25/2021 7:31:04 AM : For Distributor 000000000000918 Insert Count::1 ### Delete Count::0
4/25/2021 7:31:04 AM : Import IN File --->> IN_918_20210405_659c5646b1345e1dd52b0347e5a48fb9.TXT ### 4/25/2021 7:31:04 AM
4/25/2021 7:31:04 AM : For Distributor 000000000000918 Insert Count::4 ### Delete Count::0
4/25/2021 7:31:05 AM : Import IN File --->> IN_918_20210414_d926341cbd0e191c2f2c31e02eb3ef47.TXT ### 4/25/2021 7:31:05 AM
4/25/2021 7:31:05 AM : For Distributor 000000000000918 Insert Count::3 ### Delete Count::0
4/25/2021 7:31:05 AM : Import IN File --->> IN_918_20210423_a184f89789bf6edb4f05bd59e5830821.TXT ### 4/25/2021 7:31:05 AM
4/25/2021 7:31:05 AM : For Distributor 000000000000918 Insert Count::4 ### Delete Count::0
4/25/2021 7:31:05 AM : Import IN File --->> IN_918_20210424_c3ca093ad8aa649d6a5b92cbcdee87fd.TXT ### 4/25/2021 7:31:05 AM
4/25/2021 7:31:11 AM : For Distributor 000000000000667 Insert Count::10 ### Delete Count::0
4/25/2021 7:31:11 AM : Import OT File --->> OT_667_20210331_71b08d6215339ad0a2876cbbf5ed3563.TXT ### 4/25/2021 7:31:11 AM
4/25/2021 7:31:12 AM : For Distributor 000000000000667 Insert Count::0 ### Delete Count::21
4/25/2021 7:31:12 AM : Import PR File --->> PR_667_20210425_bae62b58a0def2a8c9c49322f8484288.TXT ### 4/25/2021 7:31:12 AM
4/25/2021 7:31:13 AM : For Distributor 000000000000918 Insert Count::33 ### Delete Count::0
4/25/2021 7:31:13 AM : Import PR File --->> PR_918_20210425_ebd899f60c73941d59ff44dbf51f1284.TXT ### 4/25/2021 7:31:13 AM
4/25/2021 7:31:13 AM : PostData() --->>  ### 4/25/2021 7:31:13 AM
4/25/2021 7:31:17 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 4/25/2021 7:31:17 AM
4/25/2021 7:31:19 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '25/Apr/2021' ### 4/25/2021 7:31:19 AM
4/25/2021 7:31:19 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '25/Apr/2021' ### 4/25/2021 7:31:19 AM
4/25/2021 7:31:19 AM :  ### 
4/25/2021 7:31:19 AM : UNLINKEDSALES Record Count Before --->> 163 ### 4/25/2021 7:31:19 AM
4/25/2021 7:31:19 AM : UNLINKEDSALES_DEL Record Count Before --->> 3 ### 4/25/2021 7:31:19 AM
4/25/2021 7:31:31 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '25/Apr/2021' ### 4/25/2021 7:31:31 AM
4/25/2021 7:31:31 AM : UNLINKEDSALES Record Count After --->> 0 ### 4/25/2021 7:31:31 AM
4/25/2021 7:31:31 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/25/2021 7:31:31 AM
4/25/2021 7:31:31 AM :  ### 
4/25/2021 7:31:31 AM : Posting Supplierlink Query for Purchases --->>  ### 4/25/2021 7:31:31 AM
4/25/2021 7:31:38 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '25/Apr/2021' ### 4/25/2021 7:31:38 AM
4/25/2021 7:31:43 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '25/Apr/2021' ### 4/25/2021 7:31:43 AM
4/25/2021 7:31:43 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 4/25/2021 7:31:43 AM
4/25/2021 7:31:43 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '25/Apr/2021' ### 4/25/2021 7:31:43 AM
4/25/2021 7:31:44 AM : Posting ClosingStock Successful --->>  ### 4/25/2021 7:31:44 AM
4/25/2021 7:31:44 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 4/25/2021 7:31:44 AM
4/25/2021 7:31:44 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
4/25/2021 7:31:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/25/2021 7:31:44 AM
4/25/2021 7:31:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:31:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/25/2021 7:31:44 AM
4/25/2021 7:31:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:31:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/25/2021 7:31:44 AM
4/25/2021 7:31:44 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:31:44 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2838040_TEMPLATE1.TXT ### 4/25/2021 7:31:44 AM
4/25/2021 7:31:44 AM : Count:: ### TEMPLATE1:155
4/25/2021 7:31:57 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:31:57 AM
4/25/2021 7:31:57 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 4/25/2021 7:31:57 AM
4/25/2021 7:31:57 AM : Count:: ### TEMPLATE1:64
4/25/2021 7:31:59 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:31:59 AM
4/25/2021 7:31:59 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/25/2021 7:31:59 AM
4/25/2021 7:31:59 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:31:59 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/25/2021 7:31:59 AM
4/25/2021 7:31:59 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:31:59 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/25/2021 7:31:59 AM
4/25/2021 7:31:59 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:31:59 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3897231_TEMPLATE1.txt ### 4/25/2021 7:31:59 AM
4/25/2021 7:31:59 AM : Count:: ### TEMPLATE1:23
4/25/2021 7:32:01 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:32:01 AM
4/25/2021 7:32:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3898324_TEMPLATE1.TXT ### 4/25/2021 7:32:01 AM
4/25/2021 7:32:01 AM : Count:: ### TEMPLATE1:23
4/25/2021 7:32:03 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:32:03 AM
4/25/2021 7:32:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3937444_TEMPLATE1.txt ### 4/25/2021 7:32:03 AM
4/25/2021 7:32:03 AM : Count:: ### TEMPLATE1:110
4/25/2021 7:32:08 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:32:08 AM
4/25/2021 7:32:08 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3993798_TEMPLATE1.TXT ### 4/25/2021 7:32:08 AM
4/25/2021 7:32:08 AM : Count:: ### TEMPLATE1:8
4/25/2021 7:32:08 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:32:08 AM
4/25/2021 7:32:09 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 4/25/2021 7:32:09 AM
4/25/2021 7:32:09 AM : Count:: ### TEMPLATE1:17
4/25/2021 7:32:11 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:32:11 AM
4/25/2021 7:32:11 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4188862_TEMPLATE1.TXT ### 4/25/2021 7:32:11 AM
4/25/2021 7:32:11 AM : Count:: ### TEMPLATE1:13
4/25/2021 7:32:12 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:32:12 AM
4/25/2021 7:32:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060613_TEMPLATE1.txt ### 4/25/2021 7:32:12 AM
4/25/2021 7:32:12 AM : Count:: ### TEMPLATE1:3188
4/25/2021 7:34:03 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:34:03 AM
4/25/2021 7:34:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060858_TEMPLATE1.txt ### 4/25/2021 7:34:03 AM
4/25/2021 7:34:03 AM : Count:: ### TEMPLATE1:499
4/25/2021 7:34:19 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:34:19 AM
4/25/2021 7:34:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 4/25/2021 7:34:19 AM
4/25/2021 7:34:19 AM : Count:: ### TEMPLATE1:287
4/25/2021 7:34:28 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:34:28 AM
4/25/2021 7:34:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/25/2021 7:34:28 AM
4/25/2021 7:34:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:34:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063250_TEMPLATE1.TXT ### 4/25/2021 7:34:28 AM
4/25/2021 7:34:28 AM : Count:: ### TEMPLATE1:120
4/25/2021 7:34:36 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:34:36 AM
4/25/2021 7:34:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/25/2021 7:34:36 AM
4/25/2021 7:34:36 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 7:34:36 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063977_TEMPLATE1.TXT ### 4/25/2021 7:34:36 AM
4/25/2021 7:34:36 AM : Count:: ### TEMPLATE1:70
4/25/2021 7:34:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 7:34:37 AM
4/25/2021 7:34:37 AM : Template Import Complete  ### 4/25/2021 7:34:37 AM
4/25/2021 7:34:39 AM : Completed Updating Has Transaction Flag  ### 4/25/2021 7:34:39 AM
4/25/2021 7:34:39 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/25/2021 7:34:39 AM
4/25/2021 7:34:39 AM : Zylem Access Unblocked  ### 4/25/2021 7:34:39 AM
4/25/2021 7:34:39 AM : Application Ended  ### 4/25/2021 7:34:39 AM

4/25/2021 2:30:03 PM : Start Process : checkAllTablesExists()  ### Driver={SQL Server};Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/25/2021 2:30:04 PM : StartProcess  ### 4/25/2021 2:30:04 PM

4/25/2021 2:30:04 PM : 11  ### 4/25/2021 2:30:04 PM

4/25/2021 2:30:04 PM : 22  ### 4/25/2021 2:30:04 PM

4/25/2021 2:30:04 PM : 33  ### 4/25/2021 2:30:04 PM

4/25/2021 2:30:04 PM : Application Started  ### 4/25/2021 2:30:04 PM

4/25/2021 2:30:04 PM : Start Process : checkAllTablesExists()  ### 
4/25/2021 2:30:04 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 4/25/2021 2:30:04 PM
4/25/2021 2:30:05 PM : MainForm_Load  ### AlertSystem ON
4/25/2021 2:30:05 PM : No. of Files to import (RECEIVEFINAL):  ### 156
4/25/2021 2:30:05 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
4/25/2021 2:30:05 PM : For Distributor 000000000000264 Insert Count::7 ### Delete Count::0
4/25/2021 2:30:05 PM : Import AD File --->> AD_264_20210425_84651411939768aaf61fb9fd79802f9e.TXT ### 4/25/2021 2:30:05 PM
4/25/2021 2:30:06 PM : Import DN File --->> DN_99_20210423_5e3adb0ded23eb3b25bb64d6f1f66919.TXT ### 4/25/2021 2:30:06 PM
4/25/2021 2:30:06 PM : NO Previous File For Distributor 000000000000099 ### Insert Count::1
4/25/2021 2:30:11 PM : For Distributor 000000000000264 Insert Count::0 ### Delete Count::3
4/25/2021 2:30:11 PM : Import IN File --->> IN_264_20210326_4c90b8604eb7a22bf2fea3d5b09e2cab.TXT ### 4/25/2021 2:30:11 PM
4/25/2021 2:30:11 PM : For Distributor 000000000000264 Insert Count::0 ### Delete Count::5
4/25/2021 2:30:11 PM : Import IN File --->> IN_264_20210327_2e2c093c85d3ed4409ba0c3b699b30bd.TXT ### 4/25/2021 2:30:11 PM
4/25/2021 2:30:11 PM : For Distributor 000000000000264 Insert Count::0 ### Delete Count::3
4/25/2021 2:30:11 PM : Import IN File --->> IN_264_20210328_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/25/2021 2:30:11 PM
4/25/2021 2:30:11 PM : For Distributor 000000000000264 Insert Count::0 ### Delete Count::1
4/25/2021 2:30:11 PM : Import IN File --->> IN_264_20210329_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/25/2021 2:30:11 PM
4/25/2021 2:30:11 PM : For Distributor 000000000000264 Insert Count::0 ### Delete Count::13
4/25/2021 2:30:11 PM : Import IN File --->> IN_264_20210330_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/25/2021 2:30:11 PM
4/25/2021 2:30:12 PM : For Distributor 000000000000264 Insert Count::0 ### Delete Count::17
4/25/2021 2:30:12 PM : Import IN File --->> IN_264_20210331_d41d8cd98f00b204e9800998ecf8427e.TXT ### 4/25/2021 2:30:12 PM
4/25/2021 2:30:14 PM : For Distributor 000000000000264 Insert Count::2 ### Delete Count::0
4/25/2021 2:30:14 PM : Import PR File --->> PR_264_20210425_8d83279ca41fe35da6d0c962a1f9148b.TXT ### 4/25/2021 2:30:14 PM
4/25/2021 2:30:14 PM : PostData() --->>  ### 4/25/2021 2:30:14 PM
4/25/2021 2:30:14 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 4/25/2021 2:30:14 PM
4/25/2021 2:30:15 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '25/Apr/2021' ### 4/25/2021 2:30:15 PM
4/25/2021 2:30:16 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '25/Apr/2021' ### 4/25/2021 2:30:16 PM
4/25/2021 2:30:16 PM :  ### 
4/25/2021 2:30:16 PM : UNLINKEDSALES Record Count Before --->> 0 ### 4/25/2021 2:30:16 PM
4/25/2021 2:30:16 PM : UNLINKEDSALES_DEL Record Count Before --->> 42 ### 4/25/2021 2:30:16 PM
4/25/2021 2:30:24 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '25/Apr/2021' ### 4/25/2021 2:30:24 PM
4/25/2021 2:30:24 PM : UNLINKEDSALES Record Count After --->> 0 ### 4/25/2021 2:30:24 PM
4/25/2021 2:30:24 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 4/25/2021 2:30:24 PM
4/25/2021 2:30:24 PM :  ### 
4/25/2021 2:30:24 PM : Posting Supplierlink Query for Purchases --->>  ### 4/25/2021 2:30:24 PM
4/25/2021 2:30:30 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '25/Apr/2021' ### 4/25/2021 2:30:30 PM
4/25/2021 2:30:35 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '25/Apr/2021' ### 4/25/2021 2:30:35 PM
4/25/2021 2:30:35 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 4/25/2021 2:30:35 PM
4/25/2021 2:30:35 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '25/Apr/2021' ### 4/25/2021 2:30:35 PM
4/25/2021 2:30:36 PM : Posting ClosingStock Successful --->>  ### 4/25/2021 2:30:36 PM
4/25/2021 2:30:36 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 4/25/2021 2:30:36 PM
4/25/2021 2:30:36 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
4/25/2021 2:30:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 4/25/2021 2:30:36 PM
4/25/2021 2:30:36 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 4/25/2021 2:30:36 PM
4/25/2021 2:30:36 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 4/25/2021 2:30:36 PM
4/25/2021 2:30:36 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 4/25/2021 2:30:36 PM
4/25/2021 2:30:36 PM : Count:: ### TEMPLATE1:64
4/25/2021 2:30:41 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 2:30:41 PM
4/25/2021 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 4/25/2021 2:30:41 PM
4/25/2021 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 4/25/2021 2:30:41 PM
4/25/2021 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 4/25/2021 2:30:41 PM
4/25/2021 2:30:41 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:41 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060566_TEMPLATE1.TXT ### 4/25/2021 2:30:41 PM
4/25/2021 2:30:41 PM : Count:: ### TEMPLATE1:46
4/25/2021 2:30:44 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 2:30:44 PM
4/25/2021 2:30:44 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 4/25/2021 2:30:44 PM
4/25/2021 2:30:44 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:44 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 4/25/2021 2:30:44 PM
4/25/2021 2:30:44 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
4/25/2021 2:30:44 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064082_TEMPLATE1.TXT ### 4/25/2021 2:30:44 PM
4/25/2021 2:30:44 PM : Count:: ### TEMPLATE1:7
4/25/2021 2:30:45 PM : SP_DistributorTemplatePosting Successful --->>  ### 4/25/2021 2:30:45 PM
4/25/2021 2:30:45 PM : Template Import Complete  ### 4/25/2021 2:30:45 PM
4/25/2021 2:30:47 PM : Completed Updating Has Transaction Flag  ### 4/25/2021 2:30:47 PM
4/25/2021 2:30:47 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 4/25/2021 2:30:47 PM
4/25/2021 2:30:47 PM : Zylem Access Unblocked  ### 4/25/2021 2:30:47 PM
4/25/2021 2:30:47 PM : Application Ended  ### 4/25/2021 2:30:47 PM