Clarity: Error "PRJ-10002: Copy project WBS failed" when trying to create a new project from a template with at least 1 task.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Description:

When trying to create a new project from a template with at least 1 task, the error message "PRJ-10002: Copy project WBS failed" will be shown if temporal folder "Tablespace" is missing on Oracle Database.

• Error shown in app-niku.log:
  
  "Exception <xopyProjectTasks.copyProjectFromTemplate() com.niku.union.utility.MessageKeyException: PRJ-10002: Copy project WBS failed".
  
  
• Error shown in SQLTrace log:
  
  "FAIL: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-25153: Temporary Tablespace is Empty".

<Please see attached file for image>

Solution:

Create the temporary Tablespace in Oracle. See example below:

create temporary tablespace temp_mtr tempfile '/dbf1/mtr_temp01.dbf' size 32m autoextend on next 32m maxsize 2048m extent management local; 

Keywords: CLARITYKB, configuration, schema

Environment

Release: NCSVCS05900-8.1-Clarity-Service Connect-for MS-SQL
Component: