1 of 1 people found this helpful
After some investigation about this error, it appears as though this error is coming from your Oracle database and not Tableau Desktop, as you said.
It may be that something within this specific workbook was thrown off at the Oracle DB level or corrupted. I found the following articles outside of Tableau in regards to the Oracle error ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit.
ORA-02391 Exceeded simultaneous session_per_user limit
With all of this in mind since a new connection to your Oracle database is working I would suggest copying your worksheets into a new Tableau workbook to see if the issue re-occurs or if this resolves this issue.
Further, the above articles recommend the Oracle DB administrator increase the number of SESSIONS_PER_USER limit of the User Profile or End some of the concurrent Oracle DB sessions.
Hope this helps
Thanks very much for the information. I attempted copying the worksheets into a new workbook and promptly hit the Oracle error in the new workbook. Having tried that, I'll reach out to my Oracle db admin to have that session limit increased. Thanks again!
Hi Dennis- did your Oracle db admin make any changes in this scenario? I reached out to mine, and was told that the account is set for multiple users, but that Tableau is using 10 sessions, most of them inactive. He suggested that i look into how to close them if they are not used (if there is a setting for timing-out and such). I dont know that this exists in Tableau...???
Tableau is using 10. Most of them inactive (which is fine) but you may look into how to close them if they are not used (if there is settings for timing-out and such).