Project and Portfolio Management Practitioners Forum
cancel

How to generate days to table KDRV_WORKING_DAYS

SOLVED
Go to solution
Highlighted
Radim79
Respected Contributor.

How to generate days to table KDRV_WORKING_DAYS

Hi all,

I have problem with generating working days for regional calendar. All calendars end with date 31.dec 2012.

I can't find any script to generate next working days.

 

Any help please?

 

Thanks

 

Radim

3 REPLIES
Oscar_Pereira
Honored Contributor.
Solution

Re: How to generate days to table KDRV_WORKING_DAYS

 

Hello Radim,

 

The KDRV_WORKING_DAYS table should get populated when you create the periods.
Because of an existing product defect (QCCR1L27332 for PPM 8 versions), the table doesn’t get populated
beyond 2012.

 

http://support.openview.hp.com/selfsolve/document/FID/DOCUMENTUM_QCCR1L27332

The issue is already resolved in PPM 9.1


I would recommend waiting to 9.1 upgrade.

If not, R&D has provided a sql file for the 8.0 version: kdrv_working_days_810_1.sql


Backup data before running the sql. Run it in development instance. Do NOT deploy it on production server. Test to make sure everything is working as expected.

 

Regards

Oscar Pereira

 

Oscar_Pereira
Honored Contributor.

Re: How to generate days to table KDRV_WORKING_DAYS

This script is for 8.0 only.

 

I attached it as a .txt  , you can change the extension back to .sql

Radim79
Respected Contributor.

Re: How to generate days to table KDRV_WORKING_DAYS

Hi Oscar,

Thank you very much. I try it and let you know if it's work correctly..

 

Best regards

 

Radim