6/8/2022 2:30:04 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
6/8/2022 2:30:05 AM : StartProcess  ### 6/8/2022 2:30:05 AM

6/8/2022 2:30:05 AM : 11  ### 6/8/2022 2:30:05 AM

6/8/2022 2:30:05 AM : 22  ### 6/8/2022 2:30:05 AM

6/8/2022 2:30:05 AM : 33  ### 6/8/2022 2:30:05 AM

6/8/2022 2:30:05 AM : Application Started  ### 6/8/2022 2:30:05 AM

6/8/2022 2:30:05 AM : Start Process : checkAllTablesExists()  ### 
6/8/2022 2:30:05 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/8/2022 2:30:05 AM
6/8/2022 2:30:05 AM : MainForm_Load  ### AlertSystem ON
6/8/2022 2:30:05 AM : No. of Files to import (RECEIVEFINAL):  ### 1
6/8/2022 2:30:05 AM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
6/8/2022 2:30:05 AM : PostData() --->>  ### 6/8/2022 2:30:05 AM
6/8/2022 2:30:05 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 6/8/2022 2:30:05 AM
6/8/2022 2:30:06 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '08/Jun/2022' ### 6/8/2022 2:30:06 AM
6/8/2022 2:30:06 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '08/Jun/2022' ### 6/8/2022 2:30:06 AM
6/8/2022 2:30:06 AM :  ### 
6/8/2022 2:30:06 AM : UNLINKEDSALES Record Count Before --->> 0 ### 6/8/2022 2:30:06 AM
6/8/2022 2:30:06 AM : UNLINKEDSALES_DEL Record Count Before --->> 0 ### 6/8/2022 2:30:06 AM
6/8/2022 2:30:14 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '08/Jun/2022' ### 6/8/2022 2:30:14 AM
6/8/2022 2:30:14 AM : UNLINKEDSALES Record Count After --->> 0 ### 6/8/2022 2:30:14 AM
6/8/2022 2:30:14 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/8/2022 2:30:14 AM
6/8/2022 2:30:14 AM :  ### 
6/8/2022 2:30:14 AM : Posting Supplierlink Query for Purchases --->>  ### 6/8/2022 2:30:14 AM
6/8/2022 2:30:20 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '08/Jun/2022' ### 6/8/2022 2:30:20 AM
6/8/2022 2:30:27 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '08/Jun/2022' ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '08/Jun/2022' ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Posting ClosingStock Successful --->>  ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
6/8/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:27 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:27 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/8/2022 2:30:27 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:28 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 2:30:28 AM : Error in file  ### TEMPLATE1 (1) at Line 124
6/8/2022 2:30:28 AM : Template Import Complete  ### 6/8/2022 2:30:28 AM
6/8/2022 2:30:31 AM : Completed Updating Has Transaction Flag  ### 6/8/2022 2:30:31 AM
6/8/2022 2:30:31 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/8/2022 2:30:31 AM
6/8/2022 2:30:31 AM : Zylem Access Unblocked  ### 6/8/2022 2:30:31 AM
6/8/2022 2:30:31 AM : Application Ended  ### 6/8/2022 2:30:31 AM

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

6/8/2022 7:30:03 AM : 11  ### 6/8/2022 7:30:03 AM

6/8/2022 7:30:03 AM : 22  ### 6/8/2022 7:30:03 AM

6/8/2022 7:30:03 AM : 33  ### 6/8/2022 7:30:03 AM

6/8/2022 7:30:03 AM : Application Started  ### 6/8/2022 7:30:03 AM

6/8/2022 7:30:03 AM : Start Process : checkAllTablesExists()  ### 
6/8/2022 7:30:03 AM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/8/2022 7:30:03 AM
6/8/2022 7:30:03 AM : MainForm_Load  ### AlertSystem ON
6/8/2022 7:30:03 AM : No. of Files to import (RECEIVEFINAL):  ### 1635
6/8/2022 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
6/8/2022 7:30:04 AM : For Distributor 000000000001316 Insert Count::4 ### Delete Count::0
6/8/2022 7:30:04 AM : Import AD File --->> AD_1316_20220608_abd54babf91cd888394a874080e0cc4d.TXT ### 6/8/2022 7:30:04 AM
6/8/2022 7:30:04 AM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::2
6/8/2022 7:30:04 AM : Import AD File --->> AD_1321_20220608_4997db40c2e64b0b6e6339da6ffd71c3.TXT ### 6/8/2022 7:30:04 AM
6/8/2022 7:30:04 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
6/8/2022 7:30:04 AM : Import AD File --->> AD_1324_20220608_e606fbf0818cb4eb3b8adc77d4251cff.TXT ### 6/8/2022 7:30:04 AM
6/8/2022 7:30:04 AM : For Distributor 000000000000369 Insert Count::1 ### Delete Count::0
6/8/2022 7:30:04 AM : Import AD File --->> AD_369_20220608_ce8b953701f85c5554b3650ecdaf76c0.TXT ### 6/8/2022 7:30:04 AM
6/8/2022 7:30:05 AM : For Distributor 000000000000374 Insert Count::1 ### Delete Count::0
6/8/2022 7:30:05 AM : Import AD File --->> AD_374_20220608_cb13033a278029486b080ed81ebcf300.TXT ### 6/8/2022 7:30:05 AM
6/8/2022 7:30:05 AM : For Distributor 000000000000424 Insert Count::1 ### Delete Count::0
6/8/2022 7:30:05 AM : Import AD File --->> AD_424_20220608_7e3d3d98e6c1e62c77ca56015099cdaf.TXT ### 6/8/2022 7:30:05 AM
6/8/2022 7:30:06 AM : For Distributor 000000000000809 Insert Count::9 ### Delete Count::0
6/8/2022 7:30:06 AM : Import AD File --->> AD_809_20220608_40af7200fd8f2a48d4a5d87c8e62a7e2.TXT ### 6/8/2022 7:30:06 AM
6/8/2022 7:30:06 AM : For Distributor 000000000000810 Insert Count::10 ### Delete Count::11
6/8/2022 7:30:06 AM : Import AD File --->> AD_810_20220608_b1090b4aa896c8f0b320cf9c82fd87bd.TXT ### 6/8/2022 7:30:06 AM
6/8/2022 7:30:18 AM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1
6/8/2022 7:30:18 AM : Import DN File --->> DN_1321_20220521_d68d2d469a3937910367d73310e93172.TXT ### 6/8/2022 7:30:18 AM
6/8/2022 7:30:43 AM : Import DN File --->> DN_495_20220607_22276c2982ad62ef8a0f840a4053e0d7.TXT ### 6/8/2022 7:30:43 AM
6/8/2022 7:30:43 AM : NO Previous File For Distributor 000000000000495 ### Insert Count::2
6/8/2022 7:30:59 AM : For Distributor 000000000001026 Insert Count::3 ### Delete Count::0
6/8/2022 7:30:59 AM : Import IN File --->> IN_1026_20220607_345d4248ebab7fbd46cef23f4fa4c6c7.TXT ### 6/8/2022 7:30:59 AM
6/8/2022 7:31:01 AM : For Distributor 000000000001316 Insert Count::5 ### Delete Count::0
6/8/2022 7:31:01 AM : Import IN File --->> IN_1316_20220607_3bc0ac0769bb7a0fb76c7896b42658ac.TXT ### 6/8/2022 7:31:01 AM
6/8/2022 7:31:02 AM : For Distributor 000000000001321 Insert Count::0 ### Delete Count::1
6/8/2022 7:31:02 AM : Import IN File --->> IN_1321_20220412_f5a88653ec6fdf738aa4fd281b5adbe4.TXT ### 6/8/2022 7:31:02 AM
6/8/2022 7:31:04 AM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::0
6/8/2022 7:31:04 AM : Import IN File --->> IN_1321_20220512_5edd21831edd32f7b836e3cb559559eb.TXT ### 6/8/2022 7:31:04 AM
6/8/2022 7:31:06 AM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::0
6/8/2022 7:31:06 AM : Import IN File --->> IN_1321_20220602_5cb36a590f2323f7b639afaad907672c.TXT ### 6/8/2022 7:31:06 AM
6/8/2022 7:31:06 AM : Import IN File --->> IN_1321_20220604_b3539af9ec606f2cc851bfd8c088097e.TXT ### 6/8/2022 7:31:06 AM
6/8/2022 7:31:06 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::3
6/8/2022 7:31:06 AM : Import IN File --->> IN_1321_20220606_31cf77e6a913501f35c8f3110b93c253.TXT ### 6/8/2022 7:31:06 AM
6/8/2022 7:31:06 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::2
6/8/2022 7:31:06 AM : Import IN File --->> IN_1321_20220607_f5f1bf67fda147cd1b6294d395aaeda5.TXT ### 6/8/2022 7:31:06 AM
6/8/2022 7:31:07 AM : NO Previous File For Distributor 000000000001321 ### Insert Count::1
6/8/2022 7:31:07 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::1
6/8/2022 7:31:07 AM : Import IN File --->> IN_1324_20220504_c7db2d5f32722ea1cfea02d174449b93.TXT ### 6/8/2022 7:31:07 AM
6/8/2022 7:31:08 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
6/8/2022 7:31:08 AM : Import IN File --->> IN_1324_20220527_82d2a7768c16063b9cc37df2595df344.TXT ### 6/8/2022 7:31:08 AM
6/8/2022 7:31:09 AM : For Distributor 000000000001324 Insert Count::0 ### Delete Count::1
6/8/2022 7:31:09 AM : Import IN File --->> IN_1324_20220531_5b68eff5a2f5f25b3e53d881e847e389.TXT ### 6/8/2022 7:31:09 AM
6/8/2022 7:31:09 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
6/8/2022 7:31:09 AM : Import IN File --->> IN_1324_20220601_ef52fc1f4c76af2b7af27ae853b84c22.TXT ### 6/8/2022 7:31:09 AM
6/8/2022 7:31:09 AM : For Distributor 000000000001324 Insert Count::2 ### Delete Count::0
6/8/2022 7:31:09 AM : Import IN File --->> IN_1324_20220604_ba33ded1f02ecad9f5c868064e054302.TXT ### 6/8/2022 7:31:09 AM
6/8/2022 7:31:09 AM : For Distributor 000000000001324 Insert Count::1 ### Delete Count::0
6/8/2022 7:31:09 AM : Import IN File --->> IN_1324_20220606_a4f8fe9876d128fb4643f25d0fb4d6f3.TXT ### 6/8/2022 7:31:09 AM
6/8/2022 7:31:10 AM : For Distributor 000000000001324 Insert Count::3 ### Delete Count::0
6/8/2022 7:31:10 AM : Import IN File --->> IN_1324_20220607_53c32e36d7a577f4fec1a81746e74cd5.TXT ### 6/8/2022 7:31:10 AM
6/8/2022 7:31:12 AM : For Distributor 000000000000353 Insert Count::2 ### Delete Count::2
6/8/2022 7:31:12 AM : Import IN File --->> IN_353_20220601_2a07521094f51f042ff021d0301ffa32.TXT ### 6/8/2022 7:31:12 AM
6/8/2022 7:31:17 AM : For Distributor 000000000000366 Insert Count::2 ### Delete Count::0
6/8/2022 7:31:17 AM : Import IN File --->> IN_366_20220606_303899bee58bfce0736845f1c6c7fc45.TXT ### 6/8/2022 7:31:17 AM
6/8/2022 7:31:17 AM : For Distributor 000000000000366 Insert Count::3 ### Delete Count::0
6/8/2022 7:31:17 AM : Import IN File --->> IN_366_20220607_233129868b7d44f86e4e11971df0e220.TXT ### 6/8/2022 7:31:17 AM
6/8/2022 7:31:19 AM : For Distributor 000000000000369 Insert Count::3 ### Delete Count::0
6/8/2022 7:31:19 AM : Import IN File --->> IN_369_20220606_cd0a9483bf1b49d78f246f8e3ee49858.TXT ### 6/8/2022 7:31:19 AM
6/8/2022 7:31:19 AM : For Distributor 000000000000369 Insert Count::7 ### Delete Count::0
6/8/2022 7:31:19 AM : Import IN File --->> IN_369_20220607_75178f40aec081a4e006a27f5631b797.TXT ### 6/8/2022 7:31:19 AM
6/8/2022 7:31:24 AM : For Distributor 000000000000374 Insert Count::1 ### Delete Count::0
6/8/2022 7:31:24 AM : Import IN File --->> IN_374_20220606_d0c7b2bfad70bd16e00c4325c2d426f7.TXT ### 6/8/2022 7:31:24 AM
6/8/2022 7:31:24 AM : Import IN File --->> IN_374_20220607_857036be256a7eba78c0ece19cee699b.TXT ### 6/8/2022 7:31:24 AM
6/8/2022 7:31:24 AM : NO Previous File For Distributor 000000000000374 ### Insert Count::1
6/8/2022 7:31:28 AM : For Distributor 000000000000424 Insert Count::3 ### Delete Count::0
6/8/2022 7:31:28 AM : Import IN File --->> IN_424_20220607_98b503e43bb2be46e5e4c97a3ed77de6.TXT ### 6/8/2022 7:31:28 AM
6/8/2022 7:31:32 AM : For Distributor 000000000000495 Insert Count::6 ### Delete Count::0
6/8/2022 7:31:32 AM : Import IN File --->> IN_495_20220606_8aff83fc2a9876d2f2bff75cb28358c6.TXT ### 6/8/2022 7:31:32 AM
6/8/2022 7:31:32 AM : Import IN File --->> IN_495_20220607_003074a7bf28483ac2753a957eead38e.TXT ### 6/8/2022 7:31:32 AM
6/8/2022 7:31:32 AM : NO Previous File For Distributor 000000000000495 ### Insert Count::8
6/8/2022 7:31:32 AM : Import IN File --->> IN_495_20220608_8156c65e9b7d4fe2cb2958813f2131d1.TXT ### 6/8/2022 7:31:32 AM
6/8/2022 7:31:32 AM : NO Previous File For Distributor 000000000000495 ### Insert Count::2
6/8/2022 7:31:35 AM : For Distributor 000000000000809 Insert Count::19 ### Delete Count::0
6/8/2022 7:31:35 AM : Import IN File --->> IN_809_20220606_05487e710635fc2b006598bd96ccc657.TXT ### 6/8/2022 7:31:35 AM
6/8/2022 7:31:35 AM : For Distributor 000000000000809 Insert Count::11 ### Delete Count::0
6/8/2022 7:31:35 AM : Import IN File --->> IN_809_20220607_9397d0545f617015cd9c4ef39f163f90.TXT ### 6/8/2022 7:31:35 AM
6/8/2022 7:31:35 AM : Import IN File --->> IN_809_20220608_b0121b42889826869eb1206e95088e3d.TXT ### 6/8/2022 7:31:35 AM
6/8/2022 7:31:35 AM : NO Previous File For Distributor 000000000000809 ### Insert Count::3
6/8/2022 7:31:35 AM : For Distributor 000000000000810 Insert Count::25 ### Delete Count::0
6/8/2022 7:31:35 AM : Import IN File --->> IN_810_20220607_fa69ceaa9f04babdbbc16c0b09b97742.TXT ### 6/8/2022 7:31:35 AM
6/8/2022 7:31:42 AM : For Distributor 000000000000820 Insert Count::0 ### Delete Count::1
6/8/2022 7:31:42 AM : Import IN File --->> IN_820_20220607_8af8f5bee5f9626730ddee8aeafca783.TXT ### 6/8/2022 7:31:42 AM
6/8/2022 7:31:42 AM : Import IN File --->> IN_820_20220608_a0c9e865c7d9d5b80fc93e73e566a712.TXT ### 6/8/2022 7:31:42 AM
6/8/2022 7:31:42 AM : NO Previous File For Distributor 000000000000820 ### Insert Count::3
6/8/2022 7:31:51 AM : PostData() --->>  ### 6/8/2022 7:31:51 AM
6/8/2022 7:31:54 AM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 6/8/2022 7:31:54 AM
6/8/2022 7:31:58 AM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '08/Jun/2022' ### 6/8/2022 7:31:58 AM
6/8/2022 7:31:58 AM : ItemLink Successful --->> exec SP_ItemLinkDiff '08/Jun/2022' ### 6/8/2022 7:31:58 AM
6/8/2022 7:31:58 AM :  ### 
6/8/2022 7:31:58 AM : UNLINKEDSALES Record Count Before --->> 125 ### 6/8/2022 7:31:58 AM
6/8/2022 7:31:58 AM : UNLINKEDSALES_DEL Record Count Before --->> 6 ### 6/8/2022 7:31:58 AM
6/8/2022 7:48:30 AM : Posting Sales Successful --->> exec prPostLinkedDiffSales '08/Jun/2022' ### 6/8/2022 7:48:30 AM
6/8/2022 7:48:30 AM : UNLINKEDSALES Record Count After --->> 0 ### 6/8/2022 7:48:30 AM
6/8/2022 7:48:30 AM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/8/2022 7:48:30 AM
6/8/2022 7:48:30 AM :  ### 
6/8/2022 7:48:30 AM : Posting Supplierlink Query for Purchases --->>  ### 6/8/2022 7:48:30 AM
6/8/2022 7:48:37 AM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '08/Jun/2022' ### 6/8/2022 7:48:37 AM
6/8/2022 7:48:43 AM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '08/Jun/2022' ### 6/8/2022 7:48:43 AM
6/8/2022 7:48:43 AM : Posting Supplierlink Query for CompanyPurchases --->>  ### 6/8/2022 7:48:43 AM
6/8/2022 7:48:43 AM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '08/Jun/2022' ### 6/8/2022 7:48:43 AM
6/8/2022 7:48:43 AM : Posting ClosingStock Successful --->>  ### 6/8/2022 7:48:43 AM
6/8/2022 7:48:43 AM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 6/8/2022 7:48:43 AM
6/8/2022 7:48:43 AM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
6/8/2022 7:48:43 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1123438_TEMPLATE1.TXT ### 6/8/2022 7:48:43 AM
6/8/2022 7:48:43 AM : Count:: ### TEMPLATE1:68
6/8/2022 7:48:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1990080_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Count:: ### TEMPLATE1:15
6/8/2022 7:48:48 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:48:48 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 6/8/2022 7:48:48 AM
6/8/2022 7:48:48 AM : Count:: ### TEMPLATE1:63
6/8/2022 7:48:52 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:48:52 AM
6/8/2022 7:48:52 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3224985_TEMPLATE1.TXT ### 6/8/2022 7:48:52 AM
6/8/2022 7:48:52 AM : Count:: ### TEMPLATE1:152
6/8/2022 7:49:12 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:12 AM
6/8/2022 7:49:12 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3513087_TEMPLATE1.TXT ### 6/8/2022 7:49:12 AM
6/8/2022 7:49:12 AM : Count:: ### TEMPLATE1:49
6/8/2022 7:49:18 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:18 AM
6/8/2022 7:49:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/8/2022 7:49:18 AM
6/8/2022 7:49:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/8/2022 7:49:18 AM
6/8/2022 7:49:18 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:18 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 6/8/2022 7:49:18 AM
6/8/2022 7:49:18 AM : Count:: ### TEMPLATE1:34
6/8/2022 7:49:19 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3814332_TEMPLATE1.TXT ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Count:: ### TEMPLATE1:25
6/8/2022 7:49:19 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:19 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:19 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/8/2022 7:49:19 AM
6/8/2022 7:49:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/8/2022 7:49:20 AM
6/8/2022 7:49:20 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 6/8/2022 7:49:20 AM
6/8/2022 7:49:20 AM : Count:: ### TEMPLATE1:10
6/8/2022 7:49:20 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:20 AM
6/8/2022 7:49:20 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060893_TEMPLATE1.txt ### 6/8/2022 7:49:20 AM
6/8/2022 7:49:20 AM : Count:: ### TEMPLATE1:106
6/8/2022 7:49:35 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:35 AM
6/8/2022 7:49:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/8/2022 7:49:35 AM
6/8/2022 7:49:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/8/2022 7:49:35 AM
6/8/2022 7:49:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/8/2022 7:49:35 AM
6/8/2022 7:49:35 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:35 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062891_TEMPLATE1.TXT ### 6/8/2022 7:49:35 AM
6/8/2022 7:49:35 AM : Count:: ### TEMPLATE1:29
6/8/2022 7:49:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:37 AM
6/8/2022 7:49:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/8/2022 7:49:37 AM
6/8/2022 7:49:37 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/8/2022 7:49:37 AM
6/8/2022 7:49:37 AM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 7:49:37 AM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9064126_TEMPLATE1.TXT ### 6/8/2022 7:49:37 AM
6/8/2022 7:49:37 AM : Count:: ### TEMPLATE1:1
6/8/2022 7:49:37 AM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 7:49:37 AM
6/8/2022 7:49:37 AM : Error in file  ### TEMPLATE1 (1) at Line 1
6/8/2022 7:49:37 AM : Template Import Complete  ### 6/8/2022 7:49:37 AM
6/8/2022 7:49:40 AM : Completed Updating Has Transaction Flag  ### 6/8/2022 7:49:40 AM
6/8/2022 7:49:40 AM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/8/2022 7:49:40 AM
6/8/2022 7:49:40 AM : Zylem Access Unblocked  ### 6/8/2022 7:49:40 AM
6/8/2022 7:49:40 AM : Application Ended  ### 6/8/2022 7:49:40 AM

6/8/2022 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
6/8/2022 2:30:03 PM : StartProcess  ### 6/8/2022 2:30:03 PM

6/8/2022 2:30:03 PM : 11  ### 6/8/2022 2:30:03 PM

6/8/2022 2:30:03 PM : 22  ### 6/8/2022 2:30:03 PM

6/8/2022 2:30:03 PM : 33  ### 6/8/2022 2:30:03 PM

6/8/2022 2:30:03 PM : Application Started  ### 6/8/2022 2:30:03 PM

6/8/2022 2:30:04 PM : Start Process : checkAllTablesExists()  ### 
6/8/2022 2:30:04 PM : ---Zylem 1.1.0 Diff Without OLEDB, OLD With/Without OLEDB as per ImportWithBulkInsert --- ### 6/8/2022 2:30:04 PM
6/8/2022 2:30:04 PM : MainForm_Load  ### AlertSystem ON
6/8/2022 2:30:04 PM : No. of Files to import (RECEIVEFINAL):  ### 1550
6/8/2022 2:30:04 PM : ImportINFile  ### Server=s3-prod.crqnyajpdabh.ap-south-1.rds.amazonaws.com;Database=ZylemMIS_BAYER;uid=admin;pwd=4R7TRSjgeOk77FFWeSr8;Connect Timeout=500
6/8/2022 2:30:04 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
6/8/2022 2:30:04 PM : Import AD File --->> AD_1025_20220608_52dce36d72ae35ae7d5ff612be9f5a9b.TXT ### 6/8/2022 2:30:04 PM
6/8/2022 2:30:05 PM : For Distributor 000000000001316 Insert Count::1 ### Delete Count::0
6/8/2022 2:30:05 PM : Import AD File --->> AD_1316_20220608_e0080ce9797800c01f07c2644be70754.TXT ### 6/8/2022 2:30:05 PM
6/8/2022 2:30:06 PM : For Distributor 000000000001321 Insert Count::3 ### Delete Count::3
6/8/2022 2:30:06 PM : Import AD File --->> AD_1321_20220608_ebadb3f75107881ff7e4dc1079d2c11a.TXT ### 6/8/2022 2:30:06 PM
6/8/2022 2:30:06 PM : For Distributor 000000000000354 Insert Count::2 ### Delete Count::7
6/8/2022 2:30:06 PM : Import AD File --->> AD_354_20220608_387f7a7a79be057462c1b9b1e805d3d5.TXT ### 6/8/2022 2:30:06 PM
6/8/2022 2:30:06 PM : For Distributor 000000000000373 Insert Count::2 ### Delete Count::0
6/8/2022 2:30:06 PM : Import AD File --->> AD_373_20220608_f30546e5db249c38ddf7b574bb933659.TXT ### 6/8/2022 2:30:06 PM
6/8/2022 2:30:06 PM : For Distributor 000000000000665 Insert Count::3 ### Delete Count::0
6/8/2022 2:30:06 PM : Import AD File --->> AD_665_20220608_d6efa66bcfd40db8e26e267160254138.TXT ### 6/8/2022 2:30:06 PM
6/8/2022 2:30:07 PM : For Distributor 000000000000820 Insert Count::2 ### Delete Count::0
6/8/2022 2:30:07 PM : Import AD File --->> AD_820_20220608_2cf08ba75a6e596278bf848331f185d5.TXT ### 6/8/2022 2:30:07 PM
6/8/2022 2:30:13 PM : For Distributor 000000000001026 Insert Count::3 ### Delete Count::0
6/8/2022 2:30:13 PM : Import DN File --->> DN_1026_20220608_1ac0ddfb04d7394e494803007fe6ef10.TXT ### 6/8/2022 2:30:13 PM
6/8/2022 2:30:17 PM : For Distributor 000000000001321 Insert Count::2 ### Delete Count::0
6/8/2022 2:30:17 PM : Import DN File --->> DN_1321_20220608_3d536ead92d8c673cb66295b490c38b4.TXT ### 6/8/2022 2:30:17 PM
6/8/2022 2:30:19 PM : For Distributor 000000000000354 Insert Count::1 ### Delete Count::0
6/8/2022 2:30:19 PM : Import DN File --->> DN_354_20220519_3b549c950370189f8bbbc92551f7ddff.TXT ### 6/8/2022 2:30:19 PM
6/8/2022 2:30:43 PM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::0
6/8/2022 2:30:43 PM : Import DN File --->> DN_665_20220502_4cbbe4105d4fe5ff5d18da4ee56e3c19.TXT ### 6/8/2022 2:30:43 PM
6/8/2022 2:30:44 PM : For Distributor 000000000000665 Insert Count::1 ### Delete Count::1
6/8/2022 2:30:44 PM : Import DN File --->> DN_665_20220506_4c3bd9f57ddb40d4caa4d8fdccfa89fd.TXT ### 6/8/2022 2:30:44 PM
6/8/2022 2:30:44 PM : For Distributor 000000000000665 Insert Count::3 ### Delete Count::1
6/8/2022 2:30:44 PM : Import DN File --->> DN_665_20220510_2587c736daea68b7cc5f44d322c51b06.TXT ### 6/8/2022 2:30:44 PM
6/8/2022 2:30:44 PM : For Distributor 000000000000665 Insert Count::0 ### Delete Count::22
6/8/2022 2:30:44 PM : Import DN File --->> DN_665_20220512_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/8/2022 2:30:44 PM
6/8/2022 2:30:45 PM : For Distributor 000000000000665 Insert Count::24 ### Delete Count::0
6/8/2022 2:30:45 PM : Import DN File --->> DN_665_20220513_cfe6496af95a442d7125124af36dbd78.TXT ### 6/8/2022 2:30:45 PM
6/8/2022 2:30:45 PM : For Distributor 000000000000665 Insert Count::2 ### Delete Count::0
6/8/2022 2:30:45 PM : Import DN File --->> DN_665_20220517_5ccae7cc74082677ef4ce9c234bb8a66.TXT ### 6/8/2022 2:30:45 PM
6/8/2022 2:30:45 PM : For Distributor 000000000000665 Insert Count::3 ### Delete Count::0
6/8/2022 2:30:45 PM : Import DN File --->> DN_665_20220521_2f1683f37d2f98ffd8fefb43150485ce.TXT ### 6/8/2022 2:30:45 PM
6/8/2022 2:30:49 PM : For Distributor 000000000001025 Insert Count::1 ### Delete Count::0
6/8/2022 2:30:49 PM : Import IN File --->> IN_1025_20220606_370de10d87a08eea3027a50629cfff88.TXT ### 6/8/2022 2:30:49 PM
6/8/2022 2:30:49 PM : Import IN File --->> IN_1025_20220607_ef5335fdd75e034584f679de8f3f2ef5.TXT ### 6/8/2022 2:30:49 PM
6/8/2022 2:30:49 PM : NO Previous File For Distributor 000000000001025 ### Insert Count::1
6/8/2022 2:30:53 PM : For Distributor 000000000001026 Insert Count::1 ### Delete Count::0
6/8/2022 2:30:53 PM : Import IN File --->> IN_1026_20220608_76a4165833c47f6903cf4fc63a146e25.TXT ### 6/8/2022 2:30:53 PM
6/8/2022 2:30:55 PM : For Distributor 000000000001316 Insert Count::2 ### Delete Count::0
6/8/2022 2:30:55 PM : Import IN File --->> IN_1316_20220608_651fe7f00cdbfc11ab9f54320a3fc7b3.TXT ### 6/8/2022 2:30:55 PM
6/8/2022 2:31:02 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1
6/8/2022 2:31:02 PM : Import IN File --->> IN_1321_20220506_1b4bdf5e1bf648c575b5c9fe438c0d97.TXT ### 6/8/2022 2:31:02 PM
6/8/2022 2:31:03 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1
6/8/2022 2:31:03 PM : Import IN File --->> IN_1321_20220523_07d65cf612d3dd6de79f40f1ff35ab0b.TXT ### 6/8/2022 2:31:03 PM
6/8/2022 2:31:03 PM : For Distributor 000000000001321 Insert Count::1 ### Delete Count::1
6/8/2022 2:31:03 PM : Import IN File --->> IN_1321_20220527_f58f2c7ca6c89cbf052745733e7d0179.TXT ### 6/8/2022 2:31:03 PM
6/8/2022 2:31:06 PM : Import IN File --->> IN_354_20220601_0b80d8797ebb83f3d5537daddd786fa5.TXT ### 6/8/2022 2:31:06 PM
6/8/2022 2:31:06 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
6/8/2022 2:31:06 PM : Import IN File --->> IN_354_20220602_06eb64dd6f0abee291051ad7a3fc4846.TXT ### 6/8/2022 2:31:06 PM
6/8/2022 2:31:06 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
6/8/2022 2:31:06 PM : Import IN File --->> IN_354_20220603_17fb5527c15897b6329452d420b10a8b.TXT ### 6/8/2022 2:31:06 PM
6/8/2022 2:31:06 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
6/8/2022 2:31:06 PM : Import IN File --->> IN_354_20220604_cd51ce5636123d82c93c92afb2a20e05.TXT ### 6/8/2022 2:31:06 PM
6/8/2022 2:31:06 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::3
6/8/2022 2:31:07 PM : Import IN File --->> IN_354_20220606_ea0d71c2447ad0e3db7da733bc86be26.TXT ### 6/8/2022 2:31:07 PM
6/8/2022 2:31:07 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::1
6/8/2022 2:31:07 PM : Import IN File --->> IN_354_20220607_36041e42fc5bb2cc7a1d2c34bd77685a.TXT ### 6/8/2022 2:31:07 PM
6/8/2022 2:31:07 PM : NO Previous File For Distributor 000000000000354 ### Insert Count::2
6/8/2022 2:31:19 PM : For Distributor 000000000000360 Insert Count::4 ### Delete Count::0
6/8/2022 2:31:19 PM : Import IN File --->> IN_360_20220607_22a69ba416579571191aece97aeb8a11.TXT ### 6/8/2022 2:31:19 PM
6/8/2022 2:31:19 PM : Import IN File --->> IN_360_20220608_84d52e80766c6aeb5beaf0e9a6183d84.TXT ### 6/8/2022 2:31:19 PM
6/8/2022 2:31:19 PM : NO Previous File For Distributor 000000000000360 ### Insert Count::2
6/8/2022 2:31:23 PM : For Distributor 000000000000361 Insert Count::2 ### Delete Count::0
6/8/2022 2:31:23 PM : Import IN File --->> IN_361_20220607_f0085db62bc0b6fe62db36aa50f686ac.TXT ### 6/8/2022 2:31:23 PM
6/8/2022 2:31:26 PM : For Distributor 000000000000371 Insert Count::20 ### Delete Count::1
6/8/2022 2:31:26 PM : Import IN File --->> IN_371_20220607_a69f806bd47e065e64592759b3529e60.TXT ### 6/8/2022 2:31:26 PM
6/8/2022 2:31:26 PM : Import IN File --->> IN_371_20220608_913d5fbe7728917f6812d6a6164b9afd.TXT ### 6/8/2022 2:31:26 PM
6/8/2022 2:31:26 PM : NO Previous File For Distributor 000000000000371 ### Insert Count::17
6/8/2022 2:31:30 PM : For Distributor 000000000000373 Insert Count::1 ### Delete Count::0
6/8/2022 2:31:30 PM : Import IN File --->> IN_373_20220607_d3c569db2f541aa20cb5d635a9ebbfa7.TXT ### 6/8/2022 2:31:30 PM
6/8/2022 2:31:30 PM : Import IN File --->> IN_373_20220608_fbc3cded30d844cae5cbf896b997ff1a.TXT ### 6/8/2022 2:31:30 PM
6/8/2022 2:31:30 PM : NO Previous File For Distributor 000000000000373 ### Insert Count::1
6/8/2022 2:31:32 PM : For Distributor 000000000000665 Insert Count::22 ### Delete Count::3
6/8/2022 2:31:32 PM : Import IN File --->> IN_665_20220607_b759d6b6b831291177b803780b084307.TXT ### 6/8/2022 2:31:32 PM
6/8/2022 2:31:32 PM : Import IN File --->> IN_665_20220608_61f39fa3f2ded07a55bb99a5fe5dc30a.TXT ### 6/8/2022 2:31:32 PM
6/8/2022 2:31:33 PM : NO Previous File For Distributor 000000000000665 ### Insert Count::3
6/8/2022 2:31:35 PM : For Distributor 000000000000809 Insert Count::0 ### Delete Count::19
6/8/2022 2:31:35 PM : Import IN File --->> IN_809_20220606_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/8/2022 2:31:35 PM
6/8/2022 2:31:35 PM : For Distributor 000000000000809 Insert Count::0 ### Delete Count::11
6/8/2022 2:31:35 PM : Import IN File --->> IN_809_20220607_d41d8cd98f00b204e9800998ecf8427e.TXT ### 6/8/2022 2:31:35 PM
6/8/2022 2:31:35 PM : For Distributor 000000000000809 Insert Count::1 ### Delete Count::3
6/8/2022 2:31:35 PM : Import IN File --->> IN_809_20220608_f698d273e691d19d947342d989886ed1.TXT ### 6/8/2022 2:31:35 PM
6/8/2022 2:31:37 PM : For Distributor 000000000000820 Insert Count::4 ### Delete Count::0
6/8/2022 2:31:37 PM : Import IN File --->> IN_820_20220608_80d362a94f970776c036c6d9d2292058.TXT ### 6/8/2022 2:31:37 PM
6/8/2022 2:31:42 PM : For Distributor 000000000000820 Insert Count::6 ### Delete Count::0
6/8/2022 2:31:42 PM : Import OT File --->> OT_820_20220608_fdb6a72535488f5525f4671fa69225f5.TXT ### 6/8/2022 2:31:42 PM
6/8/2022 2:31:42 PM : For Distributor 000000000000354 Insert Count::0 ### Delete Count::1
6/8/2022 2:31:42 PM : Import PR File --->> PR_354_20220608_0435276558d877c72d8f5737ec6e7712.TXT ### 6/8/2022 2:31:42 PM
6/8/2022 2:31:42 PM : PostData() --->>  ### 6/8/2022 2:31:42 PM
6/8/2022 2:31:45 PM : SP_CreateUnkCustomerUnkItem Successful --->>  ### 6/8/2022 2:31:45 PM
6/8/2022 2:31:48 PM : CustomerLink Successful --->> exec SP_CustomerLinkDiff '08/Jun/2022' ### 6/8/2022 2:31:48 PM
6/8/2022 2:31:48 PM : ItemLink Successful --->> exec SP_ItemLinkDiff '08/Jun/2022' ### 6/8/2022 2:31:48 PM
6/8/2022 2:31:48 PM :  ### 
6/8/2022 2:31:48 PM : UNLINKEDSALES Record Count Before --->> 96 ### 6/8/2022 2:31:48 PM
6/8/2022 2:31:48 PM : UNLINKEDSALES_DEL Record Count Before --->> 40 ### 6/8/2022 2:31:48 PM
6/8/2022 3:01:02 PM : Posting Sales Successful --->> exec prPostLinkedDiffSales '08/Jun/2022' ### 6/8/2022 3:01:02 PM
6/8/2022 3:01:02 PM : UNLINKEDSALES Record Count After --->> 0 ### 6/8/2022 3:01:02 PM
6/8/2022 3:01:02 PM : UNLINKEDSALES_DEL Record Count After --->> 0 ### 6/8/2022 3:01:02 PM
6/8/2022 3:01:02 PM :  ### 
6/8/2022 3:01:02 PM : Posting Supplierlink Query for Purchases --->>  ### 6/8/2022 3:01:02 PM
6/8/2022 3:01:10 PM : Posting Purchases Successful --->> exec prPostLinkedDiffPurchases '08/Jun/2022' ### 6/8/2022 3:01:10 PM
6/8/2022 3:01:16 PM : Posting OtherTransaction Successful --->> exec prPostLinkedDiffOtherTransaction '08/Jun/2022' ### 6/8/2022 3:01:16 PM
6/8/2022 3:01:16 PM : Posting Supplierlink Query for CompanyPurchases --->>  ### 6/8/2022 3:01:16 PM
6/8/2022 3:01:16 PM : Posting CompanyPurchases Successful --->> exec prPostLinkedCompanyPurchases '08/Jun/2022' ### 6/8/2022 3:01:16 PM
6/8/2022 3:01:17 PM : Posting ClosingStock Successful --->>  ### 6/8/2022 3:01:17 PM
6/8/2022 3:01:17 PM : FileWiseHashCode Updated for FlagImport=true records  --->>  ### 6/8/2022 3:01:17 PM
6/8/2022 3:01:17 PM : Start BulkImport False for 0 ### D:\BAYER\Zylem\ZylemImportFolders\Inspected\\
6/8/2022 3:01:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1025789_TEMPLATE1.TXT ### 6/8/2022 3:01:17 PM
6/8/2022 3:01:17 PM : Count:: ### TEMPLATE1:152
6/8/2022 3:01:36 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:36 PM
6/8/2022 3:01:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1965535_TEMPLATE1.TXT ### 6/8/2022 3:01:36 PM
6/8/2022 3:01:36 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:36 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_1986218_TEMPLATE1.TXT ### 6/8/2022 3:01:36 PM
6/8/2022 3:01:37 PM : Count:: ### TEMPLATE1:238
6/8/2022 3:01:52 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2064469_TEMPLATE1.TXT ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2221168_TEMPLATE1.TXT ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2743253_TEMPLATE1.TXT ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Count:: ### TEMPLATE1:19
6/8/2022 3:01:52 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2779314_TEMPLATE1.TXT ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2796437_TEMPLATE1.TXT ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:52 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_2848065_TEMPLATE1.TXT ### 6/8/2022 3:01:52 PM
6/8/2022 3:01:52 PM : Count:: ### TEMPLATE1:65
6/8/2022 3:01:56 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:56 PM
6/8/2022 3:01:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3559252_TEMPLATE1.TXT ### 6/8/2022 3:01:56 PM
6/8/2022 3:01:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3604959_TEMPLATE1.TXT ### 6/8/2022 3:01:56 PM
6/8/2022 3:01:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3612379_TEMPLATE1.TXT ### 6/8/2022 3:01:56 PM
6/8/2022 3:01:56 PM : Count:: ### TEMPLATE1:34
6/8/2022 3:01:56 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:56 PM
6/8/2022 3:01:56 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3622844_TEMPLATE1.TXT ### 6/8/2022 3:01:56 PM
6/8/2022 3:01:56 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3828156_TEMPLATE1.txt ### 6/8/2022 3:01:57 PM
6/8/2022 3:01:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3831146_TEMPLATE1.TXT ### 6/8/2022 3:01:57 PM
6/8/2022 3:01:57 PM : Count:: ### TEMPLATE1:20
6/8/2022 3:01:57 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:57 PM
6/8/2022 3:01:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3835404_TEMPLATE1.txt ### 6/8/2022 3:01:57 PM
6/8/2022 3:01:57 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:57 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_3985879_TEMPLATE1.txt ### 6/8/2022 3:01:57 PM
6/8/2022 3:01:57 PM : Count:: ### TEMPLATE1:15
6/8/2022 3:01:58 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4065332_TEMPLATE1.txt ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4220446_TEMPLATE1.TXT ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_4642374_TEMPLATE1.TXT ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:01:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_722734_TEMPLATE1.TXT ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Count:: ### TEMPLATE1:10
6/8/2022 3:01:58 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060542_TEMPLATE1.TXT ### 6/8/2022 3:01:58 PM
6/8/2022 3:01:58 PM : Count:: ### TEMPLATE1:47
6/8/2022 3:02:05 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:02:05 PM
6/8/2022 3:02:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9060996_TEMPLATE1.TXT ### 6/8/2022 3:02:05 PM
6/8/2022 3:02:05 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:02:05 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061358_TEMPLATE1.TXT ### 6/8/2022 3:02:05 PM
6/8/2022 3:02:05 PM : Count:: ### TEMPLATE1:86
6/8/2022 3:02:17 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:02:17 PM
6/8/2022 3:02:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061526_TEMPLATE1.TXT ### 6/8/2022 3:02:17 PM
6/8/2022 3:02:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:02:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9061548_TEMPLATE1.TXT ### 6/8/2022 3:02:17 PM
6/8/2022 3:02:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:02:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9062964_TEMPLATE1.TXT ### 6/8/2022 3:02:17 PM
6/8/2022 3:02:17 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:02:17 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063177_TEMPLATE1.TXT ### 6/8/2022 3:02:17 PM
6/8/2022 3:02:17 PM : Count:: ### TEMPLATE1:80
6/8/2022 3:02:27 PM : SP_DistributorTemplatePosting Successful --->>  ### 6/8/2022 3:02:27 PM
6/8/2022 3:02:27 PM : Import TEMPLATE1_BULKINSERT File --->> BAYER_9063548_TEMPLATE1.txt ### 6/8/2022 3:02:27 PM
6/8/2022 3:02:27 PM : Error While BulkInsert For TEMPLATE1 File ### Received an invalid column length from the bcp client for colid 4.
6/8/2022 3:02:27 PM : Error in file  ### TEMPLATE1 (1) at Line 124
6/8/2022 3:02:27 PM : Template Import Complete  ### 6/8/2022 3:02:27 PM
6/8/2022 3:02:30 PM : Completed Updating Has Transaction Flag  ### 6/8/2022 3:02:30 PM
6/8/2022 3:02:30 PM : Transaction Table lastEdiDate Update on BrandAlias Update ### 6/8/2022 3:02:30 PM
6/8/2022 3:02:30 PM : Zylem Access Unblocked  ### 6/8/2022 3:02:30 PM
6/8/2022 3:02:30 PM : Application Ended  ### 6/8/2022 3:02:30 PM