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

DATACLOUD_API_DISABLED_EXCEPTION

Bill, I have just upgraded dbamp to latest version. I am getting this error When I use SF_ReplicateAll. This error appears for only three datacloud tables. All others are fine.
10:21:56: Drop DatacloudCompany_Previous if it exists.
10:21:56: Create DatacloudCompany_Previous with new structure.
10:21:56: Run the DBAmp.exe program.
10:21:56: DBAmp Bulk Operations. V2.20.2 (c) Copyright 2006-2015 forceAmp.com LLC
10:21:56: Populating local table DatacloudCompany_Previous , server / SFDC_BCK .
10:21:56: DBAmp is using the SQL Native Client.
10:21:56: Opening SQL Server rowset
10:21:57: Error: RunQuery failed with com_error.
10:21:57: DATACLOUD_API_DISABLED_EXCEPTION: Your organization doesn't have permission to access the Data.com API
10:21:57: Error: DBAmp.exe was unsuccessful.
10:21:57: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "DatacloudCompany_Previous" "server name" "SFDC_BCK" "SALESFORCE"
--- Ending SF_Replicate. Operation FAILED.

Any idea?
1 person has
this question
+1
Reply
  • Has your company signed up to use the Data.com feature ?

    If so, are you in production mode with that feature ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Yes, I verified 'Allow Data.com api access' Check box and it is checked. We have been using SF_replicatedall for last one year but didn't get this error. I have upgraded it yesterday from 2.19 to 2.20 for fixing CollaborationGroupRecord table issue and I am getting this error now.

    Thanks,
    Suresh
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • The salesforce server is saying that the sf user used by the linked server does NOT have access to the data.com api.

    Can you verify ?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I noticed that system admin user was not in Data Administration-->Users screen. I have given rights to that user now. I tried it again for just that table. I am getting timeout error now -

    --- Starting SF_Replicate for DatacloudCompany
    15:14:15: Drop DatacloudCompany_Previous if it exists.
    15:14:15: Create DatacloudCompany_Previous with new structure.
    15:14:16: Run the DBAmp.exe program.
    15:14:16: DBAmp Bulk Operations. V2.20.2 (c) Copyright 2006-2015 forceAmp.com LLC
    15:14:16: Populating local table DatacloudCompany_Previous , USMN08MSHOT / SFDC_BCK .
    15:14:17: DBAmp is using the SQL Native Client.
    15:14:17: Opening SQL Server rowset
    15:22:20: Error: An error has occurred while fetching rows from salesforce.com.
    15:22:20: DATACLOUD_API_TIMEOUT_EXCEPTION: jigsaw api timeout - unable to fulfill request
    15:22:20: Error: Replication failed.
    Source: ForceAmpAPI.SQueryResults4.1
    Description: DATACLOUD_API_TIMEOUT_EXCEPTION: jigsaw api timeout - unable to fulfill request
    15:22:20: Error: DBAmp.exe was unsuccessful.
    15:22:20: Error: Command string is C:\"Program Files"\DBAmp\DBAmp.exe Export "DatacloudCompany_Previous" "USMN08MSHOT" "SFDC_BCK" "SALESFORCE"
    --- Ending SF_Replicate. Operation FAILED.
    Msg 50000, Level 16, State 1, Procedure SF_Replicate, Line 246
    --- Ending SF_Replicate. Operation FAILED.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • So now the salesforce server is timing out trying to run the query. Customers with this error typically have to file a case with salesforce and ask them to resolve the timeout issues on their server by increasing the timeout value.

    Alternatively, if you do not really even need these table locally, you can modify the sf_replicateAll and sf_refreshAll proc to skip these tables. Let me know and I will show you the changes involved.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Thanks, Bill. I have excluded tables that were causing an issue. I will work with sales force to resolve time out issue. Thank you so much for your help.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • This reply was removed on 2015-03-12.
    see the change log