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