This content has been marked as final. Show 6 replies
There can be a couple of things that can cause this issue; basically this is an issue with Oracle Text / Spatial indexes.
1. Ensure that there is enough tablespace space available for both data and indexes.
2. Ensure that Oracle Text is installed correctly.
If the above are fine, then try dropping and recreating the index on the Problem Summary column. The name of the index is SUMMARY_CTX_INDEX. Ensure that you use scripts that are provided by Oracle to create the index. Run the script cssrcrix.sql and pass the cs schema name(i.e @cssrcrix CS). This creates the SUMMARY_CTX_INDEX Text index.
Please check metalink note Note:312640.1 for more info on building this index.
Thanks for your response.
I got it working 1 week back.. but thanks for your response.
Can you share the resolution?
I also got the following error before i get this error
The User-Resource Link is not setup Correctly.Please contact sysadmin
Solution: Create Employee in HR
2) Import Resource by that employee Name
3) Resource Details - Under User Name match to the LOGIN Name
After I did the above steps.. I didnt get any error and was able to create SR.
I was not sure.. what was the exact solution... :)
I want to know if we have a file poller polling every 3 secs...deployed on cluster what property we need to maintain to make sure only one is active,
and only one file is picked every 3 sec????
This issue shouldn't have allowed you to open the workbench.
Anyways we will never know why you got the oracle text error.