Virtual Import Fails Due to "exceeded simultaneous SESSIONS_PER_USER limit"


(Nolan Nichols) #1

I'm connecting to Oracle and seeing the following error when trying to materialize a virtual graph:

java.sql.SQLException: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Searching around it seems related to a connection pool limit. Does virtual graph import open a large number of connections? Is there any way to set the limit?


(Jess Balint) #2

You can set the properties for the Tomcat connection pool directly in your virtual graph properties file, eg:
initialSize=1

Jess


(Nolan Nichols) #3

thanks, that appears to have done the trick!


(system) #4

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.