Skip to main content
1 of 4
Manoj Singh
  • 811
  • 4
  • 10

Content Porter 2011 generating SQL connection error

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

What could be the reason, why my content portar is not able to get sql connection of my TEST server.

Manoj Singh
  • 811
  • 4
  • 10