Edit C:\logs\grc\edealFIL.log
06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpActWhoHaveRead 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpActWhoHaveRead 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpActWhoHaveRead 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpActWhoHaveRead 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : true / alias : ext 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : true / alias : ext 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 1 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - , 1 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.InpDate DESC 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.InpDate DESC 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent FROM InformationPanel ext WHERE ( (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) ORDER BY ext.InpDate DESC 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent FROM InformationPanel ext WHERE ( (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) ORDER BY ext.InpDate DESC 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [InpActWhoHaveRead] 06/09/2025 13:29:53 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [InpActWhoHaveRead] 06/09/2025 13:29:53 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:29:53 - INFO com.edeal.frontline.BasicBean - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent FROM InformationPanel ext WHERE ( (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:29:53' and ext.InpToDate >= '2025-09-06 13:29:53' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) ORDER BY ext.InpDate DESC 06/09/2025 13:29:53 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:29:55 - DEBUG com.edeal.frontline.EDealDataSource - Connections checked (Pool size=10) : 10 checked ; 10 OK ; 0 KO 06/09/2025 13:30:00 - INFO com.edeal.frontline.tasks.FlTaskSequence - GetTaskThread[[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub,5,main] 06/09/2025 13:30:00 - INFO com.edeal.frontline.tasks.FlTaskSequence - Launch task Thread[[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub,5,main] 06/09/2025 13:30:00 - INFO com.edeal.frontline.tasks.FlTaskSequence - Waiting task Thread[[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub,5,main] 06/09/2025 13:30:00 - INFO com.edeal.frontline.tasks.FlTaskStatus - Wait final status 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.DataImport - Load Configuration {-xml=C:\\edeal\\import\\synchro_efficy\\import_etab_efficy.xml, -out=out_etab.log, -nfo=nfo_etab.log, args=[C:\\edeal\\import\\synchro_efficy], -err=err_etab.log, -ctx=/galaxie=, -ctx=/galaxie} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - request service for url [http://e-deal.biz/service/log/generate/TRACKURL/Hy8VNE0CQnJB] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - Client not open.... starting restlet Client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: TrashReport with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: TrashReport with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO TrashReport (TrpMbm, TrpMbs, TrpDieID, TrpFileName, TrpImportDate, TrpObjID, TrpPos, TrpID, TrpCrDt, TrpCreID, TrpModID, TrpUpd) VALUES (null, null, null, 'jdbc:postgresql://172.16.53.105:5432/edealLogisREC', '2025-09-06 13:30:00', '00012d00000054ed', 0, '00012d00249d8bdb', '2025-09-06 13:30:00', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:00') 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - setTrashReport => we set the trashreport. Null ? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - Importing file : "DBInSource" ... 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - getTrashReport => we get the trashreport. Null ? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: TrashReportLine with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: TrashReportLine with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de TrlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de TrlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: TrlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: TrlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to TrlTrpID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to TrlTrpID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.TrlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.TrlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.TrlTrpID = '00012d00249d8bdb')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.TrlTrpID = '00012d00249d8bdb')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.TrlID FROM TrashReportLine ext WHERE ( (ext.TrlTrpID = '00012d00249d8bdb')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.TrlID FROM TrashReportLine ext WHERE ( (ext.TrlTrpID = '00012d00249d8bdb')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.TrlID FROM TrashReportLine ext WHERE ( (ext.TrlTrpID = '00012d00249d8bdb')) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - getTrashReport => we get the trashreport. Null ? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: TrashReport with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: TrashReport with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.BasicBean - ================ Requete dans delete() ==================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.BasicBean - DELETE FROM TrashReport WHERE TrpID = '00012d00249d8bdb' 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - setTrashReport => we set the trashreport. Null ? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - File "DBInSource" has been imported. 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.dataimport.ObjectNode - *** Object Enterprise (NORMAL) : 0 line(s) have been processed, 0 saved, 0 awaited, 0 trashed, 0 deleted (19ms) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - Resource status:OK (200) - 200 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - All connections closed... closing client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - No CSV file to process.... stopping 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblWopID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblWopID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblWopID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblWopID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblElnID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblElnID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblElnID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblElnID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 7 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 7 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 8 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 8 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblWopID, ext.IblElnID, ext.IblOri, ext.IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblWopID, ext.IblElnID, ext.IblOri, ext.IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 0)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 0)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblWopID, ext.IblElnID, ext.IblOri, ext.IblEmlID FROM InBoundLog ext WHERE ( (ext.IblStatus = 0)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblWopID, ext.IblElnID, ext.IblOri, ext.IblEmlID FROM InBoundLog ext WHERE ( (ext.IblStatus = 0)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblWopID, ext.IblElnID, ext.IblOri, ext.IblEmlID FROM InBoundLog ext WHERE ( (ext.IblStatus = 0)) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - TRACKURL: Processed 0 entries 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - request service for url [http://e-deal.biz/service/log/generate/SUBSCRIBE/Hy8VNE0CQnJB] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - Client not open.... starting restlet Client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - Resource status:OK (200) - 200 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - All connections closed... closing client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - No CSV file to process.... stopping 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCivID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCivID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCivID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCivID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblFstName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblFstName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblFstName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblFstName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblEnterprise 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblEnterprise 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblEnterprise 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblEnterprise 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 7 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 7 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 8 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 8 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 9 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 9 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 10 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 10 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblCivID, ext.IblName, ext.IblFstName, ext.IblEnterprise, ext.IblNslCode, ext.IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblCivID, ext.IblName, ext.IblFstName, ext.IblEnterprise, ext.IblNslCode, ext.IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 10)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 10)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblCivID, ext.IblName, ext.IblFstName, ext.IblEnterprise, ext.IblNslCode, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 10)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblCivID, ext.IblName, ext.IblFstName, ext.IblEnterprise, ext.IblNslCode, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 10)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblCivID, ext.IblName, ext.IblFstName, ext.IblEnterprise, ext.IblNslCode, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 10)) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - request service for url [http://e-deal.biz/service/log/generate/UNSUBSCRIBE/Hy8VNE0CQnJB] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - Client not open.... starting restlet Client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - Resource status:OK (200) - 200 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - All connections closed... closing client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - No CSV file to process.... stopping 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - START Unsubscription process 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblNslCode 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblNslCode, ext.IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblNslCode, ext.IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 20)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 20)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblNslCode, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 20)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblNslCode, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 20)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblNslCode, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 20)) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - UNSUSCRIB / process inboundlog : 0 record 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - UNSUBSCRIBE: Processed 0 entries 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - request service for url [http://e-deal.biz/service/log/generate/NOMAIL/Hy8VNE0CQnJB] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - Client not open.... starting restlet Client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - Resource status:OK (200) - 200 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - All connections closed... closing client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - No CSV file to process.... stopping 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 30)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 30)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 30)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 30)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri FROM InBoundLog ext WHERE ( (ext.IblStatus = 30)) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - NOMAIL: Processed 0 entries 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'NETBUSINESSLOG.OPTION.%')) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - request service for url [http://e-deal.biz/service/log/generate/OPENMAIL/Hy8VNE0CQnJB] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - Client not open.... starting restlet Client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.netbusinesslog.impl.HubNetBusinessLogServiceImpl - Resource status:OK (200) - 200 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - All connections closed... closing client 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - No CSV file to process.... stopping 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - START OpenMailLog process 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - OpenMailLog - csv file imported 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InBoundLog with ActID: null 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object WebOperation 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LMKTG: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCCTR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSRCE: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LCXTD: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNR: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LKNP: 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LREAD: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LFROF: 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblUtk 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblCookie 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblMail 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblOri 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Testing field: IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to IblStatus 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 5 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - , 6 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri, ext.IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri, ext.IblEmlID 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 40)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.IblStatus = 40)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri, ext.IblEmlID FROM InBoundLog ext WHERE ( (ext.IblStatus = 40)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri, ext.IblEmlID FROM InBoundLog ext WHERE ( (ext.IblStatus = 40)) 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - SELECT ext.IblID, ext.IblUtk, ext.IblCookie, ext.IblMail, ext.IblOri, ext.IblEmlID FROM InBoundLog ext WHERE ( (ext.IblStatus = 40)) 06/09/2025 13:30:00 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - OpenMailLog - found 0 inboundlog of status 0 06/09/2025 13:30:00 - DEBUG com.edeal.frontline.tasks.action.NetBusinessLogAction - OpenMail: Processed 0 entries 06/09/2025 13:30:00 - INFO com.edeal.frontline.tasks.FlTaskSequence - Read Log task Thread[[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub,5,main] 06/09/2025 13:30:00 - INFO com.edeal.frontline.tasks.FlTaskLogger - Wait save Log 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskLogger - save Log 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO FlTaskLog (TslMbm, TslMbs, TslStarted, TslEnded, TslUnfinished, TslBody, TslStatus, TslTskID, TslID, TslUpd, TslCreID, TslModID, TslCrDt) VALUES (null, null, '2025-09-06 13:30:00', '2025-09-06 13:30:00', null, '#title#[Efficy] Synchro contact Efficy$!$#log#06/09/2025:13:30:00##[Efficy] Synchro contact Efficy finish : SUCCESS$!$', 10, '00012d00248db147', '00012d00249d8bdc', '2025-09-06 13:30:10', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:10') 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_NOSCHED 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_WAITING 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskLogger - save Log 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO FlTaskLog (TslMbm, TslMbs, TslStarted, TslEnded, TslUnfinished, TslBody, TslStatus, TslTskID, TslID, TslUpd, TslCreID, TslModID, TslCrDt) VALUES (null, null, '2025-09-06 13:30:00', '2025-09-06 13:30:00', null, '#title#[Efficy] Synchro entreprise Efficy$!$#log#06/09/2025:13:30:00##[Efficy] Synchro entreprise Efficy finish : SUCCESS$!$', 10, '00012d002497d80e', '00012d00249d8bdd', '2025-09-06 13:30:10', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:10') 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_NOSCHED 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_WAITING 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskLogger - save Log 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO FlTaskLog (TslMbm, TslMbs, TslStarted, TslEnded, TslUnfinished, TslBody, TslStatus, TslTskID, TslID, TslUpd, TslCreID, TslModID, TslCrDt) VALUES (null, null, '2025-09-06 13:30:00', '2025-09-06 13:30:00', null, '#title#[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub$!$#log#06/09/2025:13:30:00##<p>TRACKURL: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>SUBSCRIBE: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>UNSUBSCRIBE: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>NOMAIL: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>OPENMAIL: No logs processed</p>$!$#log#06/09/2025:13:30:00##[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub finish : SUCCESS$!$', 10, '00012d0000006143', '00012d00249d8bde', '2025-09-06 13:30:10', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:10') 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Wait status : STATUS_TREATED 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskSequence - Finish Treatment task Thread[[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub,5,main] 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_TREATED 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskSequence - GetTaskThread[[NETBIZ] Récupération des bounces | Get bounces from Hub,5,main] 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskSequence - Launch task Thread[[NETBIZ] Récupération des bounces | Get bounces from Hub,5,main] 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskSequence - Waiting task Thread[[NETBIZ] Récupération des bounces | Get bounces from Hub,5,main] 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_NOSCHED 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskStatus - Wait final status 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlOption with ActID: null 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptID 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptID 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de OptValue 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Testing field: OptValue 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to OptName 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'GETADDRESSANDSTATUS.OPTION.%')) 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (UPPER(ext.OptName) LIKE 'GETADDRESSANDSTATUS.OPTION.%')) 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'GETADDRESSANDSTATUS.OPTION.%')) 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'GETADDRESSANDSTATUS.OPTION.%')) 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:10 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:10 - INFO com.edeal.frontline.BasicBean - SELECT ext.OptID, ext.OptName, ext.OptValue FROM FlOption ext WHERE ( (UPPER(ext.OptName) LIKE 'GETADDRESSANDSTATUS.OPTION.%')) 06/09/2025 13:30:10 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - Client not open.... starting restlet Client 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.services.getaddressandstatus.impl.HubGetAddressAndStatusServiceImpl - Resource status:OK (200) - 200 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.services.RestletClientHttpHandler - All connections closed... closing client 06/09/2025 13:30:10 - DEBUG com.edeal.frontline.helper.EmailSentBaseHelper - La chaine json récupérée depuis le hub est : [] 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskSequence - Read Log task Thread[[NETBIZ] Récupération des bounces | Get bounces from Hub,5,main] 06/09/2025 13:30:10 - INFO com.edeal.frontline.tasks.FlTaskLogger - Wait save Log 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskLogger - save Log 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO FlTaskLog (TslMbm, TslMbs, TslStarted, TslEnded, TslUnfinished, TslBody, TslStatus, TslTskID, TslID, TslUpd, TslCreID, TslModID, TslCrDt) VALUES (null, null, '2025-09-06 13:30:10', '2025-09-06 13:30:10', null, '#title#[NETBIZ] Récupération des bounces | Get bounces from Hub$!$#log#06/09/2025:13:30:10##[NETBIZ] Récupération des bounces | Get bounces from Hub finish : SUCCESS$!$', 10, '00012d000000613d', '00012d00249d8bdf', '2025-09-06 13:30:20', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:20') 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskStatus - Wait status : STATUS_TREATED 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskSequence - Finish Treatment task Thread[[NETBIZ] Récupération des bounces | Get bounces from Hub,5,main] 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_TREATED 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskSequence - GetTaskThread[[NETBIZ] StatistiquesEmailing | Emailing Stats,5,main] 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskSequence - Launch task Thread[[NETBIZ] StatistiquesEmailing | Emailing Stats,5,main] 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskSequence - Waiting task Thread[[NETBIZ] StatistiquesEmailing | Emailing Stats,5,main] 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskStatus - Wait final status 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.tasks.action.NetBusinessStatisticsTask - La période pour élaborer les statistiques sur les e-mailings est 10 jours 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: MassEmailing with ActID: null 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: MassEmailing with ActID: null 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: MassEmailing 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object has parent depenancy: MassEmailing 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object MassEmailing 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for read access rights for object MassEmailing 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Actor ID is null or this is system, so just check to see if the licence is != 0 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSSTD: 0 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 1 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Rights for software code LSXTD: 1 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - User has this licence. Returning true 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de EmlID 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de EmlID 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Testing field: EmlID 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Testing field: EmlID 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlStatus 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlStatus 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlSndDate 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlSndDate 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlStatus 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlStatus 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlCrDt 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlCrDt 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlSndDate 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlSndDate 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlSndDate and EmlSndDate 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to EmlSndDate and EmlSndDate 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.EmlID 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.EmlID 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.EmlStatus = '00012d0000000a72' and ext.EmlSndDate > '2025-08-27 13:30:20') or (ext.EmlStatus = '00012d0000000a72' and ext.EmlCrDt > '2025-08-27 13:30:20' and ext.EmlSndDate is null)) 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.EmlStatus = '00012d0000000a72' and ext.EmlSndDate > '2025-08-27 13:30:20') or (ext.EmlStatus = '00012d0000000a72' and ext.EmlCrDt > '2025-08-27 13:30:20' and ext.EmlSndDate is null)) 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.EmlSndDate ASC 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.EmlSndDate ASC 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.EmlID FROM MassEmailing ext WHERE ( (ext.EmlStatus = '00012d0000000a72' and ext.EmlSndDate > '2025-08-27 13:30:20') or (ext.EmlStatus = '00012d0000000a72' and ext.EmlCrDt > '2025-08-27 13:30:20' and ext.EmlSndDate is null)) ORDER BY ext.EmlSndDate ASC 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.EmlID FROM MassEmailing ext WHERE ( (ext.EmlStatus = '00012d0000000a72' and ext.EmlSndDate > '2025-08-27 13:30:20') or (ext.EmlStatus = '00012d0000000a72' and ext.EmlCrDt > '2025-08-27 13:30:20' and ext.EmlSndDate is null)) ORDER BY ext.EmlSndDate ASC 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:30:20 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:30:20 - INFO com.edeal.frontline.BasicBean - SELECT ext.EmlID FROM MassEmailing ext WHERE ( (ext.EmlStatus = '00012d0000000a72' and ext.EmlSndDate > '2025-08-27 13:30:20') or (ext.EmlStatus = '00012d0000000a72' and ext.EmlCrDt > '2025-08-27 13:30:20' and ext.EmlSndDate is null)) ORDER BY ext.EmlSndDate ASC 06/09/2025 13:30:20 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.tasks.action.NetBusinessStatisticsTask - getSentEmailingIDs() ---- Time spent : 2 milliseconds 06/09/2025 13:30:20 - DEBUG com.edeal.frontline.tasks.action.NetBusinessStatisticsTask - getSentEmailingIDs() ---- Time spent : 2 milliseconds 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskSequence - Read Log task Thread[[NETBIZ] StatistiquesEmailing | Emailing Stats,5,main] 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskLogger - Wait save Log 06/09/2025 13:30:20 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_NOSCHED 06/09/2025 13:30:30 - INFO com.edeal.frontline.tasks.FlTaskLogger - save Log 06/09/2025 13:30:30 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:30 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:30 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:30 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:30 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO FlTaskLog (TslMbm, TslMbs, TslStarted, TslEnded, TslUnfinished, TslBody, TslStatus, TslTskID, TslID, TslUpd, TslCreID, TslModID, TslCrDt) VALUES (null, null, '2025-09-06 13:30:20', '2025-09-06 13:30:20', null, 'Statistics period is : 10 days<br>Nbr e-mailings processed is : 0<br>#title#[NETBIZ] StatistiquesEmailing | Emailing Stats$!$#log#06/09/2025:13:30:20##[NETBIZ] StatistiquesEmailing | Emailing Stats finish : SUCCESS$!$', 10, '00012d0000006144', '00012d00249d8be0', '2025-09-06 13:30:30', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:30') 06/09/2025 13:30:30 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:30 - INFO com.edeal.frontline.tasks.FlTaskStatus - Wait status : STATUS_TREATED 06/09/2025 13:30:30 - INFO com.edeal.frontline.tasks.FlTaskSequence - Finish Treatment task Thread[[NETBIZ] StatistiquesEmailing | Emailing Stats,5,main] 06/09/2025 13:30:30 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_TREATED 06/09/2025 13:30:30 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_NOSCHED 06/09/2025 13:30:40 - INFO com.edeal.frontline.tasks.FlTaskLogger - save Log 06/09/2025 13:30:40 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:40 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: FlTaskLog with ActID: null 06/09/2025 13:30:40 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:40 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:30:40 - DEBUG com.edeal.frontline.BasicBean - INSERT INTO FlTaskLog (TslMbm, TslMbs, TslStarted, TslEnded, TslUnfinished, TslBody, TslStatus, TslTskID, TslID, TslUpd, TslCreID, TslModID, TslCrDt) VALUES (null, null, '2025-09-06 13:30:00', '2025-09-06 13:30:30', null, '#title#[NETBIZ] Récupération des logs & bounce depuis le hub + calcul des statistiques$!$#title#[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub$!$#log#06/09/2025:13:30:00##<p>TRACKURL: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>SUBSCRIBE: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>UNSUBSCRIBE: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>NOMAIL: No logs processed</p>$!$#log#06/09/2025:13:30:00##<p>OPENMAIL: No logs processed</p>$!$#log#06/09/2025:13:30:00##[NETBIZ] Récupération des logs tracking Hub | get tracking logs from Hub finish : SUCCESS$!$#title#[NETBIZ] Récupération des bounces | Get bounces from Hub$!$#log#06/09/2025:13:30:10##[NETBIZ] Récupération des bounces | Get bounces from Hub finish : SUCCESS$!$#title#[NETBIZ] StatistiquesEmailing | Emailing Stats$!$#log#06/09/2025:13:30:20##[NETBIZ] StatistiquesEmailing | Emailing Stats finish : SUCCESS$!$#log#06/09/2025:13:30:30##[NETBIZ] Récupération des logs & bounce depuis le hub + calcul des statistiques finish : SUCCESS$!$', 10, '00012d0000006149', '00012d00249d8be1', '2025-09-06 13:30:40', '00012d0000000001', '00012d0000000001', '2025-09-06 13:30:40') 06/09/2025 13:30:40 - DEBUG com.edeal.frontline.sla.SLAManager - SLA Monitoring - No SlaFieldValue for bean 06/09/2025 13:30:40 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_NOSCHED 06/09/2025 13:30:40 - INFO com.edeal.frontline.tasks.FlTaskStatus - Change status : STATUS_WAITING 06/09/2025 13:34:53 - DEBUG com.edeal.frontline.controller.ControllerServlet - [ControllerServlet] retrieving action named get_infobar_information 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.controller.ControllerServlet - [ControllerServlet] processing action get_infobar_information 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: Alarm with ActID: null 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: Alarm with ActID: null 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate and AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate and AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate and AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate and AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmMessage 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de AlmMessage 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmMessage 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: AlmMessage 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate and AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to AlmDate and AlmDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.AlmID, ext.AlmDate, ext.AlmSubject, ext.AlmMessage 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.AlmID, ext.AlmDate, ext.AlmSubject, ext.AlmMessage 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.AlmActID = '00012d00249c4da1' and ext.AlmDate <= '2025-09-06 13:34:00')) 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.AlmActID = '00012d00249c4da1' and ext.AlmDate <= '2025-09-06 13:34:00')) 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.AlmDate ASC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.AlmDate ASC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.AlmID, ext.AlmDate, ext.AlmSubject, ext.AlmMessage FROM Alarm ext WHERE ( (ext.AlmActID = '00012d00249c4da1' and ext.AlmDate <= '2025-09-06 13:34:00')) ORDER BY ext.AlmDate ASC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.AlmID, ext.AlmDate, ext.AlmSubject, ext.AlmMessage FROM Alarm ext WHERE ( (ext.AlmActID = '00012d00249c4da1' and ext.AlmDate <= '2025-09-06 13:34:00')) ORDER BY ext.AlmDate ASC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - SELECT ext.AlmID, ext.AlmDate, ext.AlmSubject, ext.AlmMessage FROM Alarm ext WHERE ( (ext.AlmActID = '00012d00249c4da1' and ext.AlmDate <= '2025-09-06 13:34:00')) ORDER BY ext.AlmDate ASC 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: Actor with ActID: null 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: Actor with ActID: null 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActManager 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActManager 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActManager 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActManager 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActAssistant 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActAssistant 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActAssistant 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActAssistant 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActBackup 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de ActBackup 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActBackup 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: ActBackup 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.ActID, ext.ActManager, ext.ActAssistant, ext.ActBackup 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.ActID, ext.ActManager, ext.ActAssistant, ext.ActBackup 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.ActID, ext.ActManager, ext.ActAssistant, ext.ActBackup FROM Actor ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.ActID, ext.ActManager, ext.ActAssistant, ext.ActBackup FROM Actor ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [] 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - SELECT ext.ActID, ext.ActManager, ext.ActAssistant, ext.ActBackup FROM Actor ext 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InformationPanel with ActID: null 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Searching for object access rights for object: InformationPanel with ActID: null 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.LicenceManager.enforceAccess - Object is an 'admin' object, return true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : true / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? true 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpSubject 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpContent 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpContent 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpContent 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpContent 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : false / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpActWhoHaveRead 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] traitement de InpActWhoHaveRead 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpActWhoHaveRead 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Testing field: InpActWhoHaveRead 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpIssuerID 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpFromDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpToDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpReceiver 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpCoWorkerLimitation 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Comparing field to InpDate and InpDate 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - Is this one part of the conditions or orderBy? false 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : true / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate[] isID : false / isMultival : true / alias : ext 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] fin de traitement de fields 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] this.usedKeyAliases{ext=1} 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 2 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 3 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 4 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - , 1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - [SqlQuery.populate()] : fin de traitement 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - DBG1 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - WHERE ( (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.InpDate DESC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ORDER BY ext.InpDate DESC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - temps passé dans SqlQuery.getSQL() : 0 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - *****Requete retournee par SqlField****** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent FROM InformationPanel ext WHERE ( (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) ORDER BY ext.InpDate DESC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent FROM InformationPanel ext WHERE ( (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) ORDER BY ext.InpDate DESC 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - ***************************************** 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [InpActWhoHaveRead] 06/09/2025 13:34:56 - DEBUG com.edeal.frontline.SqlQuery - multival fields : [InpActWhoHaveRead] 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - ================ Requete dans listSummary() ==================== 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - SELECT ext.InpID, ext.InpDate, ext.InpSubject, ext.InpContent FROM InformationPanel ext WHERE ( (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and ext.InpIssuerID = '00012d00249c4da1') or (ext.InpFromDate <= '2025-09-06 13:34:56' and ext.InpToDate >= '2025-09-06 13:34:56' and EXISTS (SELECT MvaColID FROM MvaInpReceiver WHERE MvaColID = ext.InpID AND MvaText = '00012d0000000dff' GROUP BY MvaColID HAVING COUNT(*) >= 1) and ext.InpCoWorkerLimitation <> 1)) ORDER BY ext.InpDate DESC 06/09/2025 13:34:56 - INFO com.edeal.frontline.BasicBean - ==================== fin requete ======================== 06/09/2025 13:34:55 - DEBUG com.edeal.frontline.EDealDataSource - Connections checked (Pool size=10) : 10 checked ; 10 OK ; 0 KO
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de