Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Unable to map column of type 16513

I am receiving an error when using the command
Exec SF_Bulkops 'upsert:bulkapi,batchsize(4000)', 'SFDC_QA', 'Account_Load', 'Acct_Ext_ID__c'.

The error I am receiving is "Unable to map column Name of type 16513"

I have attempted multiple solutions and this fails on the first record listed in my table. If i reorder the columns, it still fails on whatever column is defined first. All columns are currently defined as nvarchars of various lengths.

Any idea on this, as it is causing a critical delay?

Thanks!
Patrick
1 person has
this problem
+1
Reply
  • Can you post the following:

    1. The complete message output of the command
    2, the version of DBAmp
    3. A create table SQL statements of your load table.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • Also, make sure that no columns are defined as varchar(Max). Instead use nvarchar and an actual length.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • There are a significant number of varchar(max)'s being used. I will attempt to convert those to nvarchar. some of these the length is quite difficult to predict, is it possible to use nvarchar(max) or do I need to avoid (max) completely?

    The version is 3.1.7

    The error I received was:
    05:52:10: Job 7503B000000LtCxQAK created.
    05:52:10: Error: Unable to map column Name of type 16513.
    05:52:10: Error: Stopping due to the above error.
    05:52:10: Job aborted.
    05:52:10: 1 rows read from SQL Table.
    05:52:10: Errors occurred. See Error column of row and above messages for more information.
    05:52:10: Error: DBAmp.exe was unsuccessful.
    05:52:10: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe upsert:bulkapi,batchsize(4000) Account_Load "DDB-CONSULT01" "SFDC_QA_Mig" "SFDC_QA" "Acct_Ext_ID__c" " "
    --- Ending SF_BulkOps. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 349
    SF_BulkOps Error: 05:52:08: DBAmp Bulk Operations. V3.1.7 (c) Copyright 2006-2016 forceAmp.com LLC05:52:08: Upserting Salesforce using Account_Load (DDB-CONSULT01 / SFDC_QA_Mig) .05:52:09: DBAmp is using the SQL Native Client.05:52:09: Batch size reset to 4000 rows per batch.05:52:09: Sort column will be used to order input rows.05:52:09: SF_Bulkops will poll every 60 seconds for up to 3600 seconds.05:52:09: Warning: Column 'Industry__c' ignored because it does not exist in the Account object.05:52:09: Warning: Column 'Vertical__c' ignored because it does not exist in the Account object.05:52:10: Job 7503B000000LtCxQAK created.05:52:10: Error: Unable to map column Name of type 16513.05:52:10: Error: Stopping due to the above error.05:52:10: Job aborted.05:52:10: 1 rows read from SQL Table.05:52:10: Errors occurred. See Error column of row and above messages for more information.

    The table creation script is:
    Create Table [dbo].[Account_Load](
    [ID] [nchar](18) NULL,
    [Error] [nvarchar](255) NULL,
    [Name] [varchar](max) NOT NULL,
    [AccountSource] [varchar](max) NULL,
    [BillingStreet] [varchar](max) NULL,
    [BillingCity] [varchar](max) NULL,
    [BillingState] [varchar](max) NULL,
    [BillingPostalCode] [varchar](max) NULL,
    [BillingCountry] [varchar](max) NULL,
    [ShippingStreet] [varchar](max) NULL,
    [ShippingCity] [varchar](max) NULL,
    [ShippingState] [varchar](max) NULL,
    [ShippingPostalCode] [varchar](max) NULL,
    [ShippingCountry] [varchar](max) NULL,
    [Phone] [varchar](max) NULL,
    [Fax] [varchar](max) NULL,
    [Website] [varchar](max) NULL,
    [AnnualRevenue] [varchar](max) NULL,
    [NumberOfEmployees] [varchar](max) NULL,
    [Description] [varchar](max) NULL,
    [OwnerID] [nchar](18) NULL,
    [CurrencyIsoCode] [varchar](max) NULL,
    [Ownership] [varchar](7) NOT NULL,
    [SIC] [varchar](max) NULL,
    [Industry__c] [varchar](max) NULL,
    [Location__c] [varchar](max) NULL,
    [Reference__c] [varchar](5) NOT NULL,
    [Area__c] [varchar](max) NULL,
    [Status__c] [varchar](max) NULL,
    [Market_Potential__c] [varchar](max) NULL,
    [Oracle_Account_Number__c] [varchar](max) NULL,
    [Solution_ID__c] [varchar](5) NOT NULL,
    [LDR_Target__c] [varchar](5) NOT NULL,
    [Managed_Partner__c] [varchar](5) NOT NULL,
    [Atlas_Account__c] [varchar](5) NOT NULL,
    [ISR_Account__c] [varchar](5) NOT NULL,
    [Do_Not_Contact__c] [varchar](5) NOT NULL,
    [Holdout_Account__c] [varchar](5) NOT NULL,
    [TSG_Customer_Account__c] [varchar](5) NOT NULL,
    [Absence_Vendor_Update_Date__c] [varchar](max) NULL,
    [Activities_Vendor_Update_Date__c] [varchar](max) NULL,
    [ERP_Vendor_Update_Date__c] [varchar](max) NULL,
    [HR_Vendor_Update_Date__c] [varchar](max) NULL,
    [XXXXXX_Company_Name_Modified_Date__c] [varchar](max) NULL,
    [LDR_Target_Date__c] [varchar](max) NULL,
    [POS_Vendor_Update_Date__c] [varchar](max) NULL,
    [Payroll_Vendor_Update_Date__c] [varchar](max) NULL,
    [T_L_Vendor_Update_Date__c] [varchar](max) NULL,
    [Talent_Management_Vendor_Update_Date__c] [varchar](max) NULL,
    [Scheduling_Vendor_Update_Date__c] [varchar](max) NULL,
    [XXXXXX_Employees_Company_Total__c] [varchar](max) NULL,
    [XXXXXX_Employees_at_location__c] [varchar](max) NULL,
    [Current_External_Factors__c] [varchar](max) NULL,
    [Current_Situation__c] [varchar](max) NULL,
    [D_B_Company_Secondary_Name__c] [varchar](max) NULL,
    [XXXXXX_Company_Name__c] [varchar](max) NULL,
    [Next_Steps__c] [varchar](max) NULL,
    [Operational_change__c] [varchar](max) NULL,
    [Organization_or_Operational_Metric__c] [varchar](max) NULL,
    [Owner_User_Sign_In_ID_WF__c] [varchar](max) NULL,
    [Qrtly_Refresh_Info__c] [varchar](max) NULL,
    [DB_Employees_Company_Total__c] [varchar](max) NULL,
    [Absence_Vendor__c] [varchar](max) NULL,
    [Activities_Vendor__c] [varchar](max) NULL,
    [Exist_Platform_DBMS__c] [varchar](max) NULL,
    [Assignment_Status__c] [varchar](max) NULL,
    [Vertical__c] [varchar](max) NULL,
    [Business_Unit__c] [varchar](max) NULL,
    [ERP_Vendor__c] [varchar](max) NULL,
    [ERP_Vendor_Intl__c] [varchar](max) NULL,
    [HR_Vendor__c] [varchar](max) NULL,
    [POS_Vendor__c] [varchar](max) NULL,
    [Payroll_Vendor__c] [varchar](max) NULL,
    [Referral_Status__c] [varchar](max) NULL,
    [Region_Intl__c] [varchar](max) NULL,
    [Scheduling_Vendor__c] [varchar](max) NULL,
    [Scheduling_Vendor_Intl__c] [varchar](max) NULL,
    [Start_of_Fiscal_Year__c] [varchar](max) NULL,
    [Sub_Industry__c] [varchar](max) NULL,
    [T_L_Vendor__c] [varchar](max) NULL,
    [Talent_Management_Vendor__c] [varchar](max) NULL,
    [Target_Rating__c] [varchar](max) NULL,
    [PO_Required__c] [varchar](max) NULL,
    [Account_Number_Intl__c] [varchar](max) NULL,
    [Assignment_Source__c] [varchar](max) NULL,
    [XXXXXX_Presence__c] [varchar](max) NULL,
    [Corporate_Initiative_Project__c] [varchar](max) NULL,
    [Corporate_Initiative_Project_2__c] [varchar](max) NULL,
    [Corporate_Initiative_Project_3__c] [varchar](max) NULL,
    [Customer_Category__c] [varchar](max) NULL,
    [DNB_Org_Level__c] [varchar](max) NULL,
    [XXXXXX_Org_Level__c] [varchar](max) NULL,
    [DNB_Global_Ultimate_Duns__c] [varchar](max) NULL,
    [DNB_Domestic_Ultimate_DUNS__c] [varchar](max) NULL,
    [DNB_Parent_DUNS__c] [varchar](max) NULL,
    [DNB_Site_DUNS__c] [varchar](max) NULL,
    [XXXXXX_Domestic_Ultimate_Duns__c] [varchar](max) NULL,
    [XXXXXX_Parent_Duns__c] [varchar](max) NULL,
    [HR_Vendor_Intl__c] [varchar](max) NULL,
    [Parent_Sales_Position_ID__c] [varchar](max) NULL,
    [Payroll_Vendor_Intl__c] [varchar](max) NULL,
    [Referred_By__c] [varchar](max) NULL,
    [Sales_Manager__c] [varchar](max) NULL,
    [Sales_Position_ID__c] [varchar](max) NULL,
    [T_L_Vendor_Intl__c] [varchar](max) NULL,
    [Territory_Name__c] [varchar](max) NULL,
    [Rep_Note_1__c] [varchar](max) NULL,
    [Rep_Note_2__c] [varchar](max) NULL,
    [Rep_Note_3__c] [varchar](max) NULL,
    [Rep_Note_4__c] [varchar](max) NULL,
    [Acct_Ext_ID__c] [varchar](4674) NULL,
    [Sort] [int] IDENTITY(1,1) NOT NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • You can use the SF_Generate stored procedure and generate an empty table with all the correct lengths and column types.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • Bill thank you.

    By switching away from using the varchar(max) it appears the issue has been resolved. Many thanks!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited indifferent, undecided, unconcerned kidding, amused, unsure, silly sad, anxious, confused, frustrated