After upgrading to PeopleTools 8.54, you may notice that the SES index crawl process keeps running at a scheduled time and fails with the below error. Interesting thing is that you’re likely to find this error in all the applications that have been upgraded to 8.54 irrespective of the fact whether or not it is a 9.1 […]
Continue readingIf you have deployed an index and crawled it, say PTPORTALREGISTRY – when you run a search against it, you receive an error like “No results were returned. Refine your search by entering a different keyword” Go to <SES Home>/logs/crawler/crawler and check the logs. You need to view the log, which has the name like search.crawler.i1ds*.mmdd* […]
Continue readingMonday mornings are usually not great because apart from the weekend being over, there is always something that won’t work and it is usually due to weekend maintenance/upgrade work. Today I found all my SES index jobs showing the same error as shown below: Integration Broker encountered an error (262,1020) PT_SEARCH.SESIMPL.MESSAGE.SESRequest.OnExecute N ame:Send PCPC:688 Statement:16 […]
Continue readingThere are certain scenarios in which you’d like to have a list of PeopleSoft SES tables handy. Some of these scenarios include: PeopleSoft instance/database refresh – When copying a PeopleSoft instance or database, for example – production to test, you may want to exclude the SES tables so that SES server details and index definitions […]
Continue readingThis error usually comes after a database refresh has happened. Root cause of the error is that the application database and the SES database have gone out of sync. The error show up when you try to undeploy a SES index and when you try to do “Report Sync Issue,” nothing happens. The error reads […]
Continue readingAll 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 readingDuring 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 readingWhen 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 readingWhen 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 readingWhen 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 readingA Drilling URL is a term associated with PeopleSoft Search Framework. A Drilling URL is a URL found in the search results when using PeopleSoft Search Framework. When clicked, it displays the appropriate PeopleSoft application page, with appropriate data populated in the page. Let us have a look using an example: When you perform a […]
Continue readingNow that you’ve installed Oracle SES, configured it for PeopleSoft application, configured the PeopleSoft application to make use of SES – it is time to deploy the indexes and start making use of the search functionalities. This is part 4 of the series on PeopleSoft Search Framework and for your reference, the other parts of this […]
Continue readingThis is part 3 of our series of configuring PeopleSoft with Oracle SES. Till now we have installed SES and applied configuration on the SES side. Now we will move on to the PeopleSoft side where we will configure a PeopleSoft application to make use of SES. Prior to implementing the PeopleSoft Search Framework, the […]
Continue readingOnce you’ve installed Oracle SES, the next step is to configure PeopleSoft PeopleTools with Oracle SES. Prior to implementing the PeopleSoft Search Framework, the following items need to be installed, configured, and functional. Oracle SES PeopleSoft Database Application Server PeopleSoft Integration Broker Process Scheduler Server Apart from the above requirements, you will also need a […]
Continue reading