How to Cleanup SES Statistics Data
All the SES Query log data, which you see in various tabs of SES console, including General tab, Statistics tab is stored in the SES database. There are situations wherein you might need to clean this data for example, if you want to capture statistics of a query, which has performance issues and you want […]
Continue reading
5
[INS-20802] Oracle Net Configuration Assistant failed.
During the installation of SES, you may come across an error “[INS-20802] Oracle Net Configuration Assistant failed.” This error is due to conflict between a declared environment variable and a configuration value provided during the installation. The variable usually causing this is “ORACLE_HOME” You can get further details of this issue from the log file […]
Continue reading
2
Report Sync Issues in SES
When you uninstall and reinstall a SES instance or you refresh a PeopleSoft instance, you can end up getting several trivial issues. Most of these issues revolve around the fact that the PeopleSoft database and the SES database have gone out of sync. The obvious way to resolve these error is to do “Report Sync […]
Continue reading
1
Java Out of memory Error when Crawling SES Index
When you schedule a search definition, it might run forever, especially in case of a large index like HC_HR_JOB_DATA or HC_BEN_HEALTH_BENEFIT or HC_HPY_CREATE_ADDL_PAY. If you go to the crawler log located in 1ds*.MMDDHHMM.log in <SES>/oradata/ses/log – you might notice an “out of memory” error like the one mentioned below: Crawl Fails and Logs Error “java.lang.OutOfMemoryError: […]
Continue readingEQA-13000: Operation “delete” Cannot Be Performed on an Object Type “schedule” in State “EXECUTING”. ( 262,1018)
When you face this issue with indexes in SES when you try to undeploy them or do report sync issues – you will receive an error and there are multiple versions of this error, namely: EQA-13000: Operation “delete” Cannot Be Performed on an Object Type “schedule” in State “EXECUTING”. ( 262,1018) EQA-13000: Operation “delete” cannot […]
Continue reading
3
How to Uninstall Oracle SES for PeopleSoft
There are a lot of valid reasons when you may need to uninstall SES. Some of the common examples include situations when there are issues with the first time install of Oracle SES and also there may be cases when applying patches or doing upgrades would have deemed SES unusable. In many of such and […]
Continue readingContent/Portal URL not defined for node %1
When performing diagnostic test to verify PeopleSoft and Oracle Secure Enterprise Search connectivity, you may face an error at “STEP 2: Deploy” or “STEP3: Crawl” The error will be something like: Content/Portal URL not defined for node HCM92DEV (262,81) PTSF_FEED.SESFeedDataSource.OnExecute Name:execute PCPC:16168 Statement:281 Called from:PTFP_FEED.Feed.OnExecute Name:execute Statement:677 Called from:PTFP_FEED.FeedFactory.OnExecute Name:getFeedDoc Statement:244 Called from:PTSF_RNDTRP_WRK.PTSF_RNDTRIP_CRAWL.FieldChange Statement:46 Content/Portal […]
Continue reading