Created question in FIWARE Q/A platform on 06-02-2018 at 18:02
Please, ANSWER this question AT https://stackoverflow.com/questions/48648274/fiware-orion-cygnus-unable-to-save-data-in-mysql

Question:
FIWARE Orion + Cygnus: unable to save data in MySQL

Description:
These are my Cygnus logs:

Startup completed
time=2018-02-06T13:47:54.311CLST | lvl=ERROR | trans= | srv= | subsrv= | function=configureInterceptors | comp=Cygnus | msg=org.apache.flume.channel.ChannelProcessor[116] : Could not instantiate Builder. Exception follows.
java.lang.InstantiationException: com.telefonica.iot.cygnus.interceptors.GroupingInterceptor
at java.lang.Class.newInstance(Class.java:364)
at org.apache.flume.interceptor.InterceptorBuilderFactory.newInstance(InterceptorBuilderFactory.java:48)
at org.apache.flume.channel.ChannelProcessor.configureInterceptors(ChannelProcessor.java:109)
at org.apache.flume.channel.ChannelProcessor.configure(ChannelProcessor.java:80)
at org.apache.flume.conf.Configurables.configure(Configurables.java:41)
at org.apache.flume.node.AbstractConfigurationProvider.loadSources(AbstractConfigurationProvider.java:353)
at org.apache.flume.node.AbstractConfigurationProvider.getConfiguration(AbstractConfigurationProvider.java:102)
at org.apache.flume.node.PollingPropertiesFileConfigurationProvider$FileWatcherRunnable.run(PollingPropertiesFileConfigurationProvider.java:140)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
time=2018-02-06T13:47:54.312CLST | lvl=ERROR | trans= | srv= | subsrv= | function=loadSources | comp=Cygnus | msg=org.apache.flume.node.AbstractConfigurationProvider[366] : Source http-source has been removed due to an error during configuration
org.apache.flume.FlumeException: Interceptor.Builder not constructable.
at org.apache.flume.channel.ChannelProcessor.configureInterceptors(ChannelProcessor.java:117)
at org.apache.flume.channel.ChannelProcessor.configure(ChannelProcessor.java:80)
at org.apache.flume.conf.Configurables.configure(Configurables.java:41)
at org.apache.flume.node.AbstractConfigurationProvider.loadSources(AbstractConfigurationProvider.java:353)
at org.apache.flume.node.AbstractConfigurationProvider.getConfiguration(AbstractConfigurationProvider.java:102)
at org.apache.flume.node.PollingPropertiesFileConfigurationProvider$FileWatcherRunnable.run(PollingPropertiesFileConfigurationProvider.java:140)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
Caused by: java.lang.InstantiationException: com.telefonica.iot.cygnus.interceptors.GroupingInterceptor
at java.lang.Class.newInstance(Class.java:364)
at org.apache.flume.interceptor.InterceptorBuilderFactory.newInstance(InterceptorBuilderFactory.java:48)
at org.apache.flume.channel.ChannelProcessor.configureInterceptors(ChannelProcessor.java:109)
... 13 more
time=2018-02-06T13:47:54.313CLST | lvl=INFO | trans= | srv= | subsrv= | function=create | comp=Cygnus | msg=org.apache.flume.sink.DefaultSinkFactory[40] : Creating instance of sink: mysql-sink, type: com.telefonica.iot.cygnus.sinks.OrionMySQLSink
time=2018-02-06T13:47:54.323CLST | lvl=INFO | trans= | srv= | subsrv= | function=getConfiguration | comp=Cygnus | msg=org.apache.flume.node.AbstractConfigurationProvider[119] : Channel mysql-channel connected to [mysql-sink]
time=2018-02-06T13:47:54.331CLST | lvl=INFO | trans= | srv= | subsrv= | function=startAllComponents | comp=Cygnus | msg=org.apache.flume.node.Application[138] : Starting new configuration:{ sourceRunners:{} sinkRunners:{mysql-sink=SinkRunner: { policy:org.apache.flume.sink.DefaultSinkProcessor@11b2c43e counterGroup:{ name:null counters:{} } }} channels:{mysql-channel=org.apache.flume.channel.MemoryChannel{name: mysql-channel}} }
time=2018-02-06T13:47:54.332CLST | lvl=INFO | trans= | srv= | subsrv= | function=startAllComponents | comp=Cygnus | msg=org.apache.flume.node.Application[145] : Starting Channel mysql-channel
time=2018-02-06T13:47:54.403CLST | lvl=INFO | trans= | srv= | subsrv= | function=register | comp=Cygnus | msg=org.apache.flume.instrumentation.MonitoredCounterGroup[110] : Monitoried counter group for type: CHANNEL, name: mysql-channel, registered successfully.
time=2018-02-06T13:47:54.404CLST | lvl=INFO | trans= | srv= | subsrv= | function=start | comp=Cygnus | msg=org.apache.flume.instrumentation.MonitoredCounterGroup[94] : Component type: CHANNEL, name: mysql-channel started
time=2018-02-06T13:47:54.404CLST | lvl=INFO | trans= | srv= | subsrv= | function=startAllComponents | comp=Cygnus | msg=org.apache.flume.node.Application[173] : Starting Sink mysql-sink
time=2018-02-06T13:47:54.409CLST | lvl=INFO | trans= | srv= | subsrv= | function=start | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionSink[236] : [mysql-sink] Startup completed
time=2018-02-06T13:47:55.149CLST | lvl=INFO | trans= | srv= | subsrv= | function=main | comp=Cygnus | msg=com.telefonica.iot.cygnus.nodes.CygnusApplication[263] : Starting a Jetty server listening on port 8081 (Management Interface)
time=2018-02-06T13:47:55.166CLST | lvl=INFO | trans= | srv= | subsrv= | function=info | comp=Cygnus | msg=org.mortbay.log.Slf4jLog[67] : Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
time=2018-02-06T13:47:55.169CLST | lvl=INFO | trans= | srv= | subsrv= | function=info | comp=Cygnus | msg=org.mortbay.log.Slf4jLog[67] : jetty-6.1.26
time=2018-02-06T13:47:55.205CLST | lvl=INFO | trans= | srv= | subsrv= | function=info | comp=Cygnus | msg=org.mortbay.log.Slf4jLog[67] : Started SocketConnector@0.0.0.0:8081
time=2018-02-06T13:48:24.418CLST | lvl=INFO | trans= | srv= | subsrv= | function=processNewBatches | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionSink[338] : Batch accumulation time reached, the batch will be processed as it is
time=2018-02-06T13:48:24.418CLST | lvl=INFO | trans= | srv= | subsrv= | function=processNewBatches | comp=Cygnus | msg=com.telefonica.iot.cygnus.sinks.OrionSink[394] : Finishing transaction ()