666
Views
2
Comments
How to fix invalid 'Invalid column name' 
Question

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)

2021-03-05 13-56-11
Ricardo Pereira
 
MVP

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

2019-07-05 10-57-41
Nikhil Purohit

Hi Pengbin,

Is the database an External DB or is it Outsystems DB?

Regards,
Nikhil


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.