Adding NFA as a data source in Performance Center fails with a bind failure

Article Id: 32550

Status: Published

Updated On: 14-02-2018 08:27

Legacy Id: TEC1556537

Products:

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration CA Performance Management - Data Polling

Issue/Introduction:

Issue:

When attempting to add NFA as a data source in Performance Center it fails with a "bind failure" The following exception is seen in the /opt/CA/PerformanceCenter/DM/logs/DMService.log:

CAPC encountered an error while trying to sync with data source

ndctnf01aa-flow.ca.com. The problem is in CAPC, not the data source.

The following stack trace shows the invalid SQL statement in CAPC:

org.springframework.dao.DataIntegrityViolationException: StatementCallback;

SQL [INSERT INTO bind_roles (SourceID, UpdateStage, RoleLocalID, RoleName,

RoleDesc) VALUES (8,1,1,'CaOperator',NULL),

(8,1,3,'CaAdmin',NULL),

(8,1,7,'WanAnalysis_NetFlow',NULL) ON DUPLICATE KEY UPDATE UpdateStage=1,

RoleLocalID=VALUES(RoleLocalID), RoleName=VALUES(RoleName),

RoleDesc=VALUES(RoleDesc)]; Column 'RoleDesc' cannot be null; nested

exception is

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:

Column 'RoleDesc' cannot be null

Environment:

2.4.x and up

Cause:

Null description column for roles

Resolution:

If you connect to the NFA "reporter" database and do a Select * from role_definitions; you will note that the "description" column will be null for one or many roles. Update the description column so that the value is not null and the NFA data source will bind successfully in Performance Center

Generic SQL syntax of UPDATE command to modify data in a MySQL table:

UPDATE table_name SET field1=new-value1, field2=new-value2

(ex) UPDATE role_definitions SET description = 'Test Users' WHERE description=NULL;

Environment:

Release: IMDAGG99000-2.5-Infrastructure Management-Data Aggregator
Component: