Project and Portfolio Management Practitioners Forum
cancel

PPM v.9.2 error update ppm_server_instance

SOLVED
Go to solution
Highlighted
marco_cattarin
Valued Contributor.

PPM v.9.2 error update ppm_server_instance

Hello, I just migrated to V.9.2 and at startup of PPM services, I obtain into the server_log.txt several error messages related to a failed attempt to "update ppm_server_instance ... retrieving 0 rows while expected 1"

 

Apparently the system is up and running (when I log on on the UI by admin user)

 

Into ppm_server_instance table all seems to me ok (apart the fact that I personally don't know what "version" number is...on the active node the version=2, before a shut-down was 31...).

 

>> WHICH service's query search WHAT into ppm_server_instance table without composing the right "WHERE" conditions ???

>> does it could be related to some "new pp version code" that I have to put into some table/file, after migration from 9.14 !?

 

thanks

 

Maroc Cattarin 

1 REPLY
Utkarsh_Mishra
Acclaimed Contributor.
Solution

Re: PPM v.9.2 error update ppm_server_instance

Well this is not a show stopper, but ppm_server_instance table data is need when you open admin console.

 

I had observe that kUpdateHtml.sh script do update this table. Can you try below step

 

 

  1. Stop PPM server (all nodes)
  2. Delete tmp and work directory in <PPM_ROOT>/server/<NODE> (in all the nodes)
  3. Execute kUpdateHtml.sh in /bin
  4. Start the PPM server
Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)