My Oracle Support Banner

"ODI-40487: Unknown file format" When Attempting to "View Data" From a JSON File (Doc ID 2577892.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


In Oracle Data Integrator (ODI), after successfully reverse-engineering of a JSON file, the following error occurs while trying to "View Data" using ODI Studio:

java.sql.SQLException: ODI-40487: Unknown file format:
  at com.sunopsis.jdbc.driver.file.impl.metadata.MetaDataExtractor.buildTableDescFromRequestSQLExceptionOnly(
  at com.sunopsis.jdbc.driver.file.FilePreparedStatement.<init>(
  at com.sunopsis.jdbc.driver.file.FileConnection.prepareStatement(
  at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  at java.lang.reflect.Method.invoke(
  at com.sun.proxy.$Proxy48.prepareStatement(Unknown Source)
  at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown Source)
  at com.borland.dx.sql.dataset.o.a(Unknown Source)
  at com.borland.dx.sql.dataset.o.d(Unknown Source)
  at com.borland.dx.sql.dataset.o.f(Unknown Source)
  at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)
  at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
  at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
  at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.