1063
Points
Questions
5
Answers
8
-
Hi Kevin,
Thanks for your update, I have CTXSYS schema in DB, but the issue is in CTXSYS schema, all these issues started when we imported latest data base file demp agile9_imp into our Agile schema earlier, with your help all those package errors were gone, but after that I see below errors in CTXSYS packages, the issue “oracle looping chain of synonyms” error, not sure what to do.
Thanks
- 2437 views
- 10 answers
- 0 votes
-
Hi Kevin,
Thanks for update, oracle team has suggested below solution, is this needed?
Step1: Download the Examples:Please refer the below KM where to download the examples CD.
Where to Download the Oracle Database 11g, Examples CD for Oracle Database 11g, WebLogic or Application Server, and Agile Software for an Agile Product Lifecycle Management (PLM) Install/Upgrade ( Doc ID 850131.1 )
Step2:
Please follow below steps to resolve the issue.1. On the Example CD (Formerly Companion CD) locate the following directory:
stageComponentsoracle.demo.cartridges.context10.1.0.2.01DataFiles2. Open group1.1.jar with WinZip or other compatible utility and extract the files to
%Oracle_home%ctxdataenlx directory3. The six files are…
drofdUS.dat
drofiUS.dat
droldUS.dat
droliUS.dat
drolkUS.dat
drolsUS.datNote that this part is kept internal as the steps for Oracle 11g and above is unknown as Example CD has different file structure.
4. Run agile9_fts.sql, and confirm that it completes without the error- 2437 views
- 10 answers
- 0 votes
-
- 2437 views
- 10 answers
- 0 votes
-
Hi Kevin,
After running the script dbmspool.sql, I am able to remove one error out of 4 , but still another 3 packages showing errors, could you please help.
below packages shows errors, please check screen shot, your help is much appreciated.AGILE9_UTILS
AGILE_SERVER_BOM_EXPANSION
AGILE_SERVER_BOM_ITERATIONThanks
- 2437 views
- 10 answers
- 0 votes
-
- 2437 views
- 10 answers
- 0 votes
-
- 4516 views
- 2 answers
- 0 votes
-
- 1666 views
- 2 answers
- 0 votes
-
- 1887 views
- 5 answers
- 0 votes