on Mar 2, 2017Article Content
| Article Number | 000034749 |
| Applies To | RSA Product Set: Archer RSA Version/Condition: 6.2 |
| Issue | When 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" /> <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.<>c__DisplayClass68_0.<GenerateDDE>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.<>c__DisplayClass40_0.<GetGenerateActions>b__0(GenerateContext executeContext, ExecuteActions`1 executor)</StackTrace> </Exception> </TraceRecord> </DataItem> </TraceData> </ApplicationData> </E2ETraceEvent> |
| Cause | The 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:  |
| Resolution |
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
 |