Roadmap Sync not Working

Products

• Clarity PPM On Premise

Issue/Introduction

A few attributes were created in the Roadmap Item object, but we are now facing issues with the Sync. Values for the attributes are not showing up on the Roadmap grid view even after having the same data type and API ID as the corresponding attribute on the Project object. 

Various other errors occur when attempting to make updates to the Roadmap such as: 

• API-1007: You are not authorized to process request. Contact your system administrator for necessary security rights. 
• Error reading rdm_roadmap_item-5xxxxxx instance with PK: 5nnnnnn

This same occurs for any user regardless of access rights. 

Environment

Release : 15.8.1

Component : CA PPM STUDIO

Resolution

When looking at the app-ca log, the following error occurs: ORA-00972: identifier is too long

This error message is referencing the alias specified in a query that is also included in the app-ca log.

Sample Alias: abc_custom_attributetimelinepos

This would indicate that the attribute ID (abc_custom_attribute) is too long to where it cannot be used as part of the alias in the backend query in roadmaps. The 31 characters that end up being the generated alias in the query exceeds the 30 byte limit that exists in Oracle 12.1.

Oracle 12.1 is not supported with Clarity 15.8.1, however, Oracle 12.2 is. In Oracle 12.2, up to 128 bytes are allowed, so this issue would not occur there. 

The workaround until you are able to upgrade to a supported Oracle version would be to have all custom Roadmap Item attributes have an ID of 19 or less characters.