No records in ODS_NC_DATA_SUMMARY

[Former Member]

Hi,

I have noticed that we have no data in the table ODS_NC_DATA_SUMMARY
even though we are running the ODSNonConformanceETL script every hour.

The table ODS_NC_DATA contains 111425 records after the
transfer has been running about a year, but the summaries are never done.

Server ME version is 6.0.4.27

ODS Rule Maintenance parameters are set as:

Perform Summary at has been tested with also "On Incident closure"

Nonconformance Summary
ODS Retention Period		9999
Copy to Global ODS	TrueFalseUse Global Setting	FALSE
Perform Summary At	On NC ClosureOn Incident ClosureUse Global Setting	On NC Closure
Summarize by Site
Summarize by NC Code
Summarize by Parent NC Code
Summarize by NC Category
Summarize by Failure ID
Summarize by Material
Summarize by Operation
Summarize by Ref Des	TrueFalseUse Global Setting	TRUE
Summarize by Grand Parent NC Code	TrueFalseUse Global Setting	TRUE
Summarize by Incident NC Code	TrueFalseUse Global Setting	TRUE
Summarize by User ID	TrueFalseUse Global Setting	TRUE
Summarize by Times Processed	TrueFalseUse Global Setting	TRUE
Summarize by Component	TrueFalseUse Global Setting	TRUE
Summarize by Inventory ID	TrueFalseUse Global Setting	TRUE
Summarize by External Lot Number	TrueFalseUse Global Setting	FALSE
Summarize by External Serial Number	TrueFalseUse Global Setting	FALSE
Summarize by Vendor	TrueFalseUse Global Setting	FALSE
Summarize by Vendor Lot	TrueFalseUse Global Setting	FALSE
Summarize by Vendor Date Code	TrueFalseUse Global Setting	FALSE
Summarize by Indentifier	TrueFalseUse Global Setting	TRUE
Summarize by Step ID	TrueFalseUse Global Setting	TRUE
Summarize by Routing	TrueFalseUse Global Setting	TRUE
Summarize by Routing Type	TrueFalseUse Global Setting	TRUE
Summarize by Reporting Center	TrueFalseUse Global Setting	TRUE
Summarize by Disposition Routing	TrueFalseUse Global Setting	FALSE
Summarize by Operation Type	TrueFalseUse Global Setting	TRUE
Summarize by Resource	TrueFalseUse Global Setting	TRUE
Summarize by Work Center	TrueFalseUse Global Setting	TRUE
Summarize by Location	TrueFalseUse Global Setting	TRUE
Summarize by Responsible Operation	TrueFalseUse Global Setting	TRUE
Summarize by Shop Order	TrueFalseUse Global Setting	TRUE
Summarize by Customer	TrueFalseUse Global Setting	TRUE
Summarize by Customer Order	TrueFalseUse Global Setting	FALSE
Summarize by Custom NC Data Fields		TRUE
Summarize by Component SFC Material	TrueFalseUse Global Setting	TRUE

[sergiy_katerinich · Accepted solution]

Hi!

Have you assigned Time Granularity for NC? If not, then it is a most likely root cause.

Regards,

Sergiy