error on create jc index

Code:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-29532: Java call terminated by uncaught Java exception: java.lang.Exception: The following exception has been thrown by the servlet: Exception: ORA-03127: no new operations allowed until the active operation ends ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-29532: Java call terminated by uncaught Java exception: java.lang.Exception: The following exception has been thrown by the servlet: Exception: ORA-03127: no new operations allowed until the active operation ends BEGIN * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-29532: Java call terminated by uncaught Java exception: java.lang.Exception: The following exception has been thrown by the servlet: Exception: ORA-03127: no new operations allowed until the active operation ends ORA-06512: at "CSPACE.QUICKBUILDPCKV3", line 1597 ORA-06512: at line 2

I am creating a number of jchem index in quick succession and have come across the error message above...





Do you have any advice on how to avoid this error - perhaps a v$ view could help determine if this error is likely to occur and in conjunction issue a wait/pause command in PL/SQL might help to avoid it being thrown?





Cheers,


Daniel.

Hi Daniel,





Please, could you post the the Java stack trace from the Tomcat log?





Please, could you also specify which JChem, Oracle and JDBC version you use? (The JDBC version is written out to the Tomcat log at the first JChem Catridge index/search operation.)





Thanks


Peter

I think this could be the assocaited error...cheers, db.





SEVERE: IOException while loading persisted sessions: java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: oracle.jdbc.driver.T4CConnection


java.io.WriteAbortedException: writing aborted; java.io.NotSerializableException: oracle.jdbc.driver.T4CConnection


at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1309)


at java.io.ObjectInputStream.defaultReadFields(ObjectInputStream.java:1908)


at java.io.ObjectInputStream.readSerialData(ObjectInputStream.java:1832)


at java.io.ObjectInputStream.readOrdinaryObject(ObjectInputStream.java:1719)


at java.io.ObjectInputStream.readObject0(ObjectInputStream.java:1305)


at java.io.ObjectInputStream.readObject(ObjectInputStream.java:348)


at org.apache.catalina.session.StandardSession.readObject(StandardSession.java:1392)


at org.apache.catalina.session.StandardSession.readObjectData(StandardSession.java:921)


at org.apache.catalina.session.StandardManager.doLoad(StandardManager.java:393)


at org.apache.catalina.session.StandardManager.load(StandardManager.java:320)


at org.apache.catalina.session.StandardManager.start(StandardManager.java:636)


at org.apache.catalina.core.ContainerBase.setManager(ContainerBase.java:431)


at org.apache.catalina.core.StandardContext.start(StandardContext.java:4155)


at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)


at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)


at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)


at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)


at org.apache.catalina.core.StandardService.start(StandardService.java:450)


at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)


at org.apache.catalina.startup.Catalina.start(Catalina.java:551)


at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


at java.lang.reflect.Method.invoke(Method.java:585)


at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)


at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)


Caused by: java.io.NotSerializableException: oracle.jdbc.driver.T4CConnection


at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1081)


at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375)


at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1347)


at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290)


at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079)


at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302)


at org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1468)


at org.apache.catalina.session.StandardSession.writeObjectData(StandardSession.java:938)


at org.apache.catalina.session.StandardManager.doUnload(StandardManager.java:516)


at org.apache.catalina.session.StandardManager.unload(StandardManager.java:462)


at org.apache.catalina.session.StandardManager.stop(StandardManager.java:666)


at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4358)


at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1066)


at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1066)


at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:447)


at org.apache.catalina.core.StandardService.stop(StandardService.java:512)


at org.apache.catalina.core.StandardServer.stop(StandardServer.java:743)


at org.apache.catalina.startup.Catalina.stop(Catalina.java:601)


at org.apache.catalina.startup.Catalina$CatalinaShutdownHook.run(Catalina.java:644)

No, this error is for something else.





Look for ORA-03127 in the Tomcat log file.





Cheers,


Peter

Hi Peter,





I have searched tomcat_home/logs using ORA-03127 and it finds nothing...bizarre - if it happens again, I'll be sure to send you proper output - for now I guess we should wait as I cannot give you associated errors with any confidence.





Cheers,


Daniel.