2019-12-12 08:53:55,651 INFO [central-0] [AbstractSymmetricEngine] [qtp172032696-15] Starting registered node [group=central, id=0, nodeId=0]
2019-12-12 08:53:55,651 INFO [central-0] [TriggerRouterService] [qtp172032696-15] Synchronizing triggers
2019-12-12 08:53:55,868 INFO [central-0] [MsSql2008SymmetricDialect] [central-0-sync-triggers-1] Creating SYM_ON_I_FOR_GR_CSTMRPCTR_C2M_CNTRL trigger for grips.dbo.gr_CustomerPicture
2019-12-12 08:53:55,947 INFO [central-0] [MsSql2008SymmetricDialect] [central-0-sync-triggers-1] Creating SYM_ON_U_FOR_GR_CSTMRPCTR_C2M_CNTRL trigger for grips.dbo.gr_CustomerPicture
2019-12-12 08:53:55,982 INFO [central-0] [MsSql2008SymmetricDialect] [central-0-sync-triggers-1] Failed to create trigger: create trigger SYM_ON_U_FOR_GR_CSTMRPCTR_C2M_CNTRL on "dbo"."gr_CustomerPicture"                                                     
       with execute as caller after update as                                                    
begin                                                                                                          
  declare @NCT int                                                                                             
  set @NCT = @@OPTIONS & 512                                                                                   
  set nocount on                                                                                               
  declare @TransactionId varchar(1000)                                                                         
  if (@@TRANCOUNT > 0)                                                                                         
  begin                                                                                                        
    select @TransactionId = convert(VARCHAR(1000),transaction_id)                                              
    from sys.dm_exec_requests                                                                                  
    where session_id=@@SPID and open_transaction_count > 0                                                     
  end                                                                                                          
                                                                                   
  if (dbo.sym_triggers_disabled() = 0)                                                                         
  begin                                                                                                        
    if (1=1  AND ( UPDATE(sym_row_id) ) )                                                       
    begin                                                                                                      
        insert into  "grips"."dbo".sym_data                                  
           (table_name, event_type, trigger_hist_id, pk_data, channel_id, transaction_id,                      
            source_node_id, external_data, create_time)                                                        
          select 'GR_CUSTOMERPICTURE','D', 2, 
          case when deleted."sym_row_id" is null then '' else '"' + replace(replace(convert(varchar(36),deleted."sym_row_id") ,'\','\\'),'"','\"') + '"' end,                                    
            'content', @TransactionId,                                     
"grips".dbo.sym_node_disabled(),                                               
            (inserted.customerid), current_timestamp                                                               
          from deleted                                                                                         
          where exists (select 1 from sym_customer2node_active_only s where s.customer_id = (inserted.customerid)) AND 1=1                                                                       
        insert into  "grips"."dbo".sym_data                                  
           (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id,                     
            source_node_id, external_data, create_time)                                                        
          select 'GR_CUSTOMERPICTURE','I', 2, 
          case when inserted."sym_row_id" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."sym_row_id") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."Id" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."Id") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."PictureId" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."PictureId") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."CustomerId" is null then '' else ('"' + convert(varchar(40), inserted."CustomerId",2) + '"') end+','+
          case when inserted."CreatedDate" is null then '' else ('"' + convert(varchar,inserted."CreatedDate",121) + '"') end+','+
          case when inserted."CreatedBy" is null then '' else '"' + replace(replace(convert(varchar(255),inserted."CreatedBy") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."ModifiedDate" is null then '' else ('"' + convert(varchar,inserted."ModifiedDate",121) + '"') end+','+
          case when inserted."ModifiedBy" is null then '' else '"' + replace(replace(convert(varchar(255),inserted."ModifiedBy") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."DeletedDate" is null then '' else ('"' + convert(varchar,inserted."DeletedDate",121) + '"') end+','+
          case when inserted."DeletedBy" is null then '' else '"' + replace(replace(convert(varchar(255),inserted."DeletedBy") ,'\','\\'),'"','\"') + '"' end,                                    
            'content', @TransactionId,                                                            
"grips".dbo.sym_node_disabled(),                                                
           (inserted.customerid), current_timestamp                                                                
                                                                                
          from inserted                                                                                        
                                                                                 
          where exists (select 1 from sym_customer2node_active_only s where s.customer_id = (inserted.customerid)) AND 1=1                                                                       
    end                                                                                                        
    else                                                                                                       
    begin                                                                                                      
         insert into  "grips"."dbo".sym_data                                 
            (table_name, event_type, trigger_hist_id, row_data, pk_data, old_data, channel_id,                 
             transaction_id, source_node_id,                                                                   
             external_data, create_time)                                                                       
          select 'GR_CUSTOMERPICTURE','U', 2, 
          case when inserted."sym_row_id" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."sym_row_id") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."Id" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."Id") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."PictureId" is null then '' else '"' + replace(replace(convert(varchar(36),inserted."PictureId") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."CustomerId" is null then '' else ('"' + convert(varchar(40), inserted."CustomerId",2) + '"') end+','+
          case when inserted."CreatedDate" is null then '' else ('"' + convert(varchar,inserted."CreatedDate",121) + '"') end+','+
          case when inserted."CreatedBy" is null then '' else '"' + replace(replace(convert(varchar(255),inserted."CreatedBy") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."ModifiedDate" is null then '' else ('"' + convert(varchar,inserted."ModifiedDate",121) + '"') end+','+
          case when inserted."ModifiedBy" is null then '' else '"' + replace(replace(convert(varchar(255),inserted."ModifiedBy") ,'\','\\'),'"','\"') + '"' end+','+
          case when inserted."DeletedDate" is null then '' else ('"' + convert(varchar,inserted."DeletedDate",121) + '"') end+','+
          case when inserted."DeletedBy" is null then '' else '"' + replace(replace(convert(varchar(255),inserted."DeletedBy") ,'\','\\'),'"','\"') + '"' end, 
          case when deleted."sym_row_id" is null then '' else '"' + replace(replace(convert(varchar(36),deleted."sym_row_id") ,'\','\\'),'"','\"') + '"' end, null,         
                   'content',                                                                       
               @TransactionId,  "grips".dbo.sym_node_disabled(), (inserted.customerid), 
                current_timestamp                                                                              
                                                                                
          from inserted                                                                                        
          inner join deleted on deleted."sym_row_id"=inserted."sym_row_id"                                                        
                                                                                 
          where exists (select 1 from sym_customer2node_active_only s where s.customer_id = (inserted.customerid)) AND 1=1 and (((inserted."sym_row_id" IS NOT NULL AND deleted."sym_row_id" IS NOT NULL AND inserted."sym_row_id"<>deleted."sym_row_id") or (inserted."sym_row_id" IS NULL AND deleted."sym_row_id" IS NOT NULL) or (inserted."sym_row_id" IS NOT NULL AND deleted."sym_row_id" IS NULL)) or ((inserted."Id" IS NOT NULL AND deleted."Id" IS NOT NULL AND inserted."Id"<>deleted."Id") or (inserted."Id" IS NULL AND deleted."Id" IS NOT NULL) or (inserted."Id" IS NOT NULL AND deleted."Id" IS NULL)) or ((inserted."PictureId" IS NOT NULL AND deleted."PictureId" IS NOT NULL AND inserted."PictureId"<>deleted."PictureId") or (inserted."PictureId" IS NULL AND deleted."PictureId" IS NOT NULL) or (inserted."PictureId" IS NOT NULL AND deleted."PictureId" IS NULL)) or ((inserted."CustomerId" IS NOT NULL AND deleted."CustomerId" IS NOT NULL AND inserted."CustomerId"<>deleted."CustomerId") or (inserted."CustomerId" IS NULL AND deleted."CustomerId" IS NOT NULL) or (inserted."CustomerId" IS NOT NULL AND deleted."CustomerId" IS NULL)) or ((inserted."CreatedDate" IS NOT NULL AND deleted."CreatedDate" IS NOT NULL AND inserted."CreatedDate"<>deleted."CreatedDate") or (inserted."CreatedDate" IS NULL AND deleted."CreatedDate" IS NOT NULL) or (inserted."CreatedDate" IS NOT NULL AND deleted."CreatedDate" IS NULL)) or ((inserted."CreatedBy" IS NOT NULL AND deleted."CreatedBy" IS NOT NULL AND inserted."CreatedBy"<>deleted."CreatedBy") or (inserted."CreatedBy" IS NULL AND deleted."CreatedBy" IS NOT NULL) or (inserted."CreatedBy" IS NOT NULL AND deleted."CreatedBy" IS NULL)) or ((inserted."ModifiedDate" IS NOT NULL AND deleted."ModifiedDate" IS NOT NULL AND inserted."ModifiedDate"<>deleted."ModifiedDate") or (inserted."ModifiedDate" IS NULL AND deleted."ModifiedDate" IS NOT NULL) or (inserted."ModifiedDate" IS NOT NULL AND deleted."ModifiedDate" IS NULL)) or ((inserted."ModifiedBy" IS NOT NULL AND deleted."ModifiedBy" IS NOT NULL AND inserted."ModifiedBy"<>deleted."ModifiedBy") or (inserted."ModifiedBy" IS NULL AND deleted."ModifiedBy" IS NOT NULL) or (inserted."ModifiedBy" IS NOT NULL AND deleted."ModifiedBy" IS NULL)) or ((inserted."DeletedDate" IS NOT NULL AND deleted."DeletedDate" IS NOT NULL AND inserted."DeletedDate"<>deleted."DeletedDate") or (inserted."DeletedDate" IS NULL AND deleted."DeletedDate" IS NOT NULL) or (inserted."DeletedDate" IS NOT NULL AND deleted."DeletedDate" IS NULL)) or ((inserted."DeletedBy" IS NOT NULL AND deleted."DeletedBy" IS NOT NULL AND inserted."DeletedBy"<>deleted."DeletedBy") or (inserted."DeletedBy" IS NULL AND deleted."DeletedBy" IS NOT NULL) or (inserted."DeletedBy" IS NOT NULL AND deleted."DeletedBy" IS NULL)))                                      
    end                                                                                                        
  end                                                                                                          
                                                                                       
  if (@NCT = 0) set nocount off                                                                                
end                                                                                                            
---- go
2019-12-12 08:53:55,993 INFO [central-0] [TriggerRouterService] [central-0-sync-triggers-1] Cleaning up trigger hist row of 2 after failing to create the associated trigger
2019-12-12 08:53:56,009 WARN [central-0] [TriggerRouterService] [central-0-sync-triggers-1] Failed to create triggers for GR_CUSTOMERPICTURE. Retry 0. Reason The multi-part identifier "inserted.customerid" could not be bound.