CA Gen CSE Model Upload Error "TIMESTAMPDATETIME could not be found in table"

book

Article ID: 186117

calendar_today

Updated On:

Products

CA Gen

Issue/Introduction

Just created a new CSE running:
Windows Server 2016
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
NOTE: Used config tool to create new Schema, (used different Ency Id).

When attempting to upload an existing model receive the following errors:

MDLADPT:
Function Work Attr Set TIMESTAMPDATETIME could not be found in table
MDLADPT:
FUNCDEF TIMESTAMPDATETIME could not be found in table

Cause

The timestampdatetime function was first added in Gen 8.6 IR1 (Windows PTF IRN86100/RS94237) and is also in Gen 8.6 Complete (Windows PTF WKS86200/SO09618)
https://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-mainframe-software/devops/ca-gen/8-6/release-notes/ca-gen-8_6-ga/incremental-release-1.html
From the message it would appear that the model being uploaded already contains the new timestampdatetime function i.e. it is at a post Gen 8.6 IR1 release level, but the new CSE is not aware of the function because it is not yet at that release level.

Environment

Release : 8.6
Component : CA Gen Client Server Encyclopedia

Resolution

Installed the Windows PTF for Gen 8.6 Complete (WKS86200/SO09618) on the new CSE to resolve the problem.
https://casupport.broadcom.com/download-center/solution-detail.html?aparNo=SO09618&os=WINDOWS