AssertionError in OraIntrospector when updating Oracle DB schema definitions.

I have trouble with one of my Oracle database. Always when I click synchronize i get error:

 

java.lang.AssertionError: Failed to obtain the current timestamp from the database
at com.intellij.database.dialects.oracle.introspector.OraIntrospector$OraSchemaRetriever.retrieveEntireSchema(OraIntrospector.kt:635)
at com.intellij.database.dialects.oracle.introspector.OraIntrospector$OraSchemaRetriever.retrieveMain$intellij_database_dialects(OraIntrospector.kt:625)
at com.intellij.database.dialects.oracle.introspector.OraIntrospector.introspectSchemasAuto(OraIntrospector.kt:217)
at com.intellij.database.dialects.base.introspector.BaseSingleDatabaseIntrospector.introspectAutoInTran(BaseSingleDatabaseIntrospector.kt:53)
at com.intellij.database.dialects.base.introspector.BaseIntrospector$introspectAuto$2.invoke(BaseIntrospector.kt:269)
at com.intellij.database.dialects.base.introspector.BaseIntrospector$introspectAuto$2.invoke(BaseIntrospector.kt:43)
at com.intellij.database.dialects.base.introspector.BaseIntrospector$inTransaction$1.run(BaseIntrospector.kt:189)
at org.jetbrains.dekaf.core.BaseFacade.inSession(BaseFacade.java:108)
at com.intellij.database.dialects.base.introspector.BaseIntrospector.inTransaction(BaseIntrospector.kt:189)
at com.intellij.database.dialects.base.introspector.BaseIntrospector.inTransactionUnit(BaseIntrospector.kt:185)
at com.intellij.database.dialects.base.introspector.BaseIntrospector.introspectAuto(BaseIntrospector.kt:269)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession$IntrospectionProcessor.processDatabases(DatabaseModelLoader.java:365)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$null$2(DatabaseModelLoader.java:406)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.withFacade(DatabaseModelLoader.java:670)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$introspect$3(DatabaseModelLoader.java:394)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$null$0(DataSourceSyncManager.java:45)
at com.intellij.database.console.session.SessionsUtil$function$1.invoke(SessionsUtil.kt:9)
at com.intellij.database.console.session.DatabaseSessionManager$Facade.compute(DatabaseSessionManager.kt:309)
at com.intellij.database.console.session.DatabaseSessionManager$Facade.runSync(DatabaseSessionManager.kt:250)
at com.intellij.database.dataSource.DataSourceSyncManager.lambda$static$1(DataSourceSyncManager.java:43)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor$1.perform(DataSourceSyncManager.java:275)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.introspect(DatabaseModelLoader.java:394)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.lambda$run$1(DatabaseModelLoader.java:307)
at com.intellij.database.dataSource.LocalDataSource.performBatch(LocalDataSource.java:1292)
at com.intellij.database.dataSource.DatabaseModelLoader$IntrospectionSession.run(DatabaseModelLoader.java:305)
at com.intellij.database.dataSource.DataSourceSyncManager$SyncProcessor.performSync(DataSourceSyncManager.java:277)
at com.intellij.database.dataSource.AsyncUtil.lambda$null$6(AsyncUtil.java:59)
at com.intellij.database.dataSource.AsyncUtil.lambda$underProgress$14(AsyncUtil.java:140)
at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:586)
at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:532)
at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:86)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:146)
at com.intellij.database.dataSource.AsyncUtil.underProgress(AsyncUtil.java:140)
at com.intellij.database.dataSource.AsyncUtil.lambda$captureIndicator$7(AsyncUtil.java:59)
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1590)
at com.intellij.openapi.application.impl.ApplicationImpl$1.run(ApplicationImpl.java:311)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748) (no stack trace).
Failed to obtain the current timestamp from the database

 

3 comments
Comment actions Permalink

@Vsevolod,

Could you specify your DataGrip version and full server and jdbc driver versions?

0
Comment actions Permalink

I used Intellij IDEA Ultimate 2018.2, now use Intellij IDEA Ultimate 2019.1 with the same error.

oracle.jdbc.OracleDriver ver. 12.1.0.2

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

0
Comment actions Permalink

@Vsevolod,

Could you try to reproduce the issue in IDEA Ultimate 2019.2 EAP?

0

Please sign in to leave a comment.