Project and Portfolio Management Practitioners Forum
cancel

Proposal getting failed in PPM 8.03

Highlighted
happa
Super Contributor.

Proposal getting failed in PPM 8.03

Hello,

 

Currently we are on PPM 8.03.

In previous version (7.5 sp3) only few proposals use to get failed.

But in this version all the proposals are geting failed, but they are creating projects successfully.

 

Failed proposals are not creating 'Snapshots'.

But proposals created by admin user are only closing successfully.

For now we are using an workaround, we are including 'admin user' in 'Operational Project leader' field then the Proposal is getting closed successfully and automatically creating Snapshots in Financial Summary.

 

Could you please help us to solve this defect.

 

Thanks in Advance.

 

Best Regards,
Harika.

62 REPLIES
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hello,

 

I am attaching the snapshots of the proposal that got failed.

 

Best Regards,

Harika.

TurboMan
Honored Contributor.

Re: Proposal getting failed in PPM 8.03

Hi happa,

 

Attachment doesn't help, we need the log file.

Under <PPM INS DIR>/SERVER/<PPM instance>/log/serverLog.txt.

 

Regards

TM

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Your execution step is failing...

 

from the attached log i can guess that the "CREATE PROJECT" command is failing... check the command logs... or share it with us.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Turbo Man,

 

I am attaching the serverLog file.

 

Best Regards,

Harika.

happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

I am attaching the snapshot of the 'Create Project' execution step.

 

Please let me know if you need any other information.

 

Best Regards,

Harika.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

please share the command logs....

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

I am attaching the execution log.

 

Do you mean the 'command log' same as execution log.

 

Please let me know if you mean command log by anything else.

 

Best Regards,

Harika. 

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Yes... I mean command logs...

 

But the Log2 is showing that project is succesfully created

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

Yes the project is getting created but the proposal is getting failed.

I sent you the exec_log1.jpg file which shows the 'Create Project' Step as failed.

I am attaching a screenshot of the transaction details which also shows in the 'result' column as 'failed'.

And when 'admin user' is also added in the 'operational project leader' field, then only the proposal is getting successfully closed.

 

Best Regards,
Harika.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Is the issue coming in all the Porposal request..?

 

 

Also try to create a Project from a Proposal which does not have the staffing profile attached.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

Yes this issue is coming for all the proposal request whenever admin user is not added to the 'operational project leader ' field.

 

Staffing profile attachment is mandatory in the 'Demand Capture ' Phase.

 

So I am not able to go to the 'Demand Capture' phase without attaching the staffing profile.

 

Best Regards,

Harika.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Happa,

 

In the attached server logs.. the reason for failure seems to be due to attached staffing profile. 

 

So for testing purpose... either try to create the project without staffing profile OR put this execution step at the inital phase of the workflow and then try to create the project without staffing profile.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

As you told, I created a project from proposal without attaching staffing profile.

 

But the result is still the same. Proposal is getting failed although the project is created.

 

And this is only happening when 'admin user' is not added to the 'operational project leader' field.

 

Best Regards,

Harika.

Celil
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Harika,

 

I think we are getting closed to solution but there are still missing small details:

 

1) According to the log file, you have a staffing profile problem but it is not related with the proposal problem. Only one staffing profile wich id 39504's data couldn't rollup by PPM rollup service. Please find this staffing profile and solve the problem.

 

2) According to the log file, you have encountered a portlet problem in the past but it is not related with the proposal problem too :)  The portlet couldn't get data beacuse of calculation of the data take more time. Please try to refine your portlet sql.

 

3) About the log file, you didn't send us the right log file because there isn't any error about the proposal problem. Please try this: Increase level of debuging/logging level of PPM from workbench. After then try to run proposal "Create Project" step. After getting error again do not forget to decrease level of debuging/logging level of PPM. Send us this log file.

 

4) As far as I see, you don't create a transition from "Create Project" step to any other step for if failed. Because of that you are getting "prop_fail3.JPG" screen. But it's not solution for the problem, just an other problem.

 

5) In addition to log file (as I described in (3) ), could you please send us full screen of screenshot "exec_log2.JPG", It show a piece of screen ? And workflow of proposal ? And could you detail where you use "operational project leader" token in request type and workflow ?

 

Celil

Celil

IT Governance Professional
& PPM Solution Architect
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Celil,

According to your instruction, I have changed the debugging level to maximum. Then I replicated the error again.

 

And in the new log file generated also, I am unable to find any error regarding proposal.

 

I am attaching newly generated log file. Could you please check and let me know about this.

 

I am also attaching the screenshots of the execution log details,workflow details and'operational project leader' field details.

 

Please let me know if you need any other information.

 

Best Regards,
Harika.

happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Celil,

 

Attached are the details of the 'operational project leader' field.

 

Best Regards,

Harika.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Happa,

 

Execute the below query and get the staffing profile name. The try to open that staffing profile.. and check whether it is getting opened properly.

 

Select * from rsc_staffing_profiles where staffing_profile_id = 39504

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
Erik Cole
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Happa, do you have any users/tokens/groups in the Security tab of that workflow execution step? If not, you might try adding 'PPM User' or whatever your base group is...

happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

I have checked the staffing profile with id 39504. When I am trying to open that it showing some error. I am attaching the screenshot.

 

Also, I have found that staffing profile with id 39504 is not being used in the project. Whereas a staffing profile with id 39521 with almost same values as 39504 is being used in the project and that is being opened properly.

 

So should I delete the staffing profile with id 39504 if not needed.

 

But, is this staffing profile error anyhow related to the proposal failure issue?

 

Please let me know if you need any other information.

 

Best Regards,

Harika.

happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Eric,

 

For the 'Create-Project' workflow step, only Administrator is there in the security tab.

 

But, I have also added ppm-user in the security tab of that step.

 

After that, I tried to create a project from a proposal.

 

Still the result is same. The project is getting created without the closure of the proposal.

 

Please let me know if you need any other information.

 

Best Regards,

Harika.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Happa,

 

In all you server logs it is showing rollups error due to staffing-prodile ID = 39504 .

 

So if this staffing profile is not in use, then you can delete it and then try to create the Project.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

Since I am not able to open the staffing profile from PPM instance as its returning an error, I dont have the option to delete it.

 

From database its showing integrity constraint violation, when I am trying to delete it.

 

Could you please tell me if I can delete it by some other way.

 

Thanks and Regards,

Harika.

Utkarsh_Mishra
Acclaimed Contributor.

Re: Proposal getting failed in PPM 8.03

Ok... then execute the below sql and then try to create the project and share the logs..

 

UPDATE RSC_STAFFING_PROFILES SET

BUDGET_ID = NULL,

IS_SYNCH_BUDGET = NULL,

DEFAULT_VIEW_EFFORT_TYPE_CODE = NULL,

IS_ACTIVE_FLAG = NULL,

START_DATE = NULL,

FINISH_DATE = NULL,

REGION_ID = NULL,

RESOURCE_POOL_ID = NULL,

IS_CONSIDERED_WORKLOAD_FLAG = NULL,

SECURABLE_ENTITY_ID = NULL,

WORK_LOAD_CATEGORY_CODE = NULL,

CONTAINER_ENTITY_ID = NULL,

CONTAINER_ENTITY_TYPE_CODE = NULL

WHERE staffing_profile_id = 39504;


COMMIT;

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
happa
Super Contributor.

Re: Proposal getting failed in PPM 8.03

Hi Utkarsh,

 

I am attaching the output of the query you asked me to run.

 

Please check the output and let me know if I need to update the parameters you mentioned.

 

Best Regards,

Harika.