Problem on publishing

Problem on publishing

  
Hi, I'm getting this error above when trying to publish my eSpace:

Publishing Error
 
Unable to upgrade database schema. Error trying to create index on database table 'OSUSR_ne5_ImovelPessoa' over fields '"IMOVELVISTORIAID"'.
Exception: Column name 'IMOVELVISTORIAID' does not exist in the target table or view.
SQL: CREATE INDEX "OSIDX_OSUSR_NE5_IMOVELPESSOA_16IMOVELVISTORIAID" 
 ON dbo."OSUSR_NE5_IMOVELPESSOA" ("IMOVELVISTORIAID");
 
 
Exception Details:
[1] Publishing Error: Unable to upgrade database schema. Error trying to create index on database table 'OSUSR_ne5_ImovelPessoa' over fields '"IMOVELVISTORIAID"'.
Exception: Column name 'IMOVELVISTORIAID' does not exist in the target table or view.
SQL: CREATE INDEX "OSIDX_OSUSR_NE5_IMOVELPESSOA_16IMOVELVISTORIAID" 
 ON dbo."OSUSR_NE5_IMOVELPESSOA" ("IMOVELVISTORIAID");
 
at #sVd.#f3.#4Yd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
   at #sVd.#f3.#3Yd(String eSpaceName, HEMessageArrayList warnings, Int32 eSpaceVersionId, DeployPhase phase, String uniqueId)
   at #sVd.#f3.#RYd(String eSpaceName, Int32 eSpaceVersionId, String uniqueId, String username, DeployPhase phase)
   at #sVd.#f3.#RYd(ICompilerContext context, String eSpaceName, Int32 eSpaceVersionId, String uniqueId, String username, DeployPhase phase)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)
   at System.Runtime.Remoting.Messaging.ServerObjectTerminatorSink.SyncProcessMessage(IMessage reqMsg)
   at System.Runtime.Remoting.Messaging.ServerContextTerminatorSink.SyncProcessMessage(IMessage reqMsg)
   at System.Runtime.Remoting.Channels.CrossContextChannel.SyncProcessMessageCallback(Object[] args)
   at System.Runtime.Remoting.Channels.ChannelServices.DispatchMessage(IServerChannelSinkStack sinkStack, IMessage msg, IMessage& replyMsg)
   at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at #sVd.#f3.#I0d.#F0d(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at System.Runtime.Remoting.Channels.Tcp.TcpServerTransportSink.ServiceRequest(Object state)
   at System.Runtime.Remoting.Channels.SocketHandler.ProcessRequestNow()
   at System.Runtime.Remoting.Channels.SocketHandler.BeginReadMessageCallback(IAsyncResult ar)
   at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Net.ContextAwareResult.Complete(IntPtr userToken)
   at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
   at System.Net.Sockets.BaseOverlappedAsyncResult.CompletionPortCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
   at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
[2] System.Data.SqlClient.SqlException: Column name 'IMOVELVISTORIAID' does not exist in the target table or view.
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#Wab(DbException e, IDbTransaction trans)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQueryDontCleanParameters(IDbCommand cmd, String description, Boolean isApplication, Boolean skipLog)
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.ExecuteNonQuery(IDbCommand cmd)
   at OutSystems.HubEdition.DeploymentController.DBCompilerService.ExecuteInlineStatementWithTimeout(IDbTransaction tran, String statement, Int32 timeout)
   at #sVd.#f3.#4Yd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)

  Imovel Entity

Can anyone help me, please?
 
Hi Rogerio,

Double click the ImovelPessoa, then on the Indexes tab select AutoIndex_ImovelVistoriaId and delete it.
That should fix it.

Any idea what you did related with the table/index to get it like that?

Regards,
João Rosado
Thank you João. That works fine. I'm newbie on the Platform and i have no idea how i got this issue.