Virtual Import Fails Due to "exceeded simultaneous SESSIONS_PER_USER limit"

Support
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?

2

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

Jess

3

thanks, that appears to have done the trick!

4

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