We are on Epicor 9.05.606a SQL.
We use Configurator for nearly every Quote and have some of the most complex Configurators I have seen. As a result our PCInValue table has become alarmingly large.
I have talked with Tech Support about this table growth but have not been able to get anyone to provide me with any suggestions to address this issue.
Has anyone had any success in either trimming old records (we don't need anything older than 6 months) or setting up meaningful SQL table partitioning on this table?
I have tried ABL code via a BPM to delete old records from PCInValue but the "DELETE" operator seems to be either blocked or running into some dependency checker that will not allow it to proceed.
Thanks,
Nathan Bonner
bonner.nathan@
gmail.com
616.717.1613
We use Configurator for nearly every Quote and have some of the most complex Configurators I have seen. As a result our PCInValue table has become alarmingly large.
I have talked with Tech Support about this table growth but have not been able to get anyone to provide me with any suggestions to address this issue.
Has anyone had any success in either trimming old records (we don't need anything older than 6 months) or setting up meaningful SQL table partitioning on this table?
I have tried ABL code via a BPM to delete old records from PCInValue but the "DELETE" operator seems to be either blocked or running into some dependency checker that will not allow it to proceed.
Thanks,
Nathan Bonner
bonner.nathan@
gmail.com
616.717.1613