If the IDX file group in Sage X3 is growing rapidly, it indicates that there may be underlying issues contributing to excessive index growth. Here are several potential reasons why the IDX file group could be growing rapidly in Sage X3:
Fragmented…
In Sage X3, the IDX file group is a set of files used by the database management system (DBMS) to store index data for tables within the Sage X3 database. These index files are used to facilitate efficient retrieval of data when executing queries against…
To prevent the IDX database file from growing massively with Sage X3, you can take several steps to manage and optimize your database usage. Here's a guide on what you can do:
1. Regular Database Maintenance:
Perform regular maintenance tasks on your…
Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…
Has anyone had to create a new V11 (or really any version) application server and connect it to an existing SQL Database server? Assume we don't have access to the old app server (although we might).
I have some ideas, but I'd like to know how others…
In this blog, I would like to show you where to look to determine if your X3 database files are stored on one or more drives. Why would this be important? The reason I bring this up is related to performance optimization. Setting up your X3 database files…
Dear Fellows,
As you may all know that when you delete a folder in X3 it will not be deleted from database with all its references which will eventually increase your database size, and therefore i created an sql procedure that safely delete the folder…
Can someone please assist me with the following.
Production Management Console.
So this issue is also the cause of our current situation on a Clients UAT environment.
This issue occurs either when I try to click on the Customisations and…
Hi,
We are a Blending & Packaging plant and have v9 Patch 5.
We have 'never' archived/purged in our Sage X3 (EM) so we have over 10yrs of data (Since June 2008...)
We've started to purge out some old data like the ATRACE and investigating into the…
Hello Sagers,
I was trying to connect Sage x3 to a virtual database ( always on ) and this virtual SQL database is pointing to two other Physical SQL database instances this to have online hot swappable database recovery.
But the console is not seeing…
