Date fields exort problem

Bug reports
1

Hi.
Export to csv and export cutting out time part of date fields. In metabase gui displays time part correctly.
Metabase v0.34.1/ Windows

2

Hi @Max.A
I cannot reproduce this - how are you opening the CSV file?
Did you upgrade from a previous version, where it used to work? Which version?
Can you post “Diagnostic Info” from Admin > Troubleshooting?

3

Hi flamber

I’ve opened csv as a text file to make sure. Only dates without time.

Yes, it was migrated from 0.33.6.

Dignostic info

{

“browser-info”: {

"language": "en-US",

"platform": "MacIntel",

"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.5 Safari/605.1.15",

"vendor": "Apple Computer, Inc."

},

“system-info”: {

"java.runtime.name": "Java(TM) SE Runtime Environment",

"java.runtime.version": "1.8.0_162-b12",

"java.vendor": "Oracle Corporation",

"java.vendor.url": "http://java.oracle.com/",

"java.version": "1.8.0_162",

"java.vm.name": "Java HotSpot(TM) 64-Bit Server VM",

"java.vm.version": "25.162-b12",

"os.name": "Windows Server 2012 R2",

"os.version": "6.3",

"user.language": "en",

"user.timezone": "Europe/Moscow"

},

“metabase-info”: {

"databases": [

  "oracle"

],

"hosting-env": "unknown",

"application-database": "h2",

"run-mode": "prod",

"version": {

  "tag": "v0.34.1",

  "date": "2020-01-13",

  "branch": "release-0.34.x",

  "hash": "265695c"

},

"settings": {

  "report-timezone": null

}

}

}

4

@Max.A I would recommend that you upgrade your Java - perhaps even try a different major version:
https://adoptopenjdk.net/releases.html?variant=openjdk11&jvmVariant=hotspot
Which version of ojdbc8.jar are you using - the recommended is 19c:
https://www.metabase.com/docs/latest/administration-guide/databases/oracle.html

5

Hi flamber,
I’ve got last version of ojdbc8 as you advised. No any changes, still can’t export date with time.
I guess it’s not jdbc problem - gui displays date and time in correct way.
Regards
Max

6

@Max.A I cannot reproduce this problem on 0.34.3
Is it the same problem if you export as JSON or XLSX?
Are you seeing the same problem if you export as CSV from the Sample Dataset?

7

Moved to 0.34.3. Still no time for all possible exports (cvs, json, xlsx ).
For Sample Dataset export works correctly.

8

@Max.A Okay, so it seems like it might be specific to Oracle.
Which version of Oracle are you using?
Which specific version of ojdbc8.jar are you using?
And what’s the SHA1 checksum?

9

Hi flamber
Oracle 12.1.0.2.0
JDBC size4.02 Mb (4210517 bytes) sha1 967C0B1A2D5B1435324DE34A9B8018D294F8F47B
Implementation-Version: 19.3.0.0.0
Ant-Version: Apache Ant 1.7.1
Repository-Id: JAVAVM_19.0.0.0.0_LINUX.X64_190404
Created-By: 25.201-b09 (Oracle Corporation)
Specification-Version: 4.2