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

<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" />
        <AssemblyVersion>6.2.0.1177</AssemblyVersion>
    </System>
    <ApplicationData>
        <TraceData>
            <DataItem>
                <TraceRecord Severity="Error" xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord">
                    <TraceIdentifier>Archer.Packaging</TraceIdentifier>
                    <UserId>183</UserId>
                    <Description>Object reference not set to an instance of an object.</Description>
                    <AppDomain>ArcherTech.JobFramework.Job.exe</AppDomain>
                    <Exception>
                        <ExceptionType>System.NullReferenceException, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType>
                        <Message>Object reference not set to an instance of an object.</Message>
                        <Source>ArcherTech.Kernel</Source>
                        <StackTrace>
   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>
                    </Exception>
                </TraceRecord>
            </DataItem>
        </TraceData>
    </ApplicationData>
</E2ETraceEvent>

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

   
   

2. For each DDE Rule in the SQL results, modify the Rule with valid Criteria or delete the Rule.