JDBC Data Source For Oracle Database Connection Fails with: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource: oracle.jdbc.driver.BlockSource.createBlockSource - Known Error

JDBC Data Source For Oracle Database Connection Fails with: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource: oracle.jdbc.driver.BlockSource.createBlockSource Description Oracle JDBC connection fails when the data source is directly connected to the Oracle database, i.e. no mid server is used, with this error:

Failure during scheduled run of job: fa3846f00b522200d109061437673ad4: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.BlockSource$ThreadedCachingBlockSource: oracle.jdbc.driver.BlockSource.createBlockSource(BlockSource.java:90) oracle.jdbc.driver.BlockSource.createBlockSource(BlockSource.java:82) oracle.jdbc.driver.PhysicalConnection.setBlockSource(PhysicalConnection.java:718) oracle.jdbc.driver.PhysicalConnection. (PhysicalConnection.java:754) oracle.jdbc.driver.T4CConnection. (T4CConnection.java:495) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:56) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) java.sql.DriverManager.getConnection(DriverManager.java:664) java.sql.DriverManager.getConnection(DriverManager.java:208) com.glide.db.impex.JDBCLoader.preLoad(JDBCLoader.java:160) com.glide.db.impex.AbstractLoader.createColumnAttributes(AbstractLoader.java:556) com.glide.db.impex.AbstractLoader.createTableAndMap(AbstractLoader.java:321) com.glide.db.impex.AbstractLoader.createTableForImport(AbstractLoader.java:293) com.glide.db.impex.AbstractLoader.load(AbstractLoader.java:181) com.glide.db.impex.AbstractLoader.startWork(AbstractLoader.java:163) com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:126) com.glide.worker.HierarchicalProgressWorker.startAndWait(HierarchicalProgressWorker.java:35) com.glide.worker.AbstractProgressWorker.start(AbstractProgressWorker.java:101) com.glide.processors.ImportProcessorWorker.startWorker(ImportProcessorWorker.java:331) com.glide.processors.ImportProcessorWorker.loadDataSource(ImportProcessorWorker.java:172) com.glide.processors.ImportProcessorWorker.startWork(ImportProcessorWorker.java:110) com.glide.worker.AbstractProgressWorker.startAndWait(AbstractProgressWorker.java:126) com.glide.worker.HierarchicalProgressWorker.startAndWait(HierarchicalProgressWorker.java:35) com.glide.worker.BackgroundProgressJob.execute(BackgroundProgressJob.java:59) com.glide.schedule.JobExecutor.lambda$executeJob$0(JobExecutor.java:115) com.glide.schedule.JobExecutor.executeJob(JobExecutor.java:118) com.glide.schedule.JobExecutor.execute(JobExecutor.java:102) com.glide.schedule_v2.SchedulerWorkerThread.executeJob(SchedulerWorkerThread.java:300) com.glide.schedule_v2.SchedulerWorkerThread.lambda$process$0(SchedulerWorkerThread.java:188) com.glide.worker.TransactionalWorkerThread.executeInTransaction(TransactionalWorkerThread.java:35) com.glide.schedule_v2.SchedulerWorkerThread.process(SchedulerWorkerThread.java:188) com.glide.schedule_v2.SchedulerWorkerThread.run(SchedulerWorkerThread.java:102)

Steps to Reproduce

(1) Have a JDBC Data Source that connects to an Oracle database directly, i.e. no mid server is used.

(2) Do a Test Load 20 or All Records from the Related Links of the Data Source, the error will be seen.

Workaround As a workaround a mid server can be used for the JDBC Data Source connection until the instance is upgraded to one of the fixed versions.

NOTE: After the instance is upgraded to a version where this PRB is fixed do the following steps:

(1) Create this System Property as follows in sys_properties:

Name = glide.sys.gc.allow_runtime_low_mem_event_threshold_pct_change Type = true|false Value = true

(2) Have ServiceNow Technical Support restart the instance