000034749 - Unable to Generate Package in RSA Archer 6.2 due to an issue with a Data Driven Event (DDE)

Document created by RSA Customer Support Employee on Mar 2, 2017Last modified by RSA Customer Support Employee on Apr 22, 2017
Version 3Show 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. 
Sample DDE Rule with invalid Criteria:

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