(SQR 3725) Bad return fetching row from database.
The PeopleTools upgrade step “Running DBTSFIX Report” might fail with the error: Rel script conversion program PRCSDEFN match Error on line 842: (SQR 3725) Bad return fetching row from database. SQR for PeopleSoft: Program Aborting. How to Fix (SQR 3725) Bad return fetching row from database. This error is caused by invalid packages in case of […]
Continue reading
1
This Oracle 12C Setting Can Jeopardize Your PeopleSoft Installation
Oracle Database 12C is supported with PeopleTools 8.53 but there is one feature in Oracle 12C that can jeopardize your PeopleSoft Installation. Recently while installing PeopleSoft 9.2 with PeopleTools 8.53 using Oracle 12C as database, I was struck at running initial database creation scripts like dbowner.sql and psroles.sql. Scripts weren’t creating users and roles as […]
Continue readingHow to Manually Uninstall Oracle in Windows 8
Let’s face it – Oracle database is an excellent product but its uninstall process is still mediocre. There are a lot of unknown issues arise when you try to uninstall Oracle database and then try to install it again. We get a lot of queries every week regarding problems installing Oracle products. Most of these […]
Continue reading
5
Understanding Oracle Database and PeopleSoft Database
Some of the terms especially when it comes to database are loosely used and may cause confusion when performing a PeopleSoft installation. This post will help you revisit and understand PeopleSoft database concepts when used with Oracle database. When you perform a PeopleSoft installation, you will create these types of PeopleSoft databases: • System (also […]
Continue readingORA-01555: snapshot too old
We were doing stress testing in PeopleSoft ELM and ran the Mass Enrollment AppEngine. After running for about 90 minutes, it failed with the error ORA-01555: snapshot too old: rollback segment number 19 with name “_SYSSMU19_1270741541$” too small The ORA-01555 error is caused by Oracle read consistency mechanism and is usually associated with long running […]
Continue reading