Hello, wanted to share something unusual, our fil...
# performance
k
Hello, wanted to share something unusual, our file storage utilization is less then 50GB however we have NSPB module which is storing files pretty much every hour and it increased our file cabinet size to 2000TB 😳, not sure if anyone has seen this #C29GDT351 #C02BF0PFB1Q
e
It's amazing that Oracle/NetSuite hasn't found this problem themselves.
j
@Karthik Check your deployment schedule on the "NSPB SS Cleanup" script {customscript_nspbcs_ss_cleanup}. That is the NSPB script that is suppose to be auto deleting files after the data syncs. Ours was set to only run 4 times per day, but we were syncing data to NSPB every hour... the amount of files it was generating way outpaced the delete script, which is what caused our file cabinet storage to pile up. Support told me that the script can only delete a max of 250 files per execution due to governance limits. We cranked the deployment schedule up to run every 15 mins for a couple weeks to get the file cabinet folder cleaned up. Once it got caught up, we've adjusted back to running every hour and its maintained a reasonable folder size ever since. Hope that helps!
🔥 1
k
@Joanna Curtis After raising support ticket they confirmed same and after redeployed NSPB cleanup script and it solved the problem. But It took a whole week to cleanup 🐢
j
Ours took a long time too. Glad it worked for you!!