Hi,

Really weird, Anything in the logfiles. CMSImport always logs in case of an error. Did you point to a url or did you upload?

Thanks,

Richard

Thanks Richard,
Yes there are a couple of errors in there. References to media files that are missing from the upload folders in the wwwroot. I can't see anything in there that might cause a 502 though?

Thanks,

Ben

2013-08-28 14:02:00,687 [18] INFO  umbraco.cms.businesslogic.web.Document - [Thread 58] New document 1539
2013-08-28 14:02:02,252 [18] INFO  Umbraco.Core.Publishing.PublishingStrategy - [Thread 58] Content '13-355-A3 - TNC Front Mount Bulkhead Solder Jack ( 2 Flats )' with Id '1539' has been unpublished.
2013-08-28 14:02:02,956 [18] INFO  umbraco.BusinessLogic.Log - [Thread 93] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: 0 | Comment: CMSImport: A record failed to import for aliasdL2dataSheets error:System.IO.FileNotFoundException: Could not find file 'C:\DWASFiles\Sites\umcoax\VirtualDirectory0\site\wwwroot\Data Sheets\13-355-A3.pdf'.
File name: 'C:\DWASFiles\Sites\umcoax\VirtualDirectory0\site\wwwroot\Data Sheets\13-355-A3.pdf'
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.File.GetAttributes(String path)
   at CMSImportLibrary.Helpers.MediaImportHelper.ImportMedia(Object value, AdvancedSettingFieldOptions advancedFieldOptions, Int32 mediaParentLocation)
   at CMSImportLibrary.AdvancedSettings.Data.MediaPickerSettingsData.Parse(Object value, AdvancedSettingFieldOptions fieldOptions, Property property)
   at CMSImportLibrary.Import.AdvancedSettingsParser.Parse(Object , String , AdvancedSettingFieldOptions , Property , Dictionary`2 )
   at CMSImportLibrary.Import.ContentImporter.(Guid , ImportActions , Document , Dictionary`2 , FieldAdapterOptions , AdvancedSettingFieldOptions , String , Object  , Boolean  )
   at CMSImportLibrary.Import.ContentImporter.(ImportState , User , ImportStatistics , String , Int32 , String )
2013-08-28 14:02:04,409 [18] INFO  umbraco.cms.businesslogic.web.Document - [Thread 58] New document 1540
2013-08-28 14:02:07,099 [18] INFO  Umbraco.Core.Publishing.PublishingStrategy - [Thread 58] Content '13-500-A3 - TNC Straight Jack to Jack Adaptor' with Id '1540' has been unpublished.
2013-08-28 14:02:07,710 [18] INFO  umbraco.BusinessLogic.Log - [Thread 101] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: -1 | Comment: [UmbracoExamine] (ExternalIndexer)Index is being optimized
2013-08-28 14:02:07,850 [18] INFO  umbraco.BusinessLogic.Log - [Thread 93] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Error | User: 0 | NodeId: 0 | Comment: CMSImport: A record failed to import for aliasproductImage3 error:System.IO.FileNotFoundException: Could not find file 'C:\DWASFiles\Sites\umcoax\VirtualDirectory0\site\wwwroot\tnc\13-500-a3-img3.jpg'.
File name: 'C:\DWASFiles\Sites\umcoax\VirtualDirectory0\site\wwwroot\tnc\13-500-a3-img3.jpg'
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.File.GetAttributes(String path)
   at CMSImportLibrary.Helpers.MediaImportHelper.ImportMedia(Object value, AdvancedSettingFieldOptions advancedFieldOptions, Int32 mediaParentLocation)
   at CMSImportLibrary.AdvancedSettings.Data.MediaPickerSettingsData.Parse(Object value, AdvancedSettingFieldOptions fieldOptions, Property property)
   at CMSImportLibrary.Import.AdvancedSettingsParser.Parse(Object , String , AdvancedSettingFieldOptions , Property , Dictionary`2 )
   at CMSImportLibrary.Import.ContentImporter.(Guid , ImportActions , Document , Dictionary`2 , FieldAdapterOptions , AdvancedSettingFieldOptions , String , Object  , Boolean  )
   at CMSImportLibrary.Import.ContentImporter.(ImportState , User , ImportStatistics , String , Int32 , String )


THEN:


2013-08-28 14:02:24,023 [18] INFO  umbraco.BusinessLogic.Log - [Thread 47] Redirected log call (please use Umbraco.Core.Logging.LogHelper instead of umbraco.BusinessLogic.Log) | Type: Custom | User: 0 | NodeId: 0 | Comment: Import DatasourceAlias:Csv ended

No real issues in the log indeed. I've just googled for the 502 errorcode, could be anything. Is it already during upload or only when importing? Are you using a clustured environment?

In case of upload could you try to use the url function? Point the csv file to a url instead of importing?

Thanks,

Richard

Hi,

I guess tha Windows Azure - as a cloud solution - is clustered for performance and resilience but maybe not in a conventional loadbalanced / failover way.

The import "progress bar" appeared for quite some time - maybe 3 minutes or more - it was after this that the 502 appeared.

Not sure if that sheds any light on things at all.

I will try the suggestions you provided re: uploading the CSV to the web server and using the URL option then report back.

Best wishes

Ben

is working on a reply...