Skip to main content
  • EN

When reading data from an Oracle database where the table holds timestamp information then I am getting the error

Error converting from OCI datetime to C character string : `ORA-01805: possible error in date/time operation' (serverType=`ORACLE8i', serverName=`***', userName=`***', password=`***', dbname=`')

In FME Desktop 2018.1.0.2 can I reproduce the error in OracleSpatialObject reader and in SQLExecutor.

 

The error does not occur in FME Desktop 2017.1.2.1, neither does e.g. DBeaver has a problem to read and show the timestamps.

I checked in FME Desktop and in DBeaver with 

select * from v$timezone_file

 what timezone_file is used, and in both cases it is timezlrg_18.dat

It could possibly be a mismatch between the Oracle db and client time zone definitions.

You can check the client time zone using the genezi utility that's installed with the Oracle client, e.g.

If the problem persists, my first recommendation would be to upgrade to the latest version of the Oracle client.

Hi @tb09114

if the problem persists, could you please share a small data dump with us? We would like to investigate the problem. Either an attachment here or a support case would be great.

Thank you in advance.

It could possibly be a mismatch between the Oracle db and client time zone definitions.

You can check the client time zone using the genezi utility that's installed with the Oracle client, e.g.

If the problem persists, my first recommendation would be to upgrade to the latest version of the Oracle client.

I'm finding the same error with FME 2019.1.2.0 Build 19630 Win64, installed on Windows 10. I've installed the Oracle Instant Client 11.2 and although I have no trouble connecting to the database, I'm still getting the ORA-01805 error exactly as described above. Other products that I use, including Oracle SQL Developer and AquaData Studio don't seem to have an issue.

Has anyone found a fix? I noticed that in the FME log the ORACLE_NONSPATIAL dataset is defined as having "server type 'ORACLE8i'. Could this be the source of the problem?

I'm finding the same error with FME 2019.1.2.0 Build 19630 Win64, installed on Windows 10. I've installed the Oracle Instant Client 11.2 and although I have no trouble connecting to the database, I'm still getting the ORA-01805 error exactly as described above. Other products that I use, including Oracle SQL Developer and AquaData Studio don't seem to have an issue.

Has anyone found a fix? I noticed that in the FME log the ORACLE_NONSPATIAL dataset is defined as having "server type 'ORACLE8i'. Could this be the source of the problem?

Hi @kddunn, You can ignore the reference to Oracle8i. This is a message that happens to contain a legacy reference... you can assume "server type "Oracle'".

As for the error. I don't believe we ever received and data from @tb09114, so perhaps he solved this another way.

I don't recall seeing this error code before. So if you are in a position to share some data that could reproduce the issue, please do! You can open a support case with Safe Software Support.

Community Stats

31,955
Posts
121,345
Replies
39,565
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.