Hello, I have the same problem.
I tried with ojdbc8 and ojdbc10.
Here is te server log.
SQLDataException:
Message: ORA-01878: o campo especificado nĂŁo foi encontrado em datetime ou no intervalo
SQLState: 22008
Error Code: 1878
01-28 10:41:27 ERROR sql-jdbc.execute :: nil
01-28 10:41:28 WARN middleware.process-userland-query :: Falha na consulta {:status :failed,
:class java.sql.SQLDataException,
:error âORA-01878: o campo especificado nĂŁo foi encontrado em datetime ou no intervalo\nâ,
:stacktrace
(âoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)â
âoracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)â
âoracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)â
âoracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)â
âoracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)â
âoracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)â
âoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)â
âoracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)â
âoracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)â
âoracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)â
âoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)â
âoracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)â
âoracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)â
âoracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)â
âoracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)â
âcom.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)â
âclojure.java.jdbc$execute_query_with_params.invokeStatic(jdbc.clj:1072)â
âclojure.java.jdbc$execute_query_with_params.invoke(jdbc.clj:1066)â
âclojure.java.jdbc$db_query_with_resultset_STAR_.invokeStatic(jdbc.clj:1081)â
âclojure.java.jdbc$db_query_with_resultset_STAR_.invoke(jdbc.clj:1075)â
âclojure.java.jdbc$query.invokeStatic(jdbc.clj:1164)â
âclojure.java.jdbc$query.invoke(jdbc.clj:1126)â
ââ> driver.sql_jdbc.execute$cancelable_run_query$fn__69313.invoke(execute.clj:225)â
âdriver.sql_jdbc.execute$do_with_ensured_connection.invokeStatic(execute.clj:202)â
âdriver.sql_jdbc.execute$do_with_ensured_connection.invoke(execute.clj:200)â
âdriver.sql_jdbc.execute$cancelable_run_query.invokeStatic(execute.clj:217)â
âdriver.sql_jdbc.execute$cancelable_run_query.invoke(execute.clj:213)â
âdriver.sql_jdbc.execute$run_query.invokeStatic(execute.clj:239)â
âdriver.sql_jdbc.execute$run_query.invoke(execute.clj:235)â
âdriver.sql_jdbc.execute$run_query_with_timezone$fn__69340.invoke(execute.clj:331)â
âdriver.sql_jdbc.execute$do_with_auto_commit_disabled.invokeStatic(execute.clj:286)â
âdriver.sql_jdbc.execute$do_with_auto_commit_disabled.invoke(execute.clj:274)â
âdriver.sql_jdbc.execute$do_in_transaction$fn__69334.invoke(execute.clj:291)â
âdriver.sql_jdbc.execute$do_in_transaction.invokeStatic(execute.clj:290)â
âdriver.sql_jdbc.execute$do_in_transaction.invoke(execute.clj:289)â
âdriver.sql_jdbc.execute$run_query_with_timezone.invokeStatic(execute.clj:317)â
âdriver.sql_jdbc.execute$run_query_with_timezone.invoke(execute.clj:316)â
âdriver.sql_jdbc.execute$execute_query$fn__69357.invoke(execute.clj:352)â
âdriver.sql_jdbc.execute$do_with_try_catch.invokeStatic(execute.clj:266)â
âdriver.sql_jdbc.execute$do_with_try_catch.invoke(execute.clj:260)â
âdriver.sql_jdbc.execute$execute_query.invokeStatic(execute.clj:346)â
âdriver.sql_jdbc.execute$execute_query.invoke(execute.clj:339)â
âdriver.sql_jdbc$fn__71223.invokeStatic(sql_jdbc.clj:44)â
âdriver.sql_jdbc$fn__71223.invoke(sql_jdbc.clj:43)â
âdriver.oracle$eval335$fn__336.invoke(oracle.clj:237)â
âquery_processor$fn__46284$execute_query__46289$fn__46290.invoke(query_processor.clj:69)â
âquery_processor$fn__46284$execute_query__46289.invoke(query_processor.clj:64)â
âquery_processor.middleware.mbql_to_native$mbql__GT_native$fn__37473.invoke(mbql_to_native.clj:40)â
âquery_processor.middleware.annotate$result_rows_maps__GT_vectors$fn__40580.invoke(annotate.clj:541)â
âquery_processor.middleware.annotate$add_column_info$fn__40486.invoke(annotate.clj:485)â
âquery_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__41521.invoke(cumulative_aggregations.clj:57)â
âquery_processor.middleware.resolve_joins$resolve_joins$fn__43379.invoke(resolve_joins.clj:184)â
âquery_processor.middleware.limit$limit$fn__42156.invoke(limit.clj:19)â
âquery_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46144.invoke(results_metadata.clj:87)â
âquery_processor.middleware.format_rows$format_rows$fn__42144.invoke(format_rows.clj:76)â
âquery_processor.middleware.add_dimension_projections$add_remapping$fn__38233.invoke(add_dimension_projections.clj:234)â
âquery_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38884.invoke(add_source_metadata.clj:107)â
âquery_processor.middleware.resolve_source_table$resolve_source_tables$fn__43429.invoke(resolve_source_table.clj:46)â
âquery_processor.middleware.add_row_count_and_status$add_row_count_and_status$fn__38721.invoke(add_row_count_and_status.clj:16)â
âquery_processor.middleware.driver_specific$process_query_in_context$fn__41596.invoke(driver_specific.clj:12)â
âquery_processor.middleware.resolve_driver$resolve_driver$fn__43043.invoke(resolve_driver.clj:22)â
âquery_processor.middleware.store$initialize_store$fn__46169$fn__46170.invoke(store.clj:11)â
âquery_processor.store$do_with_store.invokeStatic(store.clj:46)â
âquery_processor.store$do_with_store.invoke(store.clj:40)â
âquery_processor.middleware.store$initialize_store$fn__46169.invoke(store.clj:10)â
âquery_processor.middleware.async$async__GT_sync$fn__37384.invoke(async.clj:23)â
âquery_processor.middleware.async_wait$runnable$fn__40637.invoke(async_wait.clj:89)â),
:query
{:query
{:source-table 34158,
:filter [âandâ [âis-nullâ [âfield-idâ 435906]] ["=" [âfield-idâ 435903] âCompletedâ] ["=" [âdatetime-fieldâ [âfield-idâ 435923] âmonthâ] â2018-06-01T00:00:00-03:00â]],
:aggregation [[âsumâ [âfield-idâ 435904]] [âsumâ [âfield-idâ 435907]]],
:breakout [[âdatetime-fieldâ [âfield-idâ 435923] âweekâ]]},
:type âqueryâ,
:parameters [],
:async? true,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 2,
:context :ad-hoc,
:card-id nil,
:nested? false,
:query-hash [-66, -31, 70, -46, 113, -70, -47, 18, -9, 24, 46, 127, -33, 117, 28, 109, 27, -47, 58, 124, 20, 116, 47, -108, 41, -56, -31, 30, -27, 9, -21, -33]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:preprocessed
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware {:add-default-userland-constraints? true, :userland-query? true},
:info
{:executed-by 2,
:context :ad-hoc,
:nested? false,
:query-hash [-66, -31, 70, -46, 113, -70, -47, 18, -9, 24, 46, 127, -33, 117, 28, 109, 27, -47, 58, 124, 20, 116, 47, -108, 41, -56, -31, 30, -27, 9, -21, -33]},
:preprocessing-level 1,
:database 4,
:query
{:source-table 34158,
:filter
[:and
[:= [:field-id 435906] [:value nil {:base_type :type/Decimal, :special_type nil, :database_type âNUMBERâ}]]
[:= [:field-id 435903] [:value âCompletedâ {:base_type :type/Text, :special_type :type/Category, :database_type âVARCHAR2â}]]
[:and
[:>= [:datetime-field [:field-id 435923] :default] [:absolute-datetime (t/offset-date-time â2018-06-01T00:00-03:00â) :default]]
[:< [:datetime-field [:field-id 435923] :default] [:absolute-datetime (t/offset-date-time â2018-07-01T00:00-03:00â) :default]]]],
:aggregation [[:aggregation-options [:sum [:field-id 435904]] {:name âsumâ}] [:aggregation-options [:sum [:field-id 435907]] {:name âsum_2â}]],
:breakout [[:datetime-field [:field-id 435923] :week]],
:order-by [[:asc [:datetime-field [:field-id 435923] :week]]]}},
:native
{:query
âSELECT trunc(âMETABASEâ.âBEETOOLSâ.âDATA_CRIACAOâ, âdayâ) AS âDATA_CRIACAOâ, sum(âMETABASEâ.âBEETOOLSâ.âVALOR_BEETOOLSâ) AS âsumâ, sum(âMETABASEâ.âBEETOOLSâ.âTOTAL_DA_VENDAâ) AS âsum_2â FROM âMETABASEâ.âBEETOOLSâ WHERE (âMETABASEâ.âBEETOOLSâ.âNOTA_FISCALâ IS NULL AND âMETABASEâ.âBEETOOLSâ.âSTATUSâ = ? AND (âMETABASEâ.âBEETOOLSâ.âDATA_CRIACAOâ >= ? AND âMETABASEâ.âBEETOOLSâ.âDATA_CRIACAOâ < ?)) GROUP BY trunc(âMETABASEâ.âBEETOOLSâ.âDATA_CRIACAOâ, âdayâ) ORDER BY trunc(âMETABASEâ.âBEETOOLSâ.âDATA_CRIACAOâ, âdayâ) ASCâ,
:params (âCompletedâ (t/offset-date-time â2018-06-01T00:00-03:00â) (t/offset-date-time â2018-07-01T00:00-03:00â))},
:cause {:class oracle.jdbc.OracleDatabaseException, :error âORA-01878: o campo especificado nĂŁo foi encontrado em datetime ou no intervalo\nâ}}