App Designer Error: Stmt #: 914 Error Position: 0 Return: 3113 - ORA-03113: end-of-file

 App Designer Error: File: C:\PT861P06B_2408140500-retail\peopletools\src\psmgr\mgrvers.cppSQL error. Stmt #: 914  Error Position: 0  Return: 3113 - ORA-03113: end-of-file on communication channel Process ID: 1690076 Session ID: 306 Serial number: 8871 Help: https://docs.oracle.com/error-help/db/ora-03113/ 

Failed SQL stmt: SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'

Run the below statements in SQL Editor/SQL Developer/ Command Prompt

SELECT OBJECTTYPENAME, VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS';

if  returns below: 

OBJECTTYPENAME,	VERSION

SYS,

3258

🔍 Analysis:

1. SYS Version 3258:

   • The SYS (System) version is 3258, while the PSSTATUS table shows VERSION 13386.

2. Version Mismatch:

   • There is a discrepancy between the SYS version (3258) in the PSVERSION table and the PSSTATUS version (13386).
   • This mismatch can cause system inconsistencies, error messages, or issues with patches and updates.

---

🚦 Recommended Actions:

🛠️ 1. Synchronize the Version:

Run the following SQL update to synchronize the SYS version:

sql
UPDATE PSVERSION 
SET VERSION = 13386 
WHERE OBJECTTYPENAME = 'SYS';

COMMIT;

🔍 2. Verify the Update:

After updating, re-check with:

sql
SELECT OBJECTTYPENAME, VERSION 
FROM PSVERSION 
WHERE OBJECTTYPENAME = 'SYS';

You should now see:

OBJECTTYPENAME	VERSION
SYS	13386

3. Restart Application Server:

• Restart the PeopleSoft Application Server and Process Scheduler to apply changes

Restart Services:

To apply changes, restart the PeopleSoft Application Server and Process Scheduler:

1. Stop the services:

bash
psadmin -p stop
psadmin -s stop

2. Start the services:

bash
psadmin -p start
psadmin -s start

Test System Stability:
Login to the PeopleSoft application.
Test basic navigation, run a few processes, and verify no errors appear.
🚦 Why is This Important?
This syncs the database version with the PeopleSoft environment, ensuring smooth operation and compatibility with updates/patches.