000032297 - Unable to generate package applications/questionnaire in RSA Archer 5.4.1

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000032297
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Questionnaire
RSA Version/Condition: 5.4.1
IssueA package is failing to generate. 
Log files have been obtained.
CauseA package will fail to generate when the package includes an application with a values list field that contains no values. 

Due to validation steps and checking, this can also occur when the application contains a cross reference to an application which contains the blank values list. 

To assist in diagnosing the issue, some of the following lines can be seen in the error logs:
(Note that this is not a complete stack trace.)

<Message>Enum value '0' is invalid for type 'ArcherTech.Common.Enums.ValuesListDisplayControlType' and cannot be serialized. Ensure that the necessary enum values are present and are marked with EnumMemberAttribute attribute if the type has DataContractAttribute attribute.</Message>
   at System.Runtime.Serialization.EnumDataContract.WriteEnumValue(XmlWriterDelegator writer, Object value)
   at System.Runtime.Serialization.XmlObjectSerializerWriteContext.InternalSerialize(XmlWriterDelegator xmlWriter, Object obj, Boolean isDeclaredType, Boolean writeXsiType, Int32 declaredTypeID, RuntimeTypeHandle declaredTypeHandle)
   at WriteValuesListFieldDisplayToXml(XmlWriterDelegator , Object , XmlObjectSerializerWriteContext , ClassDataContract )
   at System.Runtime.Serialization.ClassDataContract.WriteXmlValue(XmlWriterDelegator xmlWriter, Object obj, XmlObjectSerializerWriteContext context)
   at System.Runtime.Serialization.XmlObjectSerializerWriteContext.SerializeAndVerifyType(DataContract dataContract, XmlWriterDelegator xmlWriter, Object obj, Boolean verifyKnownType, RuntimeTypeHandle declaredTypeHandle, Type declaredType)
   at System.Runtime.Serialization.XmlObjectSerializerWriteContext.SerializeWithXsiTypeAtTopLevel(DataContract dataContract, XmlWriterDelegator xmlWriter, Object obj, RuntimeTypeHandle originalDeclaredTypeHandle, Type graphType)
   at System.Runtime.Serialization.DataContractSerializer.InternalWriteObjectContent(XmlWriterDelegator writer, Object graph, DataContractResolver dataContractResolver)
   at System.Runtime.Serialization.DataContractSerializer.InternalWriteObject(XmlWriterDelegator writer, Object graph, DataContractResolver dataContractResolver)
   at System.Runtime.Serialization.XmlObjectSerializer.WriteObjectHandleExceptions(XmlWriterDelegator writer, Object graph, DataContractResolver dataContractResolver)
   at System.Runtime.Serialization.DataContractSerializer.WriteObject(XmlWriter writer, Object graph)
ResolutionRun SQL script below to identify values list fields that contain no values for a specific module ID.
(This script is valid ONLY for version previous to 5.5.2 an sit does not contain the necessary translation tables) 
select m.module_id,m.module_name,fd.field_id,ft.field_name 
from tblIVFieldDef FD
join tblLevel l on l.level_id=fd.level_id
join tblFieldTranslation ft on ft.field_id=fd.field_id
join tblModule m on m.module_id=l.module_id
where field_type_id = 4  --type 4 designates a values list field
and M.module_id= XXX  -- replace XXX with application ID you're investigating to limit results
and fd.field_id NOT IN (select field_id from tblXIVSelectDefFieldDef)
order by ft.field_name

If the script returns no results, expand the search by commenting out the module ID line to search for additional
applications that may be unknowingly included in the package (For example, a cross referenced application) 
WorkaroundAdd values to the Values List field OR the Values List field causing the issue may be deleted.