Export of queries with the MDB Admin Console runs into error

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager

Issue/Introduction

Symptoms: 

Exporting queries with the MDB admin console runs into following error messages:

D:\CA\DSM\MDB AdminConsole>mdbac.bat -export BoQueryDef -name "%" -work D:\TMP\E 
xport\2.Queries -source SGISBRUPM10 -user ca_itrm -pwd NOT_changedR11 
MDB Admin Console 12.8.0.8 (0) 
20160314_024406 start exporting query definition(s) 
20160314_024408 exporting query objects 
Exception in thread "main" org.hibernate.PropertyAccessException: Null value was 
assigned to a property of primitive type setter of ca.itcm.mdbac.api.pl.objects 
.Ca_query_def_contents.creation_date 
at org.hibernate.property.BasicPropertyAccessor$BasicSetter.set(BasicPro 
pertyAccessor.java:85) 
at org.hibernate.tuple.entity.AbstractEntityTuplizer.setPropertyValues(A 
bstractEntityTuplizer.java:337) 
at org.hibernate.tuple.entity.PojoEntityTuplizer.setPropertyValues(PojoE 
ntityTuplizer.java:200) 

Environment:  

MDB admin console as supplied on 12.8 DVD image

Cause: 

the problem seems to be caused by a query whose Ca_query_def_contents.creation_date = NULL 

Resolution:

 

Make a backup of the mdb first, then run following SQL query: 

use mdb 
UPDATE ca_query_def_contents 
SET creation_user=ca_query_def.creation_user, 
creation_date=ca_query_def.creation_date, 
last_update_user=ca_query_def.last_update_user, 
last_update_date=ca_query_def.last_update_date 
FROM ca_query_def 
WHERE ca_query_def.query_uuid=ca_query_def_contents.query_uuid

Environment

Release: UASIT.99000-12.8-Asset Intelligence
Component: