Troubleshooting
Problem
In some instances, a SPU may reset with DEV_UEC_DATA_STORAGE errors and cause a SPU core to be generated.
Resolving The Problem
These errors are often the result of a software-induced fault. The issue arises when a query results in a large disk-based aggregation with ORDER BY sorting operations and can result in a SPU reset and an error message similar to the following:
UEC error has been detected - DEV_UEC_DATA_STORAGE
The issue was fixed in NPS Releases 4.6.2 P21, 4.6.6 P6, and 4.6.8 so if you upgrade to one of those releases, the issue will be resolved.
If you cannot upgrade in the near term, the following is a workaround for the nz user to perform:
1. In a text editor such as VI, open the /nz/data/config/system.cfg file for editing.
2. Add the following line to the end of the file:
system.enableZMapMultiColJoinRestrict=no
3. Save the file and exit the text editor.
4. Run nzstop to stop the NPS system.
5. Run nzstart to restart the NPS system.
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21568886