Sage X3

Hi, Context: - Migration work. - Sage X3 pu9p5, Sage X3 v11p22, and Sage X3 v12p34 (destination version; do note I haven't test to bring v12 console to lower versions for multi-threading SVG backup work). - SQL Server 2022 Standard Edition on…

Let's take an example, in SEED folder, I have a Purchase Request record dated 2018. This purchase request record has two attachment in ATT folder of the SEED endpoint. I will run an archive procedure for Purchase Request with shelf life of 2 years now…

I have folder that i want to take svg for to refresh into the UAT enviroenmnet. However the SVG process takes very long time to export because of the size of the data~ 2TB Database. Now i am trying to use the BCP option to see if it can speed up the process…

Hi, Question: Can I import Sage X3 folder which was taken from a server using newer version of SQL Server to an older version SQL Server? Second question: Can I import Sage X3 folder which was taken from Oracle database to a SQL Server database? …

Hello Community. We have a Sage X3 implementation whereby we have different entities / companies. Does anyone know if its possible to backup the different entities separately or is it a all or nothing exercise. For instance if one group of accountants…

We are new to X3 and I watched the process of getting all the stuff installed. Our partner called in experts from each vendor to install their parts. We have x3, Datalinx, SEI with MSSQL. The total install time we were billed for exceeded 20 hours…

As per title, I have received an order to prepare a cold storage purely for long-term archival purpose. I am interested in how everyone deals with cold storage order. As far as I know, Sage X3 have Archive/Purge folder (which I labbed here: https…

Hello Sage City, As a Sage partner, I have heard numerous horror stories about the "PURGE" function in older v5, v6 and v7 versions of Sage X3. A customer of mine will be migrating to v12 shortly and asked about purging old data from the database…

We recently migrated from a Sage 500 to a Sage X3 based vendor provided vertical for the growing/horticulture/agriculture industry. The vendor did the setup beyond my initial setup of 3 virtual servers per their request (IIS, APP, and DB servers). We…

Sage x3 PU9 When do SVG data extraction we keep on getting the error below What would be possible causes and how can we resolve?

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…

Hi guys, I need help! My client wants me to achieve an automatic backup from her Production server to a Data recovery Server on a daily basis Please how can this be achieved? Hoping to get a positive response Thanks

Has anyone done a MongoDB migration from PU8 to V12? I'm following some KB's:36290,74246. According to the material, it consists in to perform a Mongodump in the source server and perform a Mongorestore in the new server removing some collections. …

So I know how I can write a transaction for a table and if there's an error, rollback the changes. How would I go about doing this if I wanted to rollback multiple changes to multiple tables? e.g. I'm trying to write to four tables [BPR], [BPS], …

We got a virtual machine from client with Sage X3 v65 Application server. The database server was on a different server. In this local copy of VM we have updated the configuration files to point to local database. When we try to log into Sage X3…

Is the online help data model correct for V12? The files show v6.....

We have our DOSSVG running as a nightly process on the batch server. For some reason, our SVG backups are failing because of the error popenw32. Anybody have any ideas as to why this is happening?

I need to purge some old records from the audit tables and was hoping to get some of the best known methods for this task.

Sage X3 Version 6.5 Patch 29 We have done a server migration. Installed Sage X3 v 6.5 on new server. Imported the folders +svg from old server On the new server when we log on to Sage we get the error message below. “@X3.TRT/TRTLIC$adx…

After upgrading from SEM 11.09 to 11.10 (including mongo upgrade to version 3.4.16) mongodump stopped working in all 11.10 environments with an error. Does anyone knows how to fix this behavior? Error is: "2018-11-09T11:30:08.881+0000 Failed…

Hi, While i'm creating a record due to some issue i lost the data in table maintenance ,can any one help me out to get lost data?

Someone purged our lots and we need the data to run a specific report. Is there any way that this can be fixed?

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…

Is there any best practice or document for Sage X3 PU9 or V11backup, like auto daily backup of entire Sage X3 including transactional database, MongoDB and application folder? My understanding here is we have to do the backup of 3 layers below manually…

Is there any documentation outlining what needs to be backed up for Disaster Recovery? SQL backups are done, but what happens if the server is lost? What steps can one follow to recover a system having only the SQL backups?