Event Manager Sync Failed

book

Article ID: 220836

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration

Issue/Introduction


When looking in the DMService.log, there is an error similar to:

ERROR | pool-6-thread-1          | YYYY-MM-SS HH:MM:SS,### | com.ca.im.portal.dm.productsync.DataSourcePoller                 
      | 
Data source [email protected] encountered an error while processing a sync request.  The problem is in the data source, not CAPC.  Check the logs for the data source to determine the cause of the problem.  The following stack trace shows the context of the sync request:
javax.xml.ws.soap.SOAPFaultException: StatementCallback; bad SQL grammar [REPLACE INTO snmp_profiles (ItemID,ItemName,Version,Port,UserName,Context,Security,AuthProtocol,AuthPassword,PrivProtocol,PrivPassword,Rank,Enabled,UpdatedOn) VALUES (

<LIST OF SNMP PROFILES HERE>

nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''netqos') AS CHAR), at line ##
 at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:156)
 at com.sun.proxy.$Proxy125.pushRequest(Unknown Source)
 at com.ca.im.portal.api.services.datasource.ProductSync2WSProxyImpl.pushRequest(ProductSync2WSProxyImpl.java:81)
 at com.ca.im.portal.dm.productsync.DataSourcePush.pushSync(DataSourcePush.java:184)
 at com.ca.im.portal.dm.productsync.DataSourcePushPhase.executeInternal(DataSourcePushPhase.java:36)
 at com.ca.im.portal.dm.productsync.DataSourceSyncPhase.execute(DataSourceSyncPhase.java:76)
 at com.ca.im.portal.dm.productsync.PushSyncPhaseTask.execute(PushSyncPhaseTask.java:55)
 at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:101)
 at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:94)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java)
 at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.cxf.binding.soap.SoapFault: StatementCallback; bad SQL grammar [REPLACE INTO snmp_profiles (ItemID,ItemName,Version,Port,UserName,Context,Security,AuthProtocol,AuthPassword,PrivProtocol,PrivPassword,Rank,Enabled,UpdatedOn) VALUES (

<LIST OF SNMP PROFILES HERE>

at line ##

 at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.unmarshalFault(Soap11FaultInInterceptor.java:75)
 at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:46)
 at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:35)
 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)
 at org.apache.cxf.interceptor.AbstractFaultChainInitiatorObserver.onMessage(AbstractFaultChainInitiatorObserver.java:111)
 at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:69)
 at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:34)
 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)
 at org.apache.cxf.endpoint.ClientImpl.onMessage(ClientImpl.java:798)
 at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponseInternal(HTTPConduit.java:1678)
 at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.handleResponse(HTTPConduit.java:1516)
 at org.apache.cxf.transport.http.HTTPConduit$WrappedOutputStream.close(HTTPConduit.java:1424)
 at org.apache.cxf.transport.AbstractConduit.close(AbstractConduit.java:56)
 at org.apache.cxf.transport.http.HTTPConduit.close(HTTPConduit.java:650)
 at org.apache.cxf.interceptor.MessageSenderInterceptor$MessageSenderEndingInterceptor.handleMessage(MessageSenderInterceptor.java:62)
 at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)
 at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:531)
 at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:461)
 at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:364)
 at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:317)
 at org.apache.cxf.frontend.ClientProxy.invokeSync(ClientProxy.java:88)
 at org.apache.cxf.jaxws.JaxWsClientProxy.invoke(JaxWsClientProxy.java:134)
 ... 12 more

 

Cause

There is an SNMPv3 profile with a blank username.

Environment

Release : 3.7.x

Component : CA Performance Center

Resolution

Add a username to the SNMP profile.