Found 617 results.
Run every mile at Kovai MarathON to support the cause of promising young students’ education through our Kovaion Kalvi!
When a PeopleSoft environment is refreshed, Environment Management team will mask sensitive data using scripts. PSURLDEFN is one of the key tables to be masked.
Today, we had an interesting issue at one of our customer site.
When a PeopleSoft environment is refreshed (production / post upgrade refresh), Environment Management team (DBAs) will mask sensitive data using scripts or tools. PSURLDEFN is one of the key table to be masked.
We recently had a environment refresh (Post Upgrade). One issue was reported where the connectivity to the third party system was lost after the refresh (upgrade). On analysis, the PSURLDEFN was blanked out during the refresh process and not reverted with actual values. So, the DBAs repopulated the data using SQL scripts. Post URL data population also, the same connectivity issue was encountered.
On further Analysis, GetURL(URL.XXXX) was used in PeopleCode to get the third party system URL. GetURL() function fetches the information from the App Server Cached details. This was designed for a quicker response on the Application Server. The issue was finally resolved by DBAs clearing the cache and Application Servers bounced.
So, if there are any SQL update on the PSURLDEFN table, its good practice to clear the Application Server Cache.
Connect with us for PeopleSoft End-to-End Implementation, Enhancement, Updates, and Support.
Read MoreThis website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
