Forums (Obsolete)

Member

egarrison-wte - 10/18/2011 8:59:00 PM

Cannot Create site from Template

I am unable to create a Localhost site on Dev server with 6.0 code. I did a solution build, and was able to hit the site and create the database. The CMSSiteManager loads and seems to be fine. I am creating a new test site and the following output in the install. I was using the CORP. Template.

ERROR: Error during import process
Message: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_MetaFile ([MetaFileObjectID], [MetaFileObjectType], [MetaFileGroupName], [MetaFileName], [MetaFileExtension], [MetaFileSize], [MetaFileMimeType], [MetaFileBinary], [MetaFileImageWidth], [MetaFileImageHeight], [MetaFileGUID], [MetaFileLastModified], [MetaFileSiteID], [MetaFileTitle], [MetaFileDescription], [MetaFileCustomData] ) VALUES ( @MetaFileObjectID, @MetaFileObjectType, @MetaFileGroupName, @MetaFileName, @MetaFileExtension, @MetaFileSize, @MetaFileMimeType, @MetaFileBinary, @MetaFileImageWidth, @MetaFileImageHeight, @MetaFileGUID, @MetaFileLastModified, @MetaFileSiteID, @MetaFileTitle, @MetaFileDescription, @MetaFileCustomData); SELECT SCOPE_IDENTITY() AS [MetaFileID]: caused exception: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) Stack Trace: at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Dictionary`2 importedParentIDs) in c:\temp\build6.0\SOLUTION40\ImportExport\Import\ImportProvider.cs:line 2559
at CMS.CMSImportExport.ImportProvider.ImportObjectType(SiteImportSettings settings, String objectType, Boolean siteObject, TranslationHelper th, ProcessObjectEnum process, Dictionary`2 importedParentIDs) in c:\temp\build6.0\SOLUTION40\ImportExport\Import\ImportProvider.cs:line 1237
at CMS.CMSImportExport.ImportProvider.ImportObjectsData(SiteImportSettings settings) in c:\temp\build6.0\SOLUTION40\ImportExport\Import\ImportProvider.cs:line 993 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) in c:\temp\build6.0\SOLUTION40\DataProviderSQL\DataConnection.cs:line 332

ERROR: Error importing 'Page templates' objects (Article list with teasers)
Message: [DataConnection.ExecuteQuery]: Query: INSERT INTO CMS_MetaFile ([MetaFileObjectID], [MetaFileObjectType], [MetaFileGroupName], [MetaFileName], [MetaFileExtension], [MetaFileSize], [MetaFileMimeType], [MetaFileBinary], [MetaFileImageWidth], [MetaFileImageHeight], [MetaFileGUID], [MetaFileLastModified], [MetaFileSiteID], [MetaFileTitle], [MetaFileDescription], [MetaFileCustomData] ) VALUES ( @MetaFileObjectID, @MetaFileObjectType, @MetaFileGroupName, @MetaFileName, @MetaFileExtension, @MetaFileSize, @MetaFileMimeType, @MetaFileBinary, @MetaFileImageWidth, @MetaFileImageHeight, @MetaFileGUID, @MetaFileLastModified, @MetaFileSiteID, @MetaFileTitle, @MetaFileDescription, @MetaFileCustomData); SELECT SCOPE_IDENTITY() AS [MetaFileID]: caused exception: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) Stack Trace: at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) in c:\temp\build6.0\SOLUTION40\DataProviderSQL\DataConnection.cs:line 345
at CMS.DataEngine.GeneralConnection.ExecuteScalar(QueryParameters query) in c:\temp\build6.0\SOLUTION40\DataEngine\Connections\GeneralConnection.cs:line 1000
at CMS.DataEngine.GeneralConnection.ExecuteScalar(String queryName, QueryDataParameters parameters, String where, String orderBy, Int32 topN, String columns) in c:\temp\build6.0\SOLUTION40\DataEngine\Connections\GeneralConnection.cs:line 932
at CMS.DataEngine.GeneralConnection.ExecuteScalar(String queryName, QueryDataParameters parameters) in c:\temp\build6.0\SOLUTION40\DataEngine\Connections\GeneralConnection.cs:line 867
at CMS.DataEngine.SimpleDataClass.Insert(Boolean getId) in c:\temp\build6.0\SOLUTION40\DataEngine\Data\SimpleDataClass.cs:line 816
at CMS.DataEngine.SimpleDataClass.Insert() in c:\temp\build6.0\SOLUTION40\DataEngine\Data\SimpleDataClass.cs:line 799
at CMS.DataEngine.AbstractInfo`1.InsertData() in c:\temp\build6.0\SOLUTION40\DataEngine\Data\AbstractInfo.cs:line 526
at CMS.Synchronization.SynchronizedInfo`1.InsertData() in c:\temp\build6.0\SOLUTION40\CMSSynchronization\SynchronizedInfo.cs:line 94
at CMS.DataEngine.AbstractInfoProvider`2.SetInfo(InfoType info) in c:\temp\build6.0\SOLUTION40\DataEngine\Data\AbstractInfoProvider.cs:line 783
at CMS.SiteProvider.MetaFileInfoProvider.SetMetaFileInfoInternal(MetaFileInfo metaFile) in c:\temp\build6.0\SOLUTION40\SiteProvider\Metadata\MetaFileInfoProvider.cs:line 1038
at CMS.SiteProvider.MetaFileInfoProvider.UpdateMetaFiles(Int32 objectId, String objectType, Int32 siteId, DataTable filesDT, Int32 filesObjectId, LoadDataEventHandler onLoadData, Boolean logSynchronization) in c:\temp\build6.0\SOLUTION40\SiteProvider\Metadata\MetaFileInfoProvider.cs:line 403
at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, GeneralizedInfo infoObj, Boolean siteObject, DataSet ds, TranslationHelper th, Boolean updateChild, Int32 targetSiteId, ProcessObjectEnum process, Dictionary`2 importedParentIDs, List`1 postProcessList, List`1 affectedObjects, BaseInfo parentObject) in c:\temp\build6.0\SOLUTION40\ImportExport\Import\ImportProvider.cs:line 3997
at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet ds, String objectType, Boolean siteObjects, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, Dictionary`2 importedParentIDs) in c:\temp\build6.0\SOLUTION40\ImportExport\Import\ImportProvider.cs:line 2319 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at CMS.DataProviderSQL.DataConnection.ExecuteScalar(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) in c:\temp\build6.0\SOLUTION40\DataProviderSQL\DataConnection.cs:line 332

Kentico Support

kentico_jurajo - 10/19/2011 4:39:54 AM

RE:Cannot Create site from Template

Hi,

I haven't Google the error message yet, but according to the message:

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

It seems that there is a problem with connection to the SQL server, could you please check whether the SQL server is accessible and if there are no connectivity issues?

Best regards,
Juraj Ondrus

Member

egarrison-wte - 10/19/2011 9:25:46 AM

RE:Cannot Create site from Template

That is highly unlikely. The SQL is also running on this machine. Everything runs fine, but any time I do the New site from template. I am getting it. Duplicated 5 times, with different templates. I am going to blow away the database and start from scratch. Maybe something on the initial build didn't insert into the database. This is local dev, so nothing on here.


Kentico Support	kentico_jurajo - 10/20/2011 3:11:11 AM RE:Cannot Create site from Template Hi, I just Google-d the error message and one of the suggestions says to increase the connection time out - which makes sense since creating new site takes some time and there are many SQL queries executed so maybe the connection to the SQL server just timed out. Best regards, Juraj Ondrus


Member	egarrison-wte - 10/22/2011 6:29:06 PM RE:Cannot Create site from Template Juraj, You should be aware of this. Our issue is only happening on the sourcecode install. I downloaded the 6.0 (compiled) version and that installer didn't error building sites. Now, I connected the source to the database from the compiled version and it works great.

Kentico Support

kentico_jurajo - 10/23/2011 7:09:00 AM

RE:Cannot Create site from Template

Hi,

Well, I am not aware of this issue nor any other customers reported it. What you mean by source code? You mean the source code solution? Have you made any changes to the source files or any other customizations? As I was Google-ing the error in almost all cases the problem was that the connection timed out - so it seems something is wrong with your source code.

Best regards,
Juraj Ondrus