The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error Updating Staffing Profile

Highlighted
edwas13
Acclaimed Contributor

Error Updating Staffing Profile

Hi, I currently use PPM 8 sp2. We have a custered up with 2 user nodes and 1 services node

I am getting the following error when trying to update any staffing profile.

The error only ever occurs on one of the user nodes and when I restart the problem node the issue switches to the other. Any ideas?

org.hibernate.QueryException: Not all named parameters have been set: [ids5, ids4, ids3, ids2, ids1] [SELECT distinct {rule.*} FROM fm_cost_rules rule
MINUS
SELECT cr.*
FROM fm_cost_rules cr, fm_cost_factor_vals cfv
WHERE cr.cost_rule_id = cfv.cost_rule_id
AND (cfv.cost_factor IN (:excludedCostFactors) OR
(cfv.cost_factor = 8 and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) AND cfv.cost_factor_value not in (:ids1) AND cfv.cost_factor_value not in (:ids2) AND cfv.cost_factor_value not in (:ids3) AND cfv.cost_factor_value not in (:ids4) AND cfv.cost_factor_value not in (:ids5) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) and ( 1=1 AND cfv.cost_factor_value not in (:ids0) ) ))]

Exception Correlation: GUID=80206E42-CAC1-263D-DE25-A9C6A34BE04C
Generated Time=2010/10/10-15:38:47.497 GMT+01:00
Server Node Name: app2


1 REPLY
Deepak Bhattad
Regular Collector

Re: Error Updating Staffing Profile

Was there a resolution to this issue. We are facing a similar issue for one of the users.
//Add this to "OnDomLoad" event