Old Forums
Search:
Bug reports
Version 3.x > Bug reports > SQL Import throwing error on different culture View modes: 
User avatar
Member
Member
dave.diehl-asg - 8/21/2008 10:32:53 AM
   
SQL Import throwing error on different culture
1st import -- imported four documents based on a simple document type that we created with three properties to a parent node that already exists. No problem. Selected to do another import.

2nd import -- same as 1st import only different culture. Throws the following error:

Unhandled Exception: [TreeSiteMapProvider.BuildSiteMap]; Root node for the site "XXXXX" not found.

User avatar
Member
Member
dave.diehl-asg - 8/21/2008 10:37:16 AM
   
RE:SQL Import throwing error on different culture
More info.

Error thrown after clicking "Select Path" on "Target alias path" dialog.

Here's the full error detail:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Exception: [TreeSiteMapProvider.BuildSiteMap]: Root node for the site 'ASGCOM' not found.
at SQLImport.SelectPath.Build()
at SQLImport.SelectPath.ReloadData()
at SQLImport.Step7TargetAliasPath.button1_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
SQLImport
Assembly Version: 3.1.3078.15602
Win32 Version: 3.1.3078.15602
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/SQLImport.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
CMS.SiteProvider
Assembly Version: 3.1.3078.15518
Win32 Version: 3.1.3078.15518
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.SiteProvider.DLL
----------------------------------------
CMS.DataEngine
Assembly Version: 3.1.3078.15512
Win32 Version: 3.1.3078.15512
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.DataEngine.DLL
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
CMS.IDataConnectionLibrary
Assembly Version: 3.1.3078.15497
Win32 Version: 3.1.3078.15497
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.IDataConnectionLibrary.DLL
----------------------------------------
CMS.SettingsProvider
Assembly Version: 3.1.3078.15510
Win32 Version: 3.1.3078.15510
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.SettingsProvider.DLL
----------------------------------------
CMS.DataProviderSQL
Assembly Version: 3.1.3078.15551
Win32 Version: 3.1.3078.15551
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.DataProviderSQL.DLL
----------------------------------------
CMS.GlobalHelper
Assembly Version: 3.1.3078.15511
Win32 Version: 3.1.3078.15511
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.GlobalHelper.DLL
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
CMS.GlobalEventHelper
Assembly Version: 3.1.3078.15512
Win32 Version: 3.1.3078.15512
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.GlobalEventHelper.DLL
----------------------------------------
CMS.Staging
Assembly Version: 3.1.3078.15515
Win32 Version: 3.1.3078.15515
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.Staging.DLL
----------------------------------------
CMS.LicenseProvider
Assembly Version: 3.1.3078.15516
Win32 Version: 3.1.3078.15516
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.LicenseProvider.DLL
----------------------------------------
CMS.TreeEngine
Assembly Version: 3.1.3078.15523
Win32 Version: 3.1.3078.15523
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.TreeEngine.DLL
----------------------------------------
CMS.ResourceManager
Assembly Version: 3.1.3078.15511
Win32 Version: 3.1.3078.15511
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.ResourceManager.DLL
----------------------------------------
CMS.EmailProvider
Assembly Version: 3.1.3078.15514
Win32 Version: 3.1.3078.15514
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.EmailProvider.DLL
----------------------------------------
CMS.IEmailEngine
Assembly Version: 3.1.3078.15513
Win32 Version: 3.1.3078.15513
CodeBase: file:///D:/Program%20Files/KenticoCMS/3.1/SQLImport/CMS.IEmailEngine.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 8/22/2008 4:57:38 AM
   
RE:SQL Import throwing error on different culture
Hello,

I have tried to reproduce your issue and I have found out that this error occurs unless the root exist in this culture.
Could you please check it in your CMS Desk? Unless the root in this culture is set (there is a small cross near the name of root), could you please copy the content from another language and try the import again?

Best regards,
Helena Grulichova

User avatar
Member
Member
dave.diehl-asg - 8/22/2008 11:53:41 AM
   
RE:SQL Import throwing error on different culture
As I said in my original post ("to a parent node that already exists"), the root existed in both cultures.
User avatar
Kentico Developer
Kentico Developer
kentico_helenag - 8/28/2008 7:57:32 AM
   
RE:SQL Import throwing error on different culture
Hello,

thank you for your cooperation.
Unfortunately, I am not able to reproduce your issue to get the same error. Could you please send us an export of your site, 'SQLImport.exe.config' and some other details as you can to support@kentico.com?

Best regards
Helena Grulichova

Top