Hi Dojo,
We have a DMA running 10.1 CU5 where Asset Manager reports an error when populating the tree with data: (MySQL 8.0.26)
Database SLNet reports following error in the logfile:
2021-07-27 14:22:50.700|87|Server Thread 8 - Failure 1064='You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\`network\` ORDER BY NAME ASC' at line 1' for ExecuteQuery 'SELECT * FROM \`network\` ORDER BY NAME ASC')
The table name does not contain any quotes:
Is it something to do with DataMiner trying to quote the name ? The query was ran without the quotes(\') in MySQL workbench and executed successfully.
Thank you in advance!
Hi Arun,
I performed a small test using DMA version 10.1.8.0 and MySQL 5.5.27 and I was not able to reproduce the issue. In the Inventory and Asset Management (IAM) configuration file I defined a table with the ascending order defined in the screenshot.
The issue could be related to the data available in the Network table. We can try for example perform this test without data on the table and confirm if the issue can be reproduced.
In order to further investigate this issue, we will need the following information:
- MySQL dump of the external DB
- IAM configuration file (the file can be found in C:\Skyline DataMiner\AssetManager\Configs)
In this case we will need to use the same DMA and MySQL version (10.1 CU5 and MySQL 8.0.26)
Hi Arun,
As discussed, this behavior is related to a SW issue found in 10.1 CU5.
We were not able to replicate this issue in 10.1 CU4.
Please if you can create a task to tackle this SW issue.
thank you for the input Miguel.