8/1/2021 2:30:03 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
8/1/2021 2:30:04 AM : StartProcess  ### 8/1/2021 2:30:04 AM

8/1/2021 2:30:04 AM : 11  ### 8/1/2021 2:30:04 AM

8/1/2021 2:30:04 AM : 22  ### 8/1/2021 2:30:04 AM

8/1/2021 2:30:04 AM : 33  ### 8/1/2021 2:30:04 AM

8/1/2021 2:30:04 AM : Application Started  ### 8/1/2021 2:30:04 AM

8/1/2021 2:30:04 AM : Start Process : checkAllTablesExists()  ### 
8/1/2021 2:30:04 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 8/1/2021 2:30:04 AM
8/1/2021 2:30:04 AM : MainForm_Load  ### AlertSystem ON
8/1/2021 2:30:04 AM : No. of Files to import (RECEIVEFINAL):  ### 310
8/1/2021 2:30:04 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
8/1/2021 2:30:05 AM : For Distributor 000000000000499 Insert Count::1 ### Delete Count::0
8/1/2021 2:30:05 AM : Import AD File --->> AD_499_20210801_c5c7b4e6bd7d44f7f07f74e6d1647644.TXT ### 8/1/2021 2:30:05 AM
8/1/2021 2:30:05 AM : For Distributor 000000000000515 Insert Count::1 ### Delete Count::0
8/1/2021 2:30:05 AM : Import AD File --->> AD_515_20210731_fa4d26acc4bd1ae34ee9d0b5e3e754b4.TXT ### 8/1/2021 2:30:05 AM
8/1/2021 2:30:13 AM : For Distributor 000000000000499 Insert Count::4 ### Delete Count::0
8/1/2021 2:30:13 AM : Import DN File --->> DN_499_20210731_0ff40b5b8cf63dcf25ab020281977008.TXT ### 8/1/2021 2:30:13 AM
8/1/2021 2:30:22 AM : For Distributor 000000000000499 Insert Count::12 ### Delete Count::0
8/1/2021 2:30:22 AM : Import IN File --->> IN_499_20210731_8cabb83d15269b5f47e4593dcd1d7f4b.TXT ### 8/1/2021 2:30:22 AM
8/1/2021 2:30:26 AM : For Distributor 000000000000515 Insert Count::33 ### Delete Count::0
8/1/2021 2:30:26 AM : Import IN File --->> IN_515_20210731_03e33778c674ff22e8ec9320c9f5af6a.TXT ### 8/1/2021 2:30:26 AM
8/1/2021 2:30:26 AM : PostData() --->>  ### 8/1/2021 2:30:26 AM
8/1/2021 2:30:27 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 8/1/2021 2:30:27 AM
8/1/2021 2:30:28 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '01/Aug/2021' ### 8/1/2021 2:30:28 AM
8/1/2021 2:30:28 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '01/Aug/2021' ### 8/1/2021 2:30:28 AM
8/1/2021 2:30:28 AM :  ### 
8/1/2021 2:30:28 AM : UNLINKEDSALES Record Count Before --->> 45 ### 8/1/2021 2:30:28 AM
8/1/2021 2:30:28 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 8/1/2021 2:30:28 AM
8/1/2021 2:30:37 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '01/Aug/2021' ### 8/1/2021 2:30:37 AM
8/1/2021 2:30:37 AM : UNLINKEDSALES Record Count After --->> 0 ### 8/1/2021 2:30:37 AM
8/1/2021 2:30:37 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 8/1/2021 2:30:37 AM
8/1/2021 2:30:37 AM :  ### 
8/1/2021 2:30:37 AM : Posting Supplierlink Query for Purchases --->>  ### 8/1/2021 2:30:37 AM
8/1/2021 2:30:42 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '01/Aug/2021' ### 8/1/2021 2:30:42 AM
8/1/2021 2:30:48 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '01/Aug/2021' ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '01/Aug/2021' ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Posting ClosingStock Successful --->>  ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
8/1/2021 2:30:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3596136_TEMPLATE1.txt ### 8/1/2021 2:30:48 AM
8/1/2021 2:30:48 AM : Count:: ### TEMPLATE1:19
8/1/2021 2:30:49 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3800230_TEMPLATE1.txt ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:49 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 8/1/2021 2:30:49 AM
8/1/2021 2:30:49 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 8/1/2021 2:30:50 AM
8/1/2021 2:30:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 8/1/2021 2:30:50 AM
8/1/2021 2:30:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 8/1/2021 2:30:50 AM
8/1/2021 2:30:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 8/1/2021 2:30:50 AM
8/1/2021 2:30:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:30:50 AM : Template Import Complete  ### 8/1/2021 2:30:50 AM
8/1/2021 2:30:52 AM : Completed Updating Has Transaction Flag  ### 8/1/2021 2:30:52 AM
8/1/2021 2:30:52 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 8/1/2021 2:30:52 AM
8/1/2021 2:30:52 AM : Zylem Access Unblocked  ### 8/1/2021 2:30:52 AM
8/1/2021 2:30:52 AM : Application Ended  ### 8/1/2021 2:30:52 AM

8/1/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
8/1/2021 7:30:03 AM : StartProcess  ### 8/1/2021 7:30:03 AM

8/1/2021 7:30:03 AM : 11  ### 8/1/2021 7:30:03 AM

8/1/2021 7:30:03 AM : 22  ### 8/1/2021 7:30:03 AM

8/1/2021 7:30:03 AM : 33  ### 8/1/2021 7:30:03 AM

8/1/2021 7:30:03 AM : Application Started  ### 8/1/2021 7:30:03 AM

8/1/2021 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
8/1/2021 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 8/1/2021 7:30:03 AM
8/1/2021 7:30:03 AM : MainForm_Load  ### AlertSystem ON
8/1/2021 7:30:03 AM : No. of Files to import (RECEIVEFINAL):  ### 2163
8/1/2021 7:30:03 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
8/1/2021 7:30:04 AM : For Distributor 000000000001033 Insert Count::0 ### Delete Count::29
8/1/2021 7:30:04 AM : Import AD File --->> AD_1033_20210801_54744823727dd3ff244650fbbb694e79.TXT ### 8/1/2021 7:30:04 AM
8/1/2021 7:30:04 AM : For Distributor 000000000001047 Insert Count::4 ### Delete Count::54
8/1/2021 7:30:04 AM : Import AD File --->> AD_1047_20210801_6b95c0d5c336bc827ca5e985796c12c5.TXT ### 8/1/2021 7:30:04 AM
8/1/2021 7:30:04 AM : For Distributor 000000000001186 Insert Count::2 ### Delete Count::0
8/1/2021 7:30:04 AM : Import AD File --->> AD_1186_20210801_57730ff93c2cd22684245a3ebdf5eb49.TXT ### 8/1/2021 7:30:04 AM
8/1/2021 7:30:04 AM : For Distributor 000000000001197 Insert Count::8 ### Delete Count::0
8/1/2021 7:30:04 AM : Import AD File --->> AD_1197_20210801_4d4449587b8a2255adf7febee4633d53.TXT ### 8/1/2021 7:30:04 AM
8/1/2021 7:30:05 AM : For Distributor 000000000001290 Insert Count::9 ### Delete Count::46
8/1/2021 7:30:05 AM : Import AD File --->> AD_1290_20210801_ced2563f4d06a420861532ea3579e5b8.TXT ### 8/1/2021 7:30:05 AM
8/1/2021 7:30:05 AM : For Distributor 000000000000003 Insert Count::1 ### Delete Count::42
8/1/2021 7:30:05 AM : Import AD File --->> AD_3_20210801_ead8238db1fcbef32fa8a76e59db3d93.TXT ### 8/1/2021 7:30:05 AM
8/1/2021 7:30:05 AM : For Distributor 000000000000400 Insert Count::15 ### Delete Count::8
8/1/2021 7:30:05 AM : Import AD File --->> AD_400_20210801_7bbfad58b2b3ada44b6347a51a5f7e45.TXT ### 8/1/2021 7:30:05 AM
8/1/2021 7:30:06 AM : For Distributor 000000000000407 Insert Count::10 ### Delete Count::19
8/1/2021 7:30:06 AM : Import AD File --->> AD_407_20210801_a4b6d9c55017c1e92969a87f69942212.TXT ### 8/1/2021 7:30:06 AM
8/1/2021 7:30:06 AM : For Distributor 000000000000411 Insert Count::1 ### Delete Count::12
8/1/2021 7:30:06 AM : Import AD File --->> AD_411_20210801_051f5f0e53a3868e19558ceeb9d5e47e.TXT ### 8/1/2021 7:30:06 AM
8/1/2021 7:30:06 AM : For Distributor 000000000000004 Insert Count::1 ### Delete Count::0
8/1/2021 7:30:06 AM : Import AD File --->> AD_4_20210801_9202b57b9c8e82ee8ff7ea48057d639e.TXT ### 8/1/2021 7:30:06 AM
8/1/2021 7:30:06 AM : For Distributor 000000000000519 Insert Count::6 ### Delete Count::0
8/1/2021 7:30:06 AM : Import AD File --->> AD_519_20210801_da8e1a41aee1fdaf664a53a0ad716d37.TXT ### 8/1/2021 7:30:06 AM
8/1/2021 7:30:42 AM : Import DN File --->> DN_1290_20210724_9558aa6085fa40962f2f48abe31ff7c8.TXT ### 8/1/2021 7:30:42 AM
8/1/2021 7:30:42 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::2
8/1/2021 7:30:43 AM : Import DN File --->> DN_1290_20210729_276e11f5d88a7e83208b6aa375ec3e22.TXT ### 8/1/2021 7:30:43 AM
8/1/2021 7:30:43 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::12
8/1/2021 7:30:43 AM : Import DN File --->> DN_1290_20210730_cb236573842d821879559dc0e00bf5b1.TXT ### 8/1/2021 7:30:43 AM
8/1/2021 7:30:43 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::3
8/1/2021 7:31:02 AM : For Distributor 000000000000411 Insert Count::1 ### Delete Count::0
8/1/2021 7:31:02 AM : Import DN File --->> DN_411_20210714_fb134a6cc5d252e94956a1d540811f1f.TXT ### 8/1/2021 7:31:02 AM
8/1/2021 7:31:03 AM : Import DN File --->> DN_411_20210727_9c68c41fe0504bfc4697297eef6757c8.TXT ### 8/1/2021 7:31:03 AM
8/1/2021 7:31:03 AM : NO Previous File For Distributor 000000000000411 ### Insert Count::1
8/1/2021 7:31:03 AM : Import DN File --->> DN_411_20210728_14742fd53318c56212a6ff7ec7c21b6b.TXT ### 8/1/2021 7:31:03 AM
8/1/2021 7:31:03 AM : NO Previous File For Distributor 000000000000411 ### Insert Count::6
8/1/2021 7:31:34 AM : For Distributor 000000000001047 Insert Count::78 ### Delete Count::0
8/1/2021 7:31:34 AM : Import IN File --->> IN_1047_20210731_e396ac68e137615a0ac3be1035411dca.TXT ### 8/1/2021 7:31:34 AM
8/1/2021 7:31:34 AM : Import IN File --->> IN_1047_20210801_450f8ab841b1853f1a13ae84a1143e2c.TXT ### 8/1/2021 7:31:34 AM
8/1/2021 7:31:34 AM : NO Previous File For Distributor 000000000001047 ### Insert Count::15
8/1/2021 7:31:36 AM : For Distributor 000000000001171 Insert Count::1 ### Delete Count::0
8/1/2021 7:31:36 AM : Import IN File --->> IN_1171_20210728_3c7d19c49a27ed2a3c8542d12fafdf68.TXT ### 8/1/2021 7:31:36 AM
8/1/2021 7:31:37 AM : For Distributor 000000000001171 Insert Count::4 ### Delete Count::0
8/1/2021 7:31:37 AM : Import IN File --->> IN_1171_20210730_45c234a86b0c165f0f41db0bcc14869b.TXT ### 8/1/2021 7:31:37 AM
8/1/2021 7:31:37 AM : For Distributor 000000000001171 Insert Count::6 ### Delete Count::0
8/1/2021 7:31:37 AM : Import IN File --->> IN_1171_20210731_ddd21dc803452923762dcd5f8d0af8ef.TXT ### 8/1/2021 7:31:37 AM
8/1/2021 7:31:45 AM : For Distributor 000000000001186 Insert Count::2 ### Delete Count::0
8/1/2021 7:31:45 AM : Import IN File --->> IN_1186_20210727_87d5f795ae6c2cf6bca139772ffe04e8.TXT ### 8/1/2021 7:31:45 AM
8/1/2021 7:31:45 AM : For Distributor 000000000001186 Insert Count::8 ### Delete Count::0
8/1/2021 7:31:45 AM : Import IN File --->> IN_1186_20210728_19bb748dbdad5077130728db5a842a4c.TXT ### 8/1/2021 7:31:45 AM
8/1/2021 7:31:45 AM : Import IN File --->> IN_1186_20210730_823b79e51b778c0630bd372a5d2d2411.TXT ### 8/1/2021 7:31:45 AM
8/1/2021 7:31:45 AM : NO Previous File For Distributor 000000000001186 ### Insert Count::6
8/1/2021 7:31:45 AM : Import IN File --->> IN_1186_20210731_1267252a8e1345af7e151d3494282e6a.TXT ### 8/1/2021 7:31:45 AM
8/1/2021 7:31:45 AM : NO Previous File For Distributor 000000000001186 ### Insert Count::5
8/1/2021 7:31:48 AM : Import IN File --->> IN_1197_20210728_6207e5fc3e90b47beefb240ee78fdfd9.TXT ### 8/1/2021 7:31:48 AM
8/1/2021 7:31:48 AM : NO Previous File For Distributor 000000000001197 ### Insert Count::1
8/1/2021 7:31:48 AM : Import IN File --->> IN_1197_20210729_2abb9a256eed07eeb761580dea357a4a.TXT ### 8/1/2021 7:31:48 AM
8/1/2021 7:31:48 AM : NO Previous File For Distributor 000000000001197 ### Insert Count::2
8/1/2021 7:31:48 AM : Import IN File --->> IN_1197_20210730_a02eb65f36da69aa610648d6e6955387.TXT ### 8/1/2021 7:31:48 AM
8/1/2021 7:31:48 AM : NO Previous File For Distributor 000000000001197 ### Insert Count::4
8/1/2021 7:31:48 AM : Import IN File --->> IN_1197_20210731_917f10394beb98b512432af4a332c4ec.TXT ### 8/1/2021 7:31:48 AM
8/1/2021 7:31:48 AM : NO Previous File For Distributor 000000000001197 ### Insert Count::3
8/1/2021 7:31:49 AM : For Distributor 000000000001290 Insert Count::1 ### Delete Count::0
8/1/2021 7:31:49 AM : Import IN File --->> IN_1290_20210709_ac08bc8dc6a6bbd4c94d6fdf19e197a9.TXT ### 8/1/2021 7:31:49 AM
8/1/2021 7:31:49 AM : For Distributor 000000000001290 Insert Count::10 ### Delete Count::0
8/1/2021 7:31:49 AM : Import IN File --->> IN_1290_20210717_b0662cc8c5cb441434f2c301bab43611.TXT ### 8/1/2021 7:31:49 AM
8/1/2021 7:31:50 AM : For Distributor 000000000001290 Insert Count::2 ### Delete Count::0
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210719_a7c2b640f34fbfd5fe2c3d2e7bed1c9a.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : For Distributor 000000000001290 Insert Count::3 ### Delete Count::0
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210720_871f106db83c353f273195c5e1f08961.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : For Distributor 000000000001290 Insert Count::3 ### Delete Count::0
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210721_a494d0cefb96d14216e0671c969a83e2.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210722_c633dd59f1f8dd23d505127ff312140f.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::13
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210723_0727f195e7d4f35578478374ba02255a.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::13
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210724_9f69435f3b0ed1bcf5dd355320969c9e.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::10
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210726_66c967b816f6eaa233cff02bd88c26ab.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::12
8/1/2021 7:31:50 AM : Import IN File --->> IN_1290_20210727_a3435b3ffea1a97a16b497456c982eb1.TXT ### 8/1/2021 7:31:50 AM
8/1/2021 7:31:50 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::4
8/1/2021 7:31:51 AM : Import IN File --->> IN_1290_20210728_9cbed1193f7d785ec1b94502eba68f15.TXT ### 8/1/2021 7:31:51 AM
8/1/2021 7:31:51 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::1
8/1/2021 7:31:51 AM : Import IN File --->> IN_1290_20210729_bc587f37db0b0c07e48b154d2b5bf708.TXT ### 8/1/2021 7:31:51 AM
8/1/2021 7:31:51 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::4
8/1/2021 7:31:51 AM : Import IN File --->> IN_1290_20210730_ca86a3360a6bc1d6531f8292564f6ef9.TXT ### 8/1/2021 7:31:51 AM
8/1/2021 7:31:51 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::7
8/1/2021 7:31:51 AM : Import IN File --->> IN_1290_20210731_4648e9aa2a998768b82ad3639708f8d7.TXT ### 8/1/2021 7:31:51 AM
8/1/2021 7:31:51 AM : NO Previous File For Distributor 000000000001290 ### Insert Count::6
8/1/2021 7:31:55 AM : Import IN File --->> IN_265_20210730_209679efd499c985ae0cb1ad719e754f.TXT ### 8/1/2021 7:31:55 AM
8/1/2021 7:31:55 AM : NO Previous File For Distributor 000000000000265 ### Insert Count::4
8/1/2021 7:32:07 AM : For Distributor 000000000000400 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:07 AM : Import IN File --->> IN_400_20210716_5b5ec3bf69899208aa2448c6523480a9.TXT ### 8/1/2021 7:32:07 AM
8/1/2021 7:32:07 AM : For Distributor 000000000000400 Insert Count::3 ### Delete Count::0
8/1/2021 7:32:07 AM : Import IN File --->> IN_400_20210717_94ff5b1c40f41bf595cdc8589ce22b2b.TXT ### 8/1/2021 7:32:07 AM
8/1/2021 7:32:07 AM : For Distributor 000000000000400 Insert Count::4 ### Delete Count::0
8/1/2021 7:32:07 AM : Import IN File --->> IN_400_20210719_c9859a301f1417fe967b25f04580c145.TXT ### 8/1/2021 7:32:07 AM
8/1/2021 7:32:07 AM : For Distributor 000000000000400 Insert Count::1 ### Delete Count::0
8/1/2021 7:32:07 AM : Import IN File --->> IN_400_20210720_12976b8ec095c6568737954c5674eb85.TXT ### 8/1/2021 7:32:07 AM
8/1/2021 7:32:07 AM : For Distributor 000000000000400 Insert Count::7 ### Delete Count::0
8/1/2021 7:32:07 AM : Import IN File --->> IN_400_20210721_c5e68581e1cc58a4ed33eb25ebc7f531.TXT ### 8/1/2021 7:32:07 AM
8/1/2021 7:32:07 AM : For Distributor 000000000000400 Insert Count::8 ### Delete Count::0
8/1/2021 7:32:07 AM : Import IN File --->> IN_400_20210722_17e774a4d521cd07cebd83849656031d.TXT ### 8/1/2021 7:32:07 AM
8/1/2021 7:32:08 AM : For Distributor 000000000000400 Insert Count::5 ### Delete Count::0
8/1/2021 7:32:08 AM : Import IN File --->> IN_400_20210723_15dabb8a403a1be2aefd2a663d86b277.TXT ### 8/1/2021 7:32:08 AM
8/1/2021 7:32:08 AM : For Distributor 000000000000400 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:08 AM : Import IN File --->> IN_400_20210724_bf8f4fc2237d0512719c455b70aa451a.TXT ### 8/1/2021 7:32:08 AM
8/1/2021 7:32:08 AM : For Distributor 000000000000400 Insert Count::4 ### Delete Count::0
8/1/2021 7:32:08 AM : Import IN File --->> IN_400_20210726_fe15bf0cfe15cf1b5f8ac128ca0da08b.TXT ### 8/1/2021 7:32:08 AM
8/1/2021 7:32:08 AM : For Distributor 000000000000400 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:08 AM : Import IN File --->> IN_400_20210727_e4a425284fd6bccfdf2c0ebdf718c772.TXT ### 8/1/2021 7:32:08 AM
8/1/2021 7:32:08 AM : For Distributor 000000000000400 Insert Count::3 ### Delete Count::0
8/1/2021 7:32:08 AM : Import IN File --->> IN_400_20210728_5f1eac6211544ed0b2d3d2c39503572a.TXT ### 8/1/2021 7:32:08 AM
8/1/2021 7:32:08 AM : For Distributor 000000000000400 Insert Count::3 ### Delete Count::0
8/1/2021 7:32:08 AM : Import IN File --->> IN_400_20210729_c086ebcfe04ae75212f9c8ea8102b73d.TXT ### 8/1/2021 7:32:08 AM
8/1/2021 7:32:09 AM : For Distributor 000000000000400 Insert Count::3 ### Delete Count::0
8/1/2021 7:32:09 AM : Import IN File --->> IN_400_20210730_750bc48d7d42750061c9ee85757d266f.TXT ### 8/1/2021 7:32:09 AM
8/1/2021 7:32:09 AM : For Distributor 000000000000400 Insert Count::6 ### Delete Count::0
8/1/2021 7:32:09 AM : Import IN File --->> IN_400_20210731_798946e3b13fc3da530a1b7e5b8200b1.TXT ### 8/1/2021 7:32:09 AM
8/1/2021 7:32:11 AM : For Distributor 000000000000405 Insert Count::1 ### Delete Count::0
8/1/2021 7:32:11 AM : Import IN File --->> IN_405_20210731_c5677bc209d9c608507c05ede11d2ec6.TXT ### 8/1/2021 7:32:11 AM
8/1/2021 7:32:11 AM : For Distributor 000000000000407 Insert Count::3 ### Delete Count::0
8/1/2021 7:32:11 AM : Import IN File --->> IN_407_20210703_a3fd1978c8411cf3096f7892e3e9bc1e.TXT ### 8/1/2021 7:32:11 AM
8/1/2021 7:32:12 AM : For Distributor 000000000000407 Insert Count::7 ### Delete Count::0
8/1/2021 7:32:12 AM : Import IN File --->> IN_407_20210704_1e4b3c1f1a82282cb1c8a70ee47e4336.TXT ### 8/1/2021 7:32:12 AM
8/1/2021 7:32:12 AM : For Distributor 000000000000407 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:12 AM : Import IN File --->> IN_407_20210705_935a9c35a1f6e38b8d581fe1e0f48a0a.TXT ### 8/1/2021 7:32:12 AM
8/1/2021 7:32:12 AM : For Distributor 000000000000407 Insert Count::4 ### Delete Count::0
8/1/2021 7:32:12 AM : Import IN File --->> IN_407_20210707_477f960ae56c3b0ce7f7153ca756fcdb.TXT ### 8/1/2021 7:32:12 AM
8/1/2021 7:32:12 AM : For Distributor 000000000000407 Insert Count::1 ### Delete Count::0
8/1/2021 7:32:12 AM : Import IN File --->> IN_407_20210708_33d1e5de2705ac36ac873dbab2e859f2.TXT ### 8/1/2021 7:32:12 AM
8/1/2021 7:32:12 AM : For Distributor 000000000000407 Insert Count::1 ### Delete Count::0
8/1/2021 7:32:12 AM : Import IN File --->> IN_407_20210709_58696c7aa9c55117eab63c15fb98b5b9.TXT ### 8/1/2021 7:32:12 AM
8/1/2021 7:32:13 AM : For Distributor 000000000000407 Insert Count::10 ### Delete Count::0
8/1/2021 7:32:13 AM : Import IN File --->> IN_407_20210712_b2e3d6bc8ddeea5ff1d92cfbb394ad43.TXT ### 8/1/2021 7:32:13 AM
8/1/2021 7:32:13 AM : For Distributor 000000000000407 Insert Count::6 ### Delete Count::0
8/1/2021 7:32:13 AM : Import IN File --->> IN_407_20210713_f6dd43cdaf189c2d9b92fa0f5308a635.TXT ### 8/1/2021 7:32:13 AM
8/1/2021 7:32:13 AM : For Distributor 000000000000407 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:13 AM : Import IN File --->> IN_407_20210714_375bba4a072df83762855efccf5aaeb2.TXT ### 8/1/2021 7:32:13 AM
8/1/2021 7:32:13 AM : For Distributor 000000000000407 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:13 AM : Import IN File --->> IN_407_20210715_429ace270859f39d76bafa653df5e140.TXT ### 8/1/2021 7:32:13 AM
8/1/2021 7:32:13 AM : For Distributor 000000000000407 Insert Count::2 ### Delete Count::0
8/1/2021 7:32:13 AM : Import IN File --->> IN_407_20210716_a7d6c6b60cb453851ad915f4427d6a0b.TXT ### 8/1/2021 7:32:13 AM
8/1/2021 7:32:13 AM : For Distributor 000000000000407 Insert Count::3 ### Delete Count::0
8/1/2021 7:32:13 AM : Import IN File --->> IN_407_20210717_80bb6287bfc65e9f930b230ad4dac8ed.TXT ### 8/1/2021 7:32:13 AM
8/1/2021 7:32:17 AM : Import IN File --->> IN_411_20210731_7af8d475f42c521745c608a74a852c3d.TXT ### 8/1/2021 7:32:17 AM
8/1/2021 7:32:17 AM : NO Previous File For Distributor 000000000000411 ### Insert Count::4
8/1/2021 7:32:28 AM : For Distributor 000000000000004 Insert Count::9 ### Delete Count::0
8/1/2021 7:32:28 AM : Import IN File --->> IN_4_20210731_a1b50aad09c380deb3cdb122e54b0b90.TXT ### 8/1/2021 7:32:28 AM
8/1/2021 7:32:36 AM : For Distributor 000000000000519 Insert Count::9 ### Delete Count::0
8/1/2021 7:32:36 AM : Import IN File --->> IN_519_20210731_beea96dfde746210350fa0ec6a27e925.TXT ### 8/1/2021 7:32:36 AM
8/1/2021 7:32:36 AM : For Distributor 000000000001047 Insert Count::0 ### Delete Count::5
8/1/2021 7:32:36 AM : Import PR File --->> PR_1047_20210801_c05a70b6075e60b0743b51fae7de3421.TXT ### 8/1/2021 7:32:36 AM
8/1/2021 7:32:37 AM : For Distributor 000000000000400 Insert Count::52 ### Delete Count::0
8/1/2021 7:32:37 AM : Import PR File --->> PR_400_20210801_2f141527247e11cd7ec9374b36d8cef2.TXT ### 8/1/2021 7:32:37 AM
8/1/2021 7:32:37 AM : PostData() --->>  ### 8/1/2021 7:32:37 AM
8/1/2021 7:32:42 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 8/1/2021 7:32:42 AM
8/1/2021 7:32:46 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '01/Aug/2021' ### 8/1/2021 7:32:46 AM
8/1/2021 7:32:47 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '01/Aug/2021' ### 8/1/2021 7:32:47 AM
8/1/2021 7:32:47 AM :  ### 
8/1/2021 7:32:47 AM : UNLINKEDSALES Record Count Before --->> 347 ### 8/1/2021 7:32:47 AM
8/1/2021 7:32:47 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 8/1/2021 7:32:47 AM
8/1/2021 7:32:57 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '01/Aug/2021' ### 8/1/2021 7:32:57 AM
8/1/2021 7:32:57 AM : UNLINKEDSALES Record Count After --->> 0 ### 8/1/2021 7:32:57 AM
8/1/2021 7:32:57 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 8/1/2021 7:32:57 AM
8/1/2021 7:32:57 AM :  ### 
8/1/2021 7:32:57 AM : Posting Supplierlink Query for Purchases --->>  ### 8/1/2021 7:32:57 AM
8/1/2021 7:33:03 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '01/Aug/2021' ### 8/1/2021 7:33:03 AM
8/1/2021 7:33:08 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '01/Aug/2021' ### 8/1/2021 7:33:08 AM
8/1/2021 7:33:08 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 8/1/2021 7:33:08 AM
8/1/2021 7:33:08 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '01/Aug/2021' ### 8/1/2021 7:33:08 AM
8/1/2021 7:33:09 AM : Posting ClosingStock Successful --->>  ### 8/1/2021 7:33:09 AM
8/1/2021 7:33:09 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 8/1/2021 7:33:09 AM
8/1/2021 7:33:09 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
8/1/2021 7:33:09 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 8/1/2021 7:33:09 AM
8/1/2021 7:33:09 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:33:09 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2043239_TEMPLATE1.txt ### 8/1/2021 7:33:09 AM
8/1/2021 7:33:09 AM : Count:: ### TEMPLATE1:129
8/1/2021 7:33:15 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:33:15 AM
8/1/2021 7:33:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 8/1/2021 7:33:15 AM
8/1/2021 7:33:15 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:33:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 8/1/2021 7:33:15 AM
8/1/2021 7:33:16 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:33:16 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3272418_TEMPLATE1.TXT ### 8/1/2021 7:33:16 AM
8/1/2021 7:33:16 AM : Count:: ### TEMPLATE1:154
8/1/2021 7:33:33 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:33:33 AM
8/1/2021 7:33:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 8/1/2021 7:33:33 AM
8/1/2021 7:33:33 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:33:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 8/1/2021 7:33:33 AM
8/1/2021 7:33:33 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:33:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3675389_TEMPLATE1.txt ### 8/1/2021 7:33:33 AM
8/1/2021 7:33:33 AM : Count:: ### TEMPLATE1:1518
8/1/2021 7:34:50 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:34:50 AM
8/1/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3800230_TEMPLATE1.txt ### 8/1/2021 7:34:50 AM
8/1/2021 7:34:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 8/1/2021 7:34:50 AM
8/1/2021 7:34:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 8/1/2021 7:34:50 AM
8/1/2021 7:34:50 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:34:50 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3893818_TEMPLATE1.txt ### 8/1/2021 7:34:50 AM
8/1/2021 7:34:50 AM : Count:: ### TEMPLATE1:115
8/1/2021 7:34:55 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:34:55 AM
8/1/2021 7:34:55 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3897231_TEMPLATE1.txt ### 8/1/2021 7:34:55 AM
8/1/2021 7:34:55 AM : Count:: ### TEMPLATE1:24
8/1/2021 7:34:58 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:34:58 AM
8/1/2021 7:34:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 8/1/2021 7:34:58 AM
8/1/2021 7:34:58 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:34:58 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4179428_TEMPLATE1.txt ### 8/1/2021 7:34:58 AM
8/1/2021 7:34:58 AM : Count:: ### TEMPLATE1:3
8/1/2021 7:34:59 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:34:59 AM
8/1/2021 7:34:59 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4188862_TEMPLATE1.TXT ### 8/1/2021 7:34:59 AM
8/1/2021 7:34:59 AM : Count:: ### TEMPLATE1:25
8/1/2021 7:35:01 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:35:01 AM
8/1/2021 7:35:01 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4194755_TEMPLATE1.txt ### 8/1/2021 7:35:01 AM
8/1/2021 7:35:01 AM : Count:: ### TEMPLATE1:573
8/1/2021 7:35:31 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:35:31 AM
8/1/2021 7:35:31 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4196234_TEMPLATE1.TXT ### 8/1/2021 7:35:31 AM
8/1/2021 7:35:31 AM : Count:: ### TEMPLATE1:14
8/1/2021 7:35:32 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:35:32 AM
8/1/2021 7:35:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 8/1/2021 7:35:32 AM
8/1/2021 7:35:32 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:35:32 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4483610_TEMPLATE1.txt ### 8/1/2021 7:35:32 AM
8/1/2021 7:35:32 AM : Count:: ### TEMPLATE1:106
8/1/2021 7:35:34 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:35:34 AM
8/1/2021 7:35:34 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 8/1/2021 7:35:34 AM
8/1/2021 7:35:34 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:35:34 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060858_TEMPLATE1.txt ### 8/1/2021 7:35:34 AM
8/1/2021 7:35:34 AM : Count:: ### TEMPLATE1:527
8/1/2021 7:35:43 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:35:43 AM
8/1/2021 7:35:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 8/1/2021 7:35:43 AM
8/1/2021 7:35:43 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:35:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061058_TEMPLATE1.txt ### 8/1/2021 7:35:43 AM
8/1/2021 7:35:43 AM : Count:: ### TEMPLATE1:53
8/1/2021 7:35:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:35:48 AM
8/1/2021 7:35:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 8/1/2021 7:35:48 AM
8/1/2021 7:35:48 AM : Count:: ### TEMPLATE1:306
8/1/2021 7:36:03 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:36:03 AM
8/1/2021 7:36:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 8/1/2021 7:36:03 AM
8/1/2021 7:36:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:36:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 8/1/2021 7:36:03 AM
8/1/2021 7:36:03 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:36:03 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 8/1/2021 7:36:03 AM
8/1/2021 7:36:03 AM : Count:: ### TEMPLATE1:158
8/1/2021 7:36:12 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:36:12 AM
8/1/2021 7:36:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062686_TEMPLATE1.TXT ### 8/1/2021 7:36:12 AM
8/1/2021 7:36:12 AM : Count:: ### TEMPLATE1:30
8/1/2021 7:36:15 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:36:15 AM
8/1/2021 7:36:15 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062754_TEMPLATE1.TXT ### 8/1/2021 7:36:15 AM
8/1/2021 7:36:15 AM : Count:: ### TEMPLATE1:54
8/1/2021 7:36:23 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:36:23 AM
8/1/2021 7:36:23 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062952_TEMPLATE1.TXT ### 8/1/2021 7:36:23 AM
8/1/2021 7:36:23 AM : Count:: ### TEMPLATE1:83
8/1/2021 7:36:33 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:36:33 AM
8/1/2021 7:36:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 8/1/2021 7:36:33 AM
8/1/2021 7:36:33 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 7:36:33 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9067917_TEMPLATE1.TXT ### 8/1/2021 7:36:33 AM
8/1/2021 7:36:33 AM : Count:: ### TEMPLATE1:20
8/1/2021 7:36:34 AM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 7:36:34 AM
8/1/2021 7:36:34 AM : Template Import Complete  ### 8/1/2021 7:36:34 AM
8/1/2021 7:36:36 AM : Completed Updating Has Transaction Flag  ### 8/1/2021 7:36:36 AM
8/1/2021 7:36:36 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 8/1/2021 7:36:36 AM
8/1/2021 7:36:36 AM : Zylem Access Unblocked  ### 8/1/2021 7:36:36 AM
8/1/2021 7:36:36 AM : Application Ended  ### 8/1/2021 7:36:36 AM

8/1/2021 2:30:01 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
8/1/2021 2:30:02 PM : StartProcess  ### 8/1/2021 2:30:02 PM

8/1/2021 2:30:02 PM : 11  ### 8/1/2021 2:30:02 PM

8/1/2021 2:30:02 PM : 22  ### 8/1/2021 2:30:02 PM

8/1/2021 2:30:02 PM : 33  ### 8/1/2021 2:30:02 PM

8/1/2021 2:30:02 PM : Application Started  ### 8/1/2021 2:30:02 PM

8/1/2021 2:30:02 PM : Start Process : checkAllTablesExists()  ### 
8/1/2021 2:30:02 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 8/1/2021 2:30:02 PM
8/1/2021 2:30:02 PM : MainForm_Load  ### AlertSystem ON
8/1/2021 2:30:03 PM : No. of Files to import (RECEIVEFINAL):  ### 857
8/1/2021 2:30:03 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
8/1/2021 2:30:03 PM : For Distributor 000000000001136 Insert Count::0 ### Delete Count::32
8/1/2021 2:30:03 PM : Import AD File --->> AD_1136_20210801_022295d5d0f6957090140501e1e9ff15.TXT ### 8/1/2021 2:30:03 PM
8/1/2021 2:30:03 PM : For Distributor 000000000001203 Insert Count::4 ### Delete Count::36
8/1/2021 2:30:03 PM : Import AD File --->> AD_1203_20210801_7a8b40d573edc3744d481624ba93baa7.TXT ### 8/1/2021 2:30:03 PM
8/1/2021 2:30:04 PM : For Distributor 000000000000525 Insert Count::27 ### Delete Count::7
8/1/2021 2:30:04 PM : Import AD File --->> AD_525_20210801_7e28cb2feaae8bf25c2fae261218103f.TXT ### 8/1/2021 2:30:04 PM
8/1/2021 2:30:18 PM : For Distributor 000000000001191 Insert Count::8 ### Delete Count::0
8/1/2021 2:30:18 PM : Import DN File --->> DN_1191_20210705_42a26a878190315e5ae97ed5110c0fc4.TXT ### 8/1/2021 2:30:18 PM
8/1/2021 2:30:18 PM : For Distributor 000000000001191 Insert Count::3 ### Delete Count::0
8/1/2021 2:30:18 PM : Import DN File --->> DN_1191_20210706_b25b57e61e3b76c604ffabd99ec7e5c9.TXT ### 8/1/2021 2:30:18 PM
8/1/2021 2:30:19 PM : For Distributor 000000000001191 Insert Count::5 ### Delete Count::0
8/1/2021 2:30:19 PM : Import DN File --->> DN_1191_20210722_00917ca91d264ddc6760d47234cfadb2.TXT ### 8/1/2021 2:30:19 PM
8/1/2021 2:30:22 PM : For Distributor 000000000001203 Insert Count::6 ### Delete Count::0
8/1/2021 2:30:22 PM : Import DN File --->> DN_1203_20210728_3d4c383b5da650f2ed49aebeede70225.TXT ### 8/1/2021 2:30:22 PM
8/1/2021 2:30:32 PM : For Distributor 000000000000042 Insert Count::2 ### Delete Count::0
8/1/2021 2:30:32 PM : Import DN File --->> DN_42_20210727_c3e6381e73d72612a59fd5c813ad2d81.TXT ### 8/1/2021 2:30:32 PM
8/1/2021 2:30:32 PM : For Distributor 000000000000042 Insert Count::4 ### Delete Count::0
8/1/2021 2:30:32 PM : Import DN File --->> DN_42_20210728_e7d1be624aabdae1ae807161135a6171.TXT ### 8/1/2021 2:30:32 PM
8/1/2021 2:30:33 PM : For Distributor 000000000000525 Insert Count::1 ### Delete Count::0
8/1/2021 2:30:33 PM : Import DN File --->> DN_525_20210712_48b6b99a6f4e5ce47d1d0bbb2f9da8a9.TXT ### 8/1/2021 2:30:33 PM
8/1/2021 2:30:34 PM : For Distributor 000000000000525 Insert Count::2 ### Delete Count::0
8/1/2021 2:30:34 PM : Import DN File --->> DN_525_20210716_030d94ddc1ff7516327f186852fc396a.TXT ### 8/1/2021 2:30:34 PM
8/1/2021 2:30:47 PM : For Distributor 000000000001203 Insert Count::4 ### Delete Count::0
8/1/2021 2:30:47 PM : Import IN File --->> IN_1203_20210730_8604ff091c25d73d3210a49b1b6419aa.TXT ### 8/1/2021 2:30:47 PM
8/1/2021 2:30:48 PM : For Distributor 000000000001203 Insert Count::9 ### Delete Count::0
8/1/2021 2:30:48 PM : Import IN File --->> IN_1203_20210731_af0daea706b015295b35a5a62c919829.TXT ### 8/1/2021 2:30:48 PM
8/1/2021 2:30:58 PM : For Distributor 000000000000405 Insert Count::7 ### Delete Count::0
8/1/2021 2:30:58 PM : Import IN File --->> IN_405_20210801_ad728978b4ee2c047fc0813764640fd1.TXT ### 8/1/2021 2:30:58 PM
8/1/2021 2:31:00 PM : For Distributor 000000000000042 Insert Count::1 ### Delete Count::0
8/1/2021 2:31:00 PM : Import IN File --->> IN_42_20210729_a7ca35917b61f059ddae795a1fef4015.TXT ### 8/1/2021 2:31:00 PM
8/1/2021 2:31:00 PM : For Distributor 000000000000042 Insert Count::2 ### Delete Count::0
8/1/2021 2:31:00 PM : Import IN File --->> IN_42_20210731_2012b85ee47e3754b8174588b0704a8c.TXT ### 8/1/2021 2:31:00 PM
8/1/2021 2:31:01 PM : For Distributor 000000000000525 Insert Count::14 ### Delete Count::0
8/1/2021 2:31:01 PM : Import IN File --->> IN_525_20210701_381528739858a354b5a23f48a4a03485.TXT ### 8/1/2021 2:31:01 PM
8/1/2021 2:31:01 PM : For Distributor 000000000000525 Insert Count::7 ### Delete Count::0
8/1/2021 2:31:01 PM : Import IN File --->> IN_525_20210702_773745f08f4a49634f1baa62142a5791.TXT ### 8/1/2021 2:31:01 PM
8/1/2021 2:31:01 PM : For Distributor 000000000000525 Insert Count::17 ### Delete Count::0
8/1/2021 2:31:01 PM : Import IN File --->> IN_525_20210703_d6b50719ba6227f94078078819a80fff.TXT ### 8/1/2021 2:31:01 PM
8/1/2021 2:31:01 PM : For Distributor 000000000000525 Insert Count::18 ### Delete Count::0
8/1/2021 2:31:01 PM : Import IN File --->> IN_525_20210704_8361f9cbe614c44e047f026dd8cb43d5.TXT ### 8/1/2021 2:31:01 PM
8/1/2021 2:31:01 PM : For Distributor 000000000000525 Insert Count::20 ### Delete Count::0
8/1/2021 2:31:01 PM : Import IN File --->> IN_525_20210705_763e6e9a01c811c248113d084ebf397c.TXT ### 8/1/2021 2:31:01 PM
8/1/2021 2:31:01 PM : For Distributor 000000000000525 Insert Count::16 ### Delete Count::0
8/1/2021 2:31:01 PM : Import IN File --->> IN_525_20210707_da710ef0f3f37e88af34ec1513d98e69.TXT ### 8/1/2021 2:31:01 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::20 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210708_389989d57622d83fd3e1ab815d916d38.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::13 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210709_6c1ef6a22a245fe7055ec2bf90b1b27c.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::17 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210710_0f85baaea71e6e7b05a0355a587f1497.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::13 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210711_0e87880bd42ca812fbd20c5d7a028184.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::10 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210712_2814435de8023382cb4133f28ba13fc5.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::16 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210714_00f80b71d43db489fcea822c1925fd8f.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:02 PM : For Distributor 000000000000525 Insert Count::13 ### Delete Count::0
8/1/2021 2:31:02 PM : Import IN File --->> IN_525_20210715_331ec856bd3a047c423f331318a704a8.TXT ### 8/1/2021 2:31:02 PM
8/1/2021 2:31:03 PM : For Distributor 000000000000525 Insert Count::8 ### Delete Count::0
8/1/2021 2:31:03 PM : Import IN File --->> IN_525_20210716_0c363fabae1a25638b78a9f11da4620a.TXT ### 8/1/2021 2:31:03 PM
8/1/2021 2:31:03 PM : For Distributor 000000000000525 Insert Count::14 ### Delete Count::0
8/1/2021 2:31:03 PM : Import IN File --->> IN_525_20210717_c3f79a34431f75e65ed0a01660426061.TXT ### 8/1/2021 2:31:03 PM
8/1/2021 2:31:03 PM : For Distributor 000000000000525 Insert Count::11 ### Delete Count::0
8/1/2021 2:31:03 PM : Import IN File --->> IN_525_20210718_44d4d4799f72761c89db369739c29fe5.TXT ### 8/1/2021 2:31:03 PM
8/1/2021 2:31:03 PM : For Distributor 000000000000525 Insert Count::5 ### Delete Count::0
8/1/2021 2:31:03 PM : Import IN File --->> IN_525_20210719_1a4b382580e810407f36b3ac2d4a9331.TXT ### 8/1/2021 2:31:03 PM
8/1/2021 2:31:03 PM : For Distributor 000000000000525 Insert Count::7 ### Delete Count::0
8/1/2021 2:31:03 PM : Import IN File --->> IN_525_20210721_7fcd55a34fd28a332f39c2ccee21eeab.TXT ### 8/1/2021 2:31:03 PM
8/1/2021 2:31:03 PM : For Distributor 000000000000525 Insert Count::4 ### Delete Count::0
8/1/2021 2:31:03 PM : Import IN File --->> IN_525_20210722_e3b22266e71f0fae8b1ff33c1d2400fc.TXT ### 8/1/2021 2:31:03 PM
8/1/2021 2:31:04 PM : For Distributor 000000000000525 Insert Count::9 ### Delete Count::0
8/1/2021 2:31:04 PM : Import IN File --->> IN_525_20210723_88bb44f212dfb1f5757f6fbf0534a9fd.TXT ### 8/1/2021 2:31:04 PM
8/1/2021 2:31:04 PM : For Distributor 000000000000525 Insert Count::4 ### Delete Count::0
8/1/2021 2:31:04 PM : Import IN File --->> IN_525_20210724_197ed0ef4e93660edb544bb4c108edd0.TXT ### 8/1/2021 2:31:04 PM
8/1/2021 2:31:04 PM : For Distributor 000000000000525 Insert Count::5 ### Delete Count::0
8/1/2021 2:31:04 PM : Import IN File --->> IN_525_20210725_c7f2a3b4446eca5de0724ad055b1ce8b.TXT ### 8/1/2021 2:31:04 PM
8/1/2021 2:31:05 PM : For Distributor 000000000001203 Insert Count::3 ### Delete Count::11
8/1/2021 2:31:05 PM : Import PR File --->> PR_1203_20210801_8d9f23d5447b8f304f6751fbfacd7589.TXT ### 8/1/2021 2:31:05 PM
8/1/2021 2:31:05 PM : PostData() --->>  ### 8/1/2021 2:31:05 PM
8/1/2021 2:31:06 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 8/1/2021 2:31:06 PM
8/1/2021 2:31:08 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '01/Aug/2021' ### 8/1/2021 2:31:08 PM
8/1/2021 2:31:09 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '01/Aug/2021' ### 8/1/2021 2:31:09 PM
8/1/2021 2:31:09 PM :  ### 
8/1/2021 2:31:09 PM : UNLINKEDSALES Record Count Before --->> 284 ### 8/1/2021 2:31:09 PM
8/1/2021 2:31:09 PM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 8/1/2021 2:31:09 PM
8/1/2021 2:31:15 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '01/Aug/2021' ### 8/1/2021 2:31:15 PM
8/1/2021 2:31:15 PM : UNLINKEDSALES Record Count After --->> 0 ### 8/1/2021 2:31:15 PM
8/1/2021 2:31:15 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 8/1/2021 2:31:15 PM
8/1/2021 2:31:15 PM :  ### 
8/1/2021 2:31:15 PM : Posting Supplierlink Query for Purchases --->>  ### 8/1/2021 2:31:15 PM
8/1/2021 2:31:21 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '01/Aug/2021' ### 8/1/2021 2:31:21 PM
8/1/2021 2:31:26 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '01/Aug/2021' ### 8/1/2021 2:31:26 PM
8/1/2021 2:31:26 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 8/1/2021 2:31:26 PM
8/1/2021 2:31:26 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '01/Aug/2021' ### 8/1/2021 2:31:26 PM
8/1/2021 2:31:27 PM : Posting ClosingStock Successful --->>  ### 8/1/2021 2:31:27 PM
8/1/2021 2:31:27 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 8/1/2021 2:31:27 PM
8/1/2021 2:31:27 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
8/1/2021 2:31:27 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 8/1/2021 2:31:27 PM
8/1/2021 2:31:27 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:27 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1988040_TEMPLATE1.txt ### 8/1/2021 2:31:27 PM
8/1/2021 2:31:27 PM : Count:: ### TEMPLATE1:73
8/1/2021 2:31:35 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:31:35 PM
8/1/2021 2:31:35 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2043239_TEMPLATE1.txt ### 8/1/2021 2:31:35 PM
8/1/2021 2:31:35 PM : Count:: ### TEMPLATE1:129
8/1/2021 2:31:49 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:31:49 PM
8/1/2021 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 8/1/2021 2:31:49 PM
8/1/2021 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 8/1/2021 2:31:49 PM
8/1/2021 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 8/1/2021 2:31:49 PM
8/1/2021 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 8/1/2021 2:31:49 PM
8/1/2021 2:31:49 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:49 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3643369_TEMPLATE1.TXT ### 8/1/2021 2:31:49 PM
8/1/2021 2:31:49 PM : Count:: ### TEMPLATE1:178
8/1/2021 2:31:52 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:31:52 PM
8/1/2021 2:31:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3800230_TEMPLATE1.txt ### 8/1/2021 2:31:53 PM
8/1/2021 2:31:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 8/1/2021 2:31:53 PM
8/1/2021 2:31:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 8/1/2021 2:31:53 PM
8/1/2021 2:31:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:31:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3897231_TEMPLATE1.txt ### 8/1/2021 2:31:53 PM
8/1/2021 2:31:53 PM : Count:: ### TEMPLATE1:24
8/1/2021 2:31:55 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:31:55 PM
8/1/2021 2:31:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3928843_TEMPLATE1.TXT ### 8/1/2021 2:31:55 PM
8/1/2021 2:31:55 PM : Count:: ### TEMPLATE1:51
8/1/2021 2:32:01 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:32:01 PM
8/1/2021 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 8/1/2021 2:32:01 PM
8/1/2021 2:32:01 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:32:01 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4179428_TEMPLATE1.txt ### 8/1/2021 2:32:01 PM
8/1/2021 2:32:01 PM : Count:: ### TEMPLATE1:3
8/1/2021 2:32:02 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:32:02 PM
8/1/2021 2:32:02 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 8/1/2021 2:32:02 PM
8/1/2021 2:32:02 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:32:02 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4447756_TEMPLATE1.txt ### 8/1/2021 2:32:02 PM
8/1/2021 2:32:02 PM : Count:: ### TEMPLATE1:47
8/1/2021 2:32:08 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:32:08 PM
8/1/2021 2:32:08 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 8/1/2021 2:32:08 PM
8/1/2021 2:32:08 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:32:08 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_756908_TEMPLATE1.txt ### 8/1/2021 2:32:08 PM
8/1/2021 2:32:08 PM : Count:: ### TEMPLATE1:110
8/1/2021 2:32:22 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:32:22 PM
8/1/2021 2:32:22 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060532_TEMPLATE1.TXT ### 8/1/2021 2:32:22 PM
8/1/2021 2:32:22 PM : Count:: ### TEMPLATE1:1802
8/1/2021 2:32:53 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:32:53 PM
8/1/2021 2:32:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 8/1/2021 2:32:53 PM
8/1/2021 2:32:53 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:32:53 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061033_TEMPLATE1.TXT ### 8/1/2021 2:32:53 PM
8/1/2021 2:32:53 PM : Count:: ### TEMPLATE1:32
8/1/2021 2:32:55 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:32:55 PM
8/1/2021 2:32:55 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061385_TEMPLATE1.TXT ### 8/1/2021 2:32:55 PM
8/1/2021 2:32:55 PM : Count:: ### TEMPLATE1:306
8/1/2021 2:33:32 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:33:32 PM
8/1/2021 2:33:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 8/1/2021 2:33:32 PM
8/1/2021 2:33:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:33:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 8/1/2021 2:33:32 PM
8/1/2021 2:33:32 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:33:32 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061625_TEMPLATE1.txt ### 8/1/2021 2:33:32 PM
8/1/2021 2:33:32 PM : Count:: ### TEMPLATE1:158
8/1/2021 2:33:40 PM : SP_DistributorTemplatePosting Successful --->>  ### 8/1/2021 2:33:40 PM
8/1/2021 2:33:40 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 8/1/2021 2:33:40 PM
8/1/2021 2:33:40 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
8/1/2021 2:33:40 PM : Template Import Complete  ### 8/1/2021 2:33:40 PM
8/1/2021 2:33:42 PM : Completed Updating Has Transaction Flag  ### 8/1/2021 2:33:42 PM
8/1/2021 2:33:42 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 8/1/2021 2:33:42 PM
8/1/2021 2:33:42 PM : Zylem Access Unblocked  ### 8/1/2021 2:33:42 PM
8/1/2021 2:33:42 PM : Application Ended  ### 8/1/2021 2:33:42 PM