Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m unsure

DataType table query returns Error 1 : UNKNOWN_EXCEPTION

In our prod SF instance we can successfully query the DataType table/object and get healthy returns. In our all of our sandboxen we attempt the same query (both three dot and open query) and get:
OLE DB provider "DBAmp.DBAmp" for linked server "sf_qa" returned message "Error 1 : UNKNOWN_EXCEPTION: ".
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query "SELECT "Tbl1002"."ContextServiceDataTypeId" "Col1005","Tbl1002"."ContextWsdlDataTypeId" "Col1006","Tbl1002"."DeveloperName" "Col1007","Tbl1002"."DurableId" "Col1008","Tbl1002"."Id" "Col1009","Tbl1002"."IsComplex" "Col1010","Tbl1002"."Name" "Col1011","Tbl1002"."Namespace" "Col1012","Tbl1002"."NamespacePrefix" "Col1013","Tbl1002"."ServiceId" "Col1003" FROM "DataType" "Tbl1002"" against OLE DB provider "DBAmp.DBAmp" for linked server "sf_qa".

Any ideas of what might be going on?
1 person has
this question
+1
Reply
  • What version of DBAmp are you currently running? What are the exact commands you are using?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Sorry, should have included.

    DBAmp version 3.1.0

    select * from sf_qa...DataType
    returns the error above.

    select * from openquery(sf_qa,'select * from DataType')
    returns:
    OLE DB provider "DBAmp.DBAmp" for linked server "sf_qa" returned message "Error: UNKNOWN_EXCEPTION: ".
    Msg 7320, Level 16, State 2, Line 1
    Cannot execute the query "select * from DataType" against OLE DB provider "DBAmp.DBAmp" for linked server "sf_qa".

    select * from openquery(sf_qa,'select id from DataType')
    returns:
    OLE DB provider "DBAmp.DBAmp" for linked server "sf_qa" returned message "Error: UNKNOWN_EXCEPTION: ".
    Msg 7320, Level 16, State 2, Line 1
    Cannot execute the query "select id from DataType" against OLE DB provider "DBAmp.DBAmp" for linked server "sf_qa".

    Running any of those commands on the prod instance returns a normal set of rows and columns.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • The UNKNOWN_EXCEPTION error message is actually being thrown by the Salesforce server during the processing of the query.

    Sometimes, if you restrict the columns that you are selecting from the table you can get around the error. But, if you want it to work when selecting the whole table, you will have to file a case with Salesforce.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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