---
title: Clarity PPM | How to Scale Project Duration from a Template
description: Have you tried to use a WBS template for a new project and had to manually change task dates? There's an easier way to scale projects in Clarity PPM.
image: https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/LWR_scale_Blog_760x230.jpg
---

[![Rego-Logo_Notag-Color-350](https://blog.regoconsulting.com/hs-fs/hubfs/Rego%20Guide%20Images/Rego-Logo_Notag-Color-350.png?width=224&name=Rego-Logo_Notag-Color-350.png)](http://regoconsulting.com)

- [Home](http://regoconsulting.com)

[![LWR_scale_Blog_760x230.jpg](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/LWR_scale_Blog_760x230.jpg)](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/LWR_scale_Blog_760x230.jpg)

# Clarity PPM | How to Scale Project Duration from a Template

Have you tried to use a **WBS template** for a new project and found yourself manually changing every task date? There's an easier way to scale new projects. We'll cover that today, plus two other tips: diagnose **Load DWH Job Failure** and **update a Crystal Report** displayed as a PDF.

Please feel free to comment on any alternative answers you've found. At Rego, we always love your input. 

## Learn with Rego | Q&A 

1. WBS Template

2. Load Data Warehouse Job Failure

3. Crystal Report - How to Update a Report Displayed as XLS/PDF

> *1. We have a very detailed 16-month long WBS. Can we create a project with that template—make the project 8-months long— and not have to change all the task dates? *

Yes – when you create a new project from template (at the bottom of the create screen). there is a ‘scale by.’ So in this case, the scale is –50% because you want to go from a 16-month WBS to an 8-month WBS.

![pastedImage_11 (1).png](https://blog.regoconsulting.com/hubfs/Blog%20Images/2017%20-%20May/pastedImage_11%20(1).png)

 

> *2. We just updated fiscal time periods, time slices, and the first day of the week, and now the Load Data Warehouse job is failing with the following error:*

```
ClarityDB - isOracle? - An error occurred executing this job entry :

Couldn't execute SQL: BEGIN

RPT_CALENDAR_SP();

RPT_INV_HIERARCHY_SP();

END; 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "SST484P.RPT_CALENDAR_SP", line 330

ORA-06512: at line 2 
```

> *Anyone seen this before and know how to fix it?*

Check that the First Day of the Week actually changed. If it hasn't, then it's not aligned with the DWH weekly timeslices, which causes the job to fail. 

> *3. Anyone have experience working with reports (Crystal) that display as either an XLS or PDF file when run through PPM? I’m only able to save the report to one of those two formats and therefore unable to update the source file (.rpt). Would we need to grab the (.rpt) file directly from the CMC?*

Try changing the report output via the CMC to the standard (.rpt) format, then you should be able to make the necessary changes.

## Thank You------------------------------  

A special thank you to [Mindy Calderon,](https://www.linkedin.com/in/mindy-masel-calderon-8a2b29/) [Ramesh Rathnam](https://www.linkedin.com/in/rrathnam/), [Jenn Rinella,](https://www.linkedin.com/in/rinellajenn/) [James Gille,](https://www.linkedin.com/in/james-gille-4897a6a/) [Ben Rimmasch](https://www.linkedin.com/in/rimmasch/), [Vikram Baddela](https://www.linkedin.com/in/vikram-baddela-42650a3/), [Dave Wachsmann,](https://www.linkedin.com/in/dwclarity/) [Davey Zywiec](https://www.linkedin.com/in/davidbzywiec/), [Marlon McKenzie](https://www.linkedin.com/in/marlonmckenzie/), and [the Rego Guides](http://regoconsulting.com/ca-ppm) for this Q/A material.

### **Let Rego Be Your Guide**

Rego offers [free health assessments](https://regoconsulting.com/clarity-ppm/#health), [webinars,](https://regoconsulting.com/events-ca-ppm/) and [half-day training classes for Clarity PPM](https://regoconsulting.com/free-pm-and-jaspersoft-training/) on Roadmaps in the Modern UX, Power BI, Portfolio Management, and Jaspersoft. 

For a full list of Clarity PPM Services, visit [regoconsulting.com](http://regoconsulting.com/). 

 By [Rego Consulting](https://blog.regoconsulting.com/author/rego-consulting)|May 08, 2017

#### Share on Social Media

- [Tweet](https://twitter.com/share)

### About the Author: [Rego Consulting](https://blog.regoconsulting.com/author/rego-consulting)

![Rego Consulting](https://blog.regoconsulting.com/hubfs/Blog%20Images/Rego%20Consulting.jpg)

As the leading PPM, ITBM, and Work Management services provider, Rego Consulting has helped hundreds of organizations achieve a higher return on their software investment, including 50% of Fortune 100 and 70% of Fortune 20 companies.

### Related Posts

[![Rego Home](https://no-cache.hubspot.com/cta/default/2652075/655865ab-5c17-4a7d-8626-9917913749d3.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/655865ab-5c17-4a7d-8626-9917913749d3)

[![Contact Us](https://no-cache.hubspot.com/cta/default/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4.png)](https://cta-redirect.hubspot.com/cta/redirect/2652075/80445cd5-d730-4608-a09c-dcaaeff582b4)

### Subscribe to Email Updates

[![Share on Facebook](https://static.hubspot.com/final/img/common/icons/social/facebook-24x24.png)](http://www.facebook.com/share.php?u=https%3A%2F%2Fblog.regoconsulting.com%2Fhow-to-scale-project-duration-from-a-wbs-template-ca-clarity-ppm%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on LinkedIn](https://static.hubspot.com/final/img/common/icons/social/linkedin-24x24.png)](http://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.regoconsulting.com%2Fhow-to-scale-project-duration-from-a-wbs-template-ca-clarity-ppm%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on Twitter](https://static.hubspot.com/final/img/common/icons/social/twitter-24x24.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.regoconsulting.com%2Fhow-to-scale-project-duration-from-a-wbs-template-ca-clarity-ppm%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.regoconsulting.com%2Fhow-to-scale-project-duration-from-a-wbs-template-ca-clarity-ppm%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=Clarity%20PPM%20%7C%C2%A0How%20to%20Scale%20Project%20Duration%20from%20a%20Template)

### Recent Rego Articles

### Sign up for our Weekly Newsletter

![rego-logo-white](https://blog.regoconsulting.com/hs-fs/hubfs/rego-logo-white.png?width=205&name=rego-logo-white.png)

As the leading PPM, Work Management, and Agile services provider, we have helped hundreds of organizations achieve a higher return on their software investment.

### CONTACT US

Questions? We can help.  
[info@regoconsulting.com](mailto:info@regoconsulting.com)  
888.813.0444

### Stay up-to-date

Get the latest news in industry best practices, thought leadership, and software updates.

### Solution Capabilities

[Clarity PPM](https://regoconsulting.com/clarity-ppm/)  
[Rally](https://regoconsulting.com/rally/)  
[Apptio](https://regoconsulting.com/apptio/)  
[Sciforma](https://regoconsulting.com/sciforma/)  
[Jira](https://regoconsulting.com/jira/)  
[Microsoft | SharePoint](https://regoconsulting.com/microsoft/)  
[Smartsheet](https://regoconsulting.com/smartsheet/)  
[Meisterplan](https://regoconsulting.com/meisterplan-itdesign/)

### Quick Links

[Our Company](https://regoconsulting.com/our-company/)  
[RegoUniversity](https://www.regouniversity.com/)  
[RegoXchange](http://regoxchange.com/)  
[Careers](https://regoconsulting.com/careers/)

 

Copyright 2022 Rego Consulting Corporation

[Linkedin](https://www.linkedin.com/company/rego-consulting?trk=biz-companies-cym)[Facebook](https://www.facebook.com/RegoConsulting/)[Youtube](https://www.youtube.com/channel/UCdA5xEiDrX--y2nVX2wC1UA?view_as=public)[Twitter](https://twitter.com/regoconsulting)

[Privacy Policy](https://regoconsulting.com/privacy-policy/)

![](https://dc.ads.linkedin.com/collect/?pid=14053&fmt=gif)