molecule insertion failure

Hi I am using following statement to insert smiles into a standard table, in standard table molecule column is varchar2, it has smiles, no problem to put the cart index on this column, and i can do sss on this column too. I am trying to add more molecules to this table through following statement , i am getting error:

ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20101: Cannot read molecule file.
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 36
ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 686

here is my insert statement:

insert into molecules (molecule, file_id, source )
select smiles, file_id, 'D2S-'||file_id||'-'||row_number() over (partition by file_id order by smiles ) as id from tmp_d2s_only

 

Hi,

We need the structure which causes this error.

Thanks,

Peter

i remvoed the offending structure from the tmp table, the insertion finsihed well, the error message is a bit generic, usually i check the validity of the mol ...

thanks

dong