DemandTools 2.91 Troubleshooting

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...

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...

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",...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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:...

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...

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...

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 ...

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...

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...

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...