[Backlogmanager] [FIWARE-JIRA] (HELP-9079) [fiware-stackoverflow] Can' t use attr_persistence column on mysql sink

[Fernando Lopez (JIRA)]

     [ https://jira.fiware.org/browse/HELP-9079?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fernando Lopez updated HELP-9079:
---------------------------------
    Description: 
Created question in FIWARE Q/A platform on 14-12-2015 at 11:12
{color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/34264298/cant-use-attr-persistence-column-on-mysql-sink


+Question:+
Can't use attr_persistence column on mysql sink

+Description:+
I'm trying to use the column type with OrionMySQLSink. My agent has this code: 

cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink
cygnusagent.sinks.mysql-sink.channel = mysql-channel
cygnusagent.sinks.mysql-sink.enable_grouping = false
cygnusagent.sinks.mysql-sink.mysql_host = localhost
cygnusagent.sinks.mysql-sink.mysql_port = 3306
cygnusagent.sinks.mysql-sink.mysql_username = ********
cygnusagent.sinks.mysql-sink.mysql_password = *********
cygnusagent.sinks.mysql-sink.table_type = table-by-destination
cygnusagent.sinks.mysql-sink.attr_persistence = column
cygnusagent.sinks.mysql-sink.batch_size = 1
cygnusagent.sinks.mysql-sink.batch_timeout = 10


I'm having this error when I use the sink: 

2015-12-14 08:43:58,118 (SinkRunner-PollingRunner-DefaultSinkProcessor) [ERROR - com.telefonica.iot.cygnus.sinks.OrionSink.process(OrionSink.java:187)] Persistence error (Unknown database 'fiw-serv') 


I don't have any problem with row mode, only with column mode.


  was:

Created question in FIWARE Q/A platform on 14-12-2015 at 11:12
{color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/34264298/cant-use-attr-persistence-column-on-mysql-sink


+Question:+
Can't use attr_persistence column on mysql sink

+Description:+
I'm trying to use the column type with OrionMySQLSink. My agent has this code: 

cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink
cygnusagent.sinks.mysql-sink.channel = mysql-channel
cygnusagent.sinks.mysql-sink.enable_grouping = false
cygnusagent.sinks.mysql-sink.mysql_host = localhost
cygnusagent.sinks.mysql-sink.mysql_port = 3306
cygnusagent.sinks.mysql-sink.mysql_username = ********
cygnusagent.sinks.mysql-sink.mysql_password = *********
cygnusagent.sinks.mysql-sink.table_type = table-by-destination
cygnusagent.sinks.mysql-sink.attr_persistence = column
cygnusagent.sinks.mysql-sink.batch_size = 1
cygnusagent.sinks.mysql-sink.batch_timeout = 10


I'm having this error when I use the sink: 

2015-12-14 08:43:58,118 (SinkRunner-PollingRunner-DefaultSinkProcessor) [ERROR - com.telefonica.iot.cygnus.sinks.OrionSink.process(OrionSink.java:187)] Persistence error (Unknown database 'fiw-serv') 


I don't have any problem with row mode, only with column mode.


     HD-Enabler: Cygnus

> [fiware-stackoverflow] Can't use attr_persistence column on mysql sink
> --------------------------------------------------------------------------
>
>                 Key: HELP-9079
>                 URL: https://jira.fiware.org/browse/HELP-9079
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>              Labels: fiware, fiware-cygnus, flume
>
> Created question in FIWARE Q/A platform on 14-12-2015 at 11:12
> {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/34264298/cant-use-attr-persistence-column-on-mysql-sink
> +Question:+
> Can't use attr_persistence column on mysql sink
> +Description:+
> I'm trying to use the column type with OrionMySQLSink. My agent has this code: 
> cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink
> cygnusagent.sinks.mysql-sink.channel = mysql-channel
> cygnusagent.sinks.mysql-sink.enable_grouping = false
> cygnusagent.sinks.mysql-sink.mysql_host = localhost
> cygnusagent.sinks.mysql-sink.mysql_port = 3306
> cygnusagent.sinks.mysql-sink.mysql_username = ********
> cygnusagent.sinks.mysql-sink.mysql_password = *********
> cygnusagent.sinks.mysql-sink.table_type = table-by-destination
> cygnusagent.sinks.mysql-sink.attr_persistence = column
> cygnusagent.sinks.mysql-sink.batch_size = 1
> cygnusagent.sinks.mysql-sink.batch_timeout = 10
> I'm having this error when I use the sink: 
> 2015-12-14 08:43:58,118 (SinkRunner-PollingRunner-DefaultSinkProcessor) [ERROR - com.telefonica.iot.cygnus.sinks.OrionSink.process(OrionSink.java:187)] Persistence error (Unknown database 'fiw-serv') 
> I don't have any problem with row mode, only with column mode.



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)