Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

KPFM_SCORE_SELECTIONS Table

Highlighted
cat_gon
Super Collector

KPFM_SCORE_SELECTIONS Table

Hi All,

We have a validation that is using this table KPFM_SCORE_SELECTIONS.

We have updated the column SCORE_SELECTION_NAME of one of the rows where score_selection_id = 30022. However, still the old value appears in the validation from the front-end, database shows that the record is updated.

Are we missing something?

Thanks.

Catherine

3 REPLIES
dirkf
Honored Contributor

Re: KPFM_SCORE_SELECTIONS Table

Hi Cat,

 

hope all is well.

Sounds like you are bending the backend tststs. :-)

Not all values reflect directly.

 

Try the usual:

 


- Stop PPM server.
- Delete work & tmp folders from PPM_HOME/server/SERVER_NAME (repeat for all nodes)
- Re-start PPM server, each node one by one and waiting till the one is up to start the next one. Please start with the services one.
- From the command prompt under PPM_HOME/bin run:
sh kRunCacheManager.sh A
- Clean browser 

 

HOpe it helps.

Best regards,

Dirk

cat_gon
Super Collector

Re: KPFM_SCORE_SELECTIONS Table

Hi Dirk,

 

Same thing.

 

Please see attached file for more details.

 

Is there something else that has to be changed for the modification to take effect?

 

Thanks.

 

Catherine

dirkf
Honored Contributor

Re: KPFM_SCORE_SELECTIONS Table

Hi Cat,

 

check the following:

 

select * from kpfm_score_domains_nls
select * from kpfm_score_criteria_nls sc order by sc.SCORE_DOMAIN_ID
select * from kpfm_score_selections_nls ss order by ss.SCORE_CRITERION_ID


select VALIDATION_ID, VALIDATION_NAME, COMPONENT_TYPE_CODE, VALIDATION_TYPE_CODE, VALIDATION_SQL, REFERENCE_CODE from KNTA_VALIDATIONS
where REFERENCE_CODE like '%PFM_SCORE%'

select VALIDATION_ID, VALIDATION_NAME, COMPONENT_TYPE_CODE, VALIDATION_TYPE_CODE, VALIDATION_SQL, REFERENCE_CODE from KNTA_VALIDATIONS
where VALIDATION_NAME like '%PFM Score%'

 

to see if the table values are correct in there.

 

Also make sure the the column VALIDATION_REFERENCE_CODE in the table kpfm_score_criteria links to the corresponding valication correctly.

 

Hope this helps.

Best regards,

Dirk

//Add this to "OnDomLoad" event