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)