Apex Code Development You need to sign in to do that
Don't have an account?
BenjK Bug Report: Internal Oracle Errors "SQLException while executing plsql statement"
My organization is experiencing internal Salesforce/Oracle errors when using certain custom VF pages in our Salesforce Community. The error messages look like this:
We don't have perfect steps to reproduce the issue, but we've identified a couple scenarios which often make this happen. I've listed the scenarios below. This is currently affecting at least two users in our production environment and in a sandbox. We opened case #10907381 but it was closed, and we were told to file the bug report here.
For all of these scenarios, it's helpful to keep the Developer Console open so you can access logs.
Scenario 1: Page Opens Normally in ClientConnect Community
0) Start from Health Leads Internal
1) Switch to the Community called "ClientConnect"
2) Go to this VF page: https://healthleads.force.com/clientconnect/apex/MyDeskReports
3) Page opens normally
Scenario 2: Page Crashes in Advocate Management Community
0) Start from Health Leads Internal
1) Switch to the Community called "Advocate Management"
2) Go to this VF page - https://healthleads.force.com/advocates/apex/MyDeskReports
3) Crash! if you open up the log in the Developer Console, the error message displayed.
Scenario 3: Page Crashes If You Were Ever In Advocate Management
Now that you've completed scenario 2, go back and try scenario 1 again. While it worked before, this time it crashes.
Error Message ($Site.ErrorMessage): Error occurred while loading a Visualforce page.
Error Description ($Site.ErrorDescription): common.apex.runtime.impl.ExecutionException: ORA-20001:
ORA-06512: at "SLEEPY.CAUTHSESSION", line 811
ORA-01403: no data found
ORA-06512: at line 1
SQLException while executing plsql statement: {?=call cAuthSession.get_session_key_nc(?,?)}(EXCLUDED, false)
We don't have perfect steps to reproduce the issue, but we've identified a couple scenarios which often make this happen. I've listed the scenarios below. This is currently affecting at least two users in our production environment and in a sandbox. We opened case #10907381 but it was closed, and we were told to file the bug report here.
For all of these scenarios, it's helpful to keep the Developer Console open so you can access logs.
Scenario 1: Page Opens Normally in ClientConnect Community
0) Start from Health Leads Internal
1) Switch to the Community called "ClientConnect"
2) Go to this VF page: https://healthleads.force.com/clientconnect/apex/MyDeskReports
3) Page opens normally
Scenario 2: Page Crashes in Advocate Management Community
0) Start from Health Leads Internal
1) Switch to the Community called "Advocate Management"
2) Go to this VF page - https://healthleads.force.com/advocates/apex/MyDeskReports
3) Crash! if you open up the log in the Developer Console, the error message displayed.
Scenario 3: Page Crashes If You Were Ever In Advocate Management
Now that you've completed scenario 2, go back and try scenario 1 again. While it worked before, this time it crashes.
In particular though, does your Advocate Management Community have access to the MyDeskReports visualforce page? You can check this by going to Customize->Communities->Manage Communities and then click on "Force.com" under the "Custom Pages" column.