I am experiencing this issue as well however the solution above does not seem to work for me.
Platform Version: 10.0.705.0
Development Environment: 10.0.810.0
I have an aggregate "GetRPUserById" which is very simple and just returns a "RP_User" entity by its ID. This same aggregate exists elsewhere and it randomly throws the following error throughout the application:
Invalid column name 'PASSWORD_EXPIRATION'.
Invalid column name 'FAILED_COUNT'.
Invalid column name 'DATE_CREATED'.
Invalid column name 'LAST_LOGIN'.
These columns do not exist on this entity, however they do exist on a "t_rp_user" entity that is exposed to a core service module via an extension. This entity is NOT however used in the consumer espace where the error is always thrown. Again, this occurs randomly in some parts however this page "User_Edit" it occurs consistently.
Here is the complete stack trace:
Invalid column name 'PASSWORD_EXPIRATION'.
Invalid column name 'FAILED_COUNT'.
Invalid column name 'DATE_CREATED'.
Invalid column name 'LAST_LOGIN'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at OutSystems.HubEdition.DatabaseProvider.SqlServer.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)
at #Hmb.#Qmb.ExecuteReader(String description, Boolean isApplication, Boolean transformParameters, Boolean skipLog)
at OutSystems.Internal.Db.DatabaseAccessProvider`1.ExecuteQuery[T](Command cmd, GenericRecordList`1 rl, String description, Boolean transformParameters, Boolean skipLog)
at OutSystems.Internal.Db.DatabaseAccessProvider`1.ExecuteQuery[T](Command cmd, GenericRecordList`1 rl, String description)
at ssgemRetailerCore.Flows.FlowAdmin.ScrnUser_Edit.FuncssPreparation.datasetGetRPUserById(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, Int64 qploId)
at ssgemRetailerCore.Flows.FlowAdmin.ScrnUser_Edit.Preparation(HeContext heContext)
at ssgemRetailerCore.Flows.FlowAdmin.ScrnUser_Edit.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)