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 readingCommon Database Errors Following is a list of known SQL errors, and potential solutions to the problems that they represent. Known Database Error Codes Database Error Code SQL State Message Solution DB2 -803 23505 SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are […]
Continue readingWhat is an Infographic? Infographics or Information graphics are graphic visual representations of information, data or knowledge intended to present complex information quickly and clearly. They can improve cognition by utilizing graphics to enhance the human visual system’s ability to see patterns and trends. The process of creating infographics can be referred to as data […]
Continue readingLoad testing has several names – load testing, stress testing, regression testing, performance testing, scalability testing and so on. Essentially what these names refer to a testing where you can simulate the real-time environment and perform testing before you go-live with your system. When it comes to PeopleSoft, such scenarios are common when you plan […]
Continue readingThose who have not comes across performance issues in PeopleSoft, especially PeopleSoft on Oracle might not be aware of this thing called performance issues due to function based indexes. PeopleSoft has given a lot of headache to Oracle database engineers as well as customers when it comes to function based indexes. By definition, a function-based […]
Continue reading