IV33173: PACKAGE_MGMT CODE REQUESTS A READ-ONLY CONNECTION FROM ORACLE

Service Quality Manager patch 4.1.4-TIV-TNSQM-IF0010

APAR status

• Closed as program error.

Error description

• Unable to provision packages. Errors with full stack trace found
  in the log:-
  
  18:41:14,052 [main] ERROR @.ant - XML-0006 : Target {0} finished
  with error. {0}
  /appl/sa/admin/provision/packageBuild.xml:134:
  java.lang.Exception: java.sql.SQLException: ORA-01456: may not
  perform insert/delete/update operation inside a READ ONLY
  transaction
  
   at
  com.comnitel.sm.provisioning.broker.ant.PackageBrokerTask.execut
  e(PackageBrokerTask.java:329)
   at
  org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:
  275)
   at org.apache.tools.ant.Task.perform(Task.java:364)
   at org.apache.tools.ant.Target.execute(Target.java:341)
   at org.apache.tools.ant.Target.performTasks(Target.java:369)
   at
  org.apache.tools.ant.Project.executeSortedTargets(Project.java:1
  216)
   at
  org.apache.tools.ant.Project.executeTarget(Project.java:1185)
   at
  org.apache.tools.ant.helper.DefaultExecutor.executeTargets(Defau
  ltExecutor.java:40)
   at
  org.apache.tools.ant.Project.executeTargets(Project.java:1068)
   at org.apache.tools.ant.Main.runBuild(Main.java:668)
   at org.apache.tools.ant.Main.startAnt(Main.java:187)
   at org.apache.tools.ant.launch.Launcher.run(Launcher.java:246)
   at org.apache.tools.ant.launch.Launcher.main(Launcher.java:67)
  Caused by:
  java.lang.Exception: java.sql.SQLException: ORA-01456: may not
  perform insert/delete/update operation inside a READ ONLY
  transaction
  
   at
  com.comnitel.sm.provisioning.broker.ant.db.PkgPersister.updatePa
  ckage(PkgPersister.java:332)
   at
  com.comnitel.sm.provisioning.common.PackageTaskHelper.updatePack
  age(PackageTaskHelper.java:235)
   at
  com.comnitel.sm.provisioning.broker.ant.PackageBrokerTask.execut
  e(PackageBrokerTask.java:311)
   ... 12 more
  

Local fix

Problem summary

• Package provisioning cannot write package metadata to database
  tables as it requests a read-only connection.
  

Problem conclusion

• Fix will be available as part of 4.1.4-TIV-TNSQM-IF0010
  Available for download 25/01/2013
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  NETCOOL SVC QUA

• Fixed component ID

  5724T0300

Applicable component levels

• R414 PSY

     UP