You can translate the question and the replies:

GET_VIEWS() function

I am using DENODO VDP version 6.0 20170515. When I create a view based on the following query: SELECT * FROM GET_VIEWS() I am getting an error: com.denodo.vdb.vdbinterface.common.clientResult.VQLException: Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack Do you have any ideas on why I am getting this error? What I want to achieve, is to get a list of all views on a particular folder. Thank you in advance
user
06-10-2017 05:45:24 -0400
code

2 Answers

Hi, I created a view using 'SELECT * FROM GET_VIEWS()' query and I am able to retrieve the view names and information about the view such as the user created, the folder of the view etc.,by executing this view. If I would like to get only from specific folder, I would use a 'Where condition' to match the 'folder' column to the respective folder. The error mentioned in question occurs when the Oracle database receives many requests in short duration and the listener goes to 'Blocked' state. In order to solve this, I would optimize my connection pool to have enough connections open to Oracle and also increase the maximum number of connections Oracle can accept. If you are using Oracle for Cache, you can modify the Connection Pool configuration under 'Administration > Server Configuration > Cache > Connection > Connection Pool Configuration' If you still face issues and if you are a customer with valid support user, you could raise a ticket so that our support team can help you. Hope this helps!
Denodo Team
09-10-2017 05:35:41 -0400
code
Thank you, it works
user
10-10-2017 08:57:46 -0400
You must sign in to add an answer. If you do not have an account, you can register here