Today while running the Maintain Multi-lingual tables through adadmin for the post language enablement step, it failed for the script JTFNLINS.sql with the below error.
MESG--------------------------------------------------------------------------------LANGUAGE=AMERICANPACKAGE=JTF_NOTES_PKGSQLERRM=ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
select to_date('ERROR') *ERROR at line 1:ORA-01858: a non-numeric character was found where a numeric was expected
After little research on metalink, found that the domain index JTF_NOTES_TL_C1 is causing the issue.
Resolution:
- Drop index JTF.JTF_NOTES_TL_C1 force;
- sqlplus apps/apps @$JTF_TOP/patch/115/sql/jtfntsci.sql JTF JTF
- Restart the failed adadmin job through adctrl or execute the script JTFNLINS.sql manually
