Config Settings retrieved Retrieving Email Settings master.bituatl@skyfile.com Reading Outlook Inbox Email Reading Started Email from master.bituatl@skyfile.com Count of Email : 6 collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp collectionItem newEmail Email found Email Moved in Jot_Temp Email Reading Started Email from master.bituatl@skyfile.com Count of Email : 4 collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Email Reading Started Email from master.bituatl@skyfile.com Count of Email : 3 collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Imported Started files found MARI-ATLC-O20215803.RAR System.String[] C:\JotApps\Sync\Imports\MARI-ATLC-O20215804.RAR BatchScript C:\JotApps\Sync\Imports\MARI-ATLC-O20215805.RAR BatchScript C:\JotApps\Sync\Imports\MARI-ATLC-O20215806.RAR BatchScript files found MARI-ATLC-O20215804.RAR Imported Started for MARI-ATLC-O20215804.RAR Reading Packet Data Reading file content SQL_UPDATE found in packet UPDATE JOT_Sync_Packet_Status SET EXECUTE_STATUS=1, EXECUTE_DATE='2021-10-01 11:42:32 PM' where PACKET_NAME='ATLC-MARI-V202112629.RAR' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_295_6902398C-CC10-421C-870B-F3C7FC9969F6' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_295_6902398C-CC10-421C-870B-F3C7FC9969F6',[VESSEL_ID]=295,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_295_41E1417F-5E1E-43DC-8BE3-457BD23DE37B.pdf',[Content_Type]='application/pdf',[File_Size]='549791',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-01 16:01 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_295_6902398C-CC10-421C-870B-F3C7FC9969F6' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_295_70977AD8-3ECB-4EB9-B6FC-7FCC457E91B2' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_295_70977AD8-3ECB-4EB9-B6FC-7FCC457E91B2',[VESSEL_ID]=295,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_295_AA9D57D6-145D-4CC3-AA01-B0C000B281EB.xlsx',[Content_Type]='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',[File_Size]='27672',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-01 16:01 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_295_70977AD8-3ECB-4EB9-B6FC-7FCC457E91B2' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_295_8EFE2864-CD84-4EC1-9AD8-9D3C7CAEE89B' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_295_8EFE2864-CD84-4EC1-9AD8-9D3C7CAEE89B',[VESSEL_ID]=295,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_295_66D84780-7E62-4787-988D-834A45D312BC.xlsx',[Content_Type]='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',[File_Size]='13523',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-01 16:01 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_295_8EFE2864-CD84-4EC1-9AD8-9D3C7CAEE89B' Reading file content SQL_UPDATE found in packet UPDATE JOT_Sync_Packet_Status SET EXECUTE_STATUS=1, EXECUTE_DATE='2021-10-02 12:33:28 AM' where PACKET_NAME='ATLC-MARI-V202112630.RAR' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_295_4906CB96-C973-4382-B44F-0780E238C5E9' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_295_4906CB96-C973-4382-B44F-0780E238C5E9',[VESSEL_ID]=295,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='PMS_1_295_A6F63E0F-4C1A-4E03-8D50-7FC1C456F25C.docx',[Content_Type]='application/vnd.openxmlformats-officedocument.wordprocessingml.document',[File_Size]='42664',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-01 17:17 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_295_4906CB96-C973-4382-B44F-0780E238C5E9' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_295_AFE9E922-3569-403B-8285-7EB838FE7368' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_295_AFE9E922-3569-403B-8285-7EB838FE7368',[VESSEL_ID]=295,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='PMS_1_295_EBB1CAD2-1E62-4F1F-AA94-AF928EED919B.docx',[Content_Type]='application/vnd.openxmlformats-officedocument.wordprocessingml.document',[File_Size]='44238',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-01 17:17 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_295_AFE9E922-3569-403B-8285-7EB838FE7368' Reading file content TBL_DTL_DATA_SYNCH_FILES found in packet Getting tables data type TBL_DTL_DATA_SYNCH_FILES Packet Where Condition where 1=1 and GUID='0_295_DAE2150B-0B0F-4F44-BA02-1FF1731C55FD' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_295_DAE2150B-0B0F-4F44-BA02-1FF1731C55FD',[VESSEL_ID]=295,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='PMS_1_295_96CF7278-66A1-4485-A7B3-511C0ED13CDA.docx',[Content_Type]='application/vnd.openxmlformats-officedocument.wordprocessingml.document',[File_Size]='42657',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-01 17:17 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_295_DAE2150B-0B0F-4F44-BA02-1FF1731C55FD' Reading file content found in packet Update_PacketStatus Packet Deleted Could not find file 'C:\JotApps\Sync\Imports\REP_1_295_AE14BB11-AE60-443D-9113-02AFE65E15B7.docx'. Trace :: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost) at System.IO.File.Copy(String sourceFileName, String destFileName, Boolean overwrite) at JotSynchronizerLib.ImportPacketClass.MoveAttachments(String SourcePath, Int32 Company_ID) System.String[] C:\JotApps\Sync\Imports\MARI-ATLC-O20215805.RAR BatchScript C:\JotApps\Sync\Imports\MARI-ATLC-O20215806.RAR BatchScript files found MARI-ATLC-O20215805.RAR Imported Started for MARI-ATLC-O20215805.RAR Reading Packet Data Reading file content SQL_UPDATE found in packet CREATE TABLE [dbo].[TBL_DTL_CRW_MATRIX_RULE_TEMPLATE_ANSWER]( [ID] [int] NOT NULL, [TEMPLATE_ID] [int] NOT NULL, [VESSEL_ID] [int] NULL, [VESSEL_TYPE] [int] NULL, [VESSEL_FLAG] [int] NULL, [VESSEL_FLEET] [int] NULL, [RANK_ID] [int] NULL, [RANK_CATEGORY_ID] [int] NULL, [VESSEL_DEP_ID] [int] NULL, [STAGE_ID] [int] NULL, [IS_EXCEPTION] [int] NOT NULL, [REASON] [nvarchar](500) NULL, [CREATED_BY] [int] NOT NULL, [DATE_CREATED] [datetime] NOT NULL, [MODIFIED_BY] [int] NULL, [DATE_MODIFIED] [datetime] NULL, [DELETED_BY] [int] NULL, [DATE_DELETED] [datetime] NULL, [ACTIVE_STATUS] [int] NOT NULL, CONSTRAINT [PK_DTL_CRW_MATRIX_RULE_TEMPLATE_ANSWER] PRIMARY KEY CLUSTERED ( [ID] ASC, [TEMPLATE_ID] ASC )) There is already an object named 'TBL_DTL_CRW_MATRIX_RULE_TEMPLATE_ANSWER' in the database.SQL_UPDATE Reading file content found in packet