1. Get long column built as CLOB columns (oracle 10g)
Set database_options column value in PSSTATUS table as 2.
2. Clearing archieve logs
RMAN target sys/pwd
delete noprompt archievelog all;
crosscheck archievelog all
3. Tablespace not appearing in Application Designer.
setspace.sqr / sync PSRECTBLSPC and PSTBLSPCCAT tables.
4. Cobols run out - insufficient memory (8.49.08)
Fixed in 8.49.10 tools.
5. After export of peoplesoft database from SQL Server using DataMover , one may get
" Unable to retrieve current DDL space name " error while altering tables.
for this check a few tools tables like PSSTATUS , PSACCESSPRFL etc. Some details my be
lower case. eg . PSSTATUS . OWNERID column might have ownerid in lower case (sysadm).
In Oracle , if one checks DBA_TABLES.OWNER, sysadm would be in upper case.
Update PSSTATUS.OWNERID to upper case and you should be able to alter tables through
Application Designer.
6. Some Good sites
peoplesoftguys.com/index.php?S=psstatus
go-faster.co.uk
psftdba.com
7. Query sizing - Max Fetch Size
8. PSSTATUS is an important table. If you want peoplesoft to use new oracle datatypes , set
the database_options field to 2 , else leave it as 0 to use old datatypes.
9. Building Search Index - This gets built on the peoplesoft process scheduler home. So inspite of running the process , search will not work. This happens if application server and process
scheudler are hosted on different box. Need to copy "search" from process scheduler box to
application server box.
10. Useful Queries
select
prcsinstance , prcsname ,servernamerqst "Srv Name" ,
to_char(rundttm, 'DD-MON-YYYY:HH:MI:SS') "Run Time" ,
to_char(rqstdttm, 'DD-MON-YYYY:HH:MI:SS')"Request Time",
to_char(lastupddttm, 'DD-MON-YYYY:HH:MI:SS') "Last Updated" ,
to_char(begindttm, 'DD-MON-YYYY:HH:MI:SS') "Process Started",
runstatus
from sysadm.PSPRCSRQST
where to_date(RQSTDTTM,'DD-MON-YYYY:HH:MI:SS') >
to_date((SYSDATE-15/720),'DD-MON-YYYY:HH:MI:SS')
and runstatus = 7
order by rundttm,rqstdttm,lastupddttm,prcsname,servernamerqst;
select OPRID ,PRCSINSTANCE ,PRCS,PRCSNAME ,PRCSTYPE,
decode(RUNSTATUS, 3, 'ERROR', 10, 'NO SUCCESS', 14, 'POSTING', 7, 'INITIATED', 12, 'UNABLE 2 POST', 4, 'HOLD', 8, 'CANCELLED', 'UNKNOWN') RUNSTATUS ,
RUNSTATUS STATUS ,to_char(RUNDTTM, 'DD-MON-YYYY:HH:MI:SS') Run_Time from sysadm.PSPRCSRQST
where RUNSTATUS not in (9,5,2,7,6,16)
and RUNDTTM > (sysdate-(15/1440)) order by PRCSINSTANCE;
Many more to come. Will keep udating.
11. Installing PIA as nt service in multiple server
here PIA, PIA1, PIA2,PSOL
will be created.
installntservice.cmd
installntservice.cmd PIA
installntservice.cmd PSOL so on.
we have to run startweblogicadmin.cmd before
12. Compare Reports not generating html -
go to regedit - hkey current user - software - peoplesoft - pside - dword upgHTMLoutput
the value should be 1 and not a 0. Change and it see htmls being generated.
13. Tuxedo Installation timesout -
go to regedit - hkey local machine - bea system and delete tuxedo folder
try to install again
14. Nvision reports stay in processing mode. check the task manager for excel.exe / psnvs.exe Many times you will have to kill the excel to kick off the nvsion reports.
15. How do you see the configuration used by your PIA?
https://
dayoff is the default passowrd - webprofile- custom properties tab
16. Clearing Web Server Cache
https://
