Error message "1270051 - Failed to create thread" during execution of aggregate build
Hi, I'm trying to build aggregate views after a dataload but it doesn't work anymore.
It works without problem on my preproduction server with this script:
execute aggregate build on database AD_ARI.DD_ARI
using view_file 'Freeze.csc';
Pending cache size limit (MB) was 1024.
I tried on my production server with the same script and the same Pending cache size limit (MB).
Here is the error message:
ERROR - 1270041 - Sort operation ran out of memory. Please increase the size of aggregate storage cache.
So I changed Pending cache size limit (MB) to 4096 and now my new error message is:
It works without problem on my preproduction server with this script:
execute aggregate build on database AD_ARI.DD_ARI
using view_file 'Freeze.csc';
Pending cache size limit (MB) was 1024.
I tried on my production server with the same script and the same Pending cache size limit (MB).
Here is the error message:
ERROR - 1270041 - Sort operation ran out of memory. Please increase the size of aggregate storage cache.
So I changed Pending cache size limit (MB) to 4096 and now my new error message is:
0