Passing Parameters into a BI Publisher Report Created with Subject Area Results in a Java Error - String Index Out Of Range: -31 (Doc ID 2459036.1)

Last updated on DECEMBER 05, 2021

Applies to:

Symptoms

In BI Publisher 12.2.1.3.0, the following error can occur when passing parameters into a report created with subject area.


ERROR
-----------------------

[2018-07-25T12:13:15.467-04:00] [bi_server1] [WARNING] [] [oracle.xdo] [tid: 197] [userId: weblogic] [ecid: a0fbcaaa-f0e0-4661-a644-0d37fbbc4a78-0000000c,0:2151:2] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] [xdojobid: 1652] [essjobid: null] !!!!!!! CPFileDB.file_updateCPInfo :: Exception occurred during update of record in Checkpoint Store. String index out of range: -31 : java.lang.StringIndexOutOfBoundsException: String index out of range: -31[[
at java.lang.String.substring(String.java:1960)
at oracle.xdo.enterpriseScheduler.admin.checkpoint.file.CPFileDB.file_updateCPInfo(CPFileDB.java:479)
at oracle.xdo.enterpriseScheduler.admin.checkpoint.file.ServiceSupport.put(ServiceSupport.java:561)
at oracle.xdo.enterpriseScheduler.admin.checkpoint.file.ServiceSupport.check(ServiceSupport.java:263)
  ... (10 instances)

[2018-07-25T12:16:35.664-04:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 129] [userId: ] [ecid: dca620e66e4c1117:-3f0a5a69:164b9b3169a:-8000-00000000000c50a3,1:50396:1] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] [Line 192.281] cannot close at [Line 151.6114]
[2018-07-25T12:16:35.820-04:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 129] [userId: ] [ecid: dca620e66e4c1117:-3f0a5a69:164b9b3169a:-8000-00000000000c50a3,1:50396:1] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] [Line 192.281] cannot close at [Line 151.6114]

[2018-07-25T12:23:47.265-04:00] [bi_server1] [ERROR] [] [oracle.xdo] [tid: 110] [userId: ] [ecid: a0fbcaaa-f0e0-4661-a644-0d37fbbc4a78-0002ac9e,0] [APP: bipublisher] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SI-Key: ssi] java.lang.ClassNotFoundException: oracle.apps.fnd.applcore.common.prefs.PreferencesExtractor[[
at weblogic.utils.classloaders.GenericClassLoader.findLocalClass(GenericClassLoader.java:1029)
at weblogic.utils.classloaders.GenericClassLoader.findClass(GenericClassLoader.java:990)
at weblogic.utils.classloaders.GenericClassLoader.doFindClass(GenericClassLoader.java:611)
at weblogic.utils.classloaders.GenericClassLoader.loadClass(GenericClassLoader.java:543)

Cause

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