Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Forge Discussions
[OutDoc] Error while loading eSpace page (eSpace_List.aspx)
Community
›
Forums
›
Forge Discussions
[OutDoc] Error while loading eSpace page (eSpace_List.aspx)
New Post
New Post
Forge Component
OutDoc
(27)
Published on 2017-12-07 by OutSystems R&D
27 votes
Published on 2017-12-07 by OutSystems R&D
- -
Posted on 2016-04-19
- -
Rank: #12
Posted on 2016-04-19
Outsystems Platform 9.1.0.10
Id:
41d75e8e-83ae-42c7-92a7-8e75b4c5ebf5
Time of Log:
2016-04-19 18:27:19
eSpace:
OutDoc
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: http://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)
Toni Juvani
Posted on 2017-08-30
Toni Juvani
Rank: #433
Posted on 2017-08-30
Solution
I have the same problem with MySQL and platform version 10.0.604.0. Any luck fixing this?
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...