Project and Portfolio Management Practitioners Forum
cancel

Error while creating staffing profile

Highlighted
eata
Super Contributor.

Error while creating staffing profile

Hello;

I faced with this error when I click Create Staffing profile: Fill fileds on screen and press create button:

 

 Please fix the following problems:  

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

8 REPLIES
Celil
Acclaimed Contributor.

Re: Error while creating staffing profile

Hi eata,

If you create a steffing profile(SP) before and then one of reason you deattach it from project so recreate SP with the same SP name, PPM give the error. Could you please try to give different name to SP. If error will continue let me inform.


PS: Please keep alive our forum via KUDOS the professionals
Celil

IT Governance Professional
& PPM Solution Architect
eata
Super Contributor.

Re: Error while creating staffing profile

Hi Celil;

I tried to create staffing profile with different names but the problem still exists.

AlexSavencu
Acclaimed Contributor.

Re: Error while creating staffing profile

Hi, eata,

 

does this happen for all projects?

 

cheers

alex


--remember to kudos people who helped solve your problem
Erik Cole
Acclaimed Contributor.

Re: Error while creating staffing profile

Just FYI, I'm seeing this error message a lot when working with staffing profiles that are related to entities. Usually we are trying to change the status. If we un-link it from the project we can then change the status, save, and re-link it without the error.

 

The message seems to indicate a problem in the validation on the staffing profile's header.

 

9.13

eata
Super Contributor.

Re: Error while creating staffing profile

Hi Alex; No it happaned for one project

 

Hi Eric; The project had a staffing profile. Than project manager changed staffing profile status to freestanding staffing profile. Now project manager is tring to create a new staffing profile.

 

I want project manager to change staffing profile header and link old staffing profile to the project.

Problem is solved after linking old staffing profile not creating a new one.

 

Offical HP suport suggested this but non is worked.

 

Please do these steps:
0. Run "sh kRunCacheManager.sh A"
1. Stop PPM server (all nodes)
2. Clear the browser cache
3. Delete all content in <PPM_HOME>/server/<Server_name>/tmp and <PPM_HOME>/server/<Server_name>/work (for all nodes)
4. Run "sh kUpdateHtml.sh"
5. Run "sh kJSPCompiller.sh"
6. Start PPM server (all nodes)
7. Test and provide the results

Please let me know if this helps.

Please run the following sql and replace project name and finacial name and provide the results in CSV or Excel file.

1)
SELECT req.request_id, NVL (prj.project_name, '(No Name)'), req.request_id,
prj.prj_business_unit_meaning AS business_unit
FROM kcrt_fg_pfm_project prj,
kcrt_participant_check_v pcv,
fm_financial_summary fs,
kcrt_requests req
WHERE prj.project_name LIKE '%test123%'
AND prj.prj_financial_summary_id = fs.financial_summary_id
AND req.request_id = pcv.request_id
AND pcv.user_id = 1
AND req.request_id = prj.request_id
AND req.status_code = 'IN_PROGRESS'
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);
2)

SELECT *
FROM kcrt_fg_pfm_project prj
WHERE prj.project_name LIKE '%test123%';
3)

SELECT *
FROM fm_financial_summary fs
WHERE fs.NAME LIKE '%financial_name%';

4)

SELECT *
FROM kcrt_request_types rt,
kcrt_fg_pfm_project prj,
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
AND prj.project_name LIKE '%test123%';

5)

SELECT req.request_id, NVL (prj.project_name, '(No Name)'), req.request_id,
prj.prj_business_unit_meaning AS business_unit
FROM kcrt_fg_pfm_project prj,
kcrt_participant_check_v pcv,
kcrt_requests req
WHERE prj.project_name LIKE '%test123%'
AND req.request_id = pcv.request_id
AND pcv.user_id = 1
AND req.request_id = prj.request_id
AND req.status_code = 'IN_PROGRESS';

 

Than They advised this query but I did not run since linking old staffing profile solved our problem.

 

1) backup table kcrt_fg_pfm_project prj
2) run
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
);

Restart PPM

sevcan
Super Contributor.

Re: Error while creating staffing profile

Hi,

What was the solution for this issue. I get the same error when I try to change the staffing profile header of an existing one. I also wonder if I detach the staffign profile and attach again, is there any effect on work plan becasue we assigned the resources in the workplan.
Thank in Advance,
eata
Super Contributor.

Re: Error while creating staffing profile

I change freestanding staffing profile header and I connected old staffing profile to the project.

sevcan
Super Contributor.

Re: Error while creating staffing profile

I could not detach the old staffing profile because it is arranged as required before and it does not let me to change it. I also could not delete it. Any other suggestions?