Find your content:

Search form

You are here

What would cause "SQLException while executing plsql statement: call sImportLookup.get_by_ext_id_text"?


I am getting the error below when I try to insert a record with an external id:

Error: ORA-20000: ORA-06512: at "SNEEZY.SIMPORTLOOKUP", line 850 ORA-06512: at "SNEEZY.SIMPORTLOOKUP", line 823 ORA-06512: at line 1 : SQLException while executing plsql statement: {call sImportLookup.get_by_ext_id_text(?,?,?,?,?,?,?)}([ a0co00000023vjzmaya04o0000000sspdiac, a0co00000023vjzmaya04o0000000sspeiac, a0co00000023vjzmaya04o0000000sspfiac ][Ljava.lang.String;@6e622490, a0D, custom_entity_data_id, 0, 0, false, system.plsql.ResultSetOutParam@6d4ea28d)

Screenshot of the error

Can some one explain what causes this error?

Attribution to: Nashir

Possible Suggestion/Solution #1

Got response from salesforce.

opt_external_id​​ is an optional variable that specifies the custom field that should be used to match records that already exist in your organization's data. This custom field must be created with the External Id attribute selected. Additionally, if the field does not have the Unique attribute selected, the context user must have the “View All” object-level permission for the target object or the “View All Data” permission so that upsert does not accidentally insert a duplicate record.

Attribution to: Nashir

Possible Suggestion/Solution #2

This looks like an internal error, possibly the result of a bug. Notice the similar error encountered by another user in 2009 at this link: similar error

I would contact support directly to get this resolved. When or if you get an answer for them, please add the answer here as well.

Attribution to: E.J. Wilburn

Possible Suggestion/Solution #3

Definitely looks like an internal error that Salesforce are encountering, lookup up the error codes I found this:

ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes

on one forum, and ORA-6512 is used for reporting problem line numbers:

Error: ORA-06512: at line Cause: This error message indicates the line number in the PLSQL code that the error resulted.

Salesforce support will be the way to go unless any Salesforce guys on here have a magic bullet answer!

Attribution to: Matt Lacey
This content is remixed from stackoverflow or stackexchange. Please visit

My Block Status

My Block Content