Sage X3

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Hi there, I have made 3 different upgrades from Mongodb 3.4 to 4.2 and now when I restart Windows, the mongodb service doesn't autostart. I have to start it manually. The update path was the following: Mongodb 3.4 -> 3.6 Mongodb 3.6 -> 4.0 …

Hi everyone, I'm looking for the description of this field: Table - FXDASSETS field ACGGRP_0 Example: ACGGRP_0 CM The description must be similar, but I have not been found a table yet with this description, please someone has an…

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. …

How do we manage the MongoDB log file. Mongodb has just one giant log file where all the logs get updated. Is there a way for mongodb to create multiple log files instead of just one giant file? What is the best way of purging the logs? In our…

[conn91798] SocketException handling request, closing client connection: 9001 socket exception [SEND_ERROR] server [x.x.x.x:39903]

I Have perform the log rotation in MongoDB for my nosql data , Please help me with the Code in order to perform log rotation. Here i have a specific set of Nosql data in my mongodb

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 All, How can i clear a MONGODB DATABASE, because some collection like fs.chunks are very bulky. Thanks

How are subqueries performed in SEI without creating a custom DB view ? Creating an Order Shortage Report. I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find…

Hi there , Is there a way to access the user list stored in mongodb? I am referring to the information of the users created in the Administrator ? Users > Users Thanks