Skip to Content (Press Enter)
2018-03-08 20-43-12
Robert Chanphakeo
54Views
1Comments
[OutDoc] Error while loading eSpace page (eSpace_List.aspx)
Question
Forge
outdoc
Web icon
OutDoc (O11)
Forge asset by OutSystems

Outsystems Platform 9.1.0.10



Id:
41d75e8e-83ae-42c7-92a7-8e75b4c5ebf5
Time of Log:
2016-04-19 18:27:19
eSpace:
Tenant:
ServiceCenter
User:
admin (1)
Session Id:
d4xezikuqwjhdi43ogbg3em2
Server:
WIN-MS7U63VM6D3
Module:
 
Message:
Error in advanced query GetEspaces in Preparation in eSpace_List in MainFlow in OutDoc (SELECT {Espace}.*, {Espace_Version}.[Description], {Espace_Version}.[Uploaded_Date], {UserMT}.*  FROM  {Espace}  INNER JOIN {Espace_Version} ON    (    COALESCE({Espace}.[Version_Id], 0) = 0    AND     {Espace_Version}.[Id] = (SELECT max(version2.Id) FROM {Espace_Version} version2 WHERE version2.eSpace_Id = {Espace}.[Id])    OR     {Espace}.[Version_Id] = {Espace_Version}.[Id]   )    LEFT JOIN {UserMT} ON COALESCE({Espace_Version}.[Uploaded_By], 0) = COALESCE({UserMT}.[Id], 0)  WHERE( Lower({Espace}.[Name]) LIKE (@eSpaceNamePattern )) AND {Espace}.[Is_Active] = 1 AND {Espace}.[Is_System] = 0  ORDER BY @OrderBy ): Duplicate column name 'Id'
Environment Information eSpaceVer: 1 (Id=1178, PubId=1152, CompiledWith=9.1.0.10)
RequestUrl: https://10.1.151.33/OutDoc/eSpace_List.aspx?(Not.Licensed.For.Production)= (Method: GET)
AppDomain: /LM/W3SVC/1/ROOT/OutDoc-240-131051777677890000
FilePath: C:\...\PS\running\OutDoc.01531675824\eSpace_List.aspx
Locale: en-US
DateFormat: yyyy-MM-dd
PID: 4044 ('w3wp', Started='24/02/2016 5:30:10 AM', Priv=984Mb, Virt=18658Mb)
TID: 2144
Thread Name: 
.NET: 4.0.30319.42000
Stack:
Error in advanced query GetEspaces in Preparation in eSpace_List in MainFlow in OutDoc (SELECT {Espace}.*, {Espace_Version}.[Description], {Espace_Version}.[Uploaded_Date], {UserMT}.*  FROM  {Espace}  INNER JOIN {Espace_Version} ON    (    COALESCE({Espace}.[Version_Id], 0) = 0    AND     {Espace_Version}.[Id] = (SELECT max(version2.Id) FROM {Espace_Version} version2 WHERE version2.eSpace_Id = {Espace}.[Id])    OR     {Espace}.[Version_Id] = {Espace_Version}.[Id]   )    LEFT JOIN {UserMT} ON COALESCE({Espace_Version}.[Uploaded_By], 0) = COALESCE({UserMT}.[Id], 0)  WHERE( Lower({Espace}.[Name]) LIKE (@eSpaceNamePattern )) AND {Espace}.[Is_Active] = 1 AND {Espace}.[Is_System] = 0  ORDER BY @OrderBy ): Duplicate column name 'Id'
   at ssOutDoc.Flows.FlowMainFlow.ScrneSpace_List.FuncssPreparation.QueryGetEspaces(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, String qpsteSpaceNamePattern, String qpstOrderBy)
   at ssOutDoc.Flows.FlowMainFlow.ScrneSpace_List.Preparation(HeContext heContext)
   at ssOutDoc.Flows.FlowMainFlow.ScrneSpace_List.Page_Load(Object sender, EventArgs e)
   at System.Web.UI.Control.OnLoad(EventArgs e)
   at System.Web.UI.Control.LoadRecursive()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


1
0
19 Apr 2016
Copy Link
2017-09-22 09-07-17
Toni Juvani

I have the same problem with MySQL and platform version 10.0.604.0. Any luck fixing this?

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