Hi support team we configured a mysql database into a different server and configured the offload on our DMA server to forward trending data into that database but we are getting the error mentioned above on SLDatabase[SLDataGateway].txt file is there any other log file we can check to find out why is not getting new data into the central database
Hey Edgar,
That error gets thrown by MySQL (and logged by us) when the feature that allows inserting data from files is disabled on the MySQL server. DataMiner requires this feature to be enabled as it stores the data into a file and periodically inserts these files into the database using a 'LOAD DATA LOCAL INFILE'-query.
You can enable this feature by executing the following query on the database server
SET GLOBAL local_infile = 'ON';
thanks Brent I made the changes and offload data started again