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

UNKNOWN_EXCEPTION in SSIS package

"UNKNOWN_EXCEPTION" occurs in SSIS package with Salesforce Source.

Other tables are queried with no problem except for "Account". Here is the error info from the window that pops up after trying to preview the first 200 rows of the table.

TITLE: Microsoft Visual Studio
------------------------------

There was an error displaying the preview.

------------------------------
ADDITIONAL INFORMATION:

Error: UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 614342339-3787 (404827223) (System.Data)

------------------------------
BUTTONS:

OK
------------------------------
1 person has
this problem
+1
Reply
  • Can you give the Command you are running in SQL to help us understand the error ?

    This is a SALESFORCE error and not an error from DBAmp.

    UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 614342339-3787 (404827223) (System.Data)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • It's a simple select statement in an OLE DB source. There is no where clause but there are a ton of columns. Is there a limit to the number of columns you can select by?

    The package was programmatically generated with C# and has every field from DescribeObject.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • This error message is from the salesforce server and indicates a backend problem with your data at salesforce. Often this occurs because some recently added formula field is calculating erroneous values.

    To identify the issue you must file a case with salesforce with the following wording:

    "We are executing a Query api call with a third party tool (DBAmp) that does a SOQL query against the Account object and receive the following error message from the salesforce server: UNKNOWN_EXCEPTION: An unexpected error occurred. Please include this ErrorId if you contact support: 614342339-3787 (404827223) .

    Please use the ErrorId to locate the log record appiicable to this error and let us know the root cause."
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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