OBIEE 12c Server Logs Show Repeated Errors: "Java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]ResultSet Is Not Updateable" (Doc ID 2373787.1)

Last updated on AUGUST 13, 2023

Applies to:

Symptoms

The biserver logs in an OBIEE 12.2.1.3 environment are showing repeated errors similar to those below:

java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]ResultSet is not updateable.
at weblogic.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddcv.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddea.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddea.updateString(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddea.updateString(Unknown Source)
at weblogic.jdbc.wrapper.ResultSet_weblogic_jdbc_sqlserverbase_ddeb.updateString(Unknown Source)
at oracle.biee.search.services.crawl.scheduler.dao.impl.SQLServerSchedulerDAOImpl.pickupScheduledJob(SQLServerSchedulerDAOImpl.java:71)
at oracle.biee.search.services.crawl.scheduler.BISearchCrawlScheduleExecutor.executeScheduledCrawls(BISearchCrawlScheduleExecutor.java:152)
at oracle.biee.search.services.crawl.scheduler.BISearchCrawlScheduleExecutor.run(BISearchCrawlScheduleExecutor.java:86)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)

Additionally when trying to run BISearch queries or open a scheduled report, the errors below may be reported:

[2018-02-09T15:08:48.734-05:00] [bi_server1] [NOTIFICATION] [] [oracle.biee.search] [tid: BISearchCrawlScheduler] [userId: ] [ecid: 37e2b6c3-7c2c-4248-ae42-0e6a8af9bdd9-00000009,0:122] [APP: bisearch] [partition-name: DOMAIN] [tenant-name: GLOBAL] Error while picking up scheduled job[[
java.sql.SQLException: Exception while executing JDBC operation
at oracle.biee.search.services.crawl.scheduler.dao.impl.SQLServerSchedulerDAOImpl.pickupScheduledJob(SQLServerSchedulerDAOImpl.java:82)
at oracle.biee.search.services.crawl.scheduler.BISearchCrawlScheduleExecutor.executeScheduledCrawls(BISearchCrawlScheduleExecutor.java:152)
at oracle.biee.search.services.crawl.scheduler.BISearchCrawlScheduleExecutor.run(BISearchCrawlScheduleExecutor.java:86)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]ResultSet is not updateable.
....

Changes

 Upgraded from OBIEE 11g to 12c

Cause

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