My Oracle Support Banner

OBIEE 12c: サーバー・ログに "Java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver]ResultSet Is Not Updateable" エラーが繰り返し表示される (Doc ID 2547284.1)

Last updated on NOVEMBER 12, 2019

適用範囲:

Business Intelligence Server Enterprise Edition - バージョン 12.2.1.3.0 以降
この文書の内容はすべてのプラットフォームに適用されます。

現象

OBIEE 12.2.1.3 環境の bi_serverN 管理対象サーバのログに、次のようなエラーが繰り返し表示されています。

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)

また、BI コンテンツの検索 (BISearch) を実行しようとしたり、スケジュールされたレポートを開こうとすると、以下のエラーが出力されることがあります。

[2018-02-09T15:08:48.734-05:00] [bi_server1] [NOTIFICATION] [] [oracle.biee.search] [tid: <TID>] [userId: ] [ecid: <ECID>] [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.
....

 

変更点

OBIEE を 11g から 12c にアップグレード

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.