Getting "The remote server returned an error: (409) Conflict." when trying to add rows into azure table

Question

I am trying to upload azure table row using PowerShell and I am receiving the below error. Could this be due to wrong Azure Storage powershell modules? I am using Azure.Storage 4.0.2 module.

Below is the Code:

# Getting all the resource group
$resource_group_list = Get-AzureRmResourceGroup

# Iterating through the resource group
foreach($resource_group_list_iterator in $resource_group_list){

    # Since the solution applies for virtual machines,
    # obtain the list of virtual machines for the resource group
    $virtual_machine_list = get-azurermvm -ResourceGroupName $resource_group_list_iterator.ResourceGroupName

    # Proceed only when resource group contains virtual machines
    if(!($virtual_machine_list -eq $null)){

        # Iterate through the virtual machine list
        foreach($virtual_machine_list_iterator in $virtual_machine_list){

            # Creat an unique ID by concatinating 'Resource Group name' and 'Virtual Machine name'
            $unique_id = $resource_group_list_iterator.ResourceGroupName + "__" + $virtual_machine_list_iterator.name
            Write-Host $unique_id

            # Obtain the tags associated with the virtual machines
            $virtual_machine_tags = (get-azurermvm -ResourceGroupName $resource_group_list_iterator.ResourceGroupName -Name $virtual_machine_list_iterator.name).Tags

            # Iterate over the tags to match the tag that we are looking for
            foreach($tag_iterator in $virtual_machine_tags){
    if($tag_iterator.keys -eq 'owner' -and $tag_iterator.values -eq 'ibm'){

        # Store the tags in a variable to later store it in Azure table
        $virtual_machine_tag = $tag_iterator.keys.ToString()
        $virtual_machine_value = $tag_iterator.Values.ToString()


        $partitionKey1 = $unique_id
        if($virtual_machine_tag -eq $null) {$virtual_machine_tag = $null}
        if($virtual_machine_value -eq $null) {$virtual_machine_value = $null}

    $hash = @{}
    $hash.Add('uniqueid',$unique_id)
    $hash.Add('key',$virtual_machine_tag)
    $hash.add('value',$virtual_machine_value)

    Add-StorageTableRow `
    -table $azure_table_object `
    -partitionKey $partitionKey1 `
    -rowKey ("CA") `
     -property $hash

        #Write-Output "Key: " $tag_iterator.keys
        #Write-Output "Value: " $tag_iterator.Values
    }
}


            #Write-Host "Tags: " $virtual_machine_tags
            #Write-Host " "
        }


    }


}

Below is the exception that I received:

Exception calling "Execute" with "1" argument(s): "The remote server returned an 
error: (409) Conflict."
At C:\Program Files\WindowsPowerShell\Modules\AzureRmStorageTable\1.0.0.21\AzureRmS
torageTableCoreHelper.psm1:267 char:16
+ ...      return ($table.CloudTable.Execute((invoke-expression "[Microsoft ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
    + FullyQualifiedErrorId : StorageException

I have gone thru few online resources on how to troubleshoot, but I did not get any solution.

Answer 1

As junnas mentioned that 409 error means that add a row with same partition key and row key as existing row.

You could print the partition Key and row key before insert into the table.If want to get the unique_id we could use the Guid, please have a try to use $unique_id = $resource_group_list_iterator.ResourceGroupName + "__" + $virtual_machine_list_iterator.name+[guid]::newguid()

Note: In your case, I suggest that you could use the vaule CA as partion key and $unique_id as rowkey.