Monday 5 January 2015

SQL Update on PSURLDEFN, Application Server and GetURL(URL.XXXX) - All connected

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.

11 comments:

  1. Congratulations on your article, it was very helpful and successful. 7d428b800787e83f6b55eff0295c1dd4
    website kurma
    sms onay
    website kurma

    ReplyDelete
  2. Thank you for your explanation, very good content. cc9a0627352c75c594cb61bc62472cc6
    altın dedektörü

    ReplyDelete
  3. Your odds of hitting a number second are|are actually} not 35/1 but 37/1, a significant disadvantage. The desk more_bets is a model of the bets desk augmented by every pocket's winnings on the 0/00 break up. So out of 소울카지노 5,000 simulations, we'd expect to see roughly $\frac \times 5000$, or 2,368, purple spins. Remote management by the central server both decreased this workforce whereas rushing up turnaround time from {several|a number of} days to instantaneous. This elevated effectivity also allows casinos minimize back} risk and extra accurately meet their daily efficiency metrics, both large money savers. For a slot machine, there may be a hundred possible successful outcomes.

    ReplyDelete