You can translate the question and the replies:

Error while fetching dates column from Cache

Hi Team, we are facing error while fetching the dates column from cache DB. We are using full cache option for a derived view. It is storing the data in the cache but when we are trying to fetch it dates column is throwing error. Please find the error below. There were errors while generating this response: •Code #50001 - Error executing query. Total time 19.025 seconds. QUERY [PROJECTION] [ERROR] QUERY [SELECTION] [ERROR] v_xyz [PROJECTION] [ERROR] v_xyz [JOIN] [ERROR] v_xyz [GROUPBY] [STOPPED] v_xyz [JOIN] [STOPPED] v_abc [VIRTUAL] [STOPPED] v_abc [JDBC WRAPPER] [STOPPED] v_abc#0 [JDBC ROUTE] [ERROR] Received exception with message 'ORA-01013: user requested cancel of current operation' v_xyz [GROUPBY] [ERROR] v_pqr [CACHE] [ERROR] v_pqr [JDBC WRAPPER] [ERROR] Received exception with message 'Error obtaining some values for column(s): 'fnolDate', 'claimDate'' •Code #1 - QUERY [PROJECTION] [ERROR] •Code #1 - QUERY [SELECTION] [ERROR] •Code #1 - v_xyz [PROJECTION] [ERROR] •Code #1 - v_xyz [LEFT OUTER JOIN] [ERROR] •Code #12 - v_xyz [GROUPBY] [STOPPED] •Code #12 - v_xyz [LEFT OUTER JOIN] [STOPPED] •Code #12 - v_abc [VIRTUAL] [STOPPED] •Code #12 - v_abc [JDBC WRAPPER] [STOPPED] •Code #1 - v_abc#0 [JDBC ROUTE] [ERROR] ORA-01013: user requested cancel of current operation •Code #1 - v_xyz [GROUPBY] [ERROR] •Code #1 - v_pqr [CACHE] [ERROR] •Code #1 - v_pqr [JDBC WRAPPER] [ERROR] Error obtaining some values for column(s): 'fnolDate', 'claimDate' When we trry to exclude the dates columns and run the view it is working fine. Please let us know if there is any way to handle this. Thanks for the help in advance.
user
10-08-2017 06:31:40 -0400

1 Answer

Hi, The ORA-01013 may occur when the previous query execution has failed or if the connection is not valid during execution. I would verify if the ‘Ping Query’ is provided to check the connection is valid before query execution. You can verify this by going to ‘Administration > Server Configuration > Cache’ and under ‘Connection’ tab, you can give the Ping Query under ‘Connection Pool Properties’. I advise you to provide a valid ping query supported by the datasource. Hope this helps!
Denodo Team
11-08-2017 07:56:00 -0400
You must sign in to add an answer. If you do not have an account, you can register here