Skip to main content
Question

Datetime handling possible bug in FME Desktop 2018?

  • September 13, 2018
  • 4 replies
  • 70 views
tb09114
Supporter
Forum|alt.badge.img+23

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

4 replies

david_r
Celebrity
  • david_rCelebrity
  • September 13, 2018

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.

L
Forum|alt.badge.img
  • lenaatsafe
  • September 14, 2018

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.

K
Forum|alt.badge.img
  • kddunn
  • September 4, 2019
david_r wrote:

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?

steveatsafe
Safer
Forum|alt.badge.img+12
  • steveatsafeSafer
  • Safer
  • September 10, 2019
kddunn wrote:

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.

SteveatSafe

Reply


Helpful Members This Week

Community Stats

31,250
Posts
118,507
Replies
38,840
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.