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

Project has invalid input or the input has more than one match.

SOLVED
Go to solution
Highlighted
PPMRam
Collector

Project has invalid input or the input has more than one match.

Hi,

 

We are facing the issue called  'Project has an invalid input or the input has more than one match' while creating the staffing profile in our Project.

 

We are using the PPM version 8.0 sp2  and operating system is SunSolaris.

 

Please send me the rootcause regarding this issue.

 

Regards

Praveen.

4 REPLIES
Kerim KILIC
Frequent Visitor

Re: Project has invalid input or the input has more than one match.

hello, hope this helps

http://support.openview.hp.com/selfsolve/document/KM1328296

1) backup table kcrt_fg_pfm_project prj
2) Run this SQL:

UPDATE kcrt_fg_pfm_project prj
SET (prj.prj_financial_summary_id, prj.prj_financial_summary_name) =
(SELECT fs.financial_summary_id, fs.NAME
FROM pm_projects p,
fm_financial_summary fs,
pfm_lifecycle_parent_entity pe
WHERE p.pfm_request_id = prj.request_id
AND pe.lifecycle_id = fs.parent_id
AND pe.project_req_id = prj.request_id
AND fs.parent_entity_id = 526
AND fs.entity_type = 'FS')
WHERE ( prj.prj_financial_summary_id IS NULL
OR prj.prj_financial_summary_name IS NULL
);
Kerim KILIC
Frequent Visitor

Re: Project has invalid input or the input has more than one match.

if this does not help you, i had this issue cause of an oracle patch and parameter. i dont have notes the exact oracle patch id, but you can google or your dba can check it. the parameter is _projection_pushdown” = FALSE and the oracle patch is related to this issue.
cotocald
Regular Collector

Re: Project has invalid input or the input has more than one match.

If that doesn't work please upload the results of the following:

SELECT req.request_id

, NVL(prj.project_name, '(No Name)')

, req.request_id

, prj.prj_business_unit_meaning AS business_unit

, NVL(bgtsum.projected_total, 0) AS projected_total_budget

, NVL(bensum.projected_total, 0) AS projected_total_benefit

, NVL(spsum.projected_total_fte / 100, 0) AS projected_total_fte

, NVL(prj.prj_total_score, 0) AS score

FROM kcrt_fg_pfm_project prj

, kcrt_participant_check_v pcv

, kcrt_requests req

, kcst_budget_period_sum bgtsum

, kcst_benefit_period_sum bensum

, krsc_staff_prof_period_sum spsum

WHERE UPPER(NVL(prj.project_name, '(No Name)')) like UPPER('<PROJECT NAME>')

AND ( NVL(prj.project_name, '(No Name)') like UPPER(substr('<PROJECT NAME>',1,1)) || '%'

OR NVL(prj.project_name, '(No Name)') like LOWER(substr('<PROJECT NAME>',1,1)) || '%'

)

AND bgtsum.budget_id (+) = prj.prj_budget_id

AND bgtsum.period_id (+) = -1

AND bensum.benefit_id (+) = prj.prj_benefit_id

AND bensum.period_id (+) = -1

AND spsum.staff_prof_id (+) = prj.prj_staff_prof_id

AND spsum.period_id (+) = -1

AND req.request_id = pcv.request_id

AND pcv.user_id =<user_id>

AND req.request_id = prj.request_id

AND req.status_code = 'IN_PROGRESS'

AND (prj.prj_staff_prof_id IS NULL or prj.prj_staff_prof_id='')

AND EXISTS

( select 1

from kcrt_request_types rt

, kcrt_hdr_types_field_groups fg

where rt.request_type_id = prj.request_type_id

and rt.request_header_type_id = fg.request_header_type_id

and fg.field_group_id = 12 );

 

select * from kcrt_fg_pfm_project prj where prj.PROJECT_NAME like '<PROJECT NAME>%';

(Don't forget to append "%" after the project name.)

 

select PROJECT_NAME from kcrt_fg_pfm_project group by PROJECT_NAME having count(PROJECT_NAME) > 1

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

Re: Project has invalid input or the input has more than one match.

Hi,

 

select * from kcrt_fg_pfm_project prj where prj.PROJECT_NAME like '<PROJECT NAME>%';

(Don't forget to append "%" after the project name.)

this commands works to me.Thanks for help.

 

Regards,

 

 

//Add this to "OnDomLoad" event