hi every one
we are using metabase with oracle and every thing is ok till we change database column from date to timespan after that we get this message all the time “Invalid column type” we deside to change the column back to it’s previous datataype but still we have the same issue, we try to change the dattype from the data model but still the same issue
enviroment
{
“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36 OPR/72.0.3815.400”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “Cp1256”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.10+4-202011272341”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.10”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.10+4-202011272341”,
“os.name”: “Windows 7”,
“os.version”: “6.1”,
“user.language”: “en”,
“user.timezone”: “Africa/Cairo”
},
“metabase-info”: {
“databases”: [
“mysql”,
“h2”,
“oracle”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-11-16”,
“tag”: “v0.37.2”,
“branch”: “release-x.37.x”,
“hash”: “25e5f70”
},
“settings”: {
“report-timezone”: null
}
}
}
Hi @Ramis
Please post the full error from Admin > Troubleshooting > Logs.
Which version of ojdbc8.jar are you using?
https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html
You should migrate away from H2 as the application database:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html
hi @flamber thanks for your quick reply this is the log and i am using ojdbc7
log:
“query_processor.reducible$async_qp$qp_STAR___39827$thunk__39828.invoke(reducible.clj:103)”
“query_processor.reducible$async_qp$qp_STAR___39827.invoke(reducible.clj:109)”
“query_processor.reducible$sync_qp$qp_STAR___39836$fn__39839.invoke(reducible.clj:135)”
“query_processor.reducible$sync_qp$qp_STAR___39836.invoke(reducible.clj:134)”
“query_processor$process_userland_query.invokeStatic(query_processor.clj:237)”
“query_processor$process_userland_query.doInvoke(query_processor.clj:233)”
“query_processor$fn__49234$process_query_and_save_execution_BANG___49243$fn__49246.invoke(query_processor.clj:249)”
“query_processor$fn__49234$process_query_and_save_execution_BANG___49243.invoke(query_processor.clj:241)”
“query_processor$fn__49278$process_query_and_save_with_max_results_constraints_BANG___49287$fn__49290.invoke(query_processor.clj:261)”
“query_processor$fn__49278$process_query_and_save_with_max_results_constraints_BANG___49287.invoke(query_processor.clj:254)”
“api.dataset$fn__52603$fn__52606.invoke(dataset.clj:59)”
“query_processor.streaming$streaming_response_STAR_$fn__37131$fn__37132.invoke(streaming.clj:73)”
“query_processor.streaming$streaming_response_STAR_$fn__37131.invoke(streaming.clj:72)”
“async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)”
“async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)”
“async.streaming_response$do_f_async$fn__24639.invoke(streaming_response.clj:85)”],
:context :ad-hoc,
:error “Invalid column type”,
:row_count 0,
:running_time 0,
:data {:rows [], :cols []}}
[c037b808-946f-4ccc-92df-1abb8e1e1258] 2020-12-05T20:33:07+02:00 DEBUG metabase.middleware.log POST /api/dataset 202 [ASYNC: completed] 758.7 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (3 idle, 0 queued) (100 total active threads) Queries in flight: 0 (0 queued)
[c037b808-946f-4ccc-92df-1abb8e1e1258] 2020-12-05T20:33:31+02:00 DEBUG metabase.middleware.log GET /api/util/bug_report_details 200 34.5 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 4/50 (3 idle, 0 queued) (100 total active threads) Queries in flight: 0 (0 queued)