none
E_CSC_SYSTEM_INTERNAL - An item with the same key has already been added.

    Question

  • We get the following error when submitting a job:

    <label class="msportalfx-text-label" data-bind="text: descriptionLabel" style="font-family:az_ea_font, wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif;line-height:normal;text-transform:uppercase;color:#2d3239;">DESCRIPTION</label>
    <label class="msportalfx-text-label" data-bind="text: resolutionLabel" style="font-family:az_ea_font, wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif;line-height:normal;text-transform:uppercase;color:#2d3239;">RESOLUTION</label>
    <label class="msportalfx-text-label" data-bind="text: detailsLabel" style="font-family:az_ea_font, wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif;line-height:normal;text-transform:uppercase;color:#2d3239;">DETAILS</label>
    
    <label class="msportalfx-text-label" data-bind="text: titleLabel" style="font-family:az_ea_font, wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif;line-height:normal;text-transform:uppercase;color:#2d3239;">ERROR</label>
    
    E_CSC_SYSTEM_INTERNAL
    <label class="msportalfx-text-label" data-bind="text: messageLabel" style="font-family:az_ea_font, wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif;line-height:normal;text-transform:uppercase;color:#2d3239;">MESSAGE</label>

    Internal error! An item with the same key has already been added.

    Anyone know what this means, and how to resolve it? 

    Friday, February 17, 2017 8:27 AM

Answers

  • I found the answer.

    We have two analytics accounts on this data lake store, one for development, and one for production. For this script we had done some development and tested this with combining with a production table, like:

    @proddata = SELECT col1, col2 FROM production.master.dbo.productionTable;

    This went fine running on the development analytics account, but fails when running on the production account.

    • Marked as answer by Helge RG Friday, February 17, 2017 9:24 AM
    Friday, February 17, 2017 9:24 AM