I am getting below error while I am trying to content porter from my DEVtridion to TEST tridion.
Unable to save Publication (tcm:0-230-1).
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Error Code:
0x8004033F (-2147220673)
Call stack:
System.Data.SqlClient.SqlConnection.OnError(SqlException,Boolean)
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException,Boolean)
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
System.Data.SqlClient.TdsParser.Run(RunBehavior,SqlCommand,SqlDataReader,BulkCopySimpleResultSet,TdsParserStateObject)
System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
System.Data.SqlClient.SqlDataReader.get_MetaData()
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader,RunBehavior,String)
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior,RunBehavior,Boolean,Boolean)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior,RunBehavior,Boolean,String,DbAsyncResult)
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior,RunBehavior,Boolean,String)
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior,String)
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior)
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior)
Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ExecuteReader(StoredProcedureInvocation,CommandBehavior)
Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.ExecuteReader(StoredProcedureInvocation,CommandBehavior)
Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ExecuteReader(StoredProcedureInvocation)
Tridion.ContentManager.Data.AdoNet.Sql.SqlDatabaseUtilities.ExecuteReader(StoredProcedureInvocation)
Tridion.ContentManager.Data.AdoNet.ContentManagement.RepositoryDataMapper.Tridion.ContentManager.Data.ContentManagement.IRepositoryDataMapper.FindBlueprintConflicts(TcmUri,IEnumerable`1)
Tridion.ContentManager.ContentManagement.Repository.AssertBlueprintConflicts()
Tridion.ContentManager.ContentManagement.Repository.OnSaved(SaveEventArgs)
Tridion.ContentManager.CommunicationManagement.Publication.OnSaved(SaveEventArgs)
Tridion.ContentManager.IdentifiableObject.Save(SaveEventArgs)
Tridion.ContentManager.IdentifiableObject.Save()
Tridion.ContentManager.BLFacade.IdentifiableObjectFacade.Update(UserContext,String)
XMLState.Save
Publication.Save
If I see content portar logs, I can find these:
<tcm:Line ErrorCode="8004033F" Cause="true">
<![CDATA[Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]]>
</tcm:Line>
<tcm:Line ErrorCode="8004033F" Cause="false">
<![CDATA[A database error occurred while executing Stored Procedure "EDA_PUBLICATIONS_FINDBPCONFLICTS".]]>
<tcm:Token>EDA_PUBLICATIONS_FINDBPCONFLICTS</tcm:Token>
</tcm:Line>
What could be the reason, why my content portar is not able to get sql connection of my TEST server, however same package is going perfectly on my LIVE Tridion.