none
Unable to create tables in Azure Storage

    Question

  • I created storage account "growhot01" (not blob-only). Then tried to create a table, but this seems to be broken. When I try to create a table using Azure Storage Explorer (version 0.8.6), it crashes.

    Azure Storage Explorer crashes when I try to create a new table

    I also tried creating a pipeline in DataFactory using the wizard and Azure Table Storage as destination. The wizard page hangs.

    Wizard hangs when I enter new table name and click Next

    Anyone know what might be the cause of this?


    Andreas de Ruiter (Microsoft)

    Monday, November 21, 2016 9:26 PM

Answers

  • Hi Andreas,

     

    General-purpose Storage Account has two performance tiers, standard storage performance tier and premium storage performance tier. And a premium storage performance tier which currently only supports Azure virtual machine disks, does not support Table service. For more information about Azure Premium Storage, please read this documentation.


    Wednesday, November 23, 2016 1:59 AM

All replies

  • Hi Andreas,

    Thanks for posting here!

    Please go through the sample C# code in this link for creating an Azure Table while we check your error with our internal teams.

    Regards.
    Md. Shihab

    Tuesday, November 22, 2016 4:32 AM
  • Hi - thanks for your help. I ran the C# code, and it seems to hang on the table.CreateIfNotExists() call. After a while it times out with an exception as shown below. 

    Microsoft.WindowsAzure.Storage.StorageException was unhandled
      HResult=-2146233088
      Message=The remote name could not be resolved: 'growhot01.table.core.windows.net'
      Source=Microsoft.WindowsAzure.Storage
      StackTrace:
           at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext) in c:\Program Files (x86)\Jenkins\workspace\release_dotnet_master\Lib\ClassLibraryCommon\Core\Executor\Executor.cs:line 604
           at Microsoft.WindowsAzure.Storage.Table.TableOperation.Execute(CloudTableClient client, CloudTable table, TableRequestOptions requestOptions, OperationContext operationContext) in c:\Program Files (x86)\Jenkins\workspace\release_dotnet_master\Lib\ClassLibraryCommon\Table\TableOperation.cs:line 41
           at Microsoft.WindowsAzure.Storage.Table.CloudTable.Exists(Boolean primaryOnly, TableRequestOptions requestOptions, OperationContext operationContext) in c:\Program Files (x86)\Jenkins\workspace\release_dotnet_master\Lib\ClassLibraryCommon\Table\CloudTable.cs:line 1609
           at Microsoft.WindowsAzure.Storage.Table.CloudTable.CreateIfNotExists(TableRequestOptions requestOptions, OperationContext operationContext) in c:\Program Files (x86)\Jenkins\workspace\release_dotnet_master\Lib\ClassLibraryCommon\Table\CloudTable.cs:line 1025
           at CreateTableStorage.Program.Main(String[] args) in c:\users\aruiter\documents\visual studio 2015\Projects\CreateTableStorage\CreateTableStorage\Program.cs:line 21
           at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
           at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
           at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
           at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
           at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
           at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
           at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
           at System.Threading.ThreadHelper.ThreadStart()
      InnerException: 
           HResult=-2146233079
           Message=The remote name could not be resolved: 'growhot01.table.core.windows.net'
           Source=System
           StackTrace:
                at System.Net.HttpWebRequest.GetResponse()
                at Microsoft.WindowsAzure.Storage.Core.Executor.Executor.ExecuteSync[T](RESTCommand`1 cmd, IRetryPolicy policy, OperationContext operationContext) in c:\Program Files (x86)\Jenkins\workspace\release_dotnet_master\Lib\ClassLibraryCommon\Core\Executor\Executor.cs:line 695
           InnerException: 

    Regards,

    Andreas


    Andreas de Ruiter (Microsoft)

    Tuesday, November 22, 2016 8:44 AM
  • The remote name could not be resolved: 'growhot01.table.core.windows.net'

    Hi Andreas,

    Please make sure whether your account name is “growhot01” on Azure portal, if you provide an incorrect or unavailable account name, which could return this error while you access the storage service in your code. And I’d like to know whether other services (blob, queue etc) are available. Besides, what is the geographic location you selected for your storage account? You could try to create a new Azure Storage account with different geographic location and test whether same issue will appear while you create a table. Perhaps something wrong with table service in that region at this moment.


    Tuesday, November 22, 2016 11:05 AM
  • hi - I'm sure this is the right name. I was able to create a Blob storage container - this name does exist: https://growhot01.blob.core.windows.net. I can send you the account key if you wish.

    See screenshot below with storage account details:


    Andreas de Ruiter (Microsoft)

    Tuesday, November 22, 2016 11:16 AM
  • I did a bit more research. Seems that whenever I create a General Purpose Premium storage account, the new storage account only supports blobs. I tested this in two regions (West Europe and US West).

    When I create a General Purpose Standard storage account, table storage does work as expected.

    Am I wrong in thinking that General Purpose storage accounts should always support table storage?


    Andreas de Ruiter (Microsoft)

    Tuesday, November 22, 2016 6:15 PM
  • Hi Andreas,

     

    General-purpose Storage Account has two performance tiers, standard storage performance tier and premium storage performance tier. And a premium storage performance tier which currently only supports Azure virtual machine disks, does not support Table service. For more information about Azure Premium Storage, please read this documentation.


    Wednesday, November 23, 2016 1:59 AM
  • Hi Fred - thanks for your reply, I marked it as an answer.

    Based on this thread I posted a bug for the Azure Portal here: https://social.msdn.microsoft.com/Forums/en-US/cf6cd0f6-7fd9-4bd2-ad46-9e06a86296dd/portal-lets-you-create-a-generic-purpose-storage-account-in-premium-performance-tier-invalid?forum=windowsazuremanagement

    I will also report a bug for Microsoft Azure Storage Explorer.


    Andreas de Ruiter (Microsoft)

    Wednesday, November 23, 2016 8:47 AM