search cancel

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

book

Article ID: 186117

calendar_today

Updated On:

Products

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

Environment

Release : 8.6
Component : CA Gen Client Server Encyclopedia

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.

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