+ Start a Discussion
logontokartiklogontokartik 

Weird Error - Java.sql.SQLException

Hi,

 

I am getting the below error when trying to persist data. Not sure what this is. Has anyone faced this kind of issue?

 

 java.sql.SQLException: ORA-20000: 
ORA-06512: at "DOC.SIMPORTLOOKUP", line 850
ORA-06512: at "DOC.SIMPORTLOOKUP", line 823
ORA-06512: at line 1


SQLException while executing plsql statement: {call sImportLookup.get_by_ext_id_text

Best Answer chosen by Admin (Salesforce Developers) 
logontokartiklogontokartik

Figured out the issue myself. 

 

This is a permissions issue. A Integration User doesnt have access to the object, but tries to read/write to that object via Webservices. You get these kind of errors. 

 

Fixed the permissions and the error is gone. 

 

Really a weird way to say that User is not having access in the SOAP Call. 

All Answers

sfcksfck

That's a low-level exception. The fact that you are seeing it means that there is a bug somewhere in the salesforce code. I think you should log a case to say you have found a bug.

 

It may be happening as a result of some error on your part (impossible to tell without more info), but it's still a bug, because you should not be seeing this exception.

logontokartiklogontokartik

Figured out the issue myself. 

 

This is a permissions issue. A Integration User doesnt have access to the object, but tries to read/write to that object via Webservices. You get these kind of errors. 

 

Fixed the permissions and the error is gone. 

 

Really a weird way to say that User is not having access in the SOAP Call. 

This was selected as the best answer