Skip to Content (Press Enter)
2014-03-05 19-29-07
Allan Weber
117Views
5Comments
Database Migration
Question
Database
We´re try to migrate our database server to another server but after migration some of our applications were having the error below:

Generic SQL Error. Invalid object name 'master.dbo.Audit_DDL'. System.Data.SqlClient.SqlException: Invalid object name 'master.dbo.Audit_DDL'.
   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 #xVd.#f3.#9Yd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
SQL: EXEC "SIS_OUT_BD_DES"."DBO".sp_executesql N'DROP TRIGGER OSTRG_EI_114_OSUSR_4D3_CRMVISITA';
 
.
 
Exception Details:
[1] Internal Error: Generic SQL Error. Invalid object name 'master.dbo.Audit_DDL'. System.Data.SqlClient.SqlException: Invalid object name 'master.dbo.Audit_DDL'.
   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 #xVd.#f3.#9Yd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
SQL: EXEC "SIS_OUT_BD_DES"."DBO".sp_executesql N'DROP TRIGGER OSTRG_EI_114_OSUSR_4D3_CRMVISITA';
 
.
at #xVd.#f3.#9Yd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
   at #xVd.#f3.#8Yd(String eSpaceName, HEMessageArrayList warnings, Int32 eSpaceVersionId, DeployPhase phase, String uniqueId)
   at #xVd.#f3.#WYd(String eSpaceName, Int32 eSpaceVersionId, String uniqueId, String username, DeployPhase phase)
   at #xVd.#f3.#WYd(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 #xVd.#f3.#N0d.#K0d(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: Invalid object name 'master.dbo.Audit_DDL'.
   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 #xVd.#f3.#9Yd(HEMessageArrayList warnings, IDbTransaction adminTrans, Dictionary`2 schemaTransactions, String fullQuery, Int32 updateDBTimeout)
0
0
18 Nov 2013
Copy Link
2019-11-12 17-31-26
Justin James
 
MVP
Allan -

What did you do to migrate the DB? Did you follow the directions in the migration guide, or do something else?

J.Ja
0
0
19 Nov 2013
Copy Link
2014-03-05 19-29-07
Allan Weber
Justin
Thanks for reply, but forget the question, we solved this problem, it was a internal problem about a trigger that we have in all servers.
0
0
19 Nov 2013
Copy Link
2021-06-21 09-08-42
Simone
hi Justin,

Where can i find the migration guide?

Thanks

Simon
0
0
17 Sep 2015
Copy Link
2020-01-10 13-55-33
Ivo Gonçalves
Hi Simon,

You can find the technote with the migration guide in the following link:
www.outsystems.com/goto/technote-database-clone 

Kind regards,
Ivo Gonçalves
0
0
17 Sep 2015
Copy Link
2021-06-21 09-08-42
Simone
many thanks Ivo!
0
0
17 Sep 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.