Project and Portfolio Management Practitioners Forum
cancel

Staffing profile + Index Out Of Bounds Exception Error

Highlighted
Deepak Bhattad
Super Contributor.

Staffing profile + Index Out Of Bounds Exception Error

Hi,

 

One of the users of the system has created a staffing profile with end date as September 2030 and is trying to create a position in the staffing profile.

 

However when the user enters the data and hits add an error is thrwn by the system and the error is Index out of bound exception.

 

As a test when I changed the end date to September 2020 the system worked fine.

 

Any insights as to how to deal with this issue is greatly appreciated.

 

PS: We had recently changed  created fiscal periods from 2025 to 2030 and the system has not being restarted for quite some time.

 

We are on 9.12

 

Thanks

2 REPLIES
hyllplan
Honored Contributor.

Re: Staffing profile + Index Out Of Bounds Exception Error

1) Use the following query to find out if there is some staffing profile that has a duplicate STAFFING_PROFILE_SEQ

select STAFFING_PROFILE_ID || ' ' ||STAFFING_PROFILE_SEQ,
count(STAFFING_PROFILE_ID || ' ' ||STAFFING_PROFILE_SEQ)
from rsc_positions
group by STAFFING_PROFILE_ID || ' ' ||STAFFING_PROFILE_SEQ
having (count(STAFFING_PROFILE_ID || ' ' ||STAFFING_PROFILE_SEQ) > 1)

2) If you find duplicates; let HP Support provide you with a SQL to correct it

3) Restart PPM instance
Etienne_Canaud
Outstanding Contributor.

Re: Staffing profile + Index Out Of Bounds Exception Error

Hi Deepak,

 

Generate Fiscal Periods to a very far date in the future (let's say 2035) and try again.

 

 

Note that you can generate Fiscal Periods from the Admin Console, this doesn't require a server restart.

 

Thanks,

Etienne.