Event Manager data source shows Unable to Connect

Products

• Network Observability
• CA Performance Management

Issue/Introduction

The following error is seen within the DMService.log:

com.ca.im.portal.dm.productsync.SyncPhaseExecutor | Aborting sync phase for DataSource Event Manager@<hostname> because an exception occurred: jakarta.xml.ws.WebServiceException: org.apache.cxf.binding.soap.SoapFault: PreparedStatementCallback; bad SQL grammar [REPLACE INTO snmp_profiles (ItemID,ItemName,Version,Port,UserName,Context,Security,AuthProtocol,AuthPassword,PrivProtocol,PrivPassword,Tier,Enabled,UpdatedOn) VALUES (3175098,'<SNMP_Profile_Name>',3,161,AES_ENCRYPT(,'<encrypted_string>'),'',10,17,AES_ENCRYPT(<encrypted_string>,'<encrypted_string>'),17,AES_ENCRYPT(<encrypted_string>,'<encrypted_string>'),91,'Y',<timestamp>)]

 

Environment

25.4.2

Cause

25.4.2 allows an SNMP v3 profile to be created without a Username, when one is created without the Username, this error happens

Resolution

Take a look at the error and note the Profile Name: <SNMP_Profile_Name>  Find that Profile in the UI and delete it.  You can then recreate it but ensure there is a filled in Username.

Additional Information

This is resolved and a Username is required once again in 25.4.3+