E-UPG Alter Error: Unable to Retrieve Current DDL Space. Alter Processed Failed. (76,47)

An Alter process during the Tools Only Upgrade  failed with the following error:

ERROR:
————
SQL Build process began on 3/17/2004 at 4:06:26 PM for database ****.
Error: ACCESS_GRP_LANG – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: AE_SYNCGEN_AET – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: AELOCKMGR – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: AERUNCONTROL – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: AERUNCONTROLPC – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: AETEMPTBLMGR – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: APPMSGARCH_AET – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: APPR_HDR_LNG – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)
Error: APPR_RULE_HDR – Unable to retrieve current DDL space name.  Alter processed failed. (76,47)
Error: Fatal error in function BldAlter on call to function GetOldRecDefn.  Return code = 1. (76,6)

SOLUTION:
————–  
In the PSSTATUS table, the OWNERID column data was in lowercase. When the data got converted into upper case, the error got resolved and the Alter script ran without any issues.

User is Unable to see Pagelet on a Home page

If a user is not able to see Pagelet on a Home page despite having access to it, then it indicates that the Webserver Pagelet cache is corrupt. The only way to overcome this issue is to restart the webserver. But if this problem occurs during the middle of a day, then the below steps can be followed to force the webserver Home page Pagelet cache refresh.

Add a new page to Home page tab as a required fix (PeopleTools –> Portal –> Structure and Content –> Portal Objects –> Home Page –> Tabs ->Home).

Go to the tab – ‘Content Tab’ and add the new Pagelet as required fix and select the column (usually the last column). Save it and re-login with the id of the user who is not able to see the Pagelet. After this step, the user should be able to see the missing Pagelet. Remove the newly added Pagelet, as it is no longer needed. The following sql can be used to determine which Pagelet that user has access to.

SELECT * FROM PSPRUHTABPGLT where oprid = ’7420060' ORDER BY portal_col_num,portal_row_num;

For further reference, please visit MOS (My Oracle Support) and see the following resolution.

E-PORTAL: What Are The Tables Used By Portal Technology? [ID 651342.1]

Tags: Pagelets, PeopleSoft, PeopleSoft Home page, PeopleSoft Pagelets, Portal