Project and Portfolio Management Practitioners Forum
cancel

Problem in generating the fiscal periods in HP PPM 7.5

Highlighted
Govardhan07
Super Contributor.

Problem in generating the fiscal periods in HP PPM 7.5

Hi,

 

It shows the following error, when we trying to generate the fiscal periods in HP PPM 7.5.

 

INFO: [-startYear, 2013, -endYear, 2015]
INFO: running validate ...
DEBUG: server locale is en_US
DEBUG: initial period labels ...
DEBUG: Jan, January
DEBUG: Feb, February
DEBUG: Mar, March
DEBUG: Apr, April
DEBUG: May, May
DEBUG: Jun, June
DEBUG: Jul, July
DEBUG: Aug, August
DEBUG: Sep, September
DEBUG: Oct, October
DEBUG: Nov, November
DEBUG: Dec, December
DEBUG: Q1
DEBUG: Q2
DEBUG: Q3
DEBUG: Q4
DEBUG: H1
DEBUG: H2
ERROR: exception occurred: For input string: "Q3", please check the log file for details.
java.lang.NumberFormatException: For input string: "Q3"
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
    at java.lang.Integer.parseInt(Integer.java:449)
    at java.lang.Integer.valueOf(Integer.java:554)
    at com.kintana.core.server.tools.FiscalPeriodGenerator$Util.parseInt(FiscalPeriodGenerator.java:1349)
    at com.kintana.core.server.tools.FiscalPeriodGenerator$PeriodCollection.getFiscalYear(FiscalPeriodGenerator.java:2102)
    at com.kintana.core.server.tools.FiscalPeriodGenerator$PeriodCollection.setFiscalMonthSeqAndYear(FiscalPeriodGenerator.java:2628)
    at com.kintana.core.server.tools.FiscalPeriodGenerator$PeriodCollection.getNewCopyOfExistingPeriod(FiscalPeriodGenerator.java:2033)
    at com.kintana.core.server.tools.FiscalPeriodGenerator$PeriodCollection.existingPeriods(FiscalPeriodGenerator.java:1992)
    at com.kintana.core.server.tools.FiscalPeriodGenerator$PeriodConfig.getNewConfig(FiscalPeriodGenerator.java:3395)
    at com.kintana.core.server.tools.FiscalPeriodGenerator.config(FiscalPeriodGenerator.java:648)
    at com.kintana.core.server.tools.FiscalPeriodGenerator.runValidate(FiscalPeriodGenerator.java:339)
    at com.kintana.core.server.tools.FiscalPeriodGenerator.run(FiscalPeriodGenerator.java:273)
    at com.kintana.core.server.tools.FiscalPeriodGenerator.main(FiscalPeriodGenerator.java:4608)

 

 

Regards,

Govardhan

2 REPLIES
dirkf
Acclaimed Contributor.

Re: Problem in generating the fiscal periods in HP PPM 7.5

Hi Govardhan,

 

have you changed any of the labels of the periods?

 

Please check the following output and let us have it:

 

1)
SELECT period_id, created_by, creation_date, last_updated_by,
last_update_date, period_type, period_code, start_date, end_date,
period_full_name, period_short_name, period_type_id, seq,
period_group_id
FROM knta_periods


2)
SELECT period_group_id, created_by, creation_date, last_updated_by,
last_update_date, period_group_name, parent_period_id,
child_period_id
FROM knta_period_groups
ORDER BY period_group_name

 

Best regards,

Dirk

SMCConch
Frequent Contributor.

Problem in generating the fiscal periods in HP PPM 7.5

Our version of PPM does not provide a period beyond Dec 2012 for selection during the creatiion of staffing profiles and projects.

 

PPM 7.5 SP6

We need to add periods to our PPM instance. When we execute "kGenPeriods.sh -startYear 2013 -endYear 2025" we get the following error messages:

ERROR: no year period found from parent of period group 30000
ERROR: existing periods or period groups in database are not valid, please fix it before running this script.

 

 

Attached is our knta_period_groups table for your review.