OSM 7.2.4.2.0 Patch Installation java.sql.SQLException:ORA-04013: Number To CACHE Must Be Less Than One Cycle (Doc ID 2115702.1)

Last updated on MARCH 28, 2016

Applies to:

Oracle Communications Order and Service Management - Version 7.2.4 and later
Information in this document applies to any platform.

Symptoms

During OSM 7.2.4.2.0 installation, the customer is getting bellow error and DB upgrade failed.
ERROR
-----------------------

Nested Exception: java.sql.SQLException: ORA-04013: number to CACHE must be less than one cycle
ORA-06512: at line 14

  at oracle.communications.ordermanagement.install.db.plan.InstallActionProcessor.process(InstallActionProcessor.java:34)
  at oracle.communications.ordermanagement.install.db.plan.InstallPlan.execute(InstallPlan.java:458)
  at com.mslv.install.db.processor.ApplicationProcessor.upgradeApplicationModel(ApplicationProcessor.java:943)
  at com.mslv.install.db.processor.ApplicationProcessor.importApplicationModel(ApplicationProcessor.java:164)
  at com.mslv.install.db.ImportDBTask.execute(ImportDBTask.java:39)
  at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)
  at org.apache.tools.ant.Task.perform(Task.java:348)
  at org.apache.tools.ant.Target.execute(Target.java:392)
  at org.apache.tools.ant.Target.performTasks(Target.java:413)
  at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)
  at org.apache.tools.ant.Project.executeTarget(Project.java:1368)
  at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)
  at org.apache.tools.ant.Project.executeTargets(Project.java:1251)
  at com.mslv.oms.installation.AntExecAction.run(AntExecAction.java:350)
  at java.lang.Thread.run(Unknown Source)

Caused by: com.mslv.install.db.util.DbManagerException: ORA-04013: number to CACHE must be less than one cycle



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