NPC fails to bind with NFA with Identifier is not a group

Document ID : KB000021897
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

NPC fails to bind with NFA with the following datasource log message:

Bind Phase: Identifier is not a group: [number]

Solution:

Please follow the example below to solve this issue:

The following error message shows up in NPC:

Bind Phase: Identifier is not a group: 82233

In the MySQL query below, replace the value 82233 with the value you actually see in the error log.

mysql -P 3308 netqosportal

SELECT IF(ds2.SourceType = 2, '*', '') AS IsReporter, ds2.SourceID,
ds2.ConsoleName, ds2.Host, bg.GroupLocalID,
bg.ItemName, it.ItemTypeName, bg.ItemSubTypeName, i.ItemType, i.ItemSubType
FROM bind_groups AS bg
LEFT JOIN items AS i ON i.ItemID = bg.ItemID
LEFT JOIN item_types AS it ON it.ItemType = i.ItemType AND it.ItemSubType = i.ItemSubType
LEFT JOIN data_sources2 as ds2 ON ds2.SourceID = bg.SourceID
WHERE bg.ItemID = 82233;

Take note of the values returned for the column GroupLocalID, then remote access to the NFA Console and issue the commands below from a Windows command prompt:

mysqldump -P 3308 reporter groups > groups.sql

mysql -P 3308 reporter

delete from reporter.groups where groupId in (values of GroupLocalID returned in the previous step)

For example, if the GroupLocalID values returned from the select statement above are 191,198,200,202,35,37, then, the delete command will be:

delete from reporter.groups where groupId in (191,198,200,202,35,37)