Skip to Content (Press Enter)
2017-09-22 09-07-17
Toni Juvani
152Views
0Comments
[Timer Map] MySQL error: Duplicate column name 'Name'
Question
Forge
timermap-png
Web icon
Timer Map (O11)
Forge asset by TimerMap++

Just installed this and it looks very good. However, when going to the TimerConfiguration screen I got an error:


Error in advanced query GetConfigurations in Preparation in TimerConfiguration in MainFlow in TimerMap (select       {Meta_Cyclic_Job}.[Id],  {Meta_Cyclic_Job}.[Name],      {Espace}.[Name],   {Cyclic_Job_Shared}.[Schedule],   case {Meta_Cyclic_Job}.[Effective_Timeout] when 0 then {Meta_Cyclic_Job}.[Timeout] else {Meta_Cyclic_Job}.[Effective_Timeout] end,      {TimerConfiguration}.[HasHighPayload]      from {Cyclic_Job_Shared}  inner join {Meta_Cyclic_Job} on {Meta_Cyclic_Job}.[Id] = {Cyclic_Job_Shared}.[Meta_Cyclic_Job_Id]  inner join {Espace} on {Espace}.[Id] = {Meta_Cyclic_Job}.[Espace_Id]  left join {TimerConfiguration} on {TimerConfiguration}.[Id] = {Meta_Cyclic_Job}.[Id]  where  {Espace}.[Is_System] = 0  and {Espace}.[Is_Active] = 1  and {Meta_Cyclic_Job}.[Is_Active] = 1  and ({Espace}.[Name] LIKE @NameFilter or {Meta_Cyclic_Job}.[Name] LIKE @NameFilter)  and (@HighPayloadOnly = 0 or {TimerConfiguration}.[HasHighPayload] = 1)  order by  {Meta_Cyclic_Job}.[Name] ASC,      {Espace}.[Name] ASC): Duplicate column name 'Name'


I extracted the actual SQL being executed and found no problems:

select  
     outsystems.OSSYS_META_CYCLIC_JOB.Id,
 outsystems.OSSYS_META_CYCLIC_JOB.Name,
     outsystems.OSSYS_ESPACE.Name,  
 outsystems.OSSYS_CYCLIC_JOB_SHARED.Schedule,  
case  outsystems.OSSYS_META_CYCLIC_JOB.Effective_Timeout when 0 then  outsystems.OSSYS_META_CYCLIC_JOB.Timeout else  outsystems.OSSYS_META_CYCLIC_JOB.Effective_Timeout end,
     outsystems.OSUSR_ffb_TimerConfiguration.HasHighPayload    
from  outsystems.OSSYS_CYCLIC_JOB_SHARED
inner join  outsystems.OSSYS_META_CYCLIC_JOB on  outsystems.OSSYS_META_CYCLIC_JOB.Id =  outsystems.OSSYS_CYCLIC_JOB_SHARED.Meta_Cyclic_Job_Id
inner join  outsystems.OSSYS_ESPACE on  outsystems.OSSYS_ESPACE.Id =  outsystems.OSSYS_META_CYCLIC_JOB.Espace_Id
left join  outsystems.OSUSR_ffb_TimerConfiguration on  outsystems.OSUSR_ffb_TimerConfiguration.Id =  outsystems.OSSYS_META_CYCLIC_JOB.Id
where
 outsystems.OSSYS_ESPACE.Is_System = 0
and  outsystems.OSSYS_ESPACE.Is_Active = 1
and  outsystems.OSSYS_META_CYCLIC_JOB.Is_Active = 1
-- and ( outsystems.OSSYS_ESPACE.Name LIKE  or  outsystems.OSSYS_META_CYCLIC_JOB.Name LIKE )
and (0 = 0 or  outsystems.OSUSR_ffb_TimerConfiguration.HasHighPayload = 1)
order by
 outsystems.OSSYS_META_CYCLIC_JOB.Name ASC,
     outsystems.OSSYS_ESPACE.Name ASC

Any ideas what might be causing this? 

0
0
11 Apr 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.