ORA-29532, index contains obsolete data

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production


PL/SQL Release 9.2.0.6.0 - Production


CORE 9.2.0.6.0 Production


TNS for Solaris: Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


JChem version in the database: 3.1.4


JChem version in the Tomcat server: 3.1.4


java.vm.version: 1.4.2_10-b03


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.12





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 1


Minor JDBC version in Tomcat: 0








After some succesful insert and deletes on a a structure table


created by Jcman, and applied the index


"create index idx_jchem_struct on jcbvtmol_moltable(cd_structure) indextype is jchem.jc_idxtype"





ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: The index on table 'CHEMSPEC_TEST.JCBVTMOL_MOLTABLE' contains obsolete data.








Why ?


Are there any index maintenance routines I must perform ?


Regards,


Mikael

Hi Mikael,





The only "index maintenance routine" which might be required is the "regeneration" of JChem tables after an upgrade from an older JChem version to a newer version. But I understand that there is no upgrade involved here.





When exactly did you get the error message? During index creation?





Regards


Peter