DCI Database errors

[curruscanis]

I have a node with a DCI issue.

I am getting the error:

'Read DCI data from server' has encountered a problem.  Cannot get data for DCI "Node Name":[1464]: database failure

I noticed this as the data from the node was displaying on a dashboard and now just shows "Cannot get DCI Value..."

I have run a database check and all passed, I have deleted and recreated the DCI collection items with no success.

Please let me know what I can do to troubleshoot this.

Thank you.

[victor]

Hi,

do you have any messages in server log started with "SQL query failed"?

Best regards,
Victor

[curruscanis]

I do  I have many entries with "SQL query failed"...

[curruscanis]

I have done the following attempt to repair:

[root@netxms ~]# nxdbmgr check
NetXMS Database Manager Version 2.0-M5 Build 8027

Checking database (excluding collected data):
Database is locked by server 192.168.231.150 [netxms Linux Release 2.6.32-504.23.4.el6.x86_64]
Do you wish to force database unlock? (Y/N) y
Database lock removed
* Checking zone objects...                                            [PASSED]
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                      [PASSED]
* Checking network service objects...                                [PASSED]
* Checking cluster objects...                                        [PASSED]
* Checking template to node mapping...                                [PASSED]
* Checking object properties...                                      [PASSED]
* Checking event processing policy...                                [PASSED]
* Checking network map links...                                      [PASSED]
* Checking data tables...                                            [PASSED]
Database doesn't contain any errors
Database check completed
[root@netxms ~]#

[curruscanis]

I did the following after shutting down the NetXMS service:

mysqlcheck --auto-repair netxms -u root -p

Many entries were repaired...

started the NetXMS service:

the node with failures now allows charts... however they are blank for now, which I suppose should be expected.

[mkemerci]

@curruscanis said in DCI Database errors:

I have a node with a DCI issue.

I am getting the error:

'Read DCI data from server' has encountered a problem.  Cannot get data for DCI "Node Name":[1464]: database failure

I noticed this as the data from the node was displaying on a dashboard and now just shows "Cannot get DCI Value..."

I have run a database check and all passed, I have deleted and recreated the DCI collection items with no success.

Please let me know what I can do to troubleshoot this.

Thank you.

Hi. After you delete and recreate dci items, you have to adjust dashboards, too. Because Your new DCISs' id numbers are different then older ones and dashboards save dci information as their ids. So, If you deleted and recreated any DCI that using by dashboard, you must adjust that dashboard (delete old dci info and add new ones).