Unable to Save any changes in Request Type/Workflows.
We are currently using HP PPM 8.02 in our Production as soon as we try to save any new validation,workflow step,status on Request Type/Workflow we get below mentioned 2 errors.
Any Pointers would really help.
Also Just to add on the Server and Database configurations are as per the Standard Compatibilty Matrix provided by HP
GUID=37B924C0-B821-31B5-1A9A-7E0FE6BFB7BA Generated Time=2015/06/27-05:59:47.567 MST Server Node Name: ITGPRD
No more data to read from socket
GUID=5BE66E8D-311F-C858-8D49-6590883F97C9 Generated Time=2015/06/27-06:01:05.715 MST Server Node Name: ITGPRD Connection is closed
Regards, ECMS Team Keysight Technologies
Re: Unable to Save any changes in Request Type/Workflows.
Hello ECMS Team,
The error means that the Database connection is lost. Check if the database is up and running and/or try to restart it.
You can try the following:
1) Add (or change if already exist) to server.conf the below parameters:
2) Run kUpdateHtml.sh
3) Stop PPM and then Oracle DB
4) Start Oracle DB and then PPM
Most likely this is an Oracle issue.
the exception "java.sql.SQLRecoverableException: No more data to read from socket" is what happens to the client when the DBMS has killed the session/connetion out from under the driver. Please ask your DBA to check the DBMS error log, something bad was happening there at that moment.
Also you are using an unsupported PPM version, you may upgrade to recently version so HP can provide you an immediate support service.
Hope this helps.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”