"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:

Symptoms

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(MetaDataExtractor.java:484)
  at com.sunopsis.jdbc.driver.file.FilePreparedStatement.<init>(FilePreparedStatement.java:61)
  at com.sunopsis.jdbc.driver.file.FileConnection.prepareStatement(FileConnection.java:416)
  at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
  at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:231)
  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)
  ...

Cause

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