Browse By Tags

Sage X3: v12p33 Sitemap loading failed: Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No such host is known. : ini_com:Variable dimension:!(2) Context: Hostname changed.

Sage X3 v12p34, SQL Server 2022 Standard edition. Full error as follows: `Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The SELECT permission was denied on the object 'APLLCK', database 'x3v12'…

I work for a software dev company that is setting up an application for a client. They have been using the Timberline Data driver (using ttsimba.dll) to create an ODBC DSN to their Sage 300 CRE data in Access and run some update queries. We are replacing…

I want to establish a connection between Sage X3 and SQL server but I can't do it. Can anyone help me or should I go another way?

Hola, Nos dice la empresa que nos instaló SAGE 200 que el programa dejará de funcionar con el motor SQL Server 2017 Standard Edition cuando lleguen las actualizaciónes de Febrero, y que deberemos actualizar a SQL Server 2022 Standard Edition, esto es…

Hello, We currently have Windows services (written in C#, .NET) that push data out from some Sage tables to a custom API, which then stores it in a private SQL Server Database. Depending on the service, it might trigger every minute, every 5 minutes…

I am currently running Sage Paperless on SQL 2014 ver 12.0.2269.0 (released 7/14/2015). My internal vulnerability scans have flagged this version as unsupported and it likely contains several security vulnerabilities. What is the process for updating…

Buenos días; Me gustaría saber si es posible crear un campo de última modificación en la tabla de LineasPedidoCliente. He intentado hacerlo por SQL, pero me ha sido imposible. ¿Solo se puede hacer con el cálculo? ¿Si así fuera alguien me…

Hi, Context: Sage X3: v12 Patch 33 Application folder (symbolic link): C:\ -> UNC Path at Amazon FSx DB: SQL Server 2019 Std. DB Cluster: Active/Passive Availability Group (AG). Using AG listener name and port. Followed: https://www.sagecity…

Hi, Version: X3 v12p33 Microsoft SQL Server: 2022 Standard Full error message from Sage X3: Connection to server failed : X3 engine error: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: The wait operation timed out. : ini_com:Variable dimension…

In Sage Intelligence Reporting we frequently find that we need to clear out the Tenant cache. The error message we get back is: Problem Loading Data A row with duplicates was encountered at row number 248 for data object Accounts The Values are…

Nuestra empresa dispone de un servidor de 32gb y hemos notado desde hace unos días que el programa nos va lento. Al revisar el el servidor hemos visto que el SQL esta consumiendo mas de 22 gb. Eso es normal? Puede que se haya quedado bloqueado en alguna…

Hi, This is a question for Sage X3 v12 onwards X3 console. Older console versions I know were inevitable to use `sa` account only. Link reference: online-help.sageerpx3.com/.../prerequisites_windows-sql-server.html Is `sysadmin` role level required…

Important alert: Do not use SQL Server module version 22.x with Sage X3 until further notice. Use SQL Server 21.1.18256 only. PowerShell 7.2+ is a prerequisite for Sage X3, along with the SQL Server module for PowerShell. SQL Server module version 22…

Alerta importante: No utilice el módulo SQL Server versión 22.x con Sage X3 hasta nuevo aviso. Utilice SQL Server 21.1.18256 PowerShell 7.2+ es un requisito previo para Sage X3, junto con el módulo SQL Server para PowerShell. La versión 22.0.59…

Si en el servidor se ha actualizado el módulo SQL Server de Powershell a la version 22 o se ha instalado esta versión directamente, al actualizar el Runtime, o al realizar una primera instalación obtendrá un error similar al de la segunda imagen. …

Hello. We are looking to upgrade from Advanced to premium primarily because of the need for external reporting from "3rd Party" tools. These tools require SQL server access to be able to PULL data from Sage running SQL. We have read where the SQL server…

We have a new Windows Server 2019 and SQL Server 2019 for our Sage 500 upgrade to version 2021. We use Sage via RDP. The Client is not installed on user PCs. They RDP to the server which is configured to launch a Sage session for the user. Sage is working…

Hello Everyone, We are in the process of setting up our new server and was wondering if Sage 500 will work in a RAID environment? The SQL Server will be running in a VM and we have 16 1TB SSD drives to "play" with.What RAID configuration would be best…

Hi All. We're in the process of upgrading to Sage 2022 and I'm trying to recreate some SSIS packages (SQL Server 2019 and Visual Studio 2022) that connect to Sage 2022 via the ODBC 64-bit driver and copies to one of our SQL Server 2019 tables. I'm…

In my previous post, I explained how to deploy a SQL Elastic Pool in Azure Portal. In this post, I am going to show how to perform a Sage X3 Solution configuration using the deployed Database, so let's dive right in. To create a solution, open the Solutions…

Hi, When running on SQL Server 2019, is X3 complient with the TempdbMetadataMemoryOptimized setting to true?

Hi, Console: CFG.2.54.0.5 (from v12p30 ISO disc) I have noticed latest version and newer patch level of Sage X3 v12p30 now can set the Db login. It was previously impossible to edit and must use sa. Will there be any issue if I change…

Buenos días; Escribo en este foro con la intención de descubrir lo antes posible la solución a un problema que llevamos teniendo desde hace meses con Sage 200 y al cual no nos dan ninguna solución En problema consiste en que aun sin llegar al máximo…