Config Settings retrieved Retrieving Email Settings biskra@skyfile.com Reading Outlook Inbox Email Reading Started Email from biskra@skyfile.com Count of Email : 128 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail 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 biskra@skyfile.com Count of Email : 126 collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail collectionItem newEmail Email found Email Moved in Jot_Temp Imported Started files found MARI-BISK-O20213578.RAR Imported Started for MARI-BISK-O20213578.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-02 08:06:46 PM' where PACKET_NAME='BISK-MARI-V20211796.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_294_0C5693F5-9422-48C6-AB43-3025DAF2DC57' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_294_0C5693F5-9422-48C6-AB43-3025DAF2DC57',[VESSEL_ID]=294,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_294_DE10614D-DD14-4874-9F4E-3D33458BD692.docx',[Content_Type]='application/vnd.openxmlformats-officedocument.wordprocessingml.document',[File_Size]='48892',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-02 12:39 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_294_0C5693F5-9422-48C6-AB43-3025DAF2DC57' 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_294_290B27EB-8006-49D3-90A1-A20B4AB801DB' Record already exist in TBL_DTL_DATA_SYNCH_FILES update TBL_DTL_DATA_SYNCH_FILES set [GUID]='0_294_290B27EB-8006-49D3-90A1-A20B4AB801DB',[VESSEL_ID]=294,[Ship_Path]='IMPORTS',[Office_Path]=null,[Server_or_Email_PC]=1,[File_Name]='NAD_1_294_50265913-8CC5-4B0B-9243-01C7F3DA84F8.xlsx',[Content_Type]='application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',[File_Size]='32731',[Is_Imported]=1,[Is_Synched]=1,[Is_Processed]=1,[File_Binary]=null,[IS_UNRAR]=0,[CREATED_BY]=6,[DATE_CREATED]='2021-10-02 12:39 ',[MODIFIED_BY]=null,[DATE_MODIFIED]=null,[DELETED_BY]=null,[DATE_DELETED]=null,[ACTIVE_STATUS]=1 where 1=1 and GUID='0_294_290B27EB-8006-49D3-90A1-A20B4AB801DB' Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] C:\JotApps\Sync\Imports\MARI-BISK-O20213579.RAR BatchScript C:\JotApps\Sync\Imports\MARI-BISK-O20213580.RAR BatchScript files found MARI-BISK-O20213579.RAR Imported Started for MARI-BISK-O20213579.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-02 11:42:07 PM' where PACKET_NAME='BISK-MARI-V20211797.RAR' Reading file content found in packet Update_PacketStatus Packet Deleted System.String[] C:\JotApps\Sync\Imports\MARI-BISK-O20213580.RAR BatchScript files found MARI-BISK-O20213580.RAR Imported Started for MARI-BISK-O20213580.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