eSpace Publishing Error

eSpace Publishing Error

  
I'm trying to publish an eSpace but keep getting the following error message and I'm not sure what I need to do to correct it. I've attached a copy of the eSpace.


---
Publishing Error
 
Unable to upgrade database schema. Error trying to change database field 'OSUSR_2tw_PM_PropertyManager.NAME' type (New Def: INT; DB Def: NVARCHAR(50)).
 
Exception: Conversion failed when converting the nvarchar value 'Nouman Mirza' to data type int.
The statement has been terminated.
 
SQL: ALTER TABLE "OUTSYSTEMS"."DBO"."OSUSR_2TW_PM_PROPERTYMANAGER" DROP CONSTRAINT DF__OSUSR_2TW___NAME__7A47FDD8;
 
alter table "OUTSYSTEMS"."DBO"."OSUSR_2TW_PM_PROPERTYMANAGER" alter column "NAME" INT;
alter table "OUTSYSTEMS"."DBO"."OSUSR_2TW_PM_PROPERTYMANAGER" add constraint DF_93b1c39a_6a5e_4690_b1db_d3de14748528 DEFAULT NULL FOR "NAME";
 
 
Exception Details:
[1] Publishing Error: Unable to upgrade database schema. Error trying to change database field 'OSUSR_2tw_PM_PropertyManager.NAME' type (New Def: INT; DB Def: NVARCHAR(50)).
 
Exception: Conversion failed when converting the nvarchar value 'Nouman Mirza' to data type int.
The statement has been terminated.
 
SQL: ALTER TABLE "OUTSYSTEMS"."DBO"."OSUSR_2TW_PM_PROPERTYMANAGER" DROP CONSTRAINT DF__OSUSR_2TW___NAME__7A47FDD8;
 
alter table "OUTSYSTEMS"."DBO"."OSUSR_2TW_PM_PROPERTYMANAGER" alter column "NAME" INT;
alter table "OUTSYSTEMS"."DBO"."OSUSR_2TW_PM_PROPERTYMANAGER" add constraint DF_93b1c39a_6a5e_4690_b1db_d3de14748528 DEFAULT NULL FOR "NAME";
 
at #4gd.#eY.#Hkd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
   at #4gd.#eY.#Gkd(String eSpaceName, Int32 eSpaceVersionId, IEnumerable`1 mainUpdateFiles, IEnumerable`1 optionalUpdateFiles, HEMessageArrayList warnings)
   at #4gd.#eY.#vkd(String eSpaceName, Int32 eSpaceVersionId, String uniqueId)
   at #4gd.#eY.#vkd(ICompilerContext context, String eSpaceName, Int32 eSpaceVersionId, String uniqueId)
   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.PrivateProcessMessage(RuntimeMethodHandle 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.StackBuilderSink.SyncProcessMessage(IMessage msg)
   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.DispatchChannelSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at System.Runtime.Remoting.Channels.BinaryServerFormatterSink.ProcessMessage(IServerChannelSinkStack sinkStack, IMessage requestMsg, ITransportHeaders requestHeaders, Stream requestStream, IMessage& responseMsg, ITransportHeaders& responseHeaders, Stream& responseStream)
   at #4gd.#eY.#rmd.#omd(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.RequestQueue.ProcessNextRequest(SocketHandler sh)
   at System.Runtime.Remoting.Channels.SocketHandler.BeginReadMessageCallback(IAsyncResult ar)
   at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
   at System.Net.ContextAwareResult.CompleteCallback(Object state)
   at System.Threading.ExecutionContext.runTryCode(Object userData)
   at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   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: Conversion failed when converting the nvarchar value 'Nouman Mirza' to data type int.
The statement has been terminated.
   at OutSystems.HubEdition.RuntimePlatform.DBHelper.#Y5(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, 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 #4gd.#eY.#Hkd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
The error-message tells me that you changed an attribute from a string to an integer.
This would be a problem if the columns is already filled with data.

Try deleting all data first and then publish the new espace.
or make that column empty
That worked.  I kept deleting the record from the Users eSpace rather than deleting it from the actual eSpace.  Thanks a bunch!


Joost Landgraf wrote
:
The error-message tells me that you changed an attribute from a string to an integer.
This would be a problem if the columns is already filled with data.

Try deleting all data first and then publish the new espace.
or make that column empty