You can translate the question and the replies:

Issue with CONTEXT date conversion with call from a REST Webservice

I am getting the following error when I execute a the following query from a REST Web Service to a view in Denodo: SELECT_NAVIGATIONAL <fields> FROM <denodo derived view> WHERE (1=1 and (Rcvd_Date BETWEEN DATE '0001-01-01' AND DATE '9999-12-31' ) WITH CONDITION MAPPINGS EVALUATION CONTEXT ('i18n'='rfc_restful') Error received: Received exception with message 'Error in select view conditions: Invalid parameter types of function 'to_date('yyyy-MM-dd', '0001-01-01', 'rfc_restful', '0')'' If I use CONTEXT ('i18n'='us_est), I am getting the same error as well: Received exception with message 'Error in select view conditions: Invalid parameter types of function 'to_date('yyyy-MM-dd', '0001-01-01', 'us_est', '0')'' The "base" table I am sourcing the data from is a Denodo Virtual Database on a separate server (2Q). I created a data source on the (1Q) server which points to the Virtual Database on the 2Q server via the Denodo JDBC driver. What setting do I need to set on the servers so that I do not have this issue in the future.
Date Conversion dateformat
user
19-04-2017 17:50:06 -0400
code

1 Answer

Hi, I also encountered the same error whenever I was using the to_date function it was unable to parse the date provided by me with a i18n using REST service. I was able to overcome this error after applying the Denodo Platform 6.0 Update 20170329 (beta update). If you are an existing customer and you are experiencing this problem on your production environment. I would better advice you to first try the beta update on your QA/Test environment as you wait for the actual full official update to be released. I hope this helps you!
Denodo Team
28-04-2017 06:30:57 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here