How to fix invalid 'Invalid column name'

Hi,


during page event I got this error.

I found another similar issue
https://www.outsystems.com/forums/discussion/21644/how-to-fix-invalid-invalid-column-name-after-adding-a-column-in-the-table/

gave the some solution

1.Change the name

2. Set the column to not required. [yes. the column is not required]

3. Try to add another column and see if it works 

4. Try to Republish again 

5. Check Database itself [DB has the column ard]

    > The columns weren't created. This is a bit weird as attribute has been added in the Entity

6. Refreshed all dependencies. [no refers issue]

7. Check Service Center Error Log every time you do fixes


any other advise about it? outsystems version 10.0.906.0



Invalid column name 'ACCOUNTID'.
   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 OutSystems.HubEdition.DatabaseProvider.SqlServer.ExecutionService.ExecutionService.ExecuteScalar(IDbCommand cmd)
   at OutSystems.Internal.Db.Command.ExecuteScalar(String description, Boolean isApplication, Boolean skipLog, Boolean applyTransformationsToParameters)
   at OutSystems.Internal.Db.Command.ExecuteScalar(String description, Boolean isApplication, Boolean skipLog)
   at ssContactSvc.ExtendedActions.CreateOrUpdateContact(HeContext heContext, BitArray usedFields, RCContactRecord inParamSource, Int32& outParamId)
   at ssContactSvc.Actions.ActionCreateOrUpdateAccountContact(HeContext heContext, RCContactRecord inParamContactDetail, RCContactAddressRecord inParamContactAddressDetail, RLTelecomRoleInfoRecordList inParamTelecomRoleList, RLContactPreferenceInfoRecordList inParamContactPreferenceList, RLContactGiftEventInfoRecordList inParamContactGiftEventList, Boolean inParamFromExtendApp, RCContactOwnershipRecord inParamContactOwnership, Boolean inParamIsSatellite, Boolean inParamValidateContactInd, RCAcctContactRecord inParamAcctContact, Int32 inParamUserId, String inParamFromSource, Boolean inParamIsOB, Int32& outParamAccountContactId, Int32& outParamAccountContactAddressId, Boolean& outParamStatus, RLValidationInfoBeanRecordList& outParamInvalidateMessageList, Int32& outParamRelationshipUpdated)
   at ssContactSvc.Actions.ActionCreateExternalContactWithSharedEmail(HeContext heContext, Int32 inParamAccountId, String inParamFirstName, String inParamEmailAddress, String inParamMobileNum, Int32 inParamCreatedBy, DateTime inParamCreatedTime, Boolean inParamIsSharedEmail, Boolean& outParamStatus, Int32& outParamAcctContactId, RLValidationInfoBeanRecordList& outParamInvalidateMessageList, Int32& outParamRelationshipUpdated)

Hi Pengbin,

Can you show a print or something from the section were the error is? Just to gave us a little more context.


Regards,

Ricardo