Radim79 Absent Member.
Absent Member.
549 views

How to generate days to table KDRV_WORKING_DAYS

Jump to solution

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

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Oscar_Pereira Absent Member..
Absent Member..

Re: How to generate days to table KDRV_WORKING_DAYS

Jump to solution

 

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

 

3 Replies
Highlighted
Absent Member.. Oscar_Pereira Absent Member..
Absent Member..

Re: How to generate days to table KDRV_WORKING_DAYS

Jump to solution

 

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

 

Absent Member.. Oscar_Pereira Absent Member..
Absent Member..

Re: How to generate days to table KDRV_WORKING_DAYS

Jump to solution

This script is for 8.0 only.

 

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

0 Likes
Radim79 Absent Member.
Absent Member.

Re: How to generate days to table KDRV_WORKING_DAYS

Jump to solution

Hi Oscar,

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

 

Best regards

 

Radim

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.