Custom column is not working anymore. Formula is simple ; a/b
What should I do ?
error “ORA-00904: “source”.“İş Emri Tarihi”: invalid identifier\n”,
:state “42000”}],
:json_query
{:constraints {:max-results 10000, :max-results-bare-rows 2000},
:type :query,
:middleware nil,
:database 33,
:query
{:source-query
{:source-table 2468,
:aggregation [[:sum [:field-id 49709]] [:distinct [:field-id 49706]]],
:filter [:and [:= [:field-id 49708] “CLOSE (Kapatıldı)”] [:time-interval [:field-id 49714] :current :year]],
:breakout [[:field-id 49712]]},
:expressions {:Tamamlanma Süresi [
[:field-literal “sum” :type/Float] [:field-literal “count” :type/Integer]]},
:order-by [[:desc [:expression “Tamamlanma Süresi”]]]},
:parameters [],
:async? true,
:cache-ttl 1},
:native
{:query
“SELECT * FROM (SELECT “source”.“Talep Edilen Departman” AS “Talep Edilen Departman”, “source”.“sum” AS “sum”, “source”.“count” AS “count”, “source”.“Tamamlanma Süresi” AS “Tamamlanma Süresi” FROM (SELECT (CAST(“source”.“sum” AS float) / CASE WHEN “source”.“count” = 0 THEN NULL ELSE “source”.“count” END) AS “Tamamlanma Süresi”, “source”.“İşlem Süresi (Gün)” AS “İşlem Süresi (Gün)”, “source”.“İş Emri Id” AS “İş Emri Id”, “source”.“İş Emri Durumu” AS “İş Emri Durumu”, “source”.“İş Emri Tarihi” AS “İş Emri Tarihi”, “source”.“Talep Edilen Departman” AS “Talep Edilen Departman”, “source”.“sum” AS “sum”, “source”.“count” AS “count”, “source”.“Talep Edilen Departman” AS “Talep Edilen Departman_2”, “source”.“sum” AS “sum_2”, “source”.“count” AS “count_2” FROM (SELECT “ODS”.“MB_ISEMRI_OZET”.“Talep Edilen Departman” AS “Talep Edilen Departman”, sum(“ODS”.“MB_ISEMRI_OZET”.“İşlem Süresi (Gün)”) AS “sum”, count(distinct “ODS”.“MB_ISEMRI_OZET”.“İş Emri Id”) AS “count” FROM “ODS”.“MB_ISEMRI_OZET” WHERE (“ODS”.“MB_ISEMRI_OZET”.“İş Emri Durumu” = ? AND trunc(“ODS”.“MB_ISEMRI_OZET”.“İş Emri Tarihi”, ‘year’) = trunc(SYSDATE, ‘year’)) GROUP BY “ODS”.“MB_ISEMRI_OZET”.“Talep Edilen Departman” ORDER BY “ODS”.“MB_ISEMRI_OZET”.“Talep Edilen Departman” ASC) “source”) “source” ORDER BY “source”.“Tamamlanma Süresi” DESC) WHERE rownum <= 2000”,
:params (“CLOSE (Kapatıldı)”)},
:status :failed,
:class oracle.jdbc.OracleDatabaseException,
:stacktrace
[“oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)”
“oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)”
“oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)”
“oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)”
“oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)”
“oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)”
“oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)”
“oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)”
“oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)”
“oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)”
“oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)”
“oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)”
“oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)”
“oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)”
“oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)”
“com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)”
“–> driver.sql_jdbc.execute$fn__72494.invokeStatic(execute.clj:267)”
“driver.sql_jdbc.execute$fn__72494.invoke(execute.clj:265)”
“driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:389)”
“driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)”
“driver.sql_jdbc$fn__73809.invokeStatic(sql_jdbc.clj:49)”
“driver.sql_jdbc$fn__73809.invoke(sql_jdbc.clj:47)”
“driver.oracle$eval814$fn__815.invoke(oracle.clj:264)”
“query_processor.context$executef.invokeStatic(context.clj:59)”
“query_processor.context$executef.invoke(context.clj:48)”
“query_processor.context.default$default_runf.invokeStatic(default.clj:69)”
“query_processor.context.default$default_runf.invoke(default.clj:67)”
“query_processor.context$runf.invokeStatic(context.clj:45)”
“query_processor.context$runf.invoke(context.clj:39)”
“query_processor.reducible$pivot.invokeStatic(reducible.clj:34)”
“query_processor.reducible$pivot.invoke(reducible.clj:31)”
“query_processor.middleware.mbql_to_native$mbql__GT_native$fn__45519.invoke(mbql_to_native.clj:26)”
“query_processor.middleware.check_features$check_features$fn__44821.invoke(check_features.clj:42)”
“query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45684.invoke(optimize_datetime_filters.clj:133)”
“query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47212.invoke(wrap_value_literals.clj:137)”
“query_processor.middleware.annotate$add_column_info$fn__43442.invoke(annotate.clj:574)”
“query_processor.middleware.permissions$check_query_permissions$fn__44696.invoke(permissions.clj:64)”
“query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46202.invoke(pre_alias_aggregations.clj:40)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44894.invoke(cumulative_aggregations.clj:61)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__46734.invoke(resolve_joins.clj:183)”
“query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39172.invoke(add_implicit_joins.clj:245)”
“query_processor.middleware.limit$limit$fn__45505.invoke(limit.clj:38)”
“query_processor.middleware.format_rows$format_rows$fn__45486.invoke(format_rows.clj:81)”
“query_processor.middleware.desugar$desugar$fn__44960.invoke(desugar.clj:22)”
“query_processor.middleware.binning$update_binning_strategy$fn__43986.invoke(binning.clj:229)”
“query_processor.middleware.resolve_fields$resolve_fields$fn__44502.invoke(resolve_fields.clj:24)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__38721.invoke(add_dimension_projections.clj:272)”
“query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38928.invoke(add_implicit_clauses.clj:141)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39321.invoke(add_source_metadata.clj:105)”
“query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46399.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)”
“query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43627.invoke(auto_bucket_datetimes.clj:125)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44549.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.parameters$substitute_parameters$fn__46184.invoke(parameters.clj:114)”
“query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44601.invoke(resolve_referenced.clj:80)”
“query_processor.middleware.expand_macros$expand_macros$fn__45216.invoke(expand_macros.clj:158)”
“query_processor.middleware.add_timezone_info$add_timezone_info$fn__39352.invoke(add_timezone_info.clj:15)”
“query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47096.invoke(splice_params_in_response.clj:32)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46410$fn__46414.invoke(resolve_database_and_driver.clj:33)”
“driver$do_with_driver.invokeStatic(driver.clj:61)”
“driver$do_with_driver.invoke(driver.clj:57)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46410.invoke(resolve_database_and_driver.clj:27)”
“query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45434.invoke(fetch_source_query.clj:267)”
“query_processor.middleware.store$initialize_store$fn__47105$fn__47106.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__47105.invoke(store.clj:10)”
“query_processor.middleware.cache$run_query_with_cache.invokeStatic(cache.clj:182)”
“query_processor.middleware.cache$run_query_with_cache.invoke(cache.clj:173)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__44478.invoke(cache.clj:208)”
“query_processor.middleware.validate$validate_query$fn__47114.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__45532.invoke(normalize_query.clj:22)”
“query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39190.invoke(add_rows_truncated.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47081.invoke(results_metadata.clj:147)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__44837.invoke(constraints.clj:42)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__46273.invoke(process_userland_query.clj:136)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__44780.invoke(catch_exceptions.clj:174)”
“query_processor.reducible$async_qp$qp_STAR___38004$thunk__38005.invoke(reducible.clj:101)”
“query_processor.reducible$async_qp$qp_STAR___38004$fn__38007.invoke(reducible.clj:106)”],
:context :question,
:error “ORA-00904: “source”.“İş Emri Tarihi”: invalid identifier\n”,
:row_count 0,
on the first post