Deepak Bhattad Absent Member.
Absent Member.
403 views

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

0 Likes
2 Replies
Frequent Contributor.. hyllplan Frequent Contributor..
Frequent 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
0 Likes
Micro Focus Expert
Micro Focus Expert

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.

 

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.