Catégorie : Wiki

Sage X3 ERP and BI consulting

Sage X3 – répertoire SVG déporté

Sometimes your installation server lack of space and you are not able to execute DOSEXTRA. Your cloud partner is asking recurring money for a simple disk extension. And you have several other disk available with free space. Problem : The management console nor Sage X3 is natively able to read remote standalone SVG folder You can…
Lire la suite

Sage X3 – Récupérer mot de passe sa perdu

This solution is exploiting a security breach of the software and is not the standard way to do it. Keep in mind that Sage X3 is calling an external program called crystal report in order to print the reports. The communication between this softwares is not secured, and can be « hijacked » if you have access…
Lire la suite

Sage X3 – Erreur No 76

Context : You are creating or importing a new folder Using the function Parameters > General parameters > Folders (GESADS) or using Sage X3 Console Problem : Action 1 : When you hit once the validation button of the folder Error 1 : Error No 76 [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user…
Lire la suite

Comment utiliser le debug X3 et Eclipse ?

How to connect Eclipse and Sage X3? The recent trend with cloud has several side effects, on Sage X3 debugger tools. Many Sage X3 consultants encounter several issues in order to connect their Eclipse and Sage X3 in debug mode. These issues are sometimes linked to network complexity, if you are fed up with “infbox” in…
Lire la suite

Comment ajouter une base de donnée dont le nom contient un point dans Sage Enterprise Intelligence

Sometimes your database contains a dot in the identifier name. This is allowed by SQL server : https://docs.microsoft.com/fr-be/sql/relational-databases/databases/database-identifiers?view=sql-server-2017 « When identifiers are used in Transact-SQL statements, the identifiers that do not comply with these rules must be delimited by double quotation marks or brackets. » When you use SQL query you can call this database like that : [external.db] or « external.db »…
Lire la suite

Sage X3 – Comment utiliser ATEXTRA

What is ATEXTRA ? ATEXTRA table exist since Adonix (1997) to store a part of translated text of the application. The weak point of this method is the size limitation, specificaly the maximum lenght of the boxes. It is not possible to store more than 80 characters for a box within this method. You can…
Lire la suite