Yikes. :\ From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Mike MOSSuMS Stringfellow Sent: Tuesday, 8 November 2011 4:28 PM To: ozmoss@ozmoss.com Subject: RE: Import error - guidance on troubleshooting please.
Ok - it looks like this actual 2010 install is FUBAR, as the import works fine on my dev environment and there are a variety of error in the logs, including this from nasty from SQL when importing the list: Unknown SQL Exception 206 occurred. Additional error information from SQL Server is included below. Operand type clash: datetime is incompatible with uniqueidentifier A re-run of the config wizard, and a repair, both gave this message (WEBCONFIG.ACCSRV.XML file is identical to one on my 'nilla dev sp2010): An exception of type System.IO.InvalidDataException was thrown. Additional exception information: The web configuration file, C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\config\WEBCONFIG.ACCSRV.XML, does not have element "configuration/configSections/sectionGroup[@name='SharePoint']" or it is invalid. Next steps will be a reboot and then a complete reinstall, unless there are some other ideas? ________________________________ From: mike_stringfel...@hotmail.com To: ozmoss@ozmoss.com Subject: RE: Import error - guidance on troubleshooting please. Date: Tue, 8 Nov 2011 10:06:39 +0800 Many thanks for your help Paul and Matthew Definately sounds like we are all thinking the same way as I've checked those things. Pach level was fine as it's been moved to the same farm - however missing feature references etc in the content, as it originally came from 2007 and was then upgraded, is a distinct possibility. We've also tried without identity, security, versions and dependecies - same darn com error. It's an RTM 2010, so I'm just investigating if there have been any import/export/content migration fixes making SP1 + Oct CU worthwhile - none i can see so far. However, if there is some sort of server issue an upgrade may be worthwhile. The GL command didn't help, as it does exactly the same stuff under the skin, so threw the same unhelpfull error. I'll have a look at the Chris O'Brian content migration wizard next. ________________________________ From: paul.no...@ceosyd.catholic.edu.au To: ozmoss@ozmoss.com Date: Tue, 8 Nov 2011 09:16:22 +1100 Subject: RE: Import error - guidance on troubleshooting please. I'd start by ditching dependencies and security on the export and see if it will import OK. From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Mike MOSSuMS Stringfellow Sent: Monday, 7 November 2011 6:10 PM To: ozmoss@ozmoss.com Subject: Import error - guidance on troubleshooting please. Any advice on the quickest way to trouble-shoot the below error when importing a list that was exported from a different farm? Are the ULS logs the place to start, or does the import show all the info available to stdout? Or does anyone recommend a tool or technique that gives generally better rsults/insights that the standard import/export - e.g. gl-exportlist and gl-importlist? In anticipation, thanks for your help! export-spweb -IDENTITY http://OldSiteURL<http://oldsiteurl/> -ITEMURL "OldListURL" -PATH c:\temp\export.cmp -FORCE -INCLUDEUSERSECURITY -INCLUDEVERSIONS 4 import-spweb -IDENTITY https://NewSiteURL<https://newsiteurl/> -PATH c:\temp\export.cmp -FORCE -INCLUDEUSERSECURITY -UPDATEVERSIONS OVERWRITE -VERBOSE [7/11/2011 10:29:14 AM] [List] [ListName] Progress: Importing [7/11/2011 10:29:14 AM] [List] [ListName] ExtendedVerbose: Creating [7/11/2011 10:29:14 AM] [List] [ER.BusinessUnits] Error: An unexpected error has occurred. [7/11/2011 10:29:14 AM] [List] [ER.BusinessUnits] Debug: at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.CreateListOnImport(String bstrUrl, Guid& pguidListId, String bstrTitle, String bstrDescription, Int32 lTemplateID, String bstrFeatureId, Guid guidRootFolderId, Int64 llFlags, Int32 iVersion, Int32 iAuthor, String bstrFields, String bstrContentTypes, String bstrImageUrl, String bstrEventSinkAssembly, String bstrEventSinkClass, String bstrEventSinkData, Guid guidDocTemplateId, String bstrViews, String bstrForms, Boolean bCompressedSchema, DateTime dtTimeCreated) at Microsoft.SharePoint.Deployment.ListSerializer.CreateList(SPWeb parentWeb, Dictionary`2 listMetaData, Boolean usingPublicSchema) at Microsoft.SharePoint.Deployment.ListSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector) at Microsoft.SharePoint.Deployment.XmlFormatter.CallSetObjectData(Object obj, SerializationInfo objectData, ISerializationSurrogate surrogate, ISurrogateSelector selector) [7/11/2011 10:29:14 AM] FatalError: An unexpected error has occurred. [7/11/2011 10:29:14 AM] Debug: at Microsoft.SharePoint.SPGlobal.HandleComException(COMException comEx) at Microsoft.SharePoint.Library.SPRequest.CreateListOnImport(String bstrUrl, Guid& pguidListId, String bstrTitle, String bstrDescription, Int32 lTemplateID, String bstrFeatureId, Guid guidRootFolderId, Int64 llFlags, Int32 iVersion, Int32 iAuthor, String bstrFields, String bstrContentTypes, String bstrImageUrl, String bstrEventSinkAssembly, String bstrEventSinkClass, String bstrEventSinkData, Guid guidDocTemplateId, String bstrViews, String bstrForms, Boolean bCompressedSchema, DateTime dtTimeCreated) at Microsoft.SharePoint.Deployment.ListSerializer.CreateList(SPWeb parentWeb, Dictionary`2 listMetaData, Boolean usingPublicSchema) at Microsoft.SharePoint.Deployment.ListSerializer.SetObjectData(Object obj, SerializationInfo info, StreamingContext context, ISurrogateSelector selector) at Microsoft.SharePoint.Deployment.XmlFormatter.CallSetObjectData(Object obj, SerializationInfo objectData, ISerializationSurrogate surrogate, ISurrogateSelector selector) at Microsoft.SharePoint.Deployment.XmlFormatter.ParseObject(Type objectType, Boolean isChildObject) at Microsoft.SharePoint.Deployment.XmlFormatter.DeserializeObject(Type objectType, Boolean isChildObject, DeploymentObject envelope) at Microsoft.SharePoint.Deployment.XmlFormatter.Deserialize(Stream serializationStream) at Microsoft.SharePoint.Deployment.ObjectSerializer.Deserialize(Stream serializationStream) at Microsoft.SharePoint.Deployment.SPImport.DeserializeObjects() at Microsoft.SharePoint.Deployment.SPImport.Run() [7/11/2011 10:29:14 AM] Progress: Import did not complete. [7/11/2011 10:29:14 AM] Finish Time: 7/11/2011 10:29:14 AM. [7/11/2011 10:29:14 AM] Duration: 00:01:39 [7/11/2011 10:29:14 AM] Finished with 0 warnings. [7/11/2011 10:29:14 AM] Finished with 2 errors. _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com<mailto:ozmoss@ozmoss.com> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss _______________________________________________ ozmoss mailing list ozmoss@ozmoss.com<mailto:ozmoss@ozmoss.com> http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
