DemandTools 2.91 Troubleshooting
-
DemandTools - Log File Exception Codes
Salesforce Exception Code Definitions (as seen in log files)ALREADY_IN_PROCESS A record was submitted that is already in an approval process.API_CURRENTLY_DISABLED Because of a system problem, API functionality is temporarily unavailable.API...
-
Too Many SOQL Queries Error
QUESTION: What does this error mean? 2008-12-02T11:33:58+00:00,,"",,Update,,,,," Message: MyAccountUpdate: execution of AfterUpdate<LF><LF>caused by: System.Exception: Too many SOQL queries: 21<LF><LF>Trigger.MyAccountUpdate: line 8, column 25...
-
System.LimitException: Apex CPU time limit exceeded
QUESTION: I am getting the following error when attempting to process an update in DemandTools? 2014-04-03T19:40:31-04:00,,"",,Update,,,,," Message: {MyApexCode}: System.LimitException: Apex CPU time limit exceeded Status code: 13" ANSWER: This t...
-
Single Table Dedupe Error: No Master Object
QUESTION: I found my duplicate records but when I select "Merge Checked" in the Single Table Dedupe results grid I keep getting the following error, how can I resolve? Error Message: 02-01T01:49:25-05:00,,"Dedupe action for single group started",...
-
Unable to create a DemandTools trial
QUESTION: When I try to create a trial I get an error message: You must have administrative rights on this account to use the tools. How can I obtain a trial? ANSWER: This error occurs when the user requesting the trial does not have the Salesfor...
-
Linking Person Accounts to a Campaign
QUESTION: I tried to link some Person Accounts to Campaigns in MassEffect, but received the following error: 2011-09-26T04:04:00-06:00,,"",,Insert,,,,," Message: Contact ID: id value of incorrect type: 001C000000sfk89IAA Status code: 53" What...
-
How to Generate a "dumplog" for a failed login
QUESTION: How do I generate a dumplog for a failed login? ANSWER: To generate a log file with details regarding login/license verification issues launch DemandTools with an extra parameter “dumplog” after the DemandTools.exe. To do this, a NEW sho...
-
DemandTools Closing with a BufferedGraphicsContext Error
QUESTION: DemandTools keeps shutting down when running Single Table Deduplication, and the following error is listed in the stack trace file DemandTools creates in the LogFile folder: at System.Drawing.BufferedGraphicsContext.CreateCompatibleDIB...
-
DemandTools Error Tasks
QUESTION: A task was created by DemandTools with the subject "DemandTools Error". What are these and is there something I need to do? ANSWER: These tasks are created any time DemandTools encounters an unexpected error which causes it to shut down...
-
Cannot Save a Specific Single Table Dedupe Scenario in Version 2.7, Getting "Error Saving Scenario"
QUESTION: I am trying to save an older scenario but keep getting an error message "Error Saving Scenario". That is it, no details at all, what is the issue? ANSWER: This will happen if the scenario was originally built prior to the 2.2 Release...
-
Insufficient Access Rights on Cross-Reference ID
QUESTION: I'm having a problem today updating a field through DemandTools or PeopleImport. I keep getting the message below in my log file when trying to update the Record Type. Do you know what this message means? I get the same message using Mas...
-
DemandTools 2.91 Login Error: The Remote Server Returned an Error or Authorization Error
QUESTION: What does a remote server error upon login indicate? ANSWER: If an error message appears upon login and refers to a remote server, e.g. "The remote server returned an error: (407) Proxy Authentication Required", "Authorization Error," or...
-
Error: There's a problem with this state/country, even though it may appear correct.
ISSUE: When performing an insert/update the following error is encountered: There's a problem with this state/country, even though it may appear correct. Please select a state/country from the list of valid countries.:[Billing / Shipping] State/C...
-
Endpoint Mismatch Notification When Accessing a Sandbox with DemandTools
QUESTION: When adding a a custom endpoint to my proxy settings to access a sandbox, I receive notification: The current endpoint API version is not the same as DemandTools was compiled with To ensure compatibility your endpoint should end in: xx.x...
-
Error: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information
QUESTION: Why am I getting the error "Error: Dynamic SQL generation is not supported against a SelectCommand that does not return any base table information" when trying to export to Access? ANSWER: This error occurs when trying to export more tha...
-
Using Linked Tables and Queries from an Access Database
QUESTION: I have set up a system DSN that points to an MS Access database. This database contains tables and queries that are "linked" to a SQL database. When using Access, the first time one of these is accessed it asks for the SQL DB login, and ...
-
Error converting Leads: invalid convertedStatus
QUESTION: I am trying to perform a Lead to Contact deduplication but I keep encountering an error that says "invalid convertedStatus ". How can I resolve? The error will look something like this: DemandTools: Lead to contact dedupe,"Convert",,,00...
-
"Row is out of range" error saving a file in DemandTools
QUESTION: I am getting the following error when I try to export to a file in MassEffect: Unable to save that file. Make sure the file is not open and try again. Error: Row is out of range. **I have also run into this when exporting the result...
-
"Column is out of range" error saving a file in DemandTools
QUESTION: I am getting the following error when I try to export to a file in MassEffect: Unable to save that file. Make sure the file is not open and try again. Error: Column is out of range. How can I resolve? ANSWER: This error will occur...
-
Licensing Error: Your account has expired
QUESTION: I am getting a "Licensing Error" error upon logging into DemandTools, how do I resolve? ANSWER: This means that your annual license has expired. Please contact our Sales Department to renew your account access by sending an email to:...
-
ParentFixer Unit Test Fails when State and Country Picklists are Enabled
QUESTION: We are seeing unit test failures for ParentFixer which seem to be related to having State and Country picklists enabled: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, There's a prob...
-
DemandTools 2.91 Login Error: LOGIN_MUST_USE_SECURITY_TOKEN
QUESTION: I keep getting the following error when trying to login to DemandTools: Login Error: LOGIN_MUST_USE_SECURITY_TOKEN I am not sure what I am doing wrong, can you help? ANSWER: A Security Token is required to access Salesforce via the...
-
Field Rule errors
QUESTION: I am getting one of these errors when editing or loading a scenario in Single Table Dedupe: "The following fields are defined in the rules but do not exist in Salesforce" "The following rules do not exist in the input scenario and have ...
-
DemandTools Today Web Page Error
QUESTION: I keep getting an error that "the web page cannot be displayed" after login or when I try to access the DemandTools Today page. *The Today page is the first page shown after a successful login. ANSWER: The following website needs to be...
-
DemandTools Login Error: INVALID_OPERATION_WITH_EXPIRED_PASSWORD
QUESTION: I am trying to login to DemandTools but am getting the following error: INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations. How do I resolve? ANS...
-
Strange errors when using a custom endpoint for a Sandbox: "Error accessing data from salesforce", "There is an error in XML document", or "Object reference not set to an instance of an object"
QUESTION: I have pointed DemandTools to my sandbox and am getting some strange errors when accessing various modules. How can I resolve? Possible errors you may be seeing: When accessing any module (besides MassEffect): "Error accessing data fr...