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 MARCH 14, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms