000034749 - Unable to generate package due to an issue with a Data Driven Event (DDE) for RSA Archer

Document created by RSA Customer Support Employee on Mar 2, 2017Last modified by RSA Customer Support on Jul 1, 2019
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000034749
Applies ToRSA Product Set: Archer
RSA Version/Condition: 6.2
IssueWhen generating a package within RSA Archer 6.2, an error is generated within the user interface (UI) stating that the issue is with a Data Driven Event (DDE). However, this error doesn't notate if the problem DDE is within the package or outside of the package. 

The following exception is from the Archer JobFramework logs:
<E2ETraceEvent xmlns="http://schemas.microsoft.com/2004/06/E2ETraceEvent">
    <System xmlns="http://schemas.microsoft.com/2004/06/windows/eventlog/system">
        <Source Name="Archer.Packaging" />
        <Execution ProcessName="ArcherTech.JobFramework.Job" ProcessID="5924" ThreadID="1" />
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <Description>Object reference not set to an instance of an object.</Description>
                        <ExceptionType>System.NullReferenceException, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
                        <Message>Object reference not set to an instance of an object.</Message>
   at ArcherTech.Kernel.Brokers.Packaging.Generate.GeneratePackage.DDEAddRuleFiltersAndRuleActions(PackageDataDrivenEvent packageDataDrivenEvent, GenerateContext context, IEnumerable`1 eventRules, IList`1 filters, IDictionary`2 ruleIdGuidMap, IDictionary`2 ruleIdToFilterIdMap)
   at ArcherTech.Kernel.Brokers.Packaging.Generate.GeneratePackage.&lt;&gt;c__DisplayClass68_0.&lt;GenerateDDE&gt;b__0(GenerateContext context, ExecuteActions`1 ignored)
   at ArcherTech.Kernel.Brokers.Packaging.Generate.Actions.ActionExecutor`1.ActionExecutorLoop(IEnumerable`1 actions)
   at ArcherTech.Kernel.Brokers.Packaging.Generate.GeneratePackage.&lt;&gt;c__DisplayClass40_0.&lt;GetGenerateActions&gt;b__0(GenerateContext executeContext, ExecuteActions`1 executor)</StackTrace>
CauseThe issue is caused by a Data Driven Event (DDE) Rule with invalid Criteria. The DDE Rule could be within the module being packaged OR within a related module via a Cross-Reference or Related Records field. 

A sample DDE rule with invalid criteria is shown below:

User-added image
  1. Identify all DDE Rules with invalid Criteria by running the following SQL query against the Instance database:

SELECT m.module_id, mt.module_name, lm.layout_module_name, er.sort_order, er.event_rule_id, event_rule_name, fc.*, fcc.* FROM tblEventRule er
JOIN tblIVLayoutModule lm ON lm.layout_module_id = er.layout_module_id
JOIN tblModule m ON lm.module_id = m.module_id
LEFT JOIN tblFilterCriteria fc ON fc.filter_criteria_id = er.filter_criteria_id
LEFT JOIN tblFilterCriteriaCondition fcc ON fcc.filter_criteria_id = fc.filter_criteria_id
LEFT JOIN tblModuleTranslation mt ON m.module_id = mt.module_id
WHERE er.event_rule_id IS NULL OR event_rule_name IS NULL

OR fc.filter_criteria_id IS NULL
OR fc.create_date IS NULL OR fc.create_login IS NULL OR fc.update_date IS NULL OR fc.update_login IS NULL
OR filter_criteria_condition_id IS NULL OR fc.filter_criteria_id IS NULL
OR filter_criteria_condition_type_id IS NULL
OR filter_criteria_operator_id IS NULL
OR condition_order_number IS NULL
OR fcc.create_date IS NULL
OR fcc.create_login IS NULL
OR fcc.update_date IS NULL
OR fcc.update_login IS NULL


  1. For each DDE rule in the SQL results, modify the rule with valid criteria or delete the rule.  

User-added image